…the same time? Downtime is something we like to avoid! Is it necessary to …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…able to mix servers where gtid_mode is ON with servers where gtid_mode is OFF….
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL … system; there really isn’t anything quite like that in the MySQL world, except maybe MyISAM files on top …an InnoDB table, but trying to run a simple mysqlslap just hung on me, so that’s where I left…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… table to count the movies per production year for each kind_id. It was more efficient in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the first table in the EXPLAIN seem like…, back to the query where you were trying to determine the last episode of each TV show. Couldn’t you have used…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…SHOW CREATE TABLE crashes MySQL There is yet another source of information about the table structure – InnoDB dictionary. Let’s review tables…table identifier. We will need the table id to find indexes of the table. mysql> select * from SYS_TABLES WHERE…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… Server showed fairly close results in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5…$i WHERE k like ‘%0%’ SysBench-0.5/lua: POINT_SELECT QPS test sysbench –num-threads=<1..1024> –test=oltp.lua –oltp_tables…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… you find in standard async MySQL replication. It is my belief… running “FLUSH TABLES WITH READ LOCK”, or perhaps by “LOCK TABLE“, in…likely and therefore time-consuming to the application. How to tell if flow control is happening and where…this node because ‘Flow snt’ shows a message sent as soon…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… I need). Tables looks like: CREATE TABLE `sbtest1` ( `hid` …show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x better throughput, and on data size: InnoDB table…KEY (`hid`,`mid`,`id`) where `id` is sequential, …-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…show status like ‘Open%tables‘; +—————+——-+ | Variable_name | Value | +—————+——-+ | Open_tables | 30 | | Opened_tables | 1 | +—————+——-+ 2 rows in set (0.00 sec) session10 > show… that use MySQL versions prior to 5.5: I remember a customer case where there is…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…notes of places where more effort is likely to pay off,…
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 *************************** 1… else where memory resources might be just needed more. Take Away: If you’re having large tables and need to run ALTER TABLE…
