… a new table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has… by inspecting the output of SHOW SLAVE STATUS? Look at the last field, Auto_Position: # Slave #1 mysql> show slave status\G [...] Auto_Position…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… the replication topology when using GTID-based replication. That will show where GTIDs shine and where improvements are expected. This is…; # And then check the number of records from the t table s1> select count(*) from t; +———-+ | count(*) | +———-+ | 2 | +———-+ Great! So again…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… related output from show engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use… handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as SELECT ld.label_id, cai.inventory_id….trash = ‘f’ and (cai.status is NULL) group by ld.label_id, cai.inventory_id All 4 tables in the query are…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage diagnostics. Bugs… the MySQL 5.6 version, which removed MyISAM internal temporary table mutex contention. Bug fixed #1179978. Release notes for Percona Server…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…a specific database, a set of databases, or specific tables; you can also configure the slave to replicate … there are plenty of other MySQL and OS-level status variables that you might want to keep an …number of long-running queries in the output of SHOW PROCESSLIST that might be a sign that trouble …
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… key lookups into the certification index, which is a hash table. A small fc_limit does however keep the certification index… of time (out of 1.0) since the last SHOW GLOBAL STATUS that flow control is effect, regardless of which node caused… control if I execute a FLUSH TABLES WITH READ LOCK on node3: [root@node3 ~]# myq_status wsrep Wsrep Cluster Node Queue Ops…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…–apply-log –rebuild-indexes. This allows parallel processing of individual tables when rebuilding the index. Percona XtraBackup has implemented Encrypted …the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could trigger a…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…the more general descriptors optimization in Percona Server showed fairly close results in our tests. In… Configuration: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1…..1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…available for download from our repositories. Benchmark showing the impact of memory allocators on …replicate in case DROP TABLE statement is used on a temporary table. Bug fixed #1084702 (Seppo …execution loop, which does not honor wsrep status codes correctly. Bug fixed #1144911 (Seppo Jaakola)….
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…show_statusblogpercona.commanual Com_show_storage_enginesblogpercona.commanual Com_show_table_statusblogpercona.commanual Com_show_tablesblogpercona.commanual Com_show_triggersblogpercona.commanual Com_show_variablesblogpercona.commanual Com_show…
