… is how one would start the memcached plugin: mysql> …Centos 6.4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql…the hood (redo logs, etc). Based on …MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
… arises how much logging impacts on performance. When we do performance audit often we log every query to find not only slow queries. A query may… CentOS release 4.7 MySQL setting There were two cases considered CPU- and IO-bound. Each case had three options: logging turned off; logging queries…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… that you already have a decent know how of LVM and snaphots and using LVM2 >= 2.02…. Base installs of Ubuntu 11.04 (Natty) and CentOS 5.7 includes packages with this feature, previous…position 336796712 mysql-bin.000022 … # at 336797160 #120223 1:59:55 server id 1 end_log_pos 336797275 Query thread…
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
… any queries ran on the slave directly we can do: [root@centos data]# mysqlbinlog mysql-bin.000002 | grep “server id 101″ | grep Query #100411 19:11:22 server id 101 end_log_pos 360 Query thread…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
… Oct-2012 Benchmark goal: Test how MySQL 5.6.7 performs …CentOS 6.3 MySQL Version: 5.6.7-RC Benchmark specification Benchmark name: tpcc-mysql…adaptive flushing still requires big log files. MySQL configuration: [mysqld] gdb innodb…_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_…
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
… our slow query log with microseconds patch so we’ll see how quickly and if it will be accepted for inclusion. How good will… so I use CentOS for production servers, which is effectively rebuild of RedHat Enterprise Version. Community Version of MySQL has all chances… new MySQL Version or you would be left without fixes. Same situation with Fedora Core actually was another reason to use CentOS…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…_flush_log_at_trx_commit=2 innodb_flush_method=O_DIRECT query_cache_size=0 query_cache_type=0 MySQL …filesystem used is XFS, and the OS installed is Centos 6.2 Table Structure Before moving on, let’… part of the PK in the second table. How does optimizer work with the different Join Algorithms …
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
…Log output to syslog is enabled by default Updated DEB and RPM packages Query log…how to install from the PPA are in the Drizzle manual. CentOS 6 packages are available from download.drizzle.org. Instructions on how…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…several benchmarks to see how Falcon performs in comparison… schema and queries are described here Used hardware CentOS release 4….MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…buffer-pool-size=1500M –innodb-log-file-size=100M –innodb…
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
…logs) execution plan (show info about query execution in slow log) InnoDB statistic (show extended InnoDB usage during query execution in slow log…CentOS and Suse RPMS / SRPMS when they’re available. Here are links to the source releases: mysql…we still need to decide how it fits into our development …
