Percona's MySQL & InnoDB performance and scalability blog
@Question: Did your innodb engine startup correctly? Seems to me that you can see any innodb dbs because of this.
Fabian, – please note that, as stated in the article, this technique only works well for highly selective … 10 groups per 10M records), then you don’t want to use this. Please see “Highly selective columns only” section for…
does/will Percona 5.6 include handlersocket? I assume it’s including the memcache nosql interface in mysql 5.6, correct?
Great article. Did you do a part 3-6? I did not see them in your posts. I would appreciate an email if you did. Thanks.
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
great write up, heres a video I did on my SSD: http://www.youtube.com/watch?v=gZJ-pPeE5lA
…of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table…to write the output to, make sure this is a directory that can then be accessed by a web server…
… simply to clone a server (for replication or migration) or migrate an existing schema to a new server. However, given the import/export functionality of…in (/tmp/snapshot/2013-06-03_11-30/orig) Get the table structures: mysqldump –no-data orig > /tmp/orig.schema.sql Create the new target database…
… 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 1… 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 perform…
…. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap file in the middle of requested LSN… between the directory and file name components in a bitmap file name could stop the server starting if the innodb_data_home_dir…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.