June 19, 2013

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 17, 2013 By 3 Comments

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

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Comment: Sample datasets for benchmarking and testing

June 17, 2013 By 18 Comments

the links here are useful and informative…

Filed Under: Insight for Developers, MySQL Tagged With: ,

Comment: Performance Schema overhead

June 12, 2013 By 22 Comments

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.

Filed Under: Benchmarks, Hardware and Storage, Insight for DBAs, MySQL

Comment: How to calculate a good InnoDB log file size

June 14, 2013 By 38 Comments

According to this link, https://mariadb.atlassian.net/browse/MDEV-4662 Jesper is correct and I am wrong: when InnoDB warns about not enough space in the logs, it’s overwritten its last checkpoint. Thanks to Jeremy Cole for finding out the truth.

Filed Under: Insight for DBAs Tagged With: ,

Comment: Converting Character Sets

June 12, 2013 By 22 Comments

… – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a column that has a data type of…

Filed Under: Insight for Developers Tagged With: , ,

Post: ZFS on Linux and MySQL

May 24, 2013 By 17 Comments

… just normal.  We didn’t try too hard to … penalty.  You can easily run a server with hundreds of snapshots.  With LVM, …with InnoDB, with MyISAM you‘ll have to start the snapshot while holding a “flush tables with read lock…, I allocated mirror pairs using drives from different controllers.  That…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Comment: Sphinx search performance optimization: multi-threaded search

May 24, 2013 By 10 Comments

Hi Robert, – you don’t actually need to merge sphinx indexes – it does that on the fly. If you are using sphinxql, you can actually just…, you can create a virtual index with type = distributed that has all the local indexes “merged”. See here for some explanation. And btw, you…

Filed Under: MySQL Tagged With: , , ,

Post: Migrating between MySQL schemas with Percona Xtrabackup

June 10, 2013 By 2 Comments

…, you can utilize the –export flag during the –apply-logs phase and then re-import those files to a running server.  However, you need to have existing table structures in place.  Fortunately, this can be done easily using mysqldump –no-data. Now, enough with the theory…

Filed Under: Insight for DBAs, MySQL Tagged With: , , ,

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

June 7, 2013 By Leave a Comment

…tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With…log data being sent down to the lower-level slaves. You can also use…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, MySQL Webinars Tagged With: , , ,

Post: Experiences with the McAfee MySQL Audit Plugin

May 23, 2013 By 4 Comments

…t get significant differences between either output option, or between using the plugin or enabling the general log…you can control if it gets written on not with this list. I tested this with “connect,Quit” to log…objects (tables, according to the docs) for which you want events written to the log. -…

Filed Under: Insight for DBAs, MySQL Tagged With: ,
« Older Posts
Newer Posts »