…Stripe Status Cache ========== ========= ========== ===== ======= ====== ======= ========= 0(no name) 1.088 TB 1 (1-0-0) 2 2-2 64…Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql … what you would often get on RHEL5, Ubuntu 8.04 or similar “older” systems if you …
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… are actually written in 512 byte units (in Percona Server 5.1 and 5.5 you can customize this) while I will be talking… 1MB boundary. Recent systems like RHEL6 (not verified) and Ubuntu 10.04 (verified) would by default align to 1MB if storage does… for most cases, however here’s what I got on Ubuntu 8.04 using defaults (you would get the same on RHEL5 and…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1 19018 19018 0 -1 4202752 198731 0…469.31 0.99 # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes 0 …158.14 621.67 149.04 107.34 # InnoDB: # IO r bytes 14.81G 0 1.10G 8.69k 15.96k 910.44k…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…56:04 2010 Stack: Heartbeat Current DC: monitor (504f45ea-7aee-4fa5-b0ee-a5ac07975ce4) – partition with quorum Version: 1.0.8-…install the MySQL version in the Ubuntu repository by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL has…
Comment: 5.0.86-build19 Percona binaries
October 15, 2009 By 10 Comments
1. Does this release include a patch to start/stop query … running ubuntu 8.04 server and mysql-5.0.51a. If I move to percona-5.0.86-b19 and later decide to switch back to 5.0.51a, would it work? Thanks for you great contribution to the Mysql community.
Comment: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… problem with mysql server. here of my server detail : DELL R710, Memory :16GB, OS : Ubuntu server 11.04. I use Mysql server version 5.5. some… #innodb_flush_log_at_trx_commit = 1 #innodb_thread_concurrency = 8 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key…
