… server (your router likely has this enabled already) A quality 2GB (or more) SDHC Card I use a SanDisk 8GB Class10… mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES… the configuration file, you can find it in /etc/mysql/my.cnf If you setup Percona Server to startup at boot time…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
Post: Replaying database load with Percona Playback
October 25, 2012 By 9 Comments
…query log. The service starts with an empty my.cnf configuration so all parameters are set to their …replay the load: percona-playback –mysql-host=127.0.0.1 –mysql-user=root –mysql-schema=my_db –query-log-…we’re going to ignore that. Second try, add 2GB of InnoDB Log Files (innodb_log_file_size=1G…
Post: MySQL: what read_buffer_size value is optimal ?
September 17, 2007 By 25 Comments
… some high value. Sample my.cnf values on large memory sizes recommend 1M settings and MySQL built-in default is 128K. Some… so workload will be IO bound on the box with 2GB of memory. The was running Fedora Core i686 had 2…, with 3 runs and averaged results. MySQL 5.1.21-beta was used for tests. mysql> select count(*) from dt2 where slack…
Comment: Choosing innodb_buffer_pool_size
February 26, 2009 By 39 Comments
… 2GB /intelquad PROBLEM : i start my sql 4.0.12 with innodb_buffer_pool_size = 128 After starting the server my.cnf becomes my_cnf.bak. but randomly the configuration is reseted and all… this . I can;t migrate now to other version of mysql.
Comment: Why MySQL could be slow with large tables ?
August 21, 2006 By 141 Comments
… MySQL 4.1 on RedHat Linux. The box has 2GB of RAM, it has dual 2.8GHz Xeon processors, and /etc/my.cnf…
