…in case of CPU-bound workload. The performance impact is negligibly small in IO-bound workload even if all queries are logged. In general logging all queries can hurt MySQL…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
…log all queries in slow query log by setting long_query_time=0 This patch is adapted version of patch by Georg Richter which was made…log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter (based on parse_mysql_slow_log…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…how do people approach the upgrade process ? I will describe couple of processes which I…in MySQL 4.1 or changing JOIN evaluation in 5.0 (which could both cause different result set or make query not runnable in MySQL…MySQL Replication for upgrade. Once you have setup slave with new version and made…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…do is often not simple at all. It’s impossible to predict. A customer may call and ask “how…log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL…made…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…ins; +——+ | a | +——+ | 1 | +——+ Good. Let’s see what’s in the binary log: master > show binlog events in ‘mysql-bin.000011′\G *************************** 1. row *************************** Log_name: mysql…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…in size. When I added LVM on top however, I made the logical volume slightly below 1TB. Investigating this I…mysql socket=/var/run/mysqld/mysqld.sock innodb_file_per_table = true innodb_data_file_path = ibdata1:10M:autoextend innodb_flush_log…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…mysql binary logs for point-in…made…in descending order: mysql> call flexviews.create( -> ‘demo’,'dashboard_top_customers’,'COMPLETE’); Query OK, 1 row affected (0.00 sec) mysql…all…I hope this helps you understand how Flexviews can help you ensure fast response times in…
Post: The case for getting rid of duplicate “sets”
May 17, 2011 By 2 Comments
…logging and other technologies did not exist. This made it difficult to implement the database in…in set (0.00 sec) mysql> delete from compressed where val=16; Query OK, 1 row affected (0.00 sec) mysql…
Post: MySQL Limitations Part 2: The Binary Log
October 23, 2010 By 11 Comments
…log” of events that modify data in the server. The binary log is a real limitation in MySQL. The binary log…in MySQL were handled manually. It could work if you just made…queries. This can be done, of course. It’s just a matter of how…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…all who are already doing this! 
I think I…I mentioned in more details later. How does online backup work in…MySQL Backup API which was originally implemented in MySQL 6.0. This feature is now scheduled for an upcoming version of MySQL…made the implementation of PBXT more complicated than I…queries…
