… can be rather expensive from performance point of view. The nasty thing with counters as they are implemented the most trivial way – they… system programming you perhaps could implement cache with such semantics and it will handle real-time counters very efficiently pushing few updates…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… fed into scripts to bring you automated reports or to perform actions such as: list users by the number of queries… MySQL usage Personally I would see a few more things implemented. A few examples to mention: per-user CPU time usage… which all currently fall under Other_commands a few MySQL performance counters broken down by users (full joins, table scans, disk temp…
Post: Derived Tables and Views Performance
August 31, 2006 By 14 Comments
… they compare in terms of performance ? Derived Tables in MySQL 5.0 seems to have different implementation from views, even though I… by view creator. What does it mean in terms of performance: Query on base table executes using index and it is… fact queries in this example behave differently is illogical and counter intuitive.
Comment: How to estimate query completion time in MySQL
April 23, 2008 By 14 Comments
Baron, Too bad this only works on unloaded server. It would be great to get performance counters for different thread in this case it would be much easier to see the progress. May be we should see if it is possible to implement such patch.
Comment: Implementing efficient counters with MySQL
July 16, 2007 By 16 Comments
[...] Implementing efficient counters with MySQL [from MySQL Performance Blog] [...]
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…MTR we are talking about. For a proper implementation for our purposes, Patrick has added preliminary … after the reset. A speculative processor might perform the read first, which could leave a… are unprotected. These are buffer pool statistics counters: number of read, written, evicted, etc. pages. …
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 12 Comments
… wrote an article about using UNION to implement loose index scan. First I should mention … during query execution – very helpful for MySQL Performance optimization: mysql> flush status; Query OK, 0 …now will show per session counter increments and to get global counters SHOW GLOBAL STATUS needs to be…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so it… them to propagate sometime. For example if I’m maintaining counter I may not want changing that to have complete invalidation… Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources to implement at least some portion of items from this list. I…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…tools as Innodb Hot Backup are required to perform backup. Are there any downsides ? Need to …snapshotting in general works. Really there are different implementations but the sake of them is to …use slave_skip_errors or sql_slave_skip_counter. Cloning master you’re starting from consistent copy…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… interactively, this is an action you should never perform on a slave. “SET GLOBAL server_id =…” You … stopping the slave, set global SQL_SLAVE_SKIP_COUNTER and start the slave again. This method is…dev.mysql.com/doc/refman/5.1/en/replication-implementation-details.html [2] http://dev.mysql.com/doc/…
