473,326 Members | 2,805 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Mysql High usage Problem (help)

1
Hi people i need serious help here..

I have a forum and my hosting company suspended it cuz of the high usage of sql.
We did everything to make lower the usage but its still high.

it was

Generated in 2.0792990 seconds (18.30% PHP / 50-80 % MySQL)
MySQL Queries:152 / Global Parsing Time: 0.4743950 / Memory Usage: 4.01 MB
PHP version: 4.4.4 / Server Load: Bilinmeyen / GZip Compression: Enabled


after i go back to default settings

Generated in 2.0792990 seconds (18.30% PHP / 25-60 (smtms 70-80)% MySQL)
MySQL Queries: 22-25 / Global Parsing Time: 0.4743950 / Memory Usage: 4.01 MB
PHP version: 4.4.4 / Server Load: Bilinmeyen / GZip Compression: Enabled

what can i do any more..

thanks..
May 24 '07 #1
2 1583
pbmods
5,821 Expert 4TB
Check your queries. Really slow or (to be honest, and nothing personal) poorly-written queries tend to eat up memory and CPU time.

I'd check your slow queries log and try EXPLAINing them.

Make sure your tables are well-indexed; that really helps cut down on the number of rows MySQL has to search.
May 25 '07 #2
Atli
5,058 Expert 4TB
I'd also try to avoid the LIMIT clause where possible. It has an annoying habit of scanning entire tables even if you only ask for a couple of rows.
May 25 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Scott | last post by:
Hi, I'm having a problem with a new machine running Mysql version 4.0.18 on the AMD64 version of Mandrake 10.0. The new machine has got 64bit AMD processor and 2GB of RAM. Nearly all...
2
by: JP | last post by:
My company is considering acquisition of a packaged application that's based on My SQL. This would be our first use of MySQL and the CEO is worried about using a "no-name" database (he's a...
39
by: Mairhtin O'Feannag | last post by:
Hello, I have a client (customer) who asked the question : "Why would I buy and use UDB, when MySql is free?" I had to say I was stunned. I have no experience with MySql, so I was left sort...
1
by: Good Man | last post by:
Hi there I've noticed some very weird things happening with my current MySQL setup on my XP Laptop, a development machine. For a while, I have been trying to get the MySQL cache to work....
1
by: Damien | last post by:
Hi guys, I'm looking for ideas for troubleshooting the following. We've tried some random things to try to treat the symptoms, but none seem robust enough to use when we go live, and we'd rather...
2
by: O.L. | last post by:
Hello, On my LAMP webserver, I noticed that sometimes the MySQL daemon uses 99.99% of the CPU, and does not answer SQL queries, while several minutes. Does someone know what could be the causes...
3
by: kanna | last post by:
Hi, The following prg keeps cpu usage as 79% always .When i kill/stop the prg,then cpu comes down. main() { //code for mysql conn while(1) mysql_real_query (&mysqlcon, "SET CHARACTER SET...
0
by: Learning.Net | last post by:
I have a window application that uses ActiveX browser component for testing web site automatically using mshtml. Though application is running fine but there is abnormally high page file usage....
1
by: santhescript01 | last post by:
I have a window application that uses ActiveX browser component for testing web site automatically using mshtml. Though application is running fine but there is abnormally high page file usage....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.