We are experiencing this freezing issue as well on FreeBSD 7.1 with MySQL 5.1.32. Its a pretty high traffic… make the server stop and restart. We were running FreeBSD 7.0 and MySql 5.0 and never saw this issue. Any….cnf: skip-name-resolve max_connections = 2000 skip-innodb log-bin = /usr/mysql/logs/mysql-bin.log binlog-do-db=tp server-id…
Comment: Improved InnoDB rw_lock patch
November 19, 2008 By 3 Comments
… innodb_rw_lock patch. I was close to loosing my trust in FreeBSD before applying the patch. Running our 7G InnoDB database on MySql 5.0.67 on FreeBSD 7.0 on…
Post: xtrabackup-0.7 (RC)
May 21, 2009 By 4 Comments
… it. Changelist includes: – use O_DIRECT by default for handling InnoDB files – use posix fadvise call to disable OS caching of… recovery of double buffer Also we added binary builds for FreeBSD 7 64bit platform You can download current binaries (64bit) RPM… Mac OS / Intel and .tar.gz for FreeBSD 7: http://www.percona.com/mysql/xtrabackup/0.7/. By the same link you…
Post: Percona Server 5.1.50-rel12.1
October 14, 2010 By 2 Comments
… on MySQL 5.1.50. New Features Added: innodb_lru_dump_restore – Implemented automatic dumping of the buffer pool at specified intervals. innodb… the MySQL client. (Sasha Pachev) Bug #640924 – Fixed a crash caused by innodb_doublewrite_file. (Yasufumi Kinoshita) Bug #643650 – Speeded up InnoDB shutdown… when compiling Percona Server 5.1.50-rel12.1 on FreeBSD (Oleg Tsarev) Bug #650977 – Fixed failed tests. (Oleg Tsarev) The…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
… GPL. So you can see DTrace and ZFS on Solaris, FreeBSD, MacOS, but not on Linux. However I follow the project…(find_flag=? ) innodb_srv_conc_enter_innodb(trx=? ) srv_conc_enter_innodb(trx=0x2aaaaaddb8b8 ) innodb_srv_conc_exit_innodb(trx=? ) srv_conc_exit_innodb(trx=0x2aaaaaddb8b8…_conc_force_exit_innodb(trx=0x2aaaaaddb8b8 ) Again, this case is maybe too simple, but basically you can intersect internal MySQL function and…
Comment: What's the recommended MySQL version?
February 8, 2012 By 24 Comments
… completely successful for me. I upgraded mysql 5.0.90 to 5.5.20, on FreeBSD 8.1. All of the databases have MyISAM tables. I don’t believe I had any InnoDB tables. After upgrading, I can’t start MySQL 5.5 without innodb_force_recovery set. If I…
Post: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
… release is base on 1.0.6 version of InnoDB plugin. MySQL 5.1.42 as a base release Separate purge thread… crash recovery (disabled by default) Patch to dump and restore innodb_buffer_pool Fixed bugs: Bug#488315: rename columns and add…://www.percona.com/mysql/xtradb/5.1.42-9/ . Since Release 9 .tar.gz packages are available for FreeBSD. There is an…
Post: 5.0.83-build17 Percona binaries
July 28, 2009 By 19 Comments
… Community, The build 17 of MySQL with Percona patches is available. New features in the release: MySQL-5.0.83 is taken as the basis The new patch innodb_use_sys_malloc.patch is added The new patch innodb… output of SHOW INNODB STATUS and looking at the first section, SEMAPHORES. Google’s style IO – innodb_io_patches.patch FreeBSD .tar.gz…
Comment: Choosing innodb_buffer_pool_size
January 20, 2011 By 39 Comments
… mysql 5.5.8 @ freebsd 7.1. the main db is innodb, myisam is used for the mysql-system-tables(small-sized). the production-innodb…-space, the dump is about 19GB big. i know that innodb – ibdata – files will never shrink, so i have to drop… learned(thanx to your blog!) i definitely want to increase innodb_puffer_pool_size(which is set to just 386MB). my…
Post: JOIN Performance & Charsets
October 21, 2008 By 2 Comments
… performance of your queries. Take the following example, using the InnoDB storage engine: CREATE TABLE `t1` ( `char_id` char(6) NOT…, `v` varchar(128) NOT NULL, PRIMARY KEY (`char_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; CREATE TABLE `t2` ( `id` int unsigned NOT….33 to 3.12 seconds. This test was performed with MySQL 5.0.67, FreeBSD 7, on a box with 2GB RAM.
