Mysql vraag

[Verwijderd]

Ik heb een vraag ik host nu een site maar het vraagt heel veel mysql resources maar ja dat is logisch voor een forum

hoe kan ik nu de sleep time verkorte dat ie im meteen disconnect, weet iemand dit

alvast bedankt...

=============================================
1 root localhost aussiecelebs Sleep 85 Edit Delete KILL
2 root localhost aussiecelebs Sleep 60 Edit Delete KILL
3 root localhost aussiecelebs Sleep 32 Edit Delete KILL
4 root localhost aussiecelebs Sleep 89 Edit Delete KILL
5 root localhost aussiecelebs Sleep 7 Edit Delete KILL
6 root localhost aussiecelebs Sleep 55 Edit Delete KILL
7 root localhost aussiecelebs Sleep 27 Edit Delete KILL
8 root localhost aussiecelebs Sleep 30 Edit Delete KILL
9 root localhost aussiecelebs Sleep 427 Edit Delete KILL
10 root localhost aussiecelebs Sleep 9 Edit Delete KILL
11 root localhost aussiecelebs Sleep 110 Edit Delete KILL
12 root localhost aussiecelebs Sleep 18 Edit Delete KILL
13 root localhost aussiecelebs Sleep 50 Edit Delete KILL
14 root localhost aussiecelebs Sleep 72 Edit Delete KILL
15 root localhost aussiecelebs Sleep 16 Edit Delete KILL
16 root localhost aussiecelebs Sleep 91 Edit Delete KILL
17 root localhost aussiecelebs Sleep 203 Edit Delete KILL
71 root localhost aussiecelebs Sleep 18 Edit Delete KILL
77 root localhost aussiecelebs Sleep 286 Edit Delete KILL
80 root localhost aussiecelebs Sleep 41 Edit Delete KILL
82 root localhost aussiecelebs Sleep 224 Edit Delete KILL
131 root localhost aussiecelebs Sleep 47 Edit Delete KILL
138 root localhost aussiecelebs Sleep 81 Edit Delete KILL
140 root localhost aussiecelebs Sleep 7 Edit Delete KILL
150 root localhost mysql Query 0 SHOW PROCESSLIST Edit Delete KILL
=============================================

[Verwijderd]

in je my.cnf moet je ff wat pielen

code:

...
set-variable    = wait_timeout=120
...

zou het moeten verhelpen

[Verwijderd]

draai unix waar kan ik dan my.cnf vinden

heb locate my.cnf gedaan maar niet gevonden ??

nader info graag, bedankt...

[Verwijderd]

http://www.mysql.com/doc/O/p/Option_files.html

et voilá

/etc/my.cnf | Global options
DATADIR/my.cnf | Server-specific options
defaults-extra-file | The file specified with --defaults-extra-file=#
~/.my.cnf | User-specific options