Members   Search   Help    Register    Login   Home

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

mysql going to sleep/sbwait while executing slow query [message #472] Mon, 18 December 2006 09:04  firestorm Messages: 9 Registered: September 2006 Location: Moscow Junior Member We use mysql for creating inverted index files for our small scientific search engine. We have a lot of XML files, indexate them to one big (50mln) mysql table. Then we create tables and files using group by similar rows (for example: insert ignore into table (field1, fieldCount) select field,count(*) from table_temp group by field order by field) So sometimes this query doesn't work with no errors: Using command top and iostat I see, that mysql is working, but without using processor (memory and HDD) resources. MySQL is in state sbwait (waiting for data!!??) Mysql command show processlist shows, that NULL query is executing. Mysql logs are ok - no problems. Parent process (php script, that executed query) is working, also without using resources. Does everybody know, where is the problem? Report message to a moderator

	mysql going to sleep/sbwait while executing slow query By: firestorm on Mon, 18 December 2006 09:04
	Re: mysql going to sleep/sbwait while executing slow query By: Peter on Mon, 18 December 2006 12:19
	Re: mysql going to sleep/sbwait while executing slow query By: firestorm on Tue, 19 December 2006 15:19
	Re: mysql going to sleep/sbwait while executing slow query By: firestorm on Tue, 19 December 2006 15:30
	Re: mysql going to sleep/sbwait while executing slow query By: Peter on Tue, 19 December 2006 16:21
	Re: mysql going to sleep/sbwait while executing slow query By: firestorm on Tue, 19 December 2006 17:37
	Re: mysql going to sleep/sbwait while executing slow query By: firestorm on Tue, 19 December 2006 17:26
	Re: mysql going to sleep/sbwait while executing slow query By: firestorm on Tue, 19 December 2006 18:03
	Re: mysql going to sleep/sbwait while executing slow query By: Peter on Wed, 20 December 2006 04:41

Previous Topic:	Degree of Separation Calculation
Next Topic:	Need advise of tuning mysql performance for fast transaction time

Goto Forum:

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