Bonjour,

J'ai un gros probleme au niveau de la configuration de mon serveur, et n’étant pas spécialiste j'avoue ne pas savoir comment m'en sortir.

J'ai le processeur à 100% d'utilisation et la ram à 5% (48go de ram dispo)

Voila mon my.cnf

Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
 
[client]
 
port						= 3306
socket						= /var/run/mysqld/mysqld.sock
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1
 
[php-cgi]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1
 
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1
 
[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1
 
[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1
 
[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1
 
[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1
 
[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=latin1
 
[myisamchk]
character-sets-dir=/usr/share/mysql/charsets
 
[myisampack]
character-sets-dir=/usr/share/mysql/charsets
 
[mysqld_safe]
err-log						= /var/log/mysql/mysql.err
 
[mysqld]
character-set-server		= latin1
init-connect='SET NAMES  latin1'
default-character-set		       = latin1
user 						= mysql
port = 3306
socket = /var/run/mysqld/mysqld.sock
pid-file 					= /var/run/mysqld/mysqld.pid
log-error 					= /var/log/mysql/mysqld.err
basedir 					= /usr
datadir = /var/lib/mysql
skip-locking
key_buffer 				= 32M
max_allowed_packet 			= 2M
table_cache 				= 70K
sort_buffer_size 			= 1024K
net_buffer_length 			= 16K
read_buffer_size 			= 512K
read_rnd_buffer_size 		= 1024K
myisam_sort_buffer_size 	       = 16M
language 					= /usr/share/mysql/english
 
set-variable=local-infile=0
 
max_connections = 100
wait_timeout = 15
interactive_timeout = 15
 
query-cache-type = 1
 
query_cache_limit = 1024M
 
query_cache_size = 1024M
 
log-slow-queries = /var/log/mysql/slow.log
long_query_time = 5
 
log-queries-not-using-indexes = /var/log/mysql/noindex.log
 
thread_cache_size = 256
 
tmp_table_size = 5G
max_heap_table_size = 5G
 
key_buffer_size = 512M
 
join_buffer_size = 1024M
 
concurrent_insert = 2
 
low_priority_updates = 1
 
server-id 					= 1
 
tmpdir 					= /home/tmp/
 
skip-innodb
 
[mysqldump]
quick
max_allowed_packet 			= 16M
 
[mysql]
 
[isamchk]
key_buffer 				= 20M
sort_buffer_size 			= 20M
read_buffer 				= 2M
write_buffer 				= 2M
 
[myisamchk]
key_buffer 				= 20M
sort_buffer_size 			= 20M
read_buffer 				= 2M
write_buffer 				= 2M
 
[mysqlhotcopy]
interactive-timeout
Et voila un ./mysqltuner

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.44-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive -BDB -Federated -InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 1G (Tables: 482)
[!!] Total fragmented tables: 7

-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 13m 18s (10M q [13K qps], 9K conn, TX: 359M, RX: 76M)
[--] Reads / Writes: 99% / 1%
[--] Total buffers: 6.5G global + 1.0G per thread (100 max threads)
[!!] Maximum possible memory usage: 106.8G (226% of installed RAM)
[OK] Slow queries: 0% (182/10M)
[!!] Highest connection usage: 100% (101/100)
[OK] Key buffer size / total MyISAM indexes: 512.0M/155.2M
[OK] Key buffer hit rate: 100.0% (692M cached / 31K reads)
[!!] Query cache efficiency: 11.8% (669K cached / 5M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (2 temp sorts / 15K sorts)
[!!] Joins performed without indexes: 905799
[OK] Temporary tables created on disk: 0% (3K on disk / 464K total)
[OK] Thread cache hit rate: 98% (101 created / 9K connections)
[!!] Table cache hit rate: 2% (767 open / 31K opened)
[OK] Open file limit used: 2% (1K/65K)
[OK] Table locks acquired immediately: 99% (5M immediate / 5M locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
Reduce your overall MySQL memory footprint for system stability
Reduce or eliminate persistent connections to reduce connection usage
Adjust your join queries to always utilize indexes
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
*** MySQL's maximum memory usage is dangerously high ***
*** Add RAM before increasing MySQL buffer variables ***
max_connections (> 100)
wait_timeout (< 15)
interactive_timeout (< 15)
query_cache_limit (> 1G, or use smaller result sets)
join_buffer_size (> 1024.0M, or always use indexes with joins)
table_cache (> 32712)