…plugable indexes etc), Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is… long time. For example Query Cache support for Prepared Statements is only fixed in MySQL …query timeouts, parallel query execution, CONNECT BY support and various performance related features. I’m not sure if MySQL…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… on “Read/Write Splitting with PHP” for Percona Webinars. If you missed … tolerance test, then the wrapper class executes the query against the master. Q: What…MySQL database for persistence, but when we measured query load with pt-query-digest, we found that 30% of the database response time…
Post: On Good Instrumentation
May 31, 2010 By 1 Comment
…queries taking 30 seconds it is clearly slow queries. If it is 10.000 queries executed and total response time… time. For example we can report time it took to execute SQL query from PHP …time for given kind of request. I see response time is coming from MySQL. I check the number of MySQL Queries…
Post: Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
March 6, 2013 By 2 Comments
… the same time. It is an interesting question: If we have N nodes, can we send queries to nodes to be executed in… parallel execution, so this is where an asynchronous call helps. What does this call do? Basically we send a query to MySQL, and…)); As conclusion, we see that using PHP with MySQLnd drivers we can execute 5 MySQL asynchronous queries in parallel against 5 different nodes of…
Post: MySQL Prepared Statements
August 2, 2006 By 21 Comments
…about archiving best performance in your application using MySQL you should learn about prepared statements. These …the time in this case. It could also reduce performance in certain cases because if you execute query …. I had a lot of problems with PHP prepared statements. It is getting better but …
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… of clode but having only couple of queries to MySQL parsing may be performance bottleneck, assuming PHP opcode cache is not used. Also… data read from database multiple times. Examining MySQL full query logs from many applications seeing several exactly same queries executed during page load is not…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…)”; $stmt = $pdo->prepare($sql); $stmt->execute($params); Radu M. asked: Q:…. Their MySQL server became CPU-bound, while their multiple PHP application servers …Unfortunately, this can be laborious and time-consuming to do code review…if you use query results in a subsequent SQL query, then you…
Comment: Slow Query Log analyzes tools
January 30, 2007 By 84 Comments
… 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 … only unique query strings with additional statistics: max_query_time, max_rows_examined, execution count [default sorting: max_query_time, max_rows_examined]…
Post: MySQL automatic data truncation can backfire
January 9, 2007 By 10 Comments
… queries would take enormous amount of time while CRC32 conflicts are really rare. Looking deep into the problem I found out PHP and MySQL are both to blame. PHP… kind of expected. What was unexpected however is how MySQL executed select queries if key value would be out of signed int range…
Comment: Slow Query Log analyzes tools
February 4, 2007 By 84 Comments
…-5 times faster than the PHP5 version according to my personal tests, depending on the log size. Usage Examples: # Filter 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…
