Hi,
My mysql is crashing. Below table has the values it logs in the .err file
before restarting. I am using the large.cnf file.
The parameters I have changed are below. Rest are default values.
#for performance SSR
log=/var/log/mysql-queries.log
join_buffer_size=1M
max_connections=300
query_cache_size=64M
query_cache_limit=2M
#for performance SSR
ERROR LOG TABLE
===============
KBS : key_buffer_size
RBS : read_buffer_size
MUC : max_used_connections
MC : max_connections
TC : threads_connected
All values are in KB.
======================================================================
Time KBS RBS MUC MC TC TOTAL
======================================================================
10:12:17 268435456 1044480 251 300 197 875341
10:44:42 268435456 1044480 209 300 158 875341
11:38:56 268435456 1044480 176 300 124 875341
12:42:32 268435456 1044480 187 300 134 875341
13:52:07 268435456 1044480 152 300 96 875341
14:44:58 268435456 1044480 154 300 106 875341
15:07:00 268435456 1044480 150 300 94 875341
15:42:41 268435456 1044480 150 300 100 875341
17:01:44 268435456 1044480 162 300 101 875341
17:29:32 268435456 1044480 133 300 81 875341
01:04:39 268435456 1044480 155 300 107 875341
01:44:27 268435456 1044480 190 300 139 875341
03:10:32 268435456 1044480 185 300 120 875341
04:14:23 268435456 1044480 276 300 220 875341
04:33:57 268435456 1044480 204 300 152 875341
04:58:44 268435456 1044480 233 300 179 875341
05:43:09 268435456 1044480 265 300 213 875341
06:13:44 268435456 1044480 210 300 155 875341
07:08:56 268435456 1044480 186 300 133 875341
07:44:21 268435456 1044480 250 250 203 773142
08:43:03 268435456 1044480 250 250 195 773142
09:00:13 268435456 1044480 193 250 142 773142
09:18:56 268435456 1044480 286 300 235 875341
09:38:14 268435456 1044480 211 300 152 875341
09:59:23 268435456 1044480 181 300 116 875341
10:55:17 268435456 1044480 196 300 137 875341
11:17:44 268435456 1044480 154 300 99 875341
12:14:36 268435456 1044480 147 300 87 875341
12:33:16 268435456 1044480 214 300 162 875341
13:06:38 268435456 1044480 189 300 124 875341
14:21:07 268435456 1044480 164 300 100 875341
14:54:37 268435456 1044480 167 300 116 875341
15:43:06 268435456 1044480 130 300 69 875341
16:24:04 268435456 1044480 134 300 68 875341
17:37:24 268435456 1044480 126 300 78 875341
======================================================================
-Sunil Sunder Raj
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]