… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing… push concurrency too high Many developers will test script with multiple level of concurrency and find out doing work from 32… too much in this case throttling by having relatively short queries and introducing “sleeps” between them can be a good idea…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…_threads = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see that the… by query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL. Now… partitioning to reduce the size of the B+tree, having multiple buffer pool instances to reduce contention problems caused by buffer…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…, then worst case you could be reading the same page multiple times into the buffer pool. So considering this drawback, Batched…_size set to 6M, the query time for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5… slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5 the query time decreases when the join…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions …faster with the binary log enabled Faster queries through speedier joins, faster subqueries, and …, improvements to partitioning, and the addition of multiple InnoDB buffer pools. Best of all, …
Post: What would make MySQL Multiple Queries Usable ?
September 5, 2007 By 1 Comment
MySQL Has API to run Multiple Queries at once. This feature was designed mainly with saving network …. What would make MySQL Multiple Queries API more usable ? Allow to run queries in parallel – The great benefit of knowning all queries at once is… allow to implement it. Optimize query set The other thing you can do when you get multiple queries to execute at once you…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…-Query is an open source tool kit which helps improve the performance of queries against a MySQL database by distributing the work over multiple machines and/or multiple cores. This is similar…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances hashed by query hash. It would help… when checking query cache for match. Protection from Multiple Misses So you have item invalidated from query cache and there are multiple connection requesting the same item. What MySQL will do…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 6 Comments
… running updates. Queries or transactions containing multiple update queries which add up to long time. I would keep the maximum query length at about… per batch in multiple row insert statement or Fetching data you’re planning to update/delete and having multiple queries to delete it…=1 WHERE body LIKE “%cheap rolex%”; This query will perform full table scan in MySQL 5.0 (even if there are no…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
… me. Arrays in Prepared Statements Dealing with certain types of queries, ie queries with IN is so painful with prepared statements – I… very helpful in many cases. Multiple concurrent queries I would like to be able to run multiple queries for multiple MySQL connections at once. For scale…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… are created by FlexCDC. The refresh algorithm computes changes in multiple transactions. After each transaction it must wait for FlexCDC to… view, making it available for querying: mysql> call flexviews.enable( -> flexviews.get_id(‘demo’,'dashboard_customer_sales’)); Query OK, 0 rows affected (41…
