… if bandwidth is constrained and the slaves lag for a bit, not so in Galera. So, let’s see this effect… to make sure that the multicast address space routes to my Galera replication interface, eth1: [all nodes]# ip ro add dev….192.0.11, so we’ll add this to our my.cnf: wsrep_provider_options = “gmcast.mcast_addr=239.192.0.11… DOWN:62 KB/s UP:187 KB/s eth1 DOWN:64 KB/s UP:186 KB/s eth1 DOWN:62 KB…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/mysqld is a 64-bit build, if I’m on a 64-bit OS. Examining MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep -v ‘^#’ /etc/my.cnf | grep . My goal here is to look at the my.cnf without…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… space in data dictionary. More complicated tables can take a bit more. So innodb_open_files does not affect performance a… value would be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil… value would be 64. InnoDB: You may need to raise the value of innodb_max_files_open in InnoDB: my.cnf So we…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… available in 32 and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on a micro instance, simply decrease the values in the /etc/my.cnf file….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…(lucid) Kernel | 2.6.32-31-server Architecture | CPU = 64-bit, OS = 64-bit # Processor ################################################## Processors | physical = 2, cores = 12, virtual = 24…Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… completed? HT: A query thread normally posts about 64 page read requests per a readahead. The InnoDB … help performance (keeping data smaller) or can a bit slow it down. Plus there were bunch of … is: set innodb_flush_method=O_DIRECT in my.cnf, to prevent double buffering. Configure as much memory …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…_lm bogomips : 4788.59 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: I tested MySQL-5… scalability fixes for buffer_pool (split_buffer_pool_mutex patch). my.cnf is [mysqld] user=root binlog_cache_size=1M default_table… lot database fits “in-memory” cases – but on other hand 64-128GB RAM per box is not something rare already and…
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 10, 2011 By 38 Comments
… some other Perl/Python vendor and is sometimes limited. (The 64-bit MySQL Python module is only available if you bought a… been 5.1 for some time. And indeed /etc/mysql/my.cnf also drives me nuts (wikimedia uses an empty file in…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… advantage of persisting across machine restarts. The configuration variables for my.cnf have been kept for compatibility and warnings will be printed… to a server crash. Bug Fixed: #627189 (Yasufumi Kinoshita). The 64-bit CAS implementation may lead to a server crash on IA32…
