Percona's MySQL & InnoDB performance and scalability blog
Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.
Great test and report Vadim! I think the performance schema will be a great addition to MySQL once it’s more established. Just starting with MySQL after retiring from handling oracle databases – now volunteering 
Thanks for sharing.
we use sphinx to our website where we have about 1200 tables each with … described here, but the search results have gone from milliseconds to more than 43 seconds
Please post your experience on Percona XtraDB Cluster (PXC) on AWS. I would help us since we want to explore this option.
… to 6.4, upgrading your distribution to 6.4 may break your cluster. In this post I will explain you how to fix your cluster in case it breaks after a distribution upgrade that implies an update of pacemaker from 1.1.7 to… system to 6.4 on one server… NOTE: In production you should put the cluster in maintenance mode before the update, see bellow how to…
…to create this once so that the command line is shorter and neater. In my case here is the properties file in use for my… column names in tables, and tables with the string NULL instead of the actual SQL NULL…tools you use and how do they compare with SchemaSpy? Feel free to answer via the comments…
… conference in Budapest, Hungary. My presentation will provide an overview of some possible deployment and scaling scenarios, when it makes sense to use… see in our consulting practice. Please let me know if you plan on attending – and also feel free to post questions in advance…
…correlated, derived tables, scalar subqueries) and we saw in my presentation that sometimes these perform worse …writing a SQL query optimizer and see how easy it is? ;-) Generative grammars like SQL can … recognizes, and which are left to the developer to refactor manually. There could also …
… of using GTIDs is to have much easier failover than with file-based replication. We will see how to change the replication topology… file in the datadir). So the last executed event is 219be3a9-c3ae-11e2-b985-0800272864ba:1. How can I instruct mysqlbinlog to start… mysqlbinlog? There is a solution of course, but very poor in my opinion: look for the binlog file/position of the last…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.