…MySQL query logs. So the ability to parse memcached, Postgres, Apache…mysql Perl module that have problems. And there are certain versions of MySQL…connection over the web, else it will use a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL…MySQL is an exciting release with…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
… connections will still waste resources and add latency. The other problem with persistent connections is using too many MySQL server connections…MySQL connection open, others will serve static content such as images which also does not need MySQL connection open. In optimal configuration with Apache…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… of MySQL connections quicker than you expected but it also frequently indicates serious problems in the application. If you do not use persistent connections… could be the problem. By the way does anyone know any debugger which can connect to PHP process or apache with mod_php and…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… which is obviously the problem – they take Apache Slot, MySQL Connection and other resources. I had discussion today who was thinking Apache would kill the… are some comments saying experimenting with sleep() function is wrong and if I would use real MySQL queries this would be counted…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
… projects, such as Apache Software Foundation, Linux Foundation…with Oracle MySQL, High Quality, and small but High Value changes focused on the most pressing problems…MySQL, Percona Server, and MariaDB. We also have been open in supporting the events of other organizations including MySQL Connect…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…Apache, networking config, caching layers, etc. Wherever the problem…mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with…| Value | +———————————–+———————-+ | Aborted_clients | 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use…
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
…problem of slow down of our site with…mysql connection opened in slow HTTP connection reaches to wait_timeout and MySQL aborts those mysql connections. There were about 200 Aborted_Clients per hour in mysql…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
…with other OpenSource projects such as PostgreSQL (plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL… being only problem. There are fair amount of issues with MyISAM and generally on MySQL level which… they are connected via not very fast network you need to come up with different …
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 13 Comments
…such as a database, memcached, Apache, and so on. You can…time” means, for a given TCP connection, the time elapsed from the… protocols such as HTTP and MySQL, this is the moral …problems, so I am pretty sure it has no memory leaks or other problems… we’re happy with it and you’re happy with it, …
Comment: Why do you need many apache children ?
February 6, 2007 By 15 Comments
…apache children low you have these PHP connections almost always recycled. Plus you do not have the problem of many man thousands of connections for MySQL to handle – which is another reason people frequently avoid persistent connections…
