…Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally…. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks…Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… of MySQL performance that still stands in the way of InnoDB scalability is the trx_list scan on consistent read view creation. It was originally reported as a part of MySQL bug #49169 and can be… scalability is the same as in the previous benchmark. The overhead of maintaining the descriptors array is negligible as compared to…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…empty transaction list when creating read views. However, the more general descriptors … start suffering from the trx_list overhead created by concurrent updates. Once we…percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally…. Bug fixed #1099387 (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks…Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 57 Comments
… solve the same problem having things more modular and using MySQL VIEWs ? mysql> create view user_counts as select user_id,count(*) cnt from… implementing MySQL VIEWs in your application, especially ones which require temporary table execution method. VIEWs can be used with very small performance overhead but…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…and the difference in the index length with all overhead is not going to be huge. I think … fragmented. I also would note there are some MySQL optimizer restrictions in how well it can deal … manage indexes on servers from DBA point of view ? Is there any management required or server does …
Post: Using XtraBackup on NFS for MySQL backups
December 9, 2010 By 6 Comments
… works great for backing MySQL up to an NFS volume, but there is a gotcha … gotcha is that NFS uses client-side caching to reduce overhead of sending data across the network. If you backup to…the logs), that other server might not have a consistent view of the data. That’s because the data might not…
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
… data but also update the view counter. For smaller single system web site with no caching the overhead may well be insignificant… BBU thousands of log flushes per second may cause significant overhead or may simply be bottleneck. If you can reduce your… you rather use existing solutions you can use memcache + another mysql instance (or simply the database which is not replicated) to…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… performance by identifying the data which has changed. Maintain materialized views with Flexviews (the primary purpose of FlexCDC). Feed search engines… and MySQL timestamps may not be flexible enough. The trigger method has a lot of problems. Triggers add a significant overhead. When…
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
…_SCHEMA.INDEX_STATISTICS table. This data collection does add some overhead to your running server, but it’s important to leave… to update our droppable_indexes view to use that information: mysql> drop view if exists droppable_indexes; mysql> create view droppable_indexes as select all…
