…mysql_query uses mysql_store_result C library call and buffers all result set in the process memory. Not good if there are…mysql_query , mysql_fetch_row simply reads data from memory and so most applications do not care to check if there are any errors while fetching. With mysql…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…are now available There are now demonstration AMI images for Shard-Query. Each image comes pre-loaded with the data used in the previous Shard-Query…query command, called pivot_results cd shard-query/ $ ./run_query < queries.sql | tee raw |./pivot_results…
Post: Handling big result sets
June 26, 2006 By 13 Comments
…there can be used pair 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…
Post: Apache PHP MySQL and Runaway Scripts
May 20, 2008 By 20 Comments
…check if script continues to run. ignore_user_abort was set to FALSE for running these tests. Tests were done with PHP…if PHP script is aborted). UPDATE: There are some comments saying experimenting with sleep() function is wrong and if I would use real MySQL queries…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…are right, bugs that cause data corruption, crashes, or wrong query results get the highest priority. We are…mysql.com/bug.php… second if there are dirty pages…for every log entry? HT: No. Q34 I’m just trying to see if there…for Mysql you will still need some memory for…ll check with Alexander or check…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…query and external caching of result…there are other benefits. Also – if you’re replicating from a master to a slave, there is no…PHP applications use test database with reasonable > amount of data in it. And do run EXPLAIN for your queries, especially > if…
Post: MySQL Prepared Statements
August 2, 2006 By 19 Comments
…queries/sec when results are served from query cache. So there are good reasons to use prepared statements: Save on query…Check…there is great future ahead for MySQL Prepared statements – many of the problems such as extra round trip, non working query…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
…For example if it takes you 30 seconds to generate the search results…queries causing the problem you see the ones which cause the most impact and focus on optimizing them. There are…there are no hiccups. Check the stats from the application above for example: mysql…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
…check peak performance of all caches compared to MySQL…there are…for certain object or if you cache on different level (ie single object constructed from multiple query results) MySQL Query…query cache enabled, memcached running, apc enabled for cli mode etc. Main PHP File: global.php…
Post: Caching techinques
August 8, 2006 By 11 Comments
…There are cases when file cache works pretty well – for example caching full page results in files can be extremely efficient, especially if…MySQL Query Cache works by removing all queries derived from the table if…
