Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

This is probably just my total lack of MySQL expertise, but is it typical to see lots of phantom activity on a MySQL instance via phpMyAdmin?

I have a shared hosting plan through Lithium, and when I log in through the phpMyAdmin console and click on the 'Status' tab, it's showing crazy high numbers for queries. Within an hour of activating my account I had > 1 million queries. At first I thought this was them setting things up, but the number is climbing constantly, averaging > 170/second.

I've got a support ticket in with Lithium, but I thought I'd ask here if this were a MySQL/shared host thing, because I had the same thing happen with a shared hosting plan through Joyent.

share|improve this question

migrated from stackoverflow.com Dec 31 '10 at 17:09

This question came from our site for professional and enthusiast programmers.

3  
First Guess: They're showing activity for the entire system. Second Guess: Somebody's trying to hack your db. –  jnpcl Dec 30 '10 at 21:26
    
Yeah, the support ticket came back and he said that it's for the whole server. Anyone have any idea how to get stats for just your databases? –  LoveMeSomeCode Dec 30 '10 at 23:30

1 Answer 1

I have shared hosting with the same provider and I see the same thing (currently showing 178 queries per second). I would imagine that jnpcl is correct and the activity shown is for all accounts on the same MySQL server as you.

Edit:

Anyone have any idea how to get stats for just your databases?

This ticket suggests it is not possible.

share|improve this answer
    
Yeah, looks like it. But then again, since mysql was acquired I notice they have a commercial edition, so maybe stuff like that will he implemented but not in the free edition. –  LoveMeSomeCode Dec 31 '10 at 0:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.