… 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 all result set in the process memory. Not…
Comment: Big Iron for tests anyone ?
March 21, 2008 By 10 Comments
… machines with 4x 875MHz and 4GB RAM, and 1 machine with 8x 1GHz CPUs with 8GB RAM. These are being …systems (ext3, jfs, xfs), a variety of storage engines (MySQL 5.0 with InnoDB is my main interest, … the benchmarking. If we use the same data sets and queries, we can compare apples with apples …
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… UCS C250 box with 346GB of RAM , and I ran the tpcc-mysql benchmark with 500W (about 50GB … we have when we disable doublewrite; that is, set innodb_doublewrite=0. Now, although throughput is not …you must have the support of big log files (>4GB) to help increase throughput. Basically, by lowering …
Post: 128GB or RAM finally got cheap
August 4, 2008 By 14 Comments
…allows to get 128GB of memory with 4GB of memory chips. This means upgrade… configure PowerEdge 2950) with 128GB of RAM for about $16000. This means talking…systems are designed to have “working set to fit in memory” to perform… becomes commodity – Quite a challenge for MySQL to take 
I have not had…
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…=950M character-set-server=utf8 default-collation=utf8_unicode_ci set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log… over 30 tables and we needed referential integrity and such, MySQL was a pathetic “option”. Yes 5.x has included triggers…
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 … following in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row *************************** Name… set (0.00 sec) So we have about 3.7GB total size out of which 1.4GB is …
Comment: PBXT benchmarks
November 29, 2007 By 14 Comments
I’ve encounterd completely weird results with mysql on an 8cpu server – it performed 3!! 
times slower than … tested 2xIntel Xeon(R) CPU E5335 @ 2.00GHz (quad core) 4GB ram mysql-4.1.22/from FreeBSD ports apache+php tests done….php results: 2 cores (kernel params.h modified with MAXCPU set to 2 and 4 to diable extra cores): 9-11…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… of RAM I can assume I want 4GB allocated to row cache and I do not really care about how these 4GB will… this however should have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical order can be… Falcon gets its own tablespace and its own set of logs. With typical for MySQL use of Databases just as directories it…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… 15K RPMS) and 32GB of physical RAM, but restricted on kernel level to 4GB to emulate case B-Tree …, which you can take there https://launchpad.net/mysql-patch/mytools What makes fractal indexes so interesting … indexes, is that you can maintain a richer set of indexes at a given incoming data rate, …
Post: Beware: key_buffer_size larger than 4G does not work
February 14, 2007 By 17 Comments
… MySQL on a system with some 64GB or RAM running MyISAM, so they set key_buffer_size to 16G… and every few days MySQL crashes. Why ? Because key_buffer_size over 4GB in size is not really supported (checked with latest and greatest MySQL Enterprise…
