Why is the volume of queries on my database so high?

Asked by:
canfmach / 30 Points
Time:
2013-06-11 1:42 pm EST
Category:
Databases
Hits:
357
When I open phpMyAdmin and look at the "status" tab, my query statistics seem very abnormal. It says there are 21,000 questions per minute since startup, with over 500 million total (200 million this weekend only).

My page is technically up, but not really public yet, so no one should know about the existence of any of this. Are these queries internal somehow?

I noticed that in addition to the database I made manually there is something called "information_schema". Maybe that has something to do with it.

Thanks

To ask this user for more information, please first login.

To submit an answer, please login.

Best answer chosen by User

1

ScottM
Staff
8,833 Points
2013-06-11 1:55 pm EST
Hello canfmach,

Your hits are likely from bots. If your site is accessible via web browser, then it is up and live, even if it has not been formally introduced to the world via a search engine. You may want to check your stats to see if your site was visited by the bots. You may also want to create and use a robots.txt file to control it. This should help reduce unwanted bot traffic for your site.

Best Regards,
Scott M

To submit a comment on this answer, please first login.

Thanks for your answer.

I did see access from bots. I am somewhat familiar with "robots.txt", but didn't know there was a way to bar them specifically from querying the database.

The number of hits on my page from bots is nowhere near the number of queries on my database though,
canfmach
30 Points

2013-06-11 2:03 pm EST
Hello canfmach,

There will rarely be a 1:1 ratio for visits to database hits. One single page crawl can end up with many database queries. Another possible cause could be runaway queries via code, which causes extraneous database hits. Checking the code to ensure the queries are correct and optimized and even caching can help with reducing hits on the database.

Best Regards,
Scott M
ScottM
8,833 Points
Staff
2013-06-11 3:02 pm EST
Want to share this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!

Help Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.)
Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.