…fragmented. I also would note there are some MySQL optimizer restrictions in how well it can …of indexes. The indexes can’t fit in memory anymore. How does this affect performance? A: Typically…usage. Q: Is the b+ tree innodb index a single or double linked list at the leaf nodes? your slide showed…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance …be dedicated to RDS, not shared with the general usage of AWS as you get on normal EC2 …the line is steady enough to show that we did not cross a dramatic memory-to-disk threshold, as …
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail…There will be another blog post about the usage and performance of the splitter. It is… data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G …
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… typically do not expect to gain much by increasing the memory. This however have to be watched carefully. Performance does not… be increasing memory is helpful to solve this problem. If it is IO bound (high IO system utilization, low CPU usage) one… very IO bound showing 100% IO subsystem utilization on 5% of CPU usage ? This is the true challenge becomes because MySQL has no…
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 45 Comments
…the PK column comment_ID with a unique index: mysql> show create table wp_comments\G *************************** 1. row *************************** Table: wp_comments…+———-+ 1 row in set (1.19 sec) mysql> and the buffer pool usage: Total memory allocated 589194920; in additional pool allocated …
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… that table must be created on disk instead of in memory, in such case Disk_tmp_table will state that. Filesort… USAGE The final part are the InnoDB usage statistics. MySQL currently allows you to see many per-session statistics for operations with SHOW SESSION… entire buffer pool, because it could take a lot of memory to map all the pages. The inaccuracy grows with the…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… instead of how many systems they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the …few rows to show search results which does not require too much IO capacity or high in memory fit. … want your runaway logs or extreme temporary space usage to stop the database, but they usually can …
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…metrics, more scalability on many cores, and better memory usage. We choose features and fixes based on … do. documentation Improvements to SHOW INNODB STATUS. We’ve added more memory information and lock information, … plugin for existing MySQL-5.1.30 installation http://www.percona.com/mysql/5.1.30/…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… the data bigger than buffer pool (right graph shows CPU usage) The workload emulates TPC-C and has … (no thinking time, no keying time), it uses MySQL C API and the server side prepared statement…. performance drops when data does not fit in memory. Attention!(Windows only): You should not use with …
Comment: Neat tricks for the MySQL command-line pager
June 23, 2008 By 13 Comments
… My most frequent usage of “pager” is “vim -” and then manipulate the … database from a SHOW TABLE STATUS. (Useful when you need to calculate how much memory to allocate for …[17];END{print $i}’ mysql> pager ./index_size.sh PAGER set to ‘./index_size.sh’ mysql> show table status; 71680 mysql> nopager…
