June 20, 2013

Post: Why you don't want to shard.

… large working set – The amount of memory you require to keep your frequently… keeps the architecture still simple, and should work for most cases unless …when you are rolling through an upgrade where the schema will not … This concludes Part 1 – I hope I‘ve justified why we are not covering sharding…

Post: How Percona does a MySQL Performance Audit

…the operating parameters are. Can we suggest upgrades, rewriting queries, or whatnot? Sometimes there …I‘m on a machine with 32GB of memory and there is very little load. I see that mysqld is using 10g of memory… point I should have identified a handful of tables that really matter. That’s why I save …

Post: Different flavors of InnoDB flushing

… needed in order to test different memory/dataset size ratios. But why is it important, and how …give the biggest benefit is: Install more memory or upgrade the I/O subsystem. If you are flush list …really needed. Of course, more memory and/or a better I/O subsystem should also be helpful. (Post …

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

… | +—-+————————————————————————+——————-+ Wow. I‘m not sure if I should be…) NOT NULL DEFAULT ” ) ENGINE=MEMORY DEFAULT CHARSET… the question of why it works…upgrade before rolling it into production! Percona has tools (pt-upgrade

Post: Heikki Tuuri answers to Innodb questions, Part II

…0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs …I do not know how it is for sequential writes, like log flushes. A question is why to use a flash memory…the amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main database…

Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages

…numbers are relevant from the BUFFER POOL AND MEMORY section of SHOW ENGINE INNODB STATUS: Database pages…in progress to the disk.   I‘m not sure why this is still useful if … any kind of production MySQL server, you should be monitoring your Checkpoint age and your… reasons to consider an upgrade

Post: Group commit and real fsync

I‘ve seen few cases of customers upgrading to MySQL 5.0 and having serious… if binary log is enabled this is why this issue is trigered by enabled binary … data is only written to the drives memory and so can be lost if power … and fsync the same page and you should see how many requests/sec it is …