Montée en charge quand sql tourne
Bonjour à tous
J'ai un fénomène curieux qui se produit
Une montée en charge extraordinaire (jusque 80 !!) d'un serveur lorsque mysql tourne.
Petite précision : de 0h00 à 09h00, ca fonctionne impec (charge : entre 0.01 et 0.35)
Taille de la bdd : > 700Mo
Serveur : PIV 3,2 GHz 40Go 512 Mb 20Mbps
Mysql : 3.23.58
mon my.cnf :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
| [mysqladmin]
password = ******
user = root
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=500
set-variable = sort_buffer=10M
set-variable = record_buffer=10M
set-variable = myisam_sort_buffer_size=256M
set-variable = thread_cache=8
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
log-bin
server-id = 1
set-variable = connect_timeout=10
set-variable = max_connections=200
skip-networking
set-variable = long_query_time=4
log-slow-queries = /var/log/mysql/slow-query.log
[safe_mysqld]
err-log = /var/log/mysql/info.log
[mysqldump]
quick
set-variable = max_allowed_packet=16M
[mysql]
no-auto-rehash
[isamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=256M
set-variable = read_buffer=2M
set-variable = write_buffer=2M
[mysqlhotcopy]
interactive-timeout |
Si qqun à une idée...
Re: Montée en charge quand sql tourne
Citation:
Envoyé par vvb
Code:
1
2
3
|
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8 |
T'as 4 CPU ?
