phpMyAdmin & Bloglines gripe
[imported from Bloglines]
*sigh*
Typed a blog entry (first ever in this Bloglines account), it lets me do it, click “Publish to Blog” and voila, the entry is gone and a message telling me to set something up before I can publish stuff… well that’s just great – why the hell did it let me type it in the first place?!?
Anyway, here’s the crux of what my original post was about:
phpMyAdmin and server statistics (“show status”)
I’ve been using MySQL 5.x beta’s now for a while (both the server and embedded server) and noticed that the “show status” command was returning rather odd statistics, low query counts etc. I noticed that this was also the case with the phpMyAdmin statistics page. I thought it was a bug in MySQL 5.x since it’s still in beta… so time passes, I keep installing the newer versions, same problem, never fixed.. strange!
Anyway, I realised that it’s showing session statistics vs global statistics. Examing the mysql.com documentation I found that the command now takes an argument: “show [session/global] status”.
You can fix phpMyAdmin to provide global statistics like it usually does by modifying the server_status.php file and changing the “SHOW STATUS” to “SHOW GLOBAL STATUS”.