… just a moderate load on the host system, DRBD can end up in a split-brain situation. Typically DRBD is run… example, if you see a large number of long-running queries in the output of SHOW PROCESSLIST that might be a… and PRM simply attempt to connect and run a simple query, but it’s always possible to build something more involved…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
…. Basically I have a problem regarding long running select query. A query runs for say 300 seconds and because the resultset is… do show processlist, the update queries show up with state =’Updating’ or some others with state =’query end‘; there are also some other…_locks_immediate’ keeps increasing I have disabled the query cache by set global query_cache_size = 0; All this on a fairly…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… and several other InnoDB and query optimizer improvements. However, I plan….test # ######################################################################## # test.test # ######################################################################## # Key redundant ends with a prefix of the clustered index…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…_dir variable didn’t have the path separator at the end. Bug fixed #1181887. A warning is now returned if a… file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug… fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t running. Bug fixed #1185304…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…_dir variable didn’t have the path separator at the end. Bug fixed #1181887. Changed page tracking used to hold the… file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t running. Bug fixed #1185304…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3… from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I have three nodes on VM…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… little known goodie from Percona Toolkit for MySQL called pt-query-digest. One customer was suffering from periods of high load…-format profile, to get just the ranking of queries. To my luck, one query stood out right away, always appearing many times… during peaks. Rewriting that query (actually the customer removed it altogether, by merging it with another query that ended up having a much…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… declines as data growth (which is expected) and by the end of 5 hours averages at 2700 tps. With TokuDB we also see a drop, and by end of 5 hours the average throughput is 7800 tps. Something… join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See part two for handling massive… –query-log-stdin command-line option for accepting a never-ending stream of queries to playback. Read-only playback Using the –session-init-query… is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode are, by definition, read-only transactions… boxes. You can find setup/config details at the very end of this post. Hardware: HP ProLiant DL380 G6 (8cores/16… non-trivial amount of updates to the database, all SELECT queries, even those participating in read-only transactions, start suffering from…
