…, is that as you add CPUs and increase memory size, MySQL doesn’t scale as well as we would like, and… storage — specifically, the Virident tachIOn drive — has more bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price… done. You can read the full details in our Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server…
Post: Online MySQL Configuration Wizard from Percona
December 23, 2011 By 24 Comments
… new tool to help you configure and manage your MySQL servers. Our online MySQL Configuration Wizard can help you generate a good basic configuration file for a server. This MySQL tuning wizard is our answer to the commonly asked question… default configuration file for my server with 16 GB of RAM?” We have a raft of new features planned for future…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… the relevance sorting by default, adding relevance sorting to the MySQL queries would make them even slower, I’m sure. Indeed… to, either individually as you add new data to the MySQL database or else periodically batch-insert data that has changed… i3 processor, 8GB of RAM, and two SSD drives: one for the Windows partition, and one for the MySQL data partition. I…
Post: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
… performance of on-disk temporary tables. Servers usually have less RAM than disk space so those kind of partitions are very… you run a big UPDATE, INSERT or LOAD DATA INFILE MySQL send the rows to the Binary Log Cache before writing… physical memory, most likely killing system in the end. Conclusion MySQL can creates temporary files even thought those temporary files are…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
….12-0.2-desktop x86_64 Â with 96 GB RAM when the innodb_buffer_pool_size was set to anything…_pool_size estimations when the system has a lot of RAM and you want to have the largest possible innodb_buffer…
Post: 128GB or RAM finally got cheap
August 4, 2008 By 14 Comments
… (just as we usually configure PowerEdge 2950) with 128GB of RAM for about $16000. This means talking to Dell Sales rep… and 128GB of memory becomes commodity – Quite a challenge for MySQL to take 
I have not had a chance to play…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… 16G of RAM which we used for testing. Even though box had 8 cores it is little use for MySQL as only… is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query1370.50372.161.00 Query2724.63623… to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0.4Ratio Query13784.453737…
Post: Disaster: MySQL 5.5 Flushing
September 18, 2011 By 27 Comments
… typical nowadays. Hardware: HP ProLiant DL380 G6, with 72GB of RAM and RAID10 on 8 disks. I took sysbench multi-tables… it, it looks like: Basically there two stages: MySQL handles traffic and MySQL stuck. As you see stalls are very severe. There… see is related to InnoDB flushing and “sync” state. Vanilla MySQL does not provide much diagnostic there, but there couple numbers…
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… NOTPM. The throughput is about 1.33x better than in “MySQL compatible mode”, though it requires 10500MB for checkpoint age; that… is ~2x better than the best result I received with MySQL 5.5.8 (with innodb_doublewrite enabled). In summary, my…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… lab: a Cisco UCS C250 server with 384GB of RAM, powered by a Virident tachIOn 400GB SLC card. To see…_pool_size settings: 13G, 52G, an 144G on a tpcc-mysql workload with 1000W (around 100GB of data). This combination of… the difference between different settings of innodb_io_capacity for MySQL 5.5.8. Small innodb_io_capacity values are really…
