… result in loop mysql_fetch_array (here I use PHP functions but they are common or similar for all APIs, including C). Consider table… two parameters and second one is result mode : MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT. (Also there can be used pair mysql_real_query / mysql_use_result…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
….000016 | | creating table | 0.168283 | | After create | 0.000061 | | copy to tmp table | 0.165808 | | rename result table | 46.446738 … uses MySQL when in HA mode. In HA mode there are two …table waiting to run on the same table, and as such I have reported the bug: http://bugs.mysql.com/bug.php…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_…php genconfig 20 > shards.ini Running the test For best performance, you should run the workers on one or two… pivot_results cd shard-query/ $ ./run_query < queries.sql | tee raw |./pivot_results & [1] 12359…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…results mysql> select sum(total_lines) from dashboard_customer_sales ; +——————+ | sum(total_lines) | +——————+ | 155186550 | +——————+ 1 row in set (0.64 sec) mysql…
Post: When EXPLAIN estimates can go wrong!
October 13, 2011 By 7 Comments
…table that I used for the test: mysql [localhost] {msandbox} (foo2) > show create table test_estimate \G *************************** 1. row *************************** Table: test_estimate Create Table: CREATE TABLE…And the EXPLAIN result, On 5.1: mysql [localhost] {msandbox….mysql.com/bug.php…the two …
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 Comments
…only 29 air carriers in the table: mysql> select count(*), count(distinct UniqueCarrier) from …Shard-Query includes a loader (loader.php) which can be used to… the new schema, and additionally two new test queries have been …”, but once again, the “scale-out” results are the most striking. — Q4 SELECT…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… same system. I used two baselines for comparison. First is speed of PHP Associative array. This … results will be wrong. So what is about results and how we can use them for MySQL Performance … MySQL queries. On Selecting from the table I should note MySQL is rather fast selecting from the table as …
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…to use query and external caching of result sets is generally a good … data in two separate databases in the same instance of MySQL. If …in my > Why MySQL Could be slow with Large Tables article. Deciding whether … > to crawl. > So developing you PHP applications use test database with reasonable …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…writes to about 6 tables, what version of Innodb/MySQL would you recommend? … data corruption, crashes, or wrong query results get the highest priority. We …found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a …/Mysql server for a client, upgrading their main database (from 16GB, 2 two…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… effort may well still bring its results but you may waste a lot …MySQL table for larger ones you can log only small portion of them. I usually keep one table…at the data such way we have two great benefits. First we really understand … spend a lot of time optimizing PHP code but because it takes only …
