MYSQL Server Monitor

[Jackolantern]

yes those are not true queries. If you are not refreshing then you are not running queries. Hence why I always stated that I do not trust any of those numbers including the time to query.

Yeah, if you are constantly refreshing the status page to keep an eye on your queries, it is likely to be complete BS. I have heard that there are some good 3rd party MySQL monitors, though.

[Ravinos]

I just got off work and had my server running with two players logged in idle.

4 hours, 44 minutes and 4 seconds.

Traffic 1 ø per hour
Received 8,115 KiB 1,714 KiB
Sent 335 MiB 71 MiB
Total 343 MiB 73 MiB

292,849 queries

The biggest thing about this to me isn't the queries but the data being pushed back and forth. With just two clients idle I'm at 73mb an hour. That is 1.7 gigs per day.

[hallsofvallhalla]

trust me your mysql is not transfering 343 megs per 4 hours.

[Ravinos]

That is why I'd like to get a third party monitor but most seem like they can't run on remote server if you don't have shell access. Suffice to say though it's made me rethink how my scripts work and it's definitely increased performance and decreased loading times.

[Torniquet]

i cant find any that run on a local server lol... u know of any?

[jpoisson]

... this seems so senseless to have so many crons / updates when players are not logged on, or are idled.

[Torniquet]

this might help maybe

http://dev.mysql.com/doc/refman/5.0/en/ ... ation.html

[Jackolantern]

... this seems so senseless to have so many crons / updates when players are not logged on, or are idled.

The numbers they are posting are complete BS. The status page on PHPMyAdmin is complete crap. As Halls said, you are not transferring anywhere near 350MB to your MySQL. Maybe in a couple of months...maybe.

[jpoisson]

Jackolantern, I completely agree but also disagree with you in a sense. I have easily gotten my site up to 30gb data transfer between myself and 3 friends. just form my old battle system because we would go through a few thousand battles an hour each. *addiction* but yea as for their figures i doubt that it is quite accurate.

[hallsofvallhalla]

if you are going through 30gigs of data transfer then you have something waaaaaaaaayyyyyyyyyyaaaaaaaayyayayayayayayayayayayayaya offff!!!!

I can battle 10 years with 100 people and not transfer 30 gigs. Most of my queries are less than 1k per battle.