… 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: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… and “Run as administrator”). Select the image file (about 1.8GB .img file) and select the destination drive to write the…’ Start Percona Server [root@alarmpi ~]# systemctl start mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… database server for those things which need to be cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL… old test server having 4*7200RPM SATA hard drives in RAID10. It has 8GB of RAM and I’m running Percona Server 5… read_ahead configuration. Percona Server still allows me to enable Random Read_Ahead which is not available in MySQL 5.5 (different…
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: ALTER TABLE: Creating Index by Sort and Buffer Pool Size
June 27, 2012 By 4 Comments
… in terms of data and index size: mysql> show table status like “sbtest” \G *************************** 1. row … by sort even without this additional Percona Server feature. Lets now see with 6GB buffer … building index stage. On this box with 8GB of memory allocating 6GB to buffer pool…
Post: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
…: 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 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 118 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 21 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…
