… answers: Q: Can you compare the use of subqueries/multiple joins vs. multiple queries (e.g. temp tables)? For performance, it’s hard… SQL can produce an infinite variety of queries. The query optimizer analyzes queries for common patterns the MySQL designers know can be improved. But…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… which will allow you to stripe a TCP connection over multiple ports, and with a two-NIC bonded pair you’ll… queries in the output of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL… simple query, but it’s always possible to build something more involved if that’s what you need. Q: What MySQL HA…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… a number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For… baseline that offers the best response times (MySQL server does not use multiple threads to execute query in parallel at this point). Response… jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel…
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: Hidden columns of query_review_history table
August 28, 2012 By Leave a Comment
… can use pt-query-digest to process a MySQL slow query log and store historical values for review trend analysis into query_review_history… slow query log from the another server. Having hostname set might be useful for filtering queries in the database aggregating slow queries from multiple…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… 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: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 23 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 64 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 7 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…
