… only a few GB of main memory). The cost of querying this database will be 10 times higher with this partitioning… 100 disk seeks to answer a random query, assuming you can get each index query down to one disk seek.) I claim… the new partition starts getting too big, so Inno starts slowing down again. The factor of 4 speedup that occurs when…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
…=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not-using-indexes query_cache_type=1 query_cache_size=32M…
Comment: Benchmarks challenges of XtraDB Cluster
April 20, 2012 By 4 Comments
… on multiple ports/ips to vary distribution of writes/reads, slow queries/fast queries, etc.
Comment: Innodb Performance Optimization Basics
March 28, 2012 By 70 Comments
Hi, I am facing major issues with slow query output. The tables are in InnoDB with MySQL 5 and …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… query time 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 5.5 the query time decreases…_init’. Is it because of this that the query on MariaDB 5.5 is slow as compared to MySQL 5.6. Next…
Comment: Solving INFORMATION_SCHEMA slowness
April 20, 2012 By 16 Comments
I’ve just hit the INFORMATION_SCHEMA slowness today when I began the tests to integrate the pt-… taking the tool about one hour just to finish this query: “SELECT table_schema, table_name FROM information_schema.key_column_usage WHERE …” After setting innodb_stats_on_metadata = 0, that query run almost instantly (btw, Thank you Peter!). If I may…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… memory. There are implicit MEMORY tables which are allocated for query execution, which size can be controlled by tmp_table_size…. In Percona Server you can do better as you can query temporary tables too: mysql> select sum(data_length+index_length… good tools to detect memory leaks like valgrind are too slow to run in production. So the best thing to do…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… all-staff meeting last week, so we are a little slow to blog about this and acknowledge the great work that… the server much faster with the binary log enabled Faster queries through speedier joins, faster subqueries, and elimination of useless tables…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… to specify slow query time in microseconds rather than seconds and allows you to log all queries in slow query log by setting long_query_time… Slow Query Log – Especially after the changes to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had… over again you can create stored procedure, something like LAST_SLOW_QUERIES and use it instead, just remember unless you add extra… to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly feature…
