…with 64 300GB SAS drives, 3 raid controllers and 192GB of RAM. These servers will run a few slave…30 mirrors + spares + OS partition mirror) and I limited the ARC size to 4GB. I don’t want to…MySQL backup servers. All backup solutions have an impact on performance with ZFS the impact is up front and…
Comment: Big Iron for tests anyone ?
March 21, 2008 By 10 Comments
….11), 2 machines with 4x 875MHz and 4GB RAM, and 1 machine with 8x 1GHz CPUs with 8GB RAM. These are being replaced with HP… before I test our own in-house apps include testing MySQL with a variety of file systems (ext3, jfs, xfs), a variety of storage engines (MySQL 5.0 with InnoDB is my main interest, but I…
Post: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… test is rather old box with 8GB of RAM and 4*SATA disks in RAID10. I used 10mil … look as following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row … of which 1.4GB is the Index. First Lets look at results of Adding and Dropping column for…
Comment: What to tune in MySQL Server after installation
October 3, 2006 By 118 Comments
Is there anyway I can compile my own MySQL binaries and change this 4GB limit? We won’t be able to use MySQL 5.x for many months, and utilizing RAM is key here. This 4GB limit seems to have no place other than to cause headaches. Thanks.
Post: PHP Large result sets and summary tables.
July 6, 2007 By 8 Comments
… RAM and was swapping development server which had just 4GB of Ram (and plenty of swap space) like crazy. Why ? Because by default mysql_query uses mysql_store_result C library call and buffers…
Post: 128GB or RAM finally got cheap
August 4, 2008 By 14 Comments
… Core CPUs and has 32 memory slots, which allows to get 128GB of memory with 4GB of memory …hard drives RAID and 2 CPUs (just as we usually configure PowerEdge 2950) with 128GB of RAM for about $… means 16 fast cores and 128GB of memory becomes commodity – Quite a challenge for MySQL to take 
I …
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… the Cisco UCS C250 box with 346GB of RAM , and I ran the tpcc-mysql benchmark with 500W (about 50GB of data) on… the initial tests, I used MySQL 5.5.8 (the tar.gz binary from dev.mysql.com), and for the other tests I…_pages_pct and innodb_io_capacity and having innodb_doublewrite enabled. But you must have the support of big log files (>4GB)Â…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
… is Dell 2950 with 8CPU cores and RAID10 on 6 disks with BBU, and 32GB RAM on board with CentOS 5.2 as OS. This is quite typical server we recommend to run MySQL on… plugins statically compiled in MySQL) For benchmarks I used scripts that emulate TPCC load and datasize 40W (about 4GB in size), 20 client…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… MYISAM. My my.cnf variables were as follows on a 4GB RAM system, Red Hat Enterprise with dual SCSI RAID: [mysqld] long… so and we’re fine. MySQL, I have come to realize, is as good as a file system on steroids and nothing more… 30 tables and we needed referential integrity and such, MySQL was a pathetic “option”. Yes 5.x has included triggers, stored procedures, and such…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
… significantly slower) Few words about environment: server Dell SC1425, with 4GB of RAM and Dual Intel(R) Xeon(TM) CPU 3.40GHz. InfoBright… very limited and I had to transform files to quote each field. After that load statement is: mysql -S /tmp/mysql-ib.sock… for MonetDB and 2.92s for InfoBright. Warnings: do not try EXPLAIN this query in InfoBright. MySQL is really stupid here, and EXPLAIN…
