Se connecter
Inscription
Mot de passe perdu
Supprimer un message
antp
[mysqld]
datadir=/home/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
slow_query_log=1
slow_query_log_file=/var/log/mysql-slow.log
thread_cache_size = 20
max_connections = 50
query_cache_size = 1024M
query_cache_limit = 128M
table_cache = 512
tmp_table_size = 400M
max_heap_table_size = 400M
read_buffer_size = 10M
sort_buffer_size = 20M
read_rnd_buffer_size = 1M
ft_stopword_file=""
ft_min_word_len=3
transaction-isolation = READ-COMMITTED
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
datadir=/home/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
slow_query_log=1
slow_query_log_file=/var/log/mysql-slow.log
thread_cache_size = 20
max_connections = 50
query_cache_size = 1024M
query_cache_limit = 128M
table_cache = 512
tmp_table_size = 400M
max_heap_table_size = 400M
read_buffer_size = 10M
sort_buffer_size = 20M
read_rnd_buffer_size = 1M
ft_stopword_file=""
ft_min_word_len=3
transaction-isolation = READ-COMMITTED
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
le explain:
- id select_type table type possible_keys key key_len ref rows Extra
- 1 SIMPLE p ALL PRIMARY,poster_id NULL NULL NULL 32522 Using where
- 1 SIMPLE u eq_ref PRIMARY PRIMARY 3 antpphpbb2.p.poster_id 1 Using where
