Hi I'm trying to see how many queries per second I have running in my MySQL server. I understand that the number i see (Queries per second avg) is the average since the time the MySQL Server came up. The numbers i see below do not make much sense since the number stabilizes around 47 at any given time. Uptime: 4295 Threads: 188 Questions: 203027 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.271 Uptime: 4296 Threads: 186 Questions: 203033 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.261 Uptime: 4297 Threads: 186 Questions: 203085 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.262 Uptime: 4298 Threads: 182 Questions: 203114 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.258 Uptime: 4299 Threads: 180 Questions: 203175 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.261 Uptime: 4300 Threads: 177 Questions: 203231 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.263 Uptime: 4301 Threads: 176 Questions: 203263 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.259 Uptime: 4302 Threads: 181 Questions: 203349 Slow queries: 0 Opens: 144 Flush tables: 1 Open tables: 30 Queries per second avg: 47.268
how can i ask to see the number of queries per second in at a given second or a defined period of time? thanks berber --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
