…amazing MySQL manual, especially the option and …Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow…_nullblogpercona.commanual sql_big_selectsblogpercona.commanual sql_big_tablesblogpercona.commanual…
Comment: Disaster: LVM Performance in Snapshot Mode
February 9, 2009 By 55 Comments
…read in order to map your logical offset to the actual physical offset in the file. That means extra …in O_DIRECT mode. This can have big consequences. Look at the slow start of ext3 – it took nearly 15…a good representation of what MySQL is doing so we are currently testing xfs with MySQL. But if my …
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…of the secondary key. Even though MySQL 5.6 uses MRR to offset the effect of random access of PK,…table lineitem. Hence the reason why hash join is slow in this case, because we have to refill the…clause on a non-indexed column. They also provide big improvement in query response time when you are …
