Is there a way (perhaps by using PhpMyAdmin?) to see which MySQL database is
getting the most queries on a server?
getting the most queries on a server?
-
-
Re: MySQL busiest database
M. wrote:[color=blue]
> Is there a way (perhaps by using PhpMyAdmin?) to see which MySQL database is
> getting the most queries on a server?
>
>[/color]
Take a look at the command mysqladmin. Specifically the processlist.
mysqladmin -uUSERNAME -pPASSWORD processlist
You could pipe the results into "wc -l" to count the lines it returns
(which includes 4 lines for the formatting). Hope this helps.
--
-Calico Jack-
Comment