FUDforum: Database discussions

Home » General » Database discussions » SQL Optimization (or maybe the ISP doesn't know what they are talking about)

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

SQL Optimization [message #161212]

Wed, 25 November 2009 03:47

art

Messages: 35
Registered: June 2009

Karma:

Member

Recently, my ISP complained that my database usage was too high and shut me down. This is one of the reasons they gave:

Time: 29% (7230 sec) Amount: 25% (446 queries) Rows Examined/Sent: 0 / 0 Avg. Query Exec/Lock Time: 16 / 7 sec.
use my_forum; INSERT INTO fud28_ses (ses_id, time_sec, sys_id, user_id) VALUES ('5a4f44865d9ab78f5fe9db19d3bd943c', 1258704641, '7e891bc61071df49e48390596180088c', 2142232494);

Now when I look at that, I think to myself, how in the world can a simple insert like that take an average of over 16 seconds per statement. I think it was the server, not the statement. But maybe some of you will see something I don't.

What say you?

Report message to a moderator

[Message index]

		SQL Optimization By: art on Wed, 25 November 2009 03:47
		Re: SQL Optimization By: naudefj on Wed, 25 November 2009 07:02
		Re: SQL Optimization By: art on Wed, 25 November 2009 13:47
		Re: SQL Optimization By: fudidudi on Sat, 26 December 2009 06:13

Previous Topic:	Index command denied
Next Topic:	Looking for MySQL web hosting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 17:01:11 GMT 2024

Total time taken to generate the page: 0.04711 seconds