Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


Www.UNIX.com is slow today ???


Login or Register to Reply

 
Thread Tools Search this Thread
# 8  
Response from upper midwest

Hi.

From north-central USA via CenturyLink.

Response has been sluggish here for a few weeks, and just now it has taken 10-15 seconds to see a link.

Best wishes ... cheers, drl

PS And this post took more than 40 seconds to complete initially.

I check the network speed every morning. This morning it was just under 40 Mbps.
# 9  
Hey

Hopefully it's better now.

Seems there was some corruption in the Database, and I ran some utilities to optimize and repair the db and it works much better now.

I think we may be "good to go!" now.
# 10  
OK MY BAD....

Just optimized the db and the site is running fast again; so please remind me if the site "goes slow" again to optimize the db.

Thanks!
This User Gave Thanks to Neo For This Post:
# 11  
Yes, it's back to its usual response behaviour. Thank you!
# 12  
Haha..

Next time anyone reports of a perceived slowdown, I'm running this command:

Code:
mysqlcheck -u<user> -p --optimize --databases <dbname>;

... before spending hours trying to find the problem LOL

Also, consider:

Code:
mysqlcheck -u <user> -p --auto-repair -c -o --databases <dbname>;

# 13  
Couldn't this be done on a regular basis, e.g. weekly?
# 14  
Yes, it could be done in a trivially simple weekly script from a cron file at 3AM during the weekend every weekend.

LOL

(PS: Anyway, I'll just do it manually.... I am not very comfortable running batch commands against the DB without being "in the loop" ... )
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
www.unix.com
sssow
Of late, when i start www.unix.com my system is going to 100% CPU and takes lot of time to get the information. I think this is happening after adding the graphics on the page. Has anyone seen this problem..Sorry to post this here..... Post Here to Contact Site Administrators and Moderators
6
Post Here to Contact Site Administrators and Moderators
New www.unix.com search
sierra_aar
PUZZLED: How can I search for posts on 'VI' if by the new rules (or maybe they are old) I get the messge: "The search term you specified (vi) is under the minimum word length (3) and therefore will not be found. Please make this term longer. If this term contains a wildcard, please make...... Post Here to Contact Site Administrators and Moderators
13
Post Here to Contact Site Administrators and Moderators

Featured Tech Videos