@Martin your local database is probably out-of-sync with what packages are available. pacman -Syu will update your system and probably take a long time. 
Comment: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
March 21, 2013 By 10 Comments
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… long as they don’t touch the same row. Row locks are held for modifications until the transaction commits and that takes… where rows won’t be able to be updated more than just a few times a second at best. Some things the… some poor user experience. batch writes Instead of updating global counters one at a time (from Example 1, above), how about maintaining…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… should produce updates in-place (I will use INSERT .. ON DUPLICATE KEY UPDATE statements… to run this experiment that long. So there we see the strong… is 7800 tps. Something to take into account: TokuDB results are not… checkpoint interval, as TokuDB does time-based checkpoints. These drops are quite…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…is brand-new pt-upgrade was written once long ago and not updated since. Now that we have four base…from running queries on a server. Granted, this can take a lot of disk space, but it allows …by default, so specify –iterations or –run-time to limit how long they run. There are more changes in …
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… its output looks like: ### 3579 Queries ### Total time: 3.348823, Average time: 0.000935686784017883 ### Taking 0.000269 to 0.130820 seconds to complete… minimum and maximum execution times so you will be able to see if only in certain cases query takes long time to execute, for… adding indexes often help SELECT queries but slow down INSERT/UPDATE ones. Final Note: You do not have to have patched…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… too large will increase recovery time, so in case of MySQL crash or power failure it may take long time before MySQL Server is…. This is called redo phase of recovery. It can take pretty long time and this time depends on number of variables – how large are… recovery can take quite a long time. The only way you can reduce “undo” phase is size your transactions appropriately – so updates/inserts/deletes…
Post: Drilling down to the source of the problem
November 8, 2008 By 7 Comments
… often causing even very simple queries both reads and writes taking long time to complete, with progress almost paused (dropping from thousands to… more trivial selects taking a lot of time but there were a lot of write queries taking a lot of time being… many of… auto-increment columns and general updates. The stall was not caused by row level locks too. Taking a closer look at Innodb…
Post: What is exec_time in binary logs?
January 31, 2011 By 2 Comments
…, the exec_time will look believable. But on replicas, exec_time can be completely different. Suppose you execute an UPDATE that takes one second… see a very different exec_time, such as exec_time=1000, even if the statement did not take 1000 seconds to execute. Why…, thus causing the statement to appear to have taken a long time to execute.
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… story, especially now as MySQL has triggers which can make updates very different. Also there is no way to tell you… of key_cache as it can for MyISAM. EXPLAIN may take long time In MySQL 5.0 with addition of greedy join the… is elevated, however there are still cases when it may take too long. Most practically important one is if Derived tables (selects…
Comment: How to convert MySQL's SHOW PROFILES into a real profile
September 26, 2012 By 12 Comments
I have a update query, it take long time. when check the profiler, I find the init state has almost all the time, what does it mean?
