… slave; # For s1, s3 and s4 mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; Those of you who… mysql> stop slave; mysql> change master to master_port=10002; mysql> start slave; # And then check the number of records from the t table s1…’ column would have been useful. In our case we can check that 3ec18c45-c3ae-11e2-b986-0800272864ba is the server UUID…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack… into the certification index, which is a hash table. A small fc_limit does however keep the… is coming from There are two global status variables you can check to see what flow control is …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… 16 tables with 5M rows each (about 23GB). So it makes sense to check if … Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1…=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… This allows parallel processing of individual tables when rebuilding the index. … DBD::MySQL package for server communication instead of spawning the MySQL command …: innobackupex is using SHOW MASTER STATUS to obtain binlog file and …to fail. Fixed by fix checking if xtrabackup_pid file exists …
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. But just as frequently,…commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb_thread_sleep_delayblogpercona.commanual Innodb_truncated_status_writesblogpercona…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… sleep 60 done Check for Table Cache Related Allocations There are cases when MySQL will allocate a lot of memory for table cache, especially… deeper to check which sessions have created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G… do as it is least intrusive. Run SHOW ENGINE INNODB STATUS and look for memory information block, which can use like…
Post: Can you Trust CHECK TABLE ?
September 11, 2008 By 6 Comments
…CHECK TABLE is not reporting any error Why ? Because CHECK TABLE…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… reflect natural state of the table as it would be in the production over time: mysql> show table status like “post_channel” \G *************************** 1…. I run CHECK TABLE on this table which essentially performs data and indexes scan which will be reflective to large full table scan and…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
…. I used 10mil row table which would look as following in terms of data and index size: mysql> show table status like “sbtest” \G…_time: 2012-06-27 13:04:56 Update_time: NULL Check_time: NULL Collation: latin1_swedish_ci Checksum: NULL Create_options…: If you’re having large tables and need to run ALTER TABLE which rebuilds the table or OPTIMIZE TABLE do not forget to enable…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, etc etc. Nothing unusual. Next I check what the MySQL version is, and I check (with the ‘file’ command) whether /usr/… the status values for Created_tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | …
