mysql升级后速度慢一倍_优化后mySQL运行速度慢了5倍？

我有一台带有16GB内存的Xeon 2.0Ghz服务器(12个内核)，运行Apache和mySQL的网站在InnoDB(Percona)中有大约50,000条记录。我的查询大概在0.17到0.25秒之间返回，然后我运行Percona工具mySQL优化器，上传了新的my.cnf文件，突然间相同的查询花费了1.20到1.30秒，因此延长了大约5倍。

我做错了什么？这里是我的新旧my.cnf文件“

新：

[mysqld]

default_storage_engine = InnoDB

key_buffer_size = 32M

myisam_recover = FORCE,BACKUP

max_allowed_packet = 16M

max_connect_errors = 1000000

log_bin = /var/lib/mysql/mysql-bin

expire_logs_days = 14

sync_binlog = 1

tmp_table_size = 32M

max_heap_table_size = 32M

query_cache_type = 0

query_cache_size = 0

max_connections = 200

thread_cache_size = 50

open_files_limit = 65535

table_definition_cache = 1024

table_open_cache = 2048

innodb_flush_method = O_DIRECT

innodb_log_files_in_group = 2

innodb_log_file_size = 256M

innodb_flush_log_at_trx_commit = 1

innodb_file_per_table = 1

innodb_buffer_pool_size = 12G

log_error = /var/lib/mysql/mysql-error.log

log_queries_not_using_indexes = 1

slow_query_log = 1

slow_query_log_file = /var/lib/mysql/mysql-slow.log旧：

[mysqld]

innodb_buffer_pool_size = 12000M

innodb_log_file_size = 256M

innodb_flush_method = O_DIRECT

innodb_file_per_table = 1

innodb_flush_log_at_trx_commit = 2

innodb_log_buffer_size = 16M

innodb_additional_mem_pool_size = 20M

innodb_thread_concurrency = 20

read_rnd_buffer_size=50M

query_cache_size=128M

query_cache_type=1

tmp_table_size=512M

wait_timeout=90

query_cache_limit=64M

key_buffer_size=128M

max_heap_table_size=512M

max_allowed_packet=32M

log_slow_queries

log-queries-not-using-indexes

long_query_time = 1