…queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not-using-indexes query_cache_type=1 query…mysql/mysql.sock When I start the database service that starts smoothly with a low number of connections…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 31 Comments
…connections is of course reducing number of connects which are rather expensive, even though they are much faster with MySQL…number of connections is limited you start getting connection errors which are easy to handle, in case of large number of connections allowed you may have 4000 of queries…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
… terminated after certain amount of seconds: Unlike set_time_limit() which specifies cpu time, pcntl_alarm() specifies number of wall clock seconds and… can open another MySQL connection to kill the query which was running (otherwise query may well continue to run even if PHP script is aborted…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… MySQL or PHP landscape you should have seen announcement by MySQL to develop pure PHP driver. If …page output listing all the queries, their exec times and number of rows they are returned. … Multiple concurrent queries I would like to be able to run multiple queries for multiple MySQL connections at…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…PHP applications abstraction layer is not the main performance problem, also benefit from persistent connections…MySQL you might be better of using several queries than doing complicated ones. Of course you would rather use IN() than do 100 of queries… number of indexing missing which requires queries…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…should work for most MySQL installations which allow connections as root with…. php ./setup_flexcdc.php –ini consumer.ini $ php setup_flexcdc.php setup …Query OK, 0 rows affected (0.00 sec) mysql> insert into test.demo values (1,1); Query…small number of tables, and you want to track changes on all of…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
…of simple query (single row point select) using standard statement, prepared statement and have it served from query cache. Prepared statements give 2290 queries…connection or multiple connections. Do not forget to close prepared statements – Many memory leaks reported in MySQL…number of…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…mysql_real_query / mysql_use_result or mysql_store_result, which are the same). mysqli_query with MYSQLI_STORE_RESULT (used by default) is equal mysql_query…Number of…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
…mysql and memcache” block would not be helpful. Even further I would prefer to split “mysql time” in the “connect time” and “query…number of mysql calls in addition to MySQL response time. This helps to understand if it is the issue with number of queries…to execute SQL query from PHP application side…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…PHP applications abstraction layer is > not the main performance problem, also benefit from persistent > connections…number of indexing missing which > requires queries…
