… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…’s take a look at the graphs have a better view of the whole picture. Note, in the above graph, we…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… in years.” Darren Cassar called it “one of the best MySQL conferences since I started attending four years ago,” while Marco… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and….tv for your viewing pleasure anytime. Sheeri Cabral also recorded some of the breakout sessions, so watch Planet MySQL for an announcement…
Post: Speaking at POSSCON
March 23, 2012 By 1 Comment
… XtraDB Cluster. If you want to get a birds eye view about Open Source software Percona has created this is a…
Comment: MariaDB 5.3 is released as GA!
March 7, 2012 By 17 Comments
… would say MariaDB is seriously underrepresented on places like planet mysql. (Ie possibly real MariaDB usage must be higher than what…’t see the problem distros have with the MySQL model. Contrary to common belief MySQL maintenance releases have never included new features… whereas MySQL also fixes non-security bugs like server crash, wrong result or just performance regressions. From my point of view the…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
Hello All – I have created a backup of my mysql database using the innobackupex-1.5.1 command. I have … get the database in my /var/lib/mysql folder. But I am able to view/access ONLY MYISAM table – but none of…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 53 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 12 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_…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL… ‘dpkg –configure -a’ would cause MySQL to shut down. The MySQL package scripts for Debian force MySQL stop/start upon completion and unlike…
