…: MySQL: 3746 tps Percona Server: 3704 tps And for comparison, average throughput for 4 tables: MySQL: 3882 tps Percona Server: 6735 tps The Percona Server… in Percona Server: increase innodb_log_file_size. There are stability timeline for Percona Server with innodb_log_file_size=8GB And to…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… for MySQL Server code and various small static buffers. This is memory which you can consider used when you just start MySQL Server. The rest of memory is available for connections. For exampe with 8GB server you might have everything… to be impractical. Here is why: List of rarely considered MySQL Server Memory Requirements Thread buffers can be allocated more than once…
Post: The #1 mistake hosting providers make for MySQL servers
July 25, 2008 By 30 Comments
…you’re getting someone else to build and host your servers for you. Most hosting providers — even the big names — …gladly install 8 or 16GB of memory for you, but MySQL can’t use it because it runs in a …a hosting provider for a medium-high-end system with 8GB of RAM, and forgot to tell them 64-bit …
Post: MySQL 5.5.8 and Percona Server: being adaptive
December 20, 2010 By 25 Comments
…_files_in_group=2) for Percona Server. That gave 8GB in total size for log files (MySQL 5.5.8 has a 4GB… MySQL 5.5.8 has periodic drops here, too. The margin between Percona Server and MySQL is about 2500-2800 NOTPM (~15% difference). MySQL…=/var/lib/mysql/mysql.sock [mysqld] core basedir=/usr/local/mysql user=root socket=/var/lib/mysql/mysql.sock skip-grant-tables server_id=1 local…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 116 Comments
… quad core processor with 8gb of RAM. This server is a dedicated database server. So, my problems are, the mysql process always use 1… not sure why it happen like it. Below are my server ‘TOP’ status, as you can see cpu4 use 100% usage…_concurrency thread_concurrency = 16 set-variable=max_connections=2000 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 20 Comments
…, because those idle threads are presents in internal MySQL list objects that need to be scanned and …them for benchmarking. On the desktop, I installed Percona-Server-11.2 which I configured with the following … 32768 The desktop is running Ubuntu 10.04, has 8GB of RAM and a Core i5 CPU (dual …
Post: MySQL 5.5.4 in tpcc-like workload
April 21, 2010 By 25 Comments
….com/docs/wiki/benchmark:mysql:554-tpcc:start I took MySQL-5.5.4 with InnoDB-1.1, tpcc-mysql benchmark with 200W ( about 18GB worth of data), InnoDB log files are 3.8GB size, and run… it can be compared with Percona Server/XtraDB, so there is the same load on our server: As you see our adaptive…
Comment: Choosing innodb_buffer_pool_size
November 25, 2010 By 38 Comments
… Mysql server is heavily loaded, now 300 qps average. It uses %50 Cpu in average and just 700MB of ram. My server has 8GB…
Comment: Big Iron for tests anyone ?
March 21, 2008 By 10 Comments
…, but I’ve put in requests for some replacement DB servers at work. They’re currently running a custom/proprietary DB… 4GB RAM, and 1 machine with 8x 1GHz CPUs with 8GB RAM. These are being replaced with HP 680c blades. I… servers before they go into production. Things I want to do before I test our own in-house apps include testing MySQL…
Comment: How Percona diagnoses MySQL server stalls
March 8, 2011 By 6 Comments
We had mysql lockups on a server with 96GB ram. We had allocated an 8GB query cache – and that was a problem. Every two or three hours mysql would lock up for 20 minutes. Our server…
