…MySQL manual, especially the option and…insert_buffer_sizeblogpercona.commanual Bytes_receivedblogpercona.commanual Bytes_sentblogpercona.commanual character_set_clientblogpercona.commanual character_set_client_handshakeblogpercona.commanual character_set_connectionblogpercona.commanual character_set…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… is created and then INSERT INTO new_table SELECT * FROM old_table is done and … logging slow query | 0.000002 | | cleaning up | 0.000002 | +———————-+————+ 17 rows in set (0.00 sec) And…is not really documented and as such I have reported a bug: http://bugs.mysql.com/bug.php?id…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…AND string=’string’ The other thing you need to consider is string comparison in MySQL is…slow down your inserts and make primary key significantly fragmented. I also would note there are some MySQL…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… INSERT IGNORE INTO articles (id, body,)VALUES(3558268,’sample text’); Filtering Slow Query Log – Especially after the changes to log all queries slow query… this tool set ? First be aware this patch to MySQL is not official and should be used with caution. We think it is pretty safe…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…is the ability to enable logging atomically, not just for new connections as in MySQL. This is…is set the variable log_slow_verbosity to ‘full’, this variable is available in Percona Server and… 0.0002 1.00 0.00 INSERT poller_output # MISC 0xMISC 0.8137… tt ON tt.term_id = t.term_id INNER JOIN wp_term_…
Post: Beware of MySQL Data Truncation
February 7, 2009 By 4 Comments
…slow. So how to avoid this problem ? It is actually quite easy – you just need to enable strict mode: mysql> set sql_mode=STRICT_ALL_TABLES; Query OK, 0 rows affected (0.00 sec) mysql> insert…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…is pretty tricky, and all that extra network traffic would really slow… test on and insert some data: node2 mysql> create…and attempt to modify the same row: node1 mysql> set autocommit=off; Query OK, 0 rows affected (0.00 sec) node1 mysql…MySQL thread id 3972, OS thread handle 0x7fddb84e0700, query id…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…slow on this machine, so we need to stop the buffer pool and…insert into tableB… | 6322 | user | update | insert…IDs, and that one is…mysql tables in use 7, locked 0 MySQL thread id 6424, query id 1579718 10.255.106.47 user statistics And correlating the thread ID…
Post: InnoDB: look after fragmentation
November 5, 2009 By 12 Comments
…id” inserted not in order. +—————————+ | count(distinct username) | +—————————+ | 5903053 | +—————————+ 1 row in set (2 min 8.92 sec) mysql…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…is scheduled next time object will be free already. OS Waits are relatively slow, and…MySQL thread id 9697561, query id 188161264 localhost root update insert…is in “Sleep” stage – if it is multiple statement transaction. Innodb also will print OS thread_id and process id…
