…how to setup and run this benchmark, can be found here. We decided to run…10GB). We used this dataset to check server behavior when data…_t*, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long) … 31.41% 15534570…-definition-cache=1000 query_cache_size=0 query_cache_type=…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…running queries on a server. Granted, this can take a lot of disk space, but it allows you to “run…run forever by default, so specify –iterations or –run-time to limit how long they run. There are more changes in addition to…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…designs and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See part two for handling …slowlogd. This daemon is similar to running `tail -f slow.log`, except that it knows how to follow the log stream … the graph lines up with the blue part. Check back Thursday for Part 2…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…queries themselves. If the client has long-running queries, it can be pretty easy to catch. Maybe they’re long-running… checking for default users in the mysql.* tables, running mk-duplicate-key-checker to…the query plan. This is where you need to really know how to write queries and how EXPLAIN …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…to include others as well. Here’s how you can use our new monitoring plugins to check… long-running transactions, or other problems. The pmp-check-mysql-innodb plugin checks …checking that the server is alive and responds to a query. The pmp-check-mysql-status is also very flexible and can be used to…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
…to load data (especially if you disable unique key checks and foreign key checks…. Even simple SELECT queries might have to scan through lots …to roll back, it will take a Very Long Time to do — I hate to think how long. I’m sure it would be faster to… I also used ‘time’ to run the Perl fifo script,…
Post: Innodb undo segment size and transaction isolation
January 12, 2011 By 3 Comments
…long time and there could be a lot of garbage in undo segment. If you’re running Percona Server it is easy to check… pointer to appropriate blob version. Now lets move on to the main topic – how does…long running queries will cause problems in this case anyway, even if you set transaction isolation to…
Post: MySQL optimizer: ANALYZE TABLE and Waiting for table flush
February 27, 2013 By 3 Comments
…to trigger this problem we need: – Lot of concurrency – A long running query – Run an ANALYZE TABLE on a table accessed by the long running query…check the running queries. If the table that you are going to work on is very used the recommendation is to run…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…to check though. Run “FLUSH TABLES” and see whenever memory usage goes down. Note though because of how…to see how many prepared statements are allocated on server and Com_stmt_send_long_data to see whenever sending long…exist for duration of query execution so it is usually easy to catch them. There …
Post: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
August 28, 2007 By 57 Comments
… than run two separate queries: one – to get a result set, another – to count total number of rows. In this post I’ll try to check, is this true or not and when it is better to run two separate queries. For my tests I… sec to run this query first time and 0.00-0.02 sec for all consecutive runs. And now – we need too check how long our COUNT query…
