… determine these spots? A good start is to enable full slow query logging (with long_query_time = 0) for some time… nature. Q: Are these recommendations true of all versions of MySQL? If not which versions? The recommendations I made are valid… be valid with 5.6. Q: I have good command of SQL query writing and wanted to learn MySQL administration suggest any…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
… database to demonstrate: mysql> SET profiling=1; mysql> pager cat > /dev/null mysql> SELECT * FROM… | 3 | 0.0061593333 | | Sorting result | 0.011090 | 6.42 | 1 | 0.0110900000 | | checking permissions | 0… | 0.000002 | 0.00 | 1 | 0.0000020000 | | logging slow query | 0.000001 | 0.00 | 1 | 0.0000010000…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
… system. Rather often people panic and what thought to be slow down with version upgrade is rather system warming up. You… it without side load. Setting up 2 MySQL Servers side by side (for example with MySQL Sandbox) can especially be helpful. Once… more accurate results. In recent Percona Server versions and MySQL 5.6 you can also store innodb stats in table so you…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) …CPU. With Percona Server, enabled full query logging and log_slow_verbosity=full you can also get great amount of … 7ms 0 # pages distin 65 11.43M 1 18 6.84 9.83 2.20 7.70 # queue wait …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… enable logging atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise we might… you were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3… wp_posts wp_term_relationships # 19 0x5DE709416871BF99 0.0454 0.6% 260 0.0002 1.00 0.00 DELETE poller_output…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… disconnecting ungracefully (without closing the connection properly). This is happening 6 times every ten seconds. We need to figure out what… total execution time. By the way, the slow query logs in the stock MySQL server are extremely limited, and for serious analysis… for microsecond logging and additional information in the slow query log output. The stock MySQL server’s limitation of one-second granularity…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… GA release of MySQL 5.6, and I wanted to check if any improvement has been made to the slow query log in…,Error’), CONCAT(‘# administrator command: ‘, sql_text), sql_text), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the script above in my bk-tools github project. It’s called export-slow-log…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default settings except… than data and the IO is slow (when the FS cache is cold, IO to slow IO subsystem happens) Repeated runs test… can see above, MySQL 5.6 outperformed MySQL 5.5.30 with the big buffer pool. Why is the MySQL 5.6.10 with default…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… slow log live, but that is a bit ugly solution. That is where this patch can be very useful. With simple MySQL….wp_options | 6586 | 200 | 400 | | hosting2.wp_postmeta | 5 | 2 | 6 | | hosting2.wp_posts | 542 | 4 | 12 | | hosting2.wp_term_relationships…_term_taxonomy | 729 | 3 | 6 | | hosting2.wp_usermeta | 427 | 6 | 18 | +——————————–+———–+————–+————————-+ 10 rows in set (0.00 sec) mysql> SHOW INDEX_STATISTICS LIKE…
