Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

MySQL Optimal Settings [message #1183] Wed, 02 May 2007 08:45  mimayls Messages: 11 Registered: May 2007 Junior Member Hi all I need all your advices regarding the performance of my Database. Our database was running fine and now it is lagging when there are more users. Let me explain We are using MySQL 4.0 1.We have tables having records more than 100,000 2.Our tables are growing by min 200 records per day 3.We have applied index for frequent usage and huge table. 4.We have modified the my.ini file to use the max resources 5.Our database server is running on a Windows 2000 server with 1 GB RAM Still , the site is lagging and the MySql database residing server is showing 100% CPU usage. So please, help me if our procedure are correct and any thing we are missing. All advices are highly valued and please help Thank you all mimayla Report message to a moderator

	MySQL Optimal Settings By: mimayls on Wed, 02 May 2007 08:45
	Re: MySQL Optimal Settings By: linuxrunner on Thu, 03 May 2007 12:22
	Re: MySQL Optimal Settings By: mimayls on Sun, 06 May 2007 02:56
	Re: MySQL Optimal Settings By: JGilbert on Tue, 08 May 2007 14:24
	Re: MySQL Optimal Settings By: mimayls on Wed, 09 May 2007 04:35
	Re: MySQL Optimal Settings By: JGilbert on Thu, 10 May 2007 09:16
	Re: MySQL Optimal Settings By: mimayls on Sat, 12 May 2007 02:29
	Re: MySQL Optimal Settings By: linuxrunner on Sat, 12 May 2007 08:39
	Re: MySQL Optimal Settings By: mimayls on Sat, 12 May 2007 09:09
	Re: MySQL Optimal Settings By: tanj on Wed, 09 May 2007 10:01
	Re: MySQL Optimal Settings By: mimayls on Thu, 10 May 2007 04:14
	Re: MySQL Optimal Settings By: tanj on Thu, 10 May 2007 09:24
	Re: MySQL Optimal Settings By: mimayls on Sat, 12 May 2007 02:25
	Re: MySQL Optimal Settings By: tanj on Sun, 13 May 2007 06:34
	Re: MySQL Optimal Settings By: mimayls on Sun, 13 May 2007 08:32
	Re: MySQL Optimal Settings By: mimayls on Mon, 21 May 2007 06:43
	Re: MySQL Optimal Settings By: tanj on Mon, 21 May 2007 06:57
	Re: MySQL Optimal Settings By: mimayls on Mon, 21 May 2007 09:25
	Re: MySQL Optimal Settings By: bambarbia on Tue, 22 May 2007 14:07
	Re: MySQL Optimal Settings By: mimayls on Wed, 23 May 2007 09:25
	Re: MySQL Optimal Settings By: bambarbia on Tue, 22 May 2007 14:18

Previous Topic:	which is fastest: a join or one big table?
Next Topic:	DISTINCT vs GROUP BY

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]