June 18, 2013

Post: FreeBSD tests

…://wikitest.freebsd.org/MySQL before. This page recommends to use libthr instead of libthreads. The results with libthr looks better: InnoDB threads FreeBSD 6…-2.6.13-15.x86_64 NTPL Schedulers comparsion. By request I made tests with 4BSD scheduler: InnoDB threads FreeBSD 6 ULE FreeBSD 6 4BSD… 1.20 MyISAM threads FreeBSD 6 ULE FreeBSD 6 4BSD 4BSD / ULE 1 344.72 324.9 0.94 4 531.6 518.96 0…

Post: How Percona does a MySQL Performance Audit

… in — obviously a FreeBSD box is different). For example, [percona@db1 ~]$ uname -a Linux hostname.domain 2.6.18-92.el5 #1…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max…

Post: XtraDB storage engine release 1.0.6-9

… features: The release is base on 1.0.6 version of InnoDB plugin. MySQL 5.1.42 as a base release Separate….6 + XtraDB patches extensions-1.0.6, rev. 127 fails to compile on OpenSolaris” Bug #47621: change the fix of http://bugs.mysql…://www.percona.com/mysql/xtradb/5.1.42-9/ . Since Release 9 .tar.gz packages are available for FreeBSD. There is an…

Comment: PBXT benchmarks

… weird results with mysql on an 8cpu server – it performed 3!! :( times slower than on the same 4cpu server: FreeBSD-6.2/7…) CPU E5335 @ 2.00GHz (quad core) 4GB ram mysql-4.1.22/from FreeBSD ports apache+php tests done with apache benchmark…

Comment: PBXT benchmarks

… the figures showing the performance details. Do you ever use FreeBSD for MySQL benchmarks? To my dismay, I noticed that the 5… RAM pentium 4 box running FreeBSD 6.2. I went through the Performance Tuning tips found at MySQL‘s website, but it doesn…

Post: Percona and the MariaDB Foundation

… source projects, such as Apache Software Foundation, Linux Foundation or FreeBSD Foundation. A Foundation structure shows to the world there is… in Innodb Scalability, Transparency and Replication in the forthcoming MySQL 5.6 release and MariaDB for pushing boundaries with the most advanced…

Post: xtrabackup-1.1

… is built on a base of MySQL 5.1.44 with InnoDB plugin 1.0.6 Added –host option tar4ibd can treat… mysql child proc Bug #510960: innobackupex –remote-host scp doesn’t copy MyISAM files The binary packages for RHEL4,5, Debian, FreeBSD

Comment: Percona Server and Percona XtraBackup

HI In Freebsd 6.3 percona not compilling if gcc -DHAVE_CONFIG_H -I. -… file or directory *** Error code 1 Stop in /usr/mace/mysql/unp/mysql-5.0.62-percona/sql. *** Error code 1

Comment: SysBench - benchmark tool

… using sysbench for a while on a Pentium 4 running FreeBSD 6.2 and it’s been a great tool providing great… noticed that hardware components may have a substantial impact on MySQL‘s performance, especially when you choose between genuine and so…

Comment: To UUID or not to UUID ?

… becomes dramatic with 6-8 cores. Well, you probably have also seen these ones comparing MySQL in Linux and FreeBSD: http://jeffr-tech.livejournal.com/6268.html Now it seems less clear if the problem is in MySQL or in Linux, since MySQL scales fine in FreeBSD. Well, it seems that finally the…