…server deals with an empty transaction list when creating read views. However, the more general descriptors optimization in Percona Server …–max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing… fixed #1131187 (Alexey Kopytov). Removed trx_list scan in read_view_open_now() which is another problem originally reported as upstream… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: My Sessions at Percona Live MySQL Conference and Expo 2013
April 1, 2013 By Leave a Comment
…-cluster-galera-practice-part-1 http://www.percona.com/live/mysql-conference-2013/sessions/percona-xtradb-cluster-galera-practice-part-2… (and means) to migrate to PXC. Expect high level over view of PXC architectures with use cases (and anti-use cases… idea. If you’ve considered an architecture that uses standard MySQL async replication with any kind of circular replication and multi…
Comment: 10 years of MySQL User Conferences
April 13, 2013 By 6 Comments
…. I started blogging late 2008. Till then I was doing MySQL consulting in Israel, but relatively unknown. In Feb 2009 I… guy I contacted to have my blog aggregated into planet.mysql.com. He wrote how he likes my blogging and that…, and two good friends of mine were living in Mountain View and Sunnyvale, so excellent sleepover terms. Got OK from my…
Comment: Webinar: MySQL 5.6 Performance Schema
May 16, 2013 By 5 Comments
Hi Zoe, yes – all of our MySQL webinars are recorded and available for viewing afterward. You’ll find this one here: http://www.percona.com/webinars/using-mysql-56-performance-schema-troubleshoot-typical-workload-bottlenecks
Comment: Understanding the maximum number of columns in a MySQL table
April 9, 2013 By 5 Comments
… for Drizzle, imho. I assume these limits also apply to views in MySQL? —- (This post was edited to remove profanity.)
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… be very careful implementing MySQL VIEWs in your application, especially ones which require temporary table execution method. VIEWs can be used with very…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… Unlike views which use the complete refresh method, incrementally refreshable views are not built directly from SQL. Instead, Flexviews includes a MySQL stored… from the dictionary directly to determine the contents of the view. mysql> select flexviews.get_sql( -> flexviews.get_id(‘demo’,'dashboard_customer…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
… more complete view of how the Storage Engine API is called. But back to what the above strace shows. In MySQL 5…_type(). In MySQL 5.1, for some reason yet unknown to humans, it lives in sql/sql_view.cc as mysql_frm_type(). What this code snippet does is: open the FRM read 10 bytes (“header”) check if it’s a view…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… constantly referring to the amazing MySQL manual, especially the option and variable reference table. But …sizeblogpercona.commanual tx_isolationblogpercona.commanual unique_checksblogpercona.commanual updatable_views_with_limitblogpercona.commanual Uptimeblogpercona.commanual Uptime_since_flush_…
