… just for new connections as in MySQL. This is very helpful for … # Filesort: No Filesort_on_disk: No Merge_passes: 0 # InnoDB_IO_r_ops… of tmp tables created in memory vs on-disk, percentage of queries that…_one `.`wp_options`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT option_name, option_value FROM…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: How many partitions can you have ?
December 5, 2009 By 19 Comments
… large MySQL data warehouse had the table which was had data merged into …PARTITION p800000 VALUES LESS THAN(800001), PARTITION p900000 VALUES LESS THAN(900001), PARTITION p1000000 VALUES LESS THAN(1000001) ); I used MySQL…10 seconds for 1 partition vs 52 seconds for 1000 partitions (the table_cache …
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
…matches among the most current data. You would merge the delta index with the main index periodically…. SSD drives: one for the Windows partition, and one for the MySQL data partition. I performed all the tests…post where I announced the webinar: We evaluated MySQL vs Solr. I was able to index all …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 141 Comments
…accessed data stored in different servers), multi-server partitioning to use combined memory and a lot … The times for full table scan vs range scan by index: mysql> select count(pad) from large; +————+ | count(pad) | … is on a way) – MySQL can’t do hash join or sort merge join – it only can …
