…_pool_size settings: 13G, 52G, an 144G on a tpcc-mysql workload with 1000W (around 100GB of data). This combination of buffer pool… The raw results, config, and script are in our Benchmarks Wiki. Here are the graphs: 13G innodb_buffer_pool_size: In this…_buffer_pool_size: 144G innodb_buffer_pool_size: The final graph shows the difference between different settings of innodb_io_capacity for MySQL…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
Post: Get Me Some Query Logs!
November 22, 2012 By 14 Comments
… when the query itself was served out of your buffer pool memory. That’s a lot of overhead, so we need… they started with. $ full-slow-log [ -v ] [ -s seconds ] [ -c config ] -v is for verbose output. -s seconds allows you to… if you forget to give another value. -c config allows you to specify a MySQL config file other than $HOME/.my.cnf, so…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… with 16gigs or ram. Here is our my.cnf # sammple MySQL config file for very large systems. # # # This is for a large… = /tmp/mysql.sock #tmpdir =/mysql_tmp/ # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock bind… of setting memory usage too high innodb_buffer_pool_size = 8000M #innodb_additional_mem_pool_size = 80M # Set .._log_file_size to…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
Hi, My Current MYSQL Config as below. Could you please provide us suggestions to improve …_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer…_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> max_heap_table_size=128M
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… 13:21:17 InnoDB: Initializing buffer pool, size = 400.0M 120619 13:21:… on # description: mysqlchk service mysqlchk { # this is a config for xinetd, place it in /etc/xinetd.d…mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… this article can cover, and might wander into Apache, networking config, caching layers, etc. Wherever the problem is, we’ll track… and network config, etc, and I don’t see anything wrong there. So at this point, it looks like MySQL is probably…, so it’s hard to read. If the InnoDB buffer pool is set to 22GB, it’s much easier to see…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1… of 1 to 20 nodes. cd shard-query #generate a config for 20 shards (adjust to your number of nodes) php… socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… cache on SSD and I used 16GB and 10GB buffer pool sizes. I run sysbench with special distribution, not uniform, the…/benchmark:flashcache:sysbench:300mln_rows:start And short results: buffer_pool, GBRAID10 FlashCache 20% 16468.76985.47 10328.34704.36 As… I encourage you to test yourself (my full scripts and mysql config files are on Wiki page). There are binaries for CentOS…
Post: Intel SSD 910 in tpcc-mysql benchmark
September 7, 2012 By 9 Comments
…: Sep-2012 Benchmark goal: Test Intel SSD 910 under tpcc-mysql workload and compare with baseline Fusion-io ioDrive card Hardware… warm-up phase Parameters to vary: we vary innodb_buffer_pool_size: 13, 25, 50, 75GB to have different memory/data… suitable to use with MySQL / Percona Server. Link to raw results and stats Raw results, config, OS and MySQL metrics are available from…
Comment: When is it a time to upgrade memory ?
December 9, 2009 By 11 Comments
…_flush_log_at_trx_commit=2″ into the config file. The “innodb_buffer_pool_size” is set to 4Go but the whole… is my.cnf: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql max_connections=600 connect_timeout=30 wait_timeout… to about 25% of the buffer pool size innodb_log_group_home_dir = /mnt/log_mysql innodb_log_file_size=1G innodb…
