June 18, 2013

Post: Heikki Tuuri answers to Innodb questions, Part II

… come up with “Persistent DRAM” memory device, which would offer some small amount, say 512M memory which is battery backed up just… of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main database (from 16GB, 2 two… innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory as possible to InnoDB’s buffer pool…

Post: Aligning IO on a hard disk RAID – the Benchmarks

…) CPU X5650 @ 2.67GHz Caches | 24×12288 KB # Memory ##################################################### Total | 23.59G … Locator Size Speed … I used 64 files – 1GB, 4GB and 16GB total in size with 1, 4 and…5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var…

Comment: MySQL Server Memory Usage

…, I have problem with mysql server. here of my server detail : DELL R710, Memory :16GB, OS : Ubuntu server 11.04. I use Mysql… many user acces my web, this server become very very slow. i have about 400 user active. here of my.cnf setting : [client…