…mysql> SHOW PROFILE FOR QUERY 1; +———————-+———-+ | Status | Duration | +———————-+———-+ | starting… | R/Call | +———————-+———-+——-+——-+————–+ | removing tmp table | 0.095135 | … | 0.0000020000 | | logging slow query | 0.000001 …
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…a REPEATABLE READ isolation level and started WITH CONSISTENT SNAPSHOT. In the middle…format=barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona …further TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6….are not effective enough: they only slow the growth of the history list….
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… limiting MySQL Replication speed. My first idea was to check it based on slow query log, happily the server was running MySQL with slow… restart MySQL but this would make replication to be delayed few more hours because of the time Innodb takes to open tables first time after start. I knew in my case most of the…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-…, we just need to recover the dump and start the replication: slave1 > show global variables like ‘gtid_executed’; …the pt-table-checksum and pt-table-sync. How to restore a slave in a good and slow way…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…that extra network traffic would really slow down transactions. You may have … locking on the node it is started from all the way up …sec) node2 mysql> show create table autoinc\G *************************** 1. row *************************** Table: autoinc Create Table: CREATE TABLE `autoinc` ( `i`…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…slow down your inserts and make primary key significantly fragmented. I also would note there are some MySQL…it not overcome it. The best thing to start with is looking at the queries around “outliers” … mysql use index for group by? A: If you have Index on the column MySQL can avoid temporary table…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
…TABLES on Innodb table to ensure there is not ton of queries starting reading table…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
…table with simple structure: mysql> show create table dt2 \G *************************** 1. row *************************** Table: dt2 Create Table: CREATE TABLE `dt2` (…buffer_size, this is why we start from this value. As you can…ones submitting them to device which slows things down or it could be …
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… help determine these spots? A good start is to enable full slow query logging (with long_query_time = … will need to alter the table, which may be difficult if the table is big. So the best…Q: Are these recommendations true of all versions of MySQL? If not which versions? The recommendations I made…
