I have one dedicated server on Amazon EC2, running mysql5 in a custom ami based on alestic debian lenny, in a small instance.
Small Instance (default)* 1.7 GB memory 1 EC2 Compute Unit (1 virtual core with 1 EC2 Compute Unit) 160 GB instance storage (150 GB plus 10 GB root partition) 32-bit platform I/O Performance: Moderate
The problem is that CPU usage by MySQL never is more than 45%, with query that should use all aviable CPU, and makes queries slows.
One common query is a select where like "%word% for over 2kk rows.
The other process running on this machine is hyperic-hq-agent. Any idea to increment
[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 language = /usr/share/mysql/english skip-external-locking key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 128M innodb_buffer_pool_size = 1024M innodb_log_buffer_size = 4M innodb_flush_log_at_trx_commit = 2 innodb_thread_concurrency = 0 innodb_flush_method = O_DIRECT innodb_file_per_table = 1 transaction-isolation = READ-COMMITTED [mysqldump] quick quote-names max_allowed_packet = 16M [isamchk] key_buffer = 16M