[root@ns3147 init.d]# free
             total       used       free     shared    buffers     cached
Mem:        254944     248464       6480          0       5036      53624
-/+ buffers/cache:     189804      65140
Swap:       265064      29184     235880

285 processes: 284 sleeping, 1 running, 0 zombie, 0 stopped

phpBB : Critical Error  
 
Could not connect to the database  

[root@ns3147 init.d]# mysqladmin -pxxxxxxxxxxxx processlist
mysqladmin: connect to server at 'localhost' failed
error: 'User root@localhost has already more than 'max_user_connections' active connections'
[root@ns3147 init.d]# mysqladmin -pxxxxxxxxxxxx processlist
mysqladmin: connect to server at 'localhost' failed
error: 'User root@localhost has already more than 'max_user_connections' active connections'
[root@ns3147 init.d]# mysqladmin -pxxxxxxxxxxxx processlist
mysqladmin: connect to server at 'localhost' failed
error: 'User root@localhost has already more than 'max_user_connections' active connections'
[root@ns3147 init.d]# mysqladmin -pxxxxxxxxxxxx processlist
mysqladmin: connect to server at 'localhost' failed
error: 'User root@localhost has already more than 'max_user_connections' active connections'
[root@ns3147 init.d]# mysqladmin -pxxxxxxxxxxxx processlist
+------+------------+-----------+------------+---------+------+----------------+------------------------
------------------------------------------------------------------------------+
| Id   | User       | Host      | db         | Command | Time | State          | Info
                                                                              |
+------+------------+-----------+------------+---------+------+----------------+------------------------
------------------------------------------------------------------------------+
| 1143 | maxiforumw | localhost | maxiforumw | Query   | 11   | Opening table  | DELETE FROM usersonline
 WHERE date <> '2002-06-24'                                                   |
| 1152 | morpheus   | localhost | morpheus   | Query   | 9    | closing tables | SELECT attach_id
        FROM phpbb_attach
        WHERE post_id = 4103                                            |
| 1160 | maxiforu   | localhost | maxiforu   | Query   | 4    | Opening tables | SELECT username FROM ph
pbb_users WHERE user_id = 1374                                                |
| 1161 | maxiforu   | localhost | maxiforu   | Query   | 12   | closing tables | SELECT poster_id, post_
time FROM phpbb_posts WHERE post_id =27787                                    |
| 1163 | maxiforu   | localhost | maxiforu   | Query   | 4    | Opening tables | SELECT username FROM ph
pbb_users WHERE user_id = 1498                                                |
| 1170 | root       | localhost | forum      | Query   | 102  | Sending data   | SELECT t.forum_id, t.to
pic_id, p.post_time
                        FROM phpbb_topics t, phpbb_posts p
                        WHERE p.post_i |
| 1174 | root       | localhost | forum      | Query   | 93   | Locked         | UPDATE phpbb_topics
        SET topic_views = topic_views + 1
        WHERE topic_id = 5618                        |
| 1186 | morpheus   | localhost | morpheus   | Query   | 16   | Locked         | SELECT f.*, p.post_time
, p.post_username, u.username, u.user_id, t.topic_title, t.topic_id
                                FROM  |
| 1187 | root       | localhost | forum      | Query   | 67   | Locked         | SELECT t.*, u.username,
 u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_user |
| 1194 | maxiforumw | localhost | maxiforumw | Query   | 9    | Opening table  | DELETE FROM usersonline
 WHERE date <> '2002-06-24'                                                   |
| 1195 | morpheus   | localhost | morpheus   | Query   | 30   | Sending data   | SELECT t.*, u.username,
 u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post |
| 1196 | forumpeu   | localhost | forumpeu   | Query   | 9    | closing tables | UPDATE phpbb_topics
        SET topic_views = topic_views + 1
        WHERE topic_id = 1545                        |
| 1199 | root       | localhost | forum      | Query   | 28   | Locked         | SELECT t.*, u.username,
 u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_user |
| 1202 | tacheron   | localhost | tacheron   | Query   | 4    | Opening tables | SELECT u.username, u.us
er_id, u.user_allow_viewonline, u.user_level, s.session_logged_in, s.session_ |
| 1210 | morpheus   | localhost | morpheus   | Query   | 12   | Locked         | SELECT u.username, u.us
er_id, u.user_posts, u.user_from, u.user_from_flag, u.user_website, u.user_em |
| 1214 | maxiforu   | localhost | maxiforu   | Query   | 11   | closing tables | SELECT f.*, p.post_time
, p.post_username, u.username, u.user_id
                                FROM (( phpbb_forums f
                                LEFT  |
| 1215 | forumpeu   | localhost | forumpeu   | Query   | 7    | Opening tables | SELECT t.*, u.username,
 u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_user |
| 1216 | tacheron   | localhost | tacheron   | Query   | 8    | closing tables | SELECT c.cat_id, c.cat_
title, c.cat_order
                FROM phpbb_categories c, phpbb_forums f
                WHERE f.cat_id |
| 1217 | root       | localhost | forum      | Query   | 16   | Locked         | SELECT t.forum_id, t.to
pic_id, p.post_time
                        FROM phpbb_topics t, phpbb_posts p
                        WHERE p.post_i |
| 1219 | maxiforu   | localhost | maxiforu   | Query   | 9    | Opening tables | SELECT t.*, u.username,
 u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_user |
| 1220 | morpheus   | localhost | morpheus   | Query   | 11   | Locked         | SELECT t.*, u.username,
 u.user_id, u2.username as user2, u2.user_id as id2, p.post_time, p.post_user |
| 1222 | maxiforu   | localhost | maxiforu   | Query   | 1    | Opening tables | SELECT aa.forum_id, u.u
ser_id, u.username
                FROM phpbb_auth_access aa, phpbb_user_group ug, phpbb_g |
| 1225 | root       | localhost | forum      | Query   | 12   | closing tables | SELECT f.*, p.post_time
, p.post_username, u.username, u.user_id
                                FROM (( phpbb_forums f
                                LEFT  |
| 1231 | a037       | localhost | a037       | Query   | 12   | Opening tables | SELECT c.cat_id, c.cat_
title, c.cat_order
        FROM phpbb_categories c
        ORDER BY c.cat_order            |
| 1232 | a037       | localhost | a037       | Query   | 3    | closing tables | INSERT INTO phpbb_users
(user_id, username, user_regdate, user_password, user_email, user_icq, user_ |
| 1238 | forumpeu   | localhost | forumpeu   | Query   | 1    | Opening table  | UPDATE phpbb_topics
        SET topic_views = topic_views + 1
        WHERE topic_id = 1545                        |
| 1239 | tacheron   | localhost | tacheron   | Query   | 3    | Sending data   | SELECT u.username, u.us
er_id, p.*,  pt.post_text, pt.post_subject, pt.bbcode_uid
                FROM phpbb_posts |
| 1240 | morpheus   | localhost | morpheus   | Query   | 22   | Locked         | UPDATE phpbb_users
                                                SET user_session_time = 1024950577, user_session_page =
3
                                                WHERE use |
| 1274 | mophpbb    | localhost | mophpbb    | Query   | 4    | Opening tables | SELECT * FROM `mods_cat
` WHERE id_cat = '2'                                                          |
| 1281 | maxiforumw | localhost | maxiforumw | Query   | 9    | Opening tables | SELECT COUNT(*) AS mess
ages FROM privatemessage WHERE userid=623                                     |
| 1282 | a037       | localhost | a037       | Query   | 1    | Opening tables | SELECT word
                FROM  phpbb_words                                                                     |
| 1296 | sato       | localhost | sato       | Query   | 4    | Sending data   | SELECT f.*, p.post_time
, p.post_username, u.username, u.user_id
                                FROM (( sato_forums f
                                LEFT J |
| 1300 | maxiforu   | localhost | maxiforu   | Query   | 4    | Opening tables | SELECT aa.forum_id, u.u
ser_id, u.username
                FROM phpbb_auth_access aa, phpbb_user_group ug, phpbb_g |
| 1305 | forumpeu   | localhost | forumpeu   | Query   | 4    | Opening tables | SELECT a.forum_id, a.au
th_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete,  |
| 1307 | tacheron   | localhost | tacheron   | Query   | 2    | Locked         | UPDATE phpbb_users SET
user_session_time = 1024950588, user_session_page = -9 WHERE user_id = 1232   |
| 1308 | forumpeu   | localhost | forumpeu   | Query   | 4    | closing tables | SELECT SUM(forum_topics
) AS topic_total, SUM(forum_posts) AS post_total
                                FROM phpbb_forums        |
| 1312 | a037       | localhost | a037       | Query   | 9    | Opening tables | SELECT ban_email
                                FROM phpbb_banlist
        |
| 1315 | forumpeu   | localhost | forumpeu   | Query   | 3    | Opening tables | SELECT SUM(forum_topics
) AS topic_total, SUM(forum_posts) AS post_total
                                FROM phpbb_forums        |
| 1320 | tacheron   | localhost | tacheron   | Query   | 2    | Opening tables | SELECT *
                FROM phpbb_themes
                WHERE themes_id = 5                                                   |
| 1328 | a037       | localhost | a037       | Query   | 4    | Opening tables | SELECT *
                FROM phpbb_themes
                WHERE themes_id = 1                                                   |
| 1332 | maxiforumw | localhost | maxiforumw | Query   | 2    | Opening tables | SELECT user.*,userfield
.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.u |
| 1333 | visualsh   | localhost | visualsh   | Query   | 10   | closing tables | SELECT *
        FROM phpbb_config                                                                          |
| 1338 | a037       | localhost | a037       | Query   | 2    | Opening table  | UPDATE phpbb_sessions
                                        SET session_time = 1024950598, session_page = 0
                                        WHERE session_id = |
| 1339 | tacheron   | localhost | tacheron   | Sleep   | 1    |                |
                                                                              |
| 1343 | a037       | localhost | a037       | Query   | 1    | Opening tables | SELECT u.*, s.*
                        FROM phpbb_sessions s, phpbb_users u
                        WHERE s.session_id = 'b06e06d95a81bdfe83e |
| 1346 | tacheron   | localhost | tacheron   | Query   | 3    | Opening tables | SELECT *
        FROM phpbb_config                                                                          |
| 1347 | root       | localhost |            | Query   | 2    |                | show processlist
                                                                              |
+------+------------+-----------+------------+---------+------+----------------+------------------------
------------------------------------------------------------------------------+

[root@ns3147 etc]# ls my*
my.cnf
[root@ns3147 etc]# vi my.cnf

[mysqld]
set-variable = connect_timeout=10
set-variable = delayed_insert_timeout=10
set-variable = delayed_insert_limit=10
set-variable = delayed_queue_size=10
set-variable = interactive_timeout=10
set-variable = join_buffer_size=1307
set-variable = key_buffer_size=10M
set-variable = max_connections=50
set-variable = max_connect_errors=3
set-variable = max_delayed_threads=20
set-variable = max_heap_table_size=1670216
set-variable = max_tmp_tables=62
set-variable = max_user_connections=7
set-variable = net_buffer_length=16384
set-variable = net_retry_count=10
set-variable = net_read_timeout=10
set-variable = net_write_timeout=10
set-variable = query_buffer_size=10
set-variable = record_buffer=51072
set-variable = slave_net_timeout=10
set-variable = slow_launch_time=2
set-variable = sort_buffer=51072
set-variable = wait_timeout=10