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?