… UCS C250 box with 346GB of RAM , and I ran the tpcc-mysql benchmark with 500W (about 50GB …in MySQL 5.5.8. But, finally, let me show the result I got running Percona Server in optimized mode… you must have the support of big log files (>4GB) to help increase throughput. Basically, by lowering …
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… rather old box with 8GB of RAM and 4*SATA disks in RAID10…. terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row… total size out of which 1.4GB is the Index. First Lets look… TABLE which rebuilds the table or OPTIMIZE TABLE do not forget to enable …
Comment: About This Blog
December 13, 2006 By 48 Comments
… new to MySQL and was hoping you might be able to give me some tips for optimizing it. I am using MySQL for… on a dual core intel processor (2* 3.0Ghz) with 4Gb RAM using SUSE Linux. The database is large with tables upto…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…RAM I can assume I want 4GB allocated to row cache and I do not really care about how these 4GB… have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical …would be very interesting to see how these optimizations will show themselves in practice. The other …
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…4GB of memory per box doing sharding 5 years ago…. well now you can get a box with 128G of RAM…becomes bottleneck so they are using various optimizations including tricky prefetch approaches suggested by YouTube…the application is only related to the MySQL redundancy for very high quality/high scale…
