So you’re running dedicated MySQL Linux box with plenty of memory, so the good question arises … a lots of connections creating large temporary tables and so MySQL running out of memory (and getting killed by kernel). It… as much memory as possible to get last bit of performance and do not mind slowdowns if you mixedup as well…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…_64 x86_64 x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 (Tikanga) From… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up…
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
… from Ronald Bradford (here), I decide to verify and benchmark performance while varying the size of the sort_buffer. It is… quickly. The important point here, at least for the Linux, glibc and MySQL versions I used and for the test I did… Fri Apr 16 09:39:35 UTC 2010 i686 GNU/Linux MySQL: 5.1.41-3ubuntu12.6-log P.S.: Gnumerics for…
Post: Intel Woodcrest vs AMD Opteron for MySQL
June 8, 2006 By 9 Comments
… the ones I had in MySQL Performance Landscape presentation – neither of them was match to Opteron performance in MySQL workloads. As benchmark used in… has very interesting observation on MySQL Multiple CPU scalability . As you can see MySQL could be slower on Linux with many connections with…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… – run 64bit operating system. We still see people running 32bit Linux on 64bit capable boxes with plenty of memory. Do not… option has some performance benefits, especially in locking in 5.0 and even more to come with MySQL 5.1 and row… these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…
Post: Percona XtraBackup 1.6
April 12, 2011 By 15 Comments
… (Stewart Smith) Ported XtraBackup to MySQL 5.1.55, MySQL 5.5.9, Percona Server 5…_55 crashed with an assertion failure on non-Linux platforms. (Alexey Kopytov) Bug #703077 – Building …the dropped table. (Alexey Kopytov) Bug #717784 – Performing parallel backups with the –parallel option could…
Post: MySQL Binaries availability
January 19, 2007 By 9 Comments
… needed to perform the build available. Furthermore there are no vendors which will create binaries for you as happens with Linux. The… published our build of MySQL 5.0.33 for Linux x86-64. Scott has provided builds both for Linux i386 and Windows. I guess over next few months community will establish trusted sources of MySQL Builds and…
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
What is often underestimated is impact of MySQL Performance by complex queries on large data sets(ie some large … 10 seconds for directory with couple of files. In recent Linux Kernels deadline or cfq IO schedulers should be better with… suffer from table locks reporting queries can affect web site performance dramatically. Sometimes instead of using slave you may use database…
Post: Using LoadAvg for Performance Optimization
December 4, 2006 By 5 Comments
… one. What does Load Average corresponds to ? At least on Linux it is number of processes which are in “running” state… mean there are no performance problems, for example if you run single batch job on the server with MySQL, Load Average is… the box it will perform well as soon as you need to do a lot of queuing performance starts to suffer. Let…
Post: thread_concurrency doesn't do what you expect
June 4, 2012 By 3 Comments
… concurrency inside MySQL with the variable thread_concurrency. Our advice is: stop wasting your time, it does nothing on GNU/Linux 
Some of the biggest GNU/Linux distributions includes the variable thread_concurrency in their… there are hundred of MySQL tuning howtos that explain how to tune the variable to get better performance. If you have the…
