I‘ve been talking and writing a bit lately about the scaling problems I‘m seeing on fast…data. These are going to get more attention as people run into them more. I…can be done about it — and that’s where improvements to the MySQL source code are necessary. But in many cases something can…
Post: How fast is FLUSH TABLES WITH READ LOCK?
April 24, 2010 By 28 Comments
…can coexist with this. However, in practice, most tables are both read and written. The first write query to…to flush its own data to the disk during normal processing. It relies on the operating system to flush the data blocks to…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…data in memory. let’s look at the 1GB Setting: What, a performance regression? But we threw more memory at it!! How can…to be helpful. I am still getting a really solid # of hits in memcached, but the # of writes in MySQL…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… how you need to query the data. It is a hard question to answer, and sometimes I… to analyze the non-aggregated data, you can store it on the filesystem and write custom scripts to do…MySQL doesn’t tend to perform well on a data warehousing workload. The nested-loop joins are not all that fast…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to know how many physical spindles are under the box, and how fast they are. I can also get information about the all-important battery-backed write…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… simply preform select to retrieve data from table. …to use query cache ? Third party application – You can‘t change how it works with MySQL to add caching but you can…fast Query Cache is fast compared to running the queries but it is still not as fast…works great. I should write an article comparing…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…MySQL Database most people compress them – which can…data. Do we have any faster alternatives to GZIP ? There are actually quite a few but I like LZO which I…write speed to the hard drive – this means restoring from backup compressed with LZO will often be as fast…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…writes to them are actually slower than to a mechanical disk. I do not know how it is for sequential writes…to get large data manageable. MySQL Master Master Manager can help you to automate it a bit. I also like to keep tables small enough, “sharding” to…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… new features in MySQL 5.1 Q15: How frequently …write is serial so that we can see the full write speed of the disk for throughput. INNODB uses fuzzy checkpointing to commit data to…fast lookups: it can be used if the columns are the first columns in an index. I think it is sound design practice to…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…to copy files. Fast Recovery Recovery time is as fast as putting data back and standard MySQL crash recovery, and it can…can be read-write. read-only snapshots may sound good enough as you’re only going to read data anyway, but in reality read-write…
