…; 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_timeout…-resolve skip-bdb default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries…_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I start the database service that starts smoothly…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
…) with a Percona type version of MySQL – ie one of Percona’s “improved” versions of MySQL (that is what Percona does, isn… for your help and information. I just made the MySQL, apache2 and php updates available to Debian Squeeze avalable on DotDeb.org… to everyone? Have some updates made to INNOdb tables really slowed down mySQL as measured by qps, in the last 4-6…
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 … attachment function here. # Apply filter to log file once php mysql_slow_log_parser.php mysql-slow-queries.log Options: -T=min_query_time Include only…
Post: Alternatives of PHP ?
September 9, 2006 By 28 Comments
… of XMLs into mysql database with PHP script, I was thinking about PHP alternatives. Why do I need that ? 1. PHP is slow – I’m… refresh my mind. List of my requirements: – Stable binding to MySQL, support of new protocol with prepared statement is necessary. – good… Perl, Ruby, Java, C, C++, even Python supports only old mysql protocol (am I wrong here?). Excluding Java (see my requirements…
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… connector log the queries. For example, if you are using PHP with mysqlnd, you can create a plugin that logs the… mk-query-digest’s built-in ability to decode the MySQL wire protocol, it is certainly the easiest and best solution…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… mysql_* functions directly This is probably bad but I do not like solutions proposed by original article ether. PEAR is slow as… with loosing data etc. Read more in my Why MySQL Could be slow with Large Tables article. 5. The n+1 pattern… growth it will however start to crawl. So developing you PHP applications use test database with reasonable amount of data in…
Comment: Slow Query Log analyzes tools
February 4, 2007 By 83 Comments
… slow queries executed from other users than root for at least 3 seconds, remove duplicates and save 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… users root and test tail -f -n 0 linux-slow.log | python mysql_filter_slow_log.py -T=3 -R=10000 -eu=root…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 28 Comments
… are slow or not available and you’re not dealing with timeouts properly. Or may be you have several connections to MySQL… stack trace originated from php stream functions not from libmysql or memcache.so, which means it is not MySQL or memcache connections… any debugger which can connect to PHP process or apache with mod_php and provide backtrace in PHP terms not the one for…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 20 Comments
… connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh -h… connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2.2.129 -u root dbt2 sleep 120 ./run_mysql.sh -h… 40%. I also verified the laptop (running dbt2) was not slowed down by handling all those connections. I tried generating the…
Comment: Slow Query Log analyzes tools
February 4, 2007 By 83 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
