FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » SQL Optimization (or maybe the ISP doesn't know what they are talking about)
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
SQL Optimization [message #161212] Tue, 24 November 2009 22:47 Go to next message
Tesla Rider is currently offline  Tesla Rider   
Messages: 20
Registered: June 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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?
Re: SQL Optimization [message #161214 is a reply to message #161212] Wed, 25 November 2009 02:02 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
I hope for their part the stats are wrong. If it's right, their servers are so overcommitted that you definitely don't want to host with them anyway.
Re: SQL Optimization [message #161219 is a reply to message #161214] Wed, 25 November 2009 08:47 Go to previous messageGo to next message
Tesla Rider is currently offline  Tesla Rider   
Messages: 20
Registered: June 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user

That's what I thought too.

Re: SQL Optimization [message #161451 is a reply to message #161214] Sat, 26 December 2009 01:13 Go to previous message
fudidudi   
Messages: 19
Registered: March 2009
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Id second that.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Index command denied
Next Topic: Looking for MySQL web hosting
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 15 22:22:39 EST 2017

Total time taken to generate the page: 0.00726 seconds