… state transfer) is not feasible. It also helps when node data integrity is compromised. So, naturally duration of SST is paramount…
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… memory. For the hot test, the data fits in the buffer pool and has been loaded by the cold test already. The… see the start of an interesting trend. MyISAM is faster when the data is not cached (the cold run) but is slower… is faster using MyISAM than InnoDB. Like the queries in Flight #3 that are faster using MyISAM, Q4.3 examines very little data…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… make a mistake and need to compare their old data to their current data on the current live server. Mysqldump works well… the need to scan the full tables and in turn, load that data into and pollute the buffer pool. Note that this… structures: mysqldump –no-data orig > /tmp/orig.schema.sql Create the new target database: mysqladmin create orig_old Load the schema into…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… I’ve seen situations where even under just a moderate load on the host system, DRBD can end up in a… useful if you’re trying to limit the amount of data sent over the wire, but it comes at the cost… on the intermediate server, thus resulting in less binary log data being sent down to the lower-level slaves. You can…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… (why keep old data if you don’t need to?). I get up to speed a lot faster and can contribute to…
Comment: How number of columns affects performance ?
May 25, 2013 By 12 Comments
… table or would it be faster to add a column to differentiate between my types of data and put them all in the same table. The only difference is the data type…all the rest of the columns would be the… column scenario and 16 if I had to add a data type column. We are probably looking at 2 million records…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… the space of a 2TB drive, but they are way faster than the old drives. So fast, that for linear writes… SSDs. But the newer SSDs are as big, and much faster than the 300GB HDDs, on MySQL type loads.
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… customer and I am involved with servers located in two data centers, one with Solaris servers and the other one with… production database servers and will perform the backups. The write load is not excessive so a single server can easily handle… well. The tpcc database, which contains a lot of random data that doesn’t compress well showed a compression ration of…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…. Auditing user activity in MySQL has traditionally been challenging. Most data can be obtained from the slow or general log, but… needed as the plugin needs the offset to some MySQL data structures that, the plugin authors say, aren’t exposed by… line for switching between file and socket for output): plugin-load=AUDIT=libaudit_plugin.so audit_offsets=6464, 6512, 4072, 4512…
Comment: Converting Character Sets
June 12, 2013 By 22 Comments
…/en/alter-table.html “For a column that has a data type of VARCHAR or one of the TEXT types, CONVERT TO CHARACTER SET will change the data type as necessary to ensure that the new column is…
