Hi Alex/Vadim, We had install mysql-server-wsrep-5.5.20-23.4 with galera-23.2.0. When starting the second node… [Note] WSREP: 1 (ubuntu-server-129): State transfer from 0 (ubuntu-server-128) complete. Apr 1 14:14:27 ubuntu-server-129 mysqld… [Note] WSREP: 0 (ubuntu-server-128): State transfer to 1 (ubuntu-server-129) complete. Apr 1 14:14:27 ubuntu-server-129 mysqld…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… some irrelevant information): # Aspersa System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | 2.6.32-31… disabled. The tool I used was sysbench 0.4.10 that came with this Ubuntu system. I have run every fileio benchmark… on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld…
Post: Quick look at Ubuntu 6.06
June 13, 2006 By 3 Comments
… if we are using the same version of MySQL. So I used MySQL 5.0.22 and my box Dual Core Athlon 3800… better): InnoDB threads Ubuntu 6.06 Suse 10.0 Suse/ Ubuntu ratio 1 478.66 536.91 1.12 4 870.50 816….04 MyISAM threads Ubuntu 6.06 Suse 10.0 Suse / Ubuntu ration 1 466.13 429.89 0.92 4 765.19 863…
Post: Percona Server version 10
April 13, 2010 By 3 Comments
…. Since the previous release 9.1 there are following changes MySQL 5.1.45 as a basis for the release I_S…. The full list includes (karmic is new): CentOS 5 (x86_64 and i386) CenOS 4 (x86_64 and i386) Debian lenny (x86… #551379:Change SE Name at mysql start Bug #550867:5.1.45+xtradb-10 compilation fails on Ubuntu Karmic Bug #547230:Add new…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
…. MySQL 5.0 with spice of enterprise features is far from being simple and MySQL 5….see large amount of big post MySQL 4 features used at the same time….Ubuntu. Most articles speaking about MySQL for Enterprises speaking about MySQL with full pack of services from MySQL AB. Obviously this is how MySQL…
Post: Percona-XtraDB version 9.1
March 14, 2010 By 16 Comments
…tar.gz packages. New features in version 9.1: MySQL 5.1.43 is taken as the basis packages …are added. The full list includes: CentOS 5 (x86_64 and i386) CenOS 4 (x86_64 and i386) Debian lenny… Ubuntu Jaunty (x86_64 and i386) Ubuntu Intrepid (x86_64 and i386) Ubuntu Hardy (x86_64 and i386) FreeBSD 8…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1… 54us 28us 35us # Rows sent 7.15M 0 56.36k 4.19 0.99 360.95 0.99 # Rows examine 33….31 0.99 # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes 0…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
…, to do that I had to switch from CentOS 5.2 to Ubuntu 8.10, as CentOS was not able to start… IO-bound workload on all devices. For tests I used MySQL 5.4/InnoDB, and all other parameters are the same from previous… and to have the same space as FusionIO we need 4 cards (but it still will be cheaper than FusionIO), but…
Post: Virtualization and IO Modes = Extra Complexity
March 21, 2011 By 12 Comments
… page writes to 1MB file using SysBench on Ubuntu, ext4 running on VirtualBox 4.0.4 running on Windows 7 on my desktop…. I’m however getting rather bizarre results: Using fsync() pz@ubuntu:~/test$ sysbench –num-threads=1 –test=fileio –file-num=1….10ms avg: 1.11ms max: 259.69ms approx. 95 percentile: 5.31ms Threads fairness: events (avg/stddev): 33900.0000/0.00…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
…,sw=5 /dev/ice (alternatively you can specify sunit=X,swidth=Y as options when mounting the device) ext2/3/4 – mke2fs… to 1MB boundary. Recent systems like RHEL6 (not verified) and Ubuntu 10.04 (verified) would by default align to 1MB if… for most cases, however here’s what I got on Ubuntu 8.04 using defaults (you would get the same on…
