… apache servers as well. At first I did standard tuning and query tuning but it seemed to make it worse! from once… went to the FreeBSD scheduler, since it really looked a classic old style deadlock. Actually reserches revealed that FreeBSD is historically weak… and later and the investigation was moving on two tracks: FreeBSD bugs, MySQL bugs. One of the nights I got your…
Comment: PBXT benchmarks
November 18, 2007 By 14 Comments
… the figures showing the performance details. Do you ever use FreeBSD for MySQL benchmarks? To my dismay, I noticed that the… my 1Gb RAM pentium 4 box running FreeBSD 6.2. I went through the Performance Tuning tips found at MySQL’s website…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… can work with systems that are at any level of tuning, from completely untuned to a system that’s already had a lot of expert attention. I use “tuning” in a generic way here — we focus on far more… to adapt to whatever environment I’m in — obviously a FreeBSD box is different). For example, [percona@db1 ~]$ uname -a Linux…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… Windows you do not need to do anything. On Linux, FreeBSD, Solaris you need to set innodb_flush_method=O_DIRECT… other buffers, which may have other performance benefits as well. Tuning your VM to be less eager to swap things by… pressure. But what is more important Innodb algorithms are finely tuned with consideration what is in memory and what is on…
Comment: Choosing innodb_buffer_pool_size
January 20, 2011 By 39 Comments
… question: i want to tune a big database. we recently upgrade to mysql 5.5.8 @ freebsd 7.1. the main db…
Comment: Living with backups
November 7, 2008 By 28 Comments
… easily restore a slave without them 2. Snapshot the filesystem (FreeBSD/UFS2) 3. UNLOCK TABLES 4. Mount the snapshot 5. Copy…, but if you copy my methodology there’s scope for tuning by varying the compression level if your CPUs are maxed…
Post: Back from RIT2007
April 20, 2007 By 6 Comments
… me – there were talks starting from very technical such as FreeBSD kernel tuning, Web QA or AJAX Development, number of Project Management…
Comment: FreeBSD tests
June 15, 2006 By 15 Comments
Suse is not cleanly installed, it is my everyday test server, but I did nothing special to tune it. FreeBSD was recompiled to support 2 CPU and with ULE scheduler.
