… be down. Basically I have a problem regarding long running select query. A query runs for say 300 seconds and because the resultset… select query) also get hang up. If I do show processlist, the update queries show up with state =’Updating’ or some others with state =’query end’; there are also some other which show…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… seeing. But, if you can connect and run a simple query and receive a response back in a reasonable (what is…, if you see a large number of long-running queries in the output of SHOW PROCESSLIST that might be a sign that trouble… and PRM simply attempt to connect and run a simple query, but it’s always possible to build something more involved…
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 massive… is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We… looked like this (we did 39 measurements), the next graph shows chunk 4’s workload warmed up with chunk 3. The…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…_read(dberr_t*, unsigned long, unsigned long, unsigned long, unsigned long, long, unsigned long) … 31.41% 15534570 mysqld …issues around mutexes and Percona Server shows much better results Configurations and how …5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… to Dimitri’s environment. To put a long story short, the results are fairly consistent … the more general descriptors optimization in Percona Server showed fairly close results in our tests. In … of updates to the database, all SELECT queries, even those participating in read-only transactions, …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… on this SSD to run this experiment that long. So there we see the strong side of TokuDB… that is why I also show 5-minute moving averages to TokuDB. So TokuDB shows about 2.8x better throughput…buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of… perform the Incremental Backups now. Bugs Fixed: innobackupex is using SHOW MASTER STATUS to obtain binlog file and position. This could…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… have enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time=0, because if you set it to some other value say 0.1 seconds, it will miss all queries… output ranks the queries and shows the top queries with largest impact – longest sum of run time which typically (not always) shows queries causing highest…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… which was to treat long_query_time value as seconds. In effect one could only choose to log all queries to see those which take less than 1s. Now long_query_time is in microseconds and… you to see many per-session statistics for operations with SHOW SESSION STATUS, but that does not include those of InnoDB…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
…_time DESC LIMIT 100) l ORDER BY start_time which shows last queries in the end similar to tail command. If you… table to MyISAM, disable concurrent inserts and run long reporting query on the log file query execution is still proceeds. I have not… aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly feature…
