I'm little newbie in configuring mysql and I need some advices.
Few days ago I made little home server on Ubuntu Server 12.04 with samba, mysql 5.5, apache 2.2, PHP 5.4.6 etc.
I'm using it to sharing files per samba and hosting my local projects in PHP/MySQL - I'm programmer, and I'm often testing new solutions etc
It is working good, but INSERTS on InnoDB tables are slow as hell.
I think it is bad config in my.cnf, becouse a few months earlier I used the same computer on Windows WAMP and queries were faster...
- CPU: Intel(R) Pentium(R) 4 CPU 3.00GHz
- RAM: 1GB
- HDD: Maxtor 6L200M0 (189GiB (203GB))
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking key_buffer = 64M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 32M innodb_buffer_pool_size=512M innodb_additional_mem_pool_size=10M innodb_flush_method=O_DIRECT innodb_log_buffer_size=80M expire_logs_days = 10 max_binlog_size = 100M [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] no-auto-rehash [isamchk] key_buffer=32M sort_buffer=32M read_buffer=16M write_buffer=16M [mysqlhotcopy] interactive-timeout [myisamchk] key_buffer=32M sort_buffer=32M read_buffer=16M write_buffer=16M