…into community version. The great question however why MySQL did not announce the split just now …flow in. In fact we have submitted our slow query log with microseconds patch so we’ll see how…customers we have no problem building binaries. Some Linux distributions, FreeBSD etc will also likely have …
Comment: Slow Query Log analyzes tools
February 4, 2007 By 84 Comments
… result to file php mysql_filter_slow_log.php -T=3 -eu=root –no-duplicates mysql-slow-queries.log # Start permanent filtering of all slow queries from now on: at least 3 seconds or examining 10000 rows, exclude users root and test tail -f -n 0 linux-slow.log…
Post: Percona Server 5.1.53-12.4
December 29, 2010 By Leave a Comment
… Percona Server 5.1.53-12.4 is based on MySQL 5.1.53.  New Features Added: Precompiled UDFs for… cause a crash or undefined behavior: 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 non_Linux platforms…
Comment: A (prototype) lower impact slow query log
September 28, 2012 By 12 Comments
…as a synchronization mechanism. The page for the Linux dup2() doesn’t make any guarantee, and …make a extended_slow_query_log.log.1 -> (somewhere/lese to change the folder of the rotated query log file (they …at all). However, the log folder needs to be only writable by mysql to prevent the TOCTTOU, …
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…_log_file_size=10M innodb_thread_concurrency=8 My Problem is that, day by day i see that the number of slow queries is increasing on. mysql> \s ————– mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using… socket: /var/lib/mysql/mysql.sock Uptime: 72 days 19 hours 45 min 58 sec Threads: 1 Questions: 10163302 Slow queries: 149 Opens: 149457…
Comment: Slow Query Log analyzes tools
February 4, 2007 By 84 Comments
Unfortunately the comments here do not translate the “greater than” and “less than” symbols on submit. Therefore I will use { and } as a replacement for the example above: php mysql_filter_slow_log.php -T=3 -eu=root –no-duplicates { linux-slow.log } mysql-slow-queries.log
Post: Percona Server 5.1.52-12.3
December 13, 2010 By 2 Comments
…” was sometimes reported after upgrading from MySQL 5.0. (Yasufumi Kinoyasu) Bug #643463 – …could produce spurious warnings when building on non-Linux platforms. A check is now made …queries when hits were actually occurring. (Oleg Tsarev) Bug #676146 – The development environment test of log_slow…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
…normal load – this can give you a clue if slow down happens because of extra IO pressure or …every second page cached may be helpful for point queries but does not save a lot of IO …to log files on Linux because it is not aligned. [root@DB01 mysql]# du -h ibdata* 246G ibdata1 [root@DB01 mysql]# perl …
Page: Tools
May 30, 2008 By 31 Comments
… is a great set of tools for MySQL Performance Analyses and maintainence. Must know and …slow query log. It reads bunch of different log formats and has various stats, and it was there before pt-query… with a catch of it being unavailable on Linux which limits it practical use dramatically. fincore …
Comment: Choosing innodb_buffer_pool_size
November 25, 2010 By 39 Comments
Hello, My Mysql server is heavily loaded, now 300 qps average. It uses %… server has 8GB and it has over 3GB free. The slow query log seems fine. There are very few and not frequent ones… and do not touch the disk unnecessarily. I think the linux OS caches the innodb file but can I trust on…
