… the Percona Live MySQL Conference and Expo next week in Santa Clara, California so look for me there – I’d love to connect… caches hot. (See my Fosdem 2013 slides for information about discarded designs and benchmarks.) First, we set long_query_time to 0 in order to log every query. (See part two for handling massive slow…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
…. Thanks again to Kyle Oppenheim at Groupon. And one more reminder that I’ll be at the Percona Live MySQL Conference and Expo… a solution for keeping the caches of a MySQL standby server hot using MySQL slow logs with long_query_time set to 0. Here are a… to logs. Flushing tables can impact running queries. Disable MySQL slow logs during rotation Flushing logs takes time. Meanwhile, queries are still being executed. To prevent MySQL…
Post: Return of the Query Cache, win a Percona Live ticket
August 26, 2011 By 4 Comments
… again, and time for another TGIF give-away of a Percona Live London ticket! But first, what’s new with the MySQL query cache? You… into the query cache and the interface between it and MySQL. It’s now possible to completely disable it, for example. This used to be… in SHOW PROCESSLIST to “Waiting on query cache mutex” when the query cache mutex is taken. This makes it really obvious when the query cache is a…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… comes to compare it to MySQL Query Cache – It performs faster than Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to MySQL MySQL Query Cache… caching, support of time to live (so you do not get cache invalidated with each update) and ability to cache composed objects which may correspond to multiple MySQL queries. On…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… using database at all. MySQL did not have replication or transactions at that time but it was easy to understand fast and free… sites. As response to these things few things happen – MySQL kept being “simple” and introduced relatively simple performance boosters – Query Cache and Replication, which…
Post: Living with backups
November 6, 2008 By 28 Comments
… over random I/O coming from MySQL, but also such large I/O requests take significant time to complete and the way typical… which converts into slower queries execution and significantly degraded performance. Anything else? All modern systems usually use caching of whatever is being…
Post: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
… same time? What alternative approach should be taken? Caching should be seen more as a burden that many applications just can’t live… long_query_time=0 and use mk-query-digest to capture queries. Run them through MySQL‘s EXPLAIN command. Do your queries SELECT *, only to use subset…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
…to MySQL 5.0. By serious I mean several times performance difference not just 5-10% you often see for simple queries due to… have this problem and we have to live with it, most likely MySQL 5.0 and 5.1 … better to get battery backed up cache unit and make sure you set your RAID cache policy to “write…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… you need to come up with different consistence guaranty and semantics… and believe me most of Web applications could live with it… Statements in MySQL 4.1 which came without query cache support but even worse not all of statements could be prepared not to mention… stays where for very long time. For example Query Cache support for Prepared Statements is only fixed in MySQL 5.1 and Most of…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
…to come to Percona Live straight from MySQL Connect or cutting their stay short on one of event. This was unfortunate timing…to dramatically increase performance of complicated join queries. MySQL…
