… I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | …indexes, and so on. As with settings and status, these set the stage for …on the system as a whole. The queries the system runs, and hence the slow query log,…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
…log_slow_timestamp_every, log_slow_sp_statements, slow_query_log_microseconds_timestamp, use_global_long_query_time. (Oleg Tsarev) Bug #673567 – Compiler could produce spurious warnings when building on…) Bug #676158 – Setting the query cache size to 512M caused test failure on low memory systems…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…OS Waits are relatively slow, and if you…30898, query id 100626 localhost root Updating update iz set pad…log flushes, read-ahead and flushing of dirty buffers. Normal reads originated from query executions are executed by threads running queries. On…by design as requiring global lock to provide …
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
…it based on slow query log, happily the server was running MySQL with slow query log with microsecond resolution so I could check exactly which update queries take…have problems picking up long_query_time when it is set online, meaning changing it via set global long_query_time=0 and restarting slave…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
…_STATISTICS but first we should enable User Statistics: mysql> SET GLOBAL userstat=on; After all this hard work we have the statistics plugin… index from the slow query log. The concept is easy to understand. pt-index-usage reads the slow query log and execute every query with EXPLAIN to…
Comment: Identifying the load with the help of pt-query-digest and Percona Server
January 4, 2012 By 3 Comments
… on Percona Server 5.5, and the other useful tidbit I found is: set global slow_query_log_use_global_control=all; Which will make the new slow log settings apply to all existing connections, not just new ones. http://www.percona.com/doc/percona-server/5.1/diagnostics/slow…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
…to building on MySQL 5…global_flush_log_at_trx_commit was added. Bug fixed: #635399. (Yasufumi Kinoshita) New variable log_warnings_silence replaced old variable suppress_log…Slow Query Log page. (Oleg Tsarev) Other Changes Additional information was added to the LOG… The XtraDB version was set to 20.0…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… failing to execute queries or make operation to swap seriously slowing down. On now legacy 32bit…innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size. If you’re…set per connection. So you can’t relay on global values if developers may use their local values to run some queries…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…can be found here and for setting up LRU dump/restore here. …Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables …Fixed: #737947 (Laurynas Biveinis) Improvements and fixes on general distribution: #806975, #790199, #782391, #802829, #…
Comment: Query Profiling with MySQL: Bypassing caches
November 26, 2008 By 6 Comments
…query uncached you need to clean these caches. for MyISAM you can do SET GLOBAL key_buffer_size=0 and when set it back to default. You can also do cat 3 > /proc/sys/vm/drop_caches on… have Slow Query log enabled with Percona Patches so you can see how many IOs query does etc. When query …
