Help Tweaking MySQL

Posted by SuperHosterz, 01-14-2008, 05:12 AM
MySQL Takes up 80-100% cpu Please help me guys
Posted by david510, 01-14-2008, 05:21 AM
Type the following command and see if resource is taken by single/multiple databases. mysqladmin -i3 processlist
Posted by Abu Mami, 01-14-2008, 05:21 AM
What is your RAM usage? What are you running? What do your scripts do? What kind of queries are you using to access your database. I would suspect that you've got a very, very nasty query that just eats up everything. Make your queries lightweight by using the LIMIT clause. Check your indexes.
Posted by SuperHosterz, 01-14-2008, 05:29 AM
Multiple I'm not pro with Linux , Just started so I need more info on what you said , Here's top results
Posted by david510, 01-14-2008, 05:52 AM
I suggest to consult this with an Admin if it is out of your control.
Posted by SuperHosterz, 01-14-2008, 05:53 AM
I'd Like to Learn about it and wanna try it myself
Posted by david510, 01-14-2008, 06:01 AM
If the database contents are not changing at a fast pace, you can try increasing the values query_cache_limit and query_cache_size.
Posted by SuperHosterz, 01-14-2008, 02:51 PM
Made it 15M Waiting for results anymore tweak I can make?

آیا این پاسخ به شما کمک کرد؟

 پرینت این مقاله

در همین زمینه

JaguarPC reselling program?

Posted by Snoopy, 09-28-2001, 11:22 PMHi, I am looking for a good reseller program....

Bind an IP to a UID?

Posted by zawk, 06-22-2008, 11:34 AMI Finally had a question worth asking so I signed up......

Sending commands to a socket (C++)

Posted by LindonNetworks, 09-19-2008, 05:53 PMI'm trying to write an SMTP wrapper and I'm...

The Planet Monitoring System .... SSH critical status

Posted by xmlxp, 09-15-2007, 03:52 PMam recieving an email every hour from the Monitoring System...

beating my head over a php/my_sql error

Posted by star_dancer, 01-16-2008, 06:15 PMI'm getting an error and I can't figure it out. I...