…mysql-and-php-prodcuts-and-cart.html create dynamic main menu and sub menu using php and mysql php… $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test’,$mysql); function display_menu($parent, $level) { $result = mysql…
Comment: SimCity outages, traffic control and Thread Pool for MySQL
March 21, 2013 By 16 Comments
…MySQL connection pool handling system for the application level via a lightweight python app (using multi threading and internal queues) that accepted connections from the app (php, java, python, etc) and then passed the …
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… mongodb stats without SSH (bug 1050537) * ss_get_by_ssh.php didn’t timeout commands that hang (bug 1160611) * pmp-check… issue (bug 1024001) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state (bug 1089506) Update note: Cacti templates have to be re-imported together with the updating of ss_get_*.php scripts…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… are _no_ parallel queries (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time… go into more details (and code) here: http://mysql.rjweb.org/doc.php/partitionmaint The third use case for PARTITIONing involves 2D…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
As you probably know PHP “mysql” extension supported persistent connections but they were disabled in new “mysqli” extension, which is … while still keeping MySQL connection open, others will serve static content such as images which also does not need MySQL connection open. In optimal…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… sometimes which is obviously the problem – they take Apache Slot, MySQL Connection and other resources. I had discussion today who was thinking… connection abort from client will not be discovered. This is unfortunately very serious limitation in practice when you’re using MySQL with PHP… open another MySQL connection to kill the query which was running (otherwise query may well continue to run even if PHP script is…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
If you’re following MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If not – Here is… and caching them. Persistent Connections Ajax applications with frequent case of one query per request make persistent connections relevant again. Automatic load… like to be able to run multiple queries for multiple MySQL connections at once. For scale out applications data to generate the…
Post: Debugging sleeping connections with MySQL
February 8, 2007 By 30 Comments
… can find which connections does this process have. Here you can see it has couple of memcached connections. Few MySQL connections (to the same host, which if usually bad idea) and connection to some external web… know any debugger which can connect to PHP process or apache with mod_php and provide backtrace in PHP terms not the one for…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
… as such I have reported a bug: http://bugs.mysql.com/bug.php?id=67647 Metadata locking behaves differently for queries that… MySQL server or causing all the connections to get depleted. There are some other interesting consequences as well for application that use MySQL…, and as such I have reported the bug: http://bugs.mysql.com/bug.php?id=67873
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… application connects to the database using persistent connection technique to avoid creating new connections for every request so it just recycle old connections. The… with the name ML*. Here is the problem. Until the connection is closed those files won’t disappear, even after committing… opened a bug report to follow this issue: http://bugs.mysql.com/bug.php?id=66237
