After using Percona xtrabackup to do a full standby and two incremental backups, part of a table's data has been mistakenly deleted, how to recover mistakenly deleted data.
Thinking: will be fully prepared and incremental backup, the latest backup generated binary log all copied to the test environment, in the test environment after the deleted data recovery, will mistakenly delete data generation INSERT statement, on the original machine execution.
"Mysql_password= ""
Mysql_cmdline= "/usr/local/mysql/bin/mysql
B. Run/usr/local/mysql/bin/clustercheck 200 indicates Clustercheck validation succeeded
2.XINETD Configuration
A.yum install-y xinetd.x86_64
b.cp/usr/local/mysql/xinetd.d/mysqlchk/etc/xinetd.d/
D.vim/etc/xinetd.d/mysqlchk changes the server to/usr/local/mysql/bin/clustercheck (server=/usr/local/mysql/bin/ Clustercheck)
E. Change of authority chmod +x Mysqlchk
F.vim/etc/services the last New line Mysqlchk 9200/tcp # Mysqlchk
G.service
Percona mysql5.7 centos/red hat-rpm package does not display a password during installation. It is in the error log. The automatically generated my.cnf contains this line of Log-error=/var/log/mysqld.log.So, here's our password:[Email protected] lyh]# cat/var/log/mysqld.log | grep "Temporary password"2017-06-26t04:28:05.537965z 1 [Note] A temporary password is generated for [email protected]:Ca!wb/i+l7elAttention! Special symbols need to be escaped th
RPM Way to install MySQL 5.6
mysql-server-5.6.27-1.el6.x86_64.rpmmysql-client-5.6.27-1.el6.x86_64.rpmMYSQL-SHARED-COMPAT-5.6.27-1.EL6.X86_64.RPM (Perl-dbd-mysql require)2.my.cnf[Email protected] lib]# VI/ETC/MY.CNF# for advice The change settings# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html[Mysqld]DataDir =/var/lib/mysqlLog_bin =/var/lib/mysql/bin-logSocket =/var/lib/mysql/mysql.sockSql_mode=no_engine_substitution,strict_trans_tables3.source Install
-visual-explain-c MYSQL-E "explain select * from Mysql.user" | Pt-visual-explainFor example:# mysql-uroot-proot-e ' Explain select * from B2b.ecs_goods ' > A.sql # pt-visual-explain/root/a.sqlOr one-step process through the pipeline:# mysql-uroot-proot-e ' Explain select * from B2b.ecs_goods ' |pt-visual-explainPt-config-diffDescriptionCompare the differences between MySQL node configuration files.Pt-config-diff diffs MySQL configuration files and server variables. CONFIG canbe a filename or a D
server IP user name password, you can analyze the entire master-slave architecture of each server information, including but not limited to MySQL version, IP address, server Id,mysql service startup time, role (main/from), Slave Status (lag behind the master server for how many seconds, there is no error, Slave is not running). Pt-Slave-Find--host=localhost--user=rhce6--password=rhce6MySQL Deadlock monitoring pt-Deadlock-Logger h='127.0.0.1' --User=root--password=123456PRIMARY key conflict Chec
data conflict, then the way is to take the inconsistent node kicked out of the cluster environment.Limitations of 4.PXC
Only the InnoDB engine is supported. Because an XA transaction is likely to occur when a commit occurs rollback
XA transactions are not supported,
A table delete operation without a primary key is not supported, and a SELECT ... limit also returns a different value.
Because of optimistic concurrency control, transaction conflicts, failed nodes are exited f
--ssl-cert PATH X509 cert in PEM format--ssl-key PATH X509 key in PEM format--ssl-cipher TEXT SSL cipher to use--ssl-verify-server-cert Verify server ' s "Common Name" in its certagainst hostname used when connecting. Thisoption is disabled by default-V,--version version of MYCLI.-D,--database TEXT database to use.-R,--prompt TEXT prompt format (Default: "\ t \[email protected]\h:\d>")-L,--logfile FILENAME Log every query and its results to a file.--defaults-group-suffix TEXT Read Config group w
DB Query Analyzer 6.03, the most excellent Universal DB Access tools on any Microsoft Windows OS,
DB Query Analyzer 6.03, the most excellent Universal database Access tools on any Microsoft Windows OS
DB Query Analyzer is presented by Master Genfeng, Ma from Chinese Mainland. It has English version named '
Tags: process build rail info from BSP content lag stop For non-Oracle DB, SQL Server is a sample description: My train of thought A:oracle DB production B:oracle DB Intermediate machine C:sqlserver db destination a-> b->c Note: B on both the rep process also has the EXT process, at this time. There is also a need to e
Tags: Oracle goldengate initial Load methodNon-Oracle DB is illustrated with SQL Server as an example:My train of thoughtA:oracle DB production B:oracle DB Intermediate machine C:sqlserver db destinationa-> b->c Note: B on both the rep process and ext process, at this time, C also need to establish a rep process for B.
Document directory
MVCC
Horizontal scalability
Query expression
Atomicity
Durability
Map reduce
Javascript
Rest
Performance
Use Cases
Http://www.mongodb.org/display/DOCS/Comparing+Mongo+DB+and+Couch+DB, English
Http://www.searchdatabase.com.cn/showcontent_46595.htm (Chinese)
The most fundamental difference is that the difference in application scenarios is the difference in the choice of CAP.
You cannot use Db-library (such as ISQL) or ODBC 3.7 or earlier to ntext data
Warning:mssql_query () [Function.mssql-query]: message: You cannot ntext data or use Unicode collations with db-library (such as ISQL) or ODBC 3.7 or earlier The Unicode data is sent to the client. (severity) in D:phpnowhtdocss includedb_mssql.class.php on line 55
The code is as follows
Copy Code
Warn
diagnosis.For a row that lasts for more than 6 seconds, most of the operations may be full table scan (in any case, this part of information is worth noting ).
We use a case study to familiarize ourselves with this waiting event:
DB Name DB Id Instance Inst Num Release OPS Host ---------- ----------- ---------- -------- ---------- ---- ---------- K2 1999167370 k2 1 8.1.5.0.0 NO k2This is a databa
Tags: mysql yii yii2 database frameworkYII2 database Exception–yii\db\exception sqlstate[hy000] [2002] No such file or directory error resolution when working with MySQL databasesA similar error occurred in the database operation, in fact, the PDO in PHP configuration file php.ini not specified Mysql.sock (or mysqld.sock) file path cannot link the databaseDatabase Exception–YII\DB\EXCEPTIONSQLSTATE[HY000] [
Problem descriptionThe following error message appears when you try to use SSAS for OLAP in the official Microsoft Tutorial:
Severity Code Description Project File Line Suppression state
Error OLE DB errors: OLE DB or ODBC error: Login failed for user ' NT service\mssqlserverolapservice '.; 28000. 0
Cause of the problemThis issue occurs because of an authorization authentication error when
principle: Pt-table-checksum in the Lord execute check statements check the consistency of MySQL replication online, generate the Replace statement, and then pass the copy to the From, and then update the MASTER_SRC value via update. Determine whether replication is consistent by detecting values from the top this_src and MASTER_SRC.Note: Run when you choose a business peak when you use it, because running can cause some of the table's records to be locked. Use--max-load to specify the maximum
oldest query. This is not really a long run of inquiries to prevent being killed, they just wait for a long time. This kind of match is queried by time, killing a maximum of time.
all kill all satisfied threads kill
all but the longest keep do not kill
action
--kill Kill the connection and exit
--kill-query only kill the connection execution statement , but the thread will not be terminated
--print Print the statement that satisfies the condition
QUERY match
Atitit. Software dashboard (4) -- db database subsystem-monitoring, atitit -- db
Atitit. Software dashboard (4) -- db database subsystem-Monitoring
Connections :::
Deadlock table list: Basic deadlock list (recent records, time, SQL, etc)
3. Monitor servers and obtain CUP and I/O usage information4. Monitor the database and obtain the remaining disk space, data sp
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.