…I have my website develop in PHP with MYSQL, these are MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_…=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not-using-indexes query_cache_type=1 query_cache_size=…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…to performance critical queries if you need. I would also note for many PHP applications …etc. Read more in my Why MySQL Could be slow with Large Tables article. 5. The…queries, especially if you see them in slow query log. If you have trouble understanding EXPLAIN or optimizing your queries…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and… time the queries and write a query log. I suggest writing out something in a standard logging format such as the slow-query-log… the queries. For example, if you are using PHP with mysqlnd, you can create a plugin that logs the queries, such as the query…
Post: Binaries of MySQL 5.0.33 Community release for AMD64 / EM64T
January 12, 2007 By 37 Comments
… more than a year ago. Great news are MySQL finally released new Community release – MySQL 5.0.33, which however as promised… (Links removed) We added one more RPM to stantard MySQL RPMs – MySQL-microslow-5.0.33-0.glibc23.x86_64.rpm This… slow-log. More info about the patch http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ http://bugs.mysql.com/bug.php…
Post: Backport of micro-time patch to mysql 4.1
October 1, 2006 By 9 Comments
… to slow-log queries. The patch allows to specify time of slow queries in microseconds and is very helpful in a fight with problematic queries. 4.1 Patch is available here (The original patch was developed by Georg Richter georg at php net)
Comment: Slow Query Log analyzes tools
March 17, 2009 By 83 Comments
[...] at MySQL Performance Blog pointed out this sweet perl script to analyze MySQL’s slow query logs. (This is supposedly a PHP [...]
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…common. > I would also note for many PHP applications abstraction layer is > not the main…etc. Read more in my > Why MySQL Could be slow with Large Tables article. Deciding …queries, especially > if you see them in slow query log. If you have trouble understanding > EXPLAIN or optimizing your queries…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
…queries or their performance. If I see 2 queries taking 30 seconds it is clearly slow queries. If it is 10.000 queries…can report time it took to execute SQL query from PHP application side, but we can’t say… response time is coming from MySQL. I check the number of MySQL Queries and it is 5x when it…
Comment: Slow Query Log analyzes tools
January 30, 2007 By 83 Comments
Dear Peter, I reimplemented the mysql_slow_log_parser in PHP in order to provide an even more filtered result. If … log file once php mysql_slow_log_parser.php mysql-slow-queries.log Options: -T=min_query_time Include only queries which took as long as min_query_time seconds… the user field [multiple] -iq=include_query Include only queries which contain the string include_query (i.e. database or table name) [multiple…
Post: mk-query-digest, query comments and the query cache
… written into MySQL log files as part of the query. This includes the general log, the binary log and the slow query log. Maatkit includes tools which interact with these logs, including mk-query-digest. This tool, in… the LAMP stack. Instrumentation-for-php collects information about the PHP process such as wall time, cpu time, mysql query times, etc, and automatically…