Members   Search   Help    Register    Login   Home

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

Queries are slowing down as table grows [message #89] Mon, 21 August 2006 18:39  sergey Messages: 3 Registered: August 2006 Location: California Junior Member I am running MySQL 4.1 on RedHat Linux. The box has 2GB of RAM, it has dual 2.8GHz Xeon processors, and /etc/my.cnf file looks like this. [mysqld] ... key_buffer = 512M max_allowed_packet = 8M table_cache = 512 sort_buffer_size = 32M read_buffer_size = 32M read_rnd_buffer_size = 128M myisam_sort_buffer_size = 256M thread_cache = 32 query_cache_size = 256M I am running data mining process that updates/inserts rows to the table (i.e. I do multifield select on indexed fields, and if row is found, I update the data, if not I insert new row). Up to about 15,000,000 rows (1.4GB of data) the procedure was quite fast (500-1000 rows per second), and then it started to slow down. Now I have about 75,000,000 rows (7GB of data) and I am getting about 30-40 rows per second. Report message to a moderator

	Queries are slowing down as table grows By: sergey on Mon, 21 August 2006 18:39
	Re: Queries are slowing down as table grows By: vadimtk on Tue, 22 August 2006 05:09
	Re: Queries are slowing down as table grows By: Peter on Tue, 22 August 2006 06:02
	Re: Queries are slowing down as table grows By: sergey on Tue, 22 August 2006 12:10
	Re: Queries are slowing down as table grows By: Peter on Tue, 22 August 2006 13:00
	Re: Queries are slowing down as table grows By: sergey on Wed, 23 August 2006 11:23
	Re: Queries are slowing down as table grows By: Peter on Wed, 23 August 2006 11:55

Previous Topic:	1 union Vs. 14 separate queries
Next Topic:	slow_launch_threads

Goto Forum:

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