… s0,s1, s3, s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # … not up-to-date, data may be lost or replication may be broken. Scenario #3… when using GTIDs is usually straightforward: just connect the slave to the correct master …be aware of the current limitations…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…mysql/mysql.log general_log = 1 User correctly authenticated: 121227 8:31:49 38 Connect root@localhost on 38 Query select @@version_comment limit… connections. Two denied connections (bad password) and 16 lost connections (not closed properly). Apart from that information we get the connection time…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… of resources system has will place a limit on amount of queries system can ran…take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat … COMMIT_TRANSACTIONS: 181243 ROLLBACK_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES:…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…referring to the amazing MySQL manual, especially the option and variable reference table…._typeblogpercona.commanual Compressionblogpercona.commanual concurrent_insertblogpercona.commanual connect_timeoutblogpercona.commanual Connectionsblogpercona.commanual consoleblogpercona.commanual core_…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…of partitions are very limited in size and there…connects to the database using persistent connection technique to avoid creating new connections for every request so it just recycle old connections… 16K ago 2 12:36 lost+found Nothing. No files… in the end. Conclusion MySQL can creates temporary files…
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… to another, something went wrong and they lost the ibdata1 file, where all the table …and good internet connectivity, I fired up an Ubuntu 10.04 EC2 instance, installed MySQL and provided …ID order by spaceid limit 1;”` if [ "a$CURRENT_SPACEID" == "a" ]; then exit fi CURRENT_TABLENAME=`mysql -u root …
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… corrupted table I am getting: mysql> check table test; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> check table test; +———–+——-+———-+———-+ | Table | Op… Duplicates: 100 Warnings: 0 mysql> insert ignore into test2 select * from test limit 300; ERROR 2013 (HY000): Lost connection to MySQL server during query As…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
…_TRANSACTIONS: 0 DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 0 1 row in set (0.00 sec) mysql> select * from… DENIED_CONNECTIONS: 0 LOST_CONNECTIONS: 0 ACCESS_DENIED: 0 EMPTY_QUERIES: 70748 and INDEX/TABLE statistics: mysql> select * from information_schema.index_STATISTICS limit 10…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…the boot output has been lost, but in many cases … | Variable_name | Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | |…log output. The stock MySQL server’s limitation of one-second granularity…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…use the mysql server: [root@percona1 ~]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection …written on the node we just restarted is lost after the SST. Now let’s try …group: trimethylxanthine sst: trivial donor: options: gcs.fc_limit=9999999; gcs.fc_factor=1.0; gcs….
