… of the database to see which tables are referenced the most, and which are candidates for dropping (why keep old data… any host:port or schema name information. Viewing SchemaSpy output A completed Relationships view of these three tables should look like this: Final Thoughts While I find the Relationships tab the most useful…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… to the presentation, it’s currently up and available for viewing over at percona.com. My apologies if we weren’t… comes with DRBD. When you run a virtual machine, in most cases your virtual disk is basically nothing more than a…? A: I have to admit that this was probably the most interesting question asked; my initial reaction was, honestly, why would…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… InnoDB scalability is the trx_list scan on consistent read view creation. It was originally reported as a part of MySQL… transaction states to determine which transactions are seen in the view later. To this end, InnoDB scans trx_list (i.e… to benefit from that optimization, you basically want all or most of your transactions to be read-only. Sometimes you may…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
… is still much more common than even the most popular NoSQL database when viewing indicators such as inclusion in LinkedIn bios Oracle… Aslett’s summary of 451 Research’s database survey by viewing the research report “451 Research database survey points to MySQL… a single web page, complete the Keynotes Recordings form To view the keynote recordings without slides, visit the Percona MySQL YouTube…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… #49169 by avoiding the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read… fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally reported as upstream…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… #49169 by avoiding the malloc call in the read_view_create_low() in most cases. This significantly improves InnoDB scalability on read… fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally reported as upstream…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
… (and means) to migrate to PXC. Expect high level over view of PXC architectures with use cases (and anti-use cases… from the MariaDB Galera Cluster team, but they are certainly most welcome. I’d really like to focus this BoF on…
Post: Derived Tables and Views Performance
August 31, 2006 By 16 Comments
…, ie forgotten join condition you might have EXPLAIN running forever. Views on other hand do not have to be materialized and… set (1 min 40.86 sec) Query using view is fast again: mysql> create view v as select * from test; Query OK… way to write the query it will be faster in most cases. In many cases even separate temporary table will be…
Post: How to find wrong indexing with glance view
August 21, 2008 By 27 Comments
… spotted with a glance view. If you have queries with multiple column restrictions in WHERE clause you most likely will need to…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… benchmarks already and this post is not for you. For most people, managing a database server during its lifetime comes down… MySQL, … . Restarting and changing MySQL version might just be the most critical operations you ever do once server is moved into… availability, which means that what you could wish for the most are quick and problem free restarts and upgrades (or downgrades…
