… 2 X quad core processor with 8gb of RAM. This server is a dedicated database server. So, my problems are, the mysql process always use 1 cpu core at 1 time and it used 100% of… is my.cnf configuration file [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main database (from 16GB… two-year old HT’ed XEONs to 32 GB, 4x quad-core AMD Opterons. Yes it helped:-). At the moment the server…_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc…
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
… a 3 weeks long 24×7 research. MySQL 5.0.81 on FreeBSD 7.0 4 quad core Xeon 16gb I was just hired by a web company and they experienced mysql crazy cpu loads… under monitoring all the parameters I could think of, and mysql processes showed in issue periods multiple copies of the same…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… CPU standpoint 2*Dual Core CPUs seems to do very well, while with even just two Quad Core CPUs scalability issues can be… you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb… about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM…
Comment: Big Iron for tests anyone ?
March 21, 2008 By 10 Comments
… HP 680c blades. I’ve specced them at 4x quad core Intel Xeons (16 cores all up), with 32 or 64 GB of… 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: 128GB or RAM finally got cheap
August 4, 2008 By 14 Comments
… check Dell Poweredge R900. This monster takes up to 4 Quad Core CPUs and has 32 memory slots, which allows to get… sockets which means 16 fast cores and 128GB of memory becomes commodity – Quite a challenge for MySQL to take 
I have not…
Comment: Heikki Tuuri to answer your in depth Innodb questions
October 1, 2007 By 51 Comments
…, etc). But the ratio of RAM used for these non-mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main database (from 16GB… two-year old HT’ed XEONs to 32 GB, 4x quad-core AMD Opterons. Yes it helped:-). At the moment the server…
Comment: Interesting MySQL and PostgreSQL Benchmarks
December 4, 2006 By 20 Comments
… they offered help in fine-tuning mysql and solaris. We have years experience with mysql on linux and we had to learn… explain that more clearly in our upcoming reviews, got some quad-cores, and getting a x4600 from sun soon for new reviews… changes to the Studio10 compiler that should increase innodb and mysql performance on solaris even more, but that was after the…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
… Quad Core E7320 Xeon, 2.13GHz, 32GB Memory, 16X2GB, 667MHz db_STRESS: 32 sessions, RW=1, dbsize = 1000000, no thinktime XtraDB: (mysql-5… able to disperse the lock using by the partitioning of MySQL. Added the following clause to the HISTORY table definition. “PARTITION…
Comment: A piece of Sun/MySQL Marketing
February 29, 2008 By 7 Comments
… was appropriately sized for this workload. We realize that typical MySQL DB boxes may be running lighter workloads that require less… benchmarks that a UltraSPARC T2 configuration can beat 4-socket quad-core Xeon both on price, performance, price/performance, watt/performance when… a lot more. It would be interesting to see how MySQL scales to address these even larger requirements. It may present…
