… way here — we focus on far more than my.cnf files. In fact my.cnf files are usually one of the smallest levers we… I see here is that this is an 8-core machine, two quad-core processors at 2GHz. I also know some things about… look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf without…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
… my problems. Fyi, i’m using 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…:41 2.2 706m 172m 4764 S mysqld Below is my.cnf configuration file [mysqld] datadir=/var/lib/mysql socket=/var/lib…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… two-year old HT’ed XEONs to 32 GB, 4x quad-core AMD Opterons. Yes it helped:-). At the moment the server… dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible… Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, concurrent inserts, instrumentation, etc.). Rather than…
Comment: Innodb Performance Optimization Basics
March 21, 2013 By 75 Comments
Hello Peter, Could you help me to come out with a best my.cnf for my cpanel server which makes use of innodb engine which has got 32G and quad core? Thanks, Riyaz
Comment: 5.0.84-build18 Percona binaries
August 24, 2009 By 4 Comments
….0.82 everything work ok. It runs with the same my.cnf except innodb_fast_recovery=true. The recovery time on a… ib_logfile 20 GB innodb_buffer_pool_size on dual quad core intel E5345 32 GB RAM 3* 16*142 GB SAS…
