Icy Phoenix

     
 


Post new topic  This topic is locked: you cannot edit posts or make replies. 
Page 1 of 1
 
 
Reply with quote Download Post 
Post Looking At Mysql Logs When The Site Slowed To A Crawl.. 
 
Does this mean high usage - It's a SQL log:

Handler_read_rnd      1 Meg      The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.

Handler_read_rnd_next     266 Meg     The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.

My site slowed to a crawl once i had more than 10 people online..
 



 
Paul_RS1Send private message  
Back to topPage bottom
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

Support us
 
Reply with quote Download Post 
Post Re: Looking At Mysql Logs When The Site Slowed To A Crawl.. 
 
Try to look in the Docs section and try to apply some settings to speed up things.

Let me know if this helps.
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Looking At Mysql Logs When The Site Slowed To A Crawl.. 
 
I ran the quick-xs settings script on here and it seemed to help..but now my albums will not display ANY thumbnails or pics. Click on a pic and it's a blank page...??
 



 
Paul_RS1Send private message  
Back to topPage bottom
Reply with quote Download Post 
Post Re: Looking At Mysql Logs When The Site Slowed To A Crawl.. 
 
This could be related to a memory limit issue... even if the script you run shouldn't have modified anything in the album !

Do you still have this problem?
 




____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
 
Mighty GorgonSend private messageSend e-mail to userVisit poster's website  
Back to topPage bottom
Post new topic  This topic is locked: you cannot edit posts or make replies.  Page 1 of 1
 


Display posts from previous:    

HideWas this topic useful?

Link this topic
URL
BBCode
HTML




 
Permissions List
You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events


  

 

  cron