MySQL Long Procees Time
Jul 11, 2007
I've got a 2.8 Dual Xenon with 2GB of ram. Taking a look at my "top" output I see the following:
Code:
18119 nobody 15 0 20812 20M 9764 S 0.8 0.9 0:05 0 httpd
3388 mysql 16 0 105M 97M 1908 S 0.7 4.8 95:08 1 mysqld
22225 nobody 15 0 18920 18M 9060 S 0.7 0.9 0:02 2 httpd
3391 mysql 16 0 105M 97M 1908 S 0.5 4.8 95:33 1 mysqld
13612 nobody 15 0 16872 16M 7192 S 0.4 0.8 0:05 3 httpd
21871 nobody 15 0 20712 19M 7768 S 0.4 0.9 0:02 2 httpd
I've got MySQL process running 95+ minutes. This isn't the first time it's happened.
I've seen it go as high as 120 minutes. The load average is 1.2. All my sites that use MySQL i.e. Wordpress blogs all run fine.
Looking at "MyTop" output everything looks normal:
Code:
MySQL on localhost (4.0.27-standard) up 37+01:40:24 [20:42:31]
Queries: 39.9M qps: 13 Slow: 211.0 Se/In/Up/De(%): 87/01/04/01
qps now: 9 Slow qps: 0.0 Threads: 20 ( 1/ 49) 64/04/09/09
Cache Hits: 27.5M Hits/s: 9.0 Hits now: 4.4 Ratio: 79.3% Ratio now: 73.3%
Key Efficiency: 100.0% Bps in/out: 571.7/961.9 Now in/out: 941.1/385.6k
Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
1263533 root localhost mysql 0 Query show full processlist
1263663 gwz3phj_v localhost gwz3phj_va 8 Sleep
1262512 DELAYED gwz3phj_va 9 Delaye Waiting for INSERT
1263618 gwz3phj_v localhost gwz3phj_va 9 Sleep
1263658 gwz3phj_v localhost gwz3phj_va 15 Sleep
1263659 gwz3phj_v localhost gwz3phj_va 15 Sleep
1263617 gwz3phj_v localhost gwz3phj_va 22 Sleep
1263651 gwz3phj_v localhost gwz3phj_va 22 Sleep
1263642 gwz3phj_v localhost gwz3phj_va 37 Sleep
1263640 gwz3phj_v localhost gwz3phj_va 43 Sleep
1263636 gwz3phj_v localhost gwz3phj_va 52 Sleep
1263633 gwz3phj_v localhost gwz3phj_va 53 Sleep
1263630 gwz3phj_v localhost gwz3phj_va 55 Sleep
1263631 gwz3phj_v localhost gwz3phj_va 55 Sleep
1263624 gwz3phj_v localhost gwz3phj_va 74 Sleep
1263625 gwz3phj_v localhost gwz3phj_va 75 Sleep
1263623 gwz3phj_v localhost gwz3phj_va 78 Sleep
1263615 gwz3phj_v localhost gwz3phj_va 79 Sleep
1263621 gwz3phj_v localhost gwz3phj_va 85 Sleep
1263616 gwz3phj_v localhost gwz3phj_va 88 Sleep
Overall my server is running just fine but these odd long running MySQL process have me worried.
View 3 Replies
ADVERTISEMENT
Dec 7, 2007
I am using Servint and I am looking for another provider with similar reputation/reliability. I have heard many good things about Zone.net on this forum, but they don't have any reviews older than a few months. Have they been around long, if so, why no early posts?
View 5 Replies
View Related
Dec 17, 2007
Just wondering... When I set my A-name records in my Domain-provider control panel, it takes almost 24hours to take effect sometimes, yet other times it can be almost instant...
I was just wondering, from a technical point of view, why this is. Does anyone know?
View 1 Replies
View Related
Nov 26, 2008
I ordered server and payed 48 hours ago by paypal. Why i do not have details for it?
In they website they wrote what they have 2 servers in stock!
View 6 Replies
View Related
Feb 20, 2007
the error log shows nothing out of the ordinary.. but its taking about 2-3 minutes to start.. which before it would take about 10 seconds.
load is fine on the machine, free mem is fine also.
View 2 Replies
View Related
Aug 2, 2007
Recently however it seems they're getting some bad press, most people are blaming growing pains.
As someone who's seen the before and after picture, i thought i'd chime in and actually put some positive notes on these boards, as I know these guys deserve more credit than this! It's one of those situations where if something goes wrong, people complain, if everything is right, not enough people speak up!
Server speed / specs:
one word: fantastic. i now have 2 VPSs with them - one in their new data center. I had moved the 2nd VPS from another host (also very well known on these boards, who I won't mention) where I had been having loads of issues regarding load and IO wait times. Load would spike up to 20+, server would crash, reboot, and this would happen 20+ times a day. Nothing critical on that server. Post-migration, using very very similar specs on futurehosting, and the load has been <0.10 since I started her up 3 days ago.
My current server sees load going up once in a while - during a large scale DOS attack last month the load only went up to 4, with over 1000 TCP connections. I only realized there was an issue as I checked one of my status scripts and noticed the enormous tcp count. I've recently moved to a new VPS on a new node, and load has been incredible, along with responsiveness.
No complaints at all on that front.
Network performance
Their old data center, softlayer, has much to be desired. There has been at least one outage every month so far which lasts in the hours duration. However, FH has made the very wise option of expanding out to a new datacenter and will hopefully slowly phase out softlayer, which has become quite pathetic. Connectivity wise though (speed/bandwidth) - no complaints.
Support
I remember getting a response within minutes months ago. However, that being said, months ago the customer service could only deal with the most basic of problems, and would escalate the issue if it was complicated, which would take time for a response.
FH did go through a growing pains phase a little while ago with regards to customer service - you wouldn't get a response too quick.
However now it seems they have begun improving. They are expanding their support base, and if you deal with the support guys you'll definitely be impressed by how dedicated and "hardcore" they are. Very recently I had a major issue with my server - it got compromised via root and someone wreaked havoc. Some script was installed that basically self-DOS'ed the server and basically killed it.
FH support instantly shut down the server and put me back up on my old server which I had migrated from only a week ago. They thoroughly went through and wiped clean my current server, fully bullet-proofed it and cleaned up the security of it all (something that was not a problem when they set it up - but rather my fault over time as I had disabled some very silly things I shouldn't have...) The guy working on the server, Jim, worked his *** off, pulled an all nighter (he was still responding to my tickets at 9am GMT, which was 4am his time - and I know he's not a night shift guy!). By the end of it all, he put me back onto my current newly-secured server, and was still revving to go, asking me what I wanted and to give him another challenge!
So, to sum this section--
good attitude: check
know-how: check
laziness: none.
I guarantee one thing - the vps company I just moved my 2nd vps from in this situation would not have spent an entire night rebuilding my server the way it was, but would've simply put me back on my old one week image, said "oh well, sorry, bad luck" and moved on.
All in all, my experience with these guys over the past couple of weeks (since the new data center opened) has been nothing short of positive, and I know they're rising out of the slight slump they had gotten themselves into.
I'll submit my URL to the mod to verify this post. And no, I don't work with FH
View 14 Replies
View Related
Nov 8, 2007
I had Qmail installed and configure more than 2 years.
Last week, when I using Post Client (The Bat) try to send email, "Connection to Host" message shows Toooo long (aprox. 10 minutes)
POP3 connection working well.
OS RedHat Linux 2.4.25
[root@host smtp]# tail /var/log/qmail/smtp/current
@400000004733722622dcef34 tcpserver: status: 16/20
@400000004733722623095e34 -Table 'vpopmail.relay' doesn't exist-db_close() called!
@4000000047337226230be6a4 db_ping() is re-calling open_db!
@40000000473372262311f954 tcpserver: status: 17/20
@400000004733722623ad3b6c tcpserver: pid 6923 from 76.65.180.227
@400000004733722625a588fc -Table 'vpopmail.relay' doesn't exist-db_close() called!
@400000004733722625cf11cc db_ping() is re-calling open_db!
@400000004733722625fe863c tcpserver: pid 6926 from 76.65.180.227
@400000004733722d1b7434b4 tcpserver: end 6190 status 0
@400000004733722d1b744454 tcpserver: status: 16/20
and ps -aux return approx 10-15 lines with:
vpopmail 7330 0.0 0.1 2152 788 ? S 15:32 0:00 /usr/bin/tcpserver -v -R -S -p -x /etc/tcprules.d/tcp.smtp.cdb -c 20 -u 107 -g ...
View 2 Replies
View Related
Mar 31, 2014
Panel-Version11.5.30 Update #38
BSDebian 7.4
Save Web Hosting Settings takes a long time. The Domains (Apache Server) are not reachable for 36 seconds.
View 12 Replies
View Related
Jun 11, 2015
We had many backups stored on our Plesk 12 server about 51 GB in total.
After reducing the backups back to 10 GB by removing old backups through the Backup Manager.
The issue is that Health Monitor still reported that there was low diskspace displayed by color yellow. And it look Health Monitor over 16 minutes to change the alarm level from Yellow to Green
However the statistics at the specific subscription still present the Backup usage of 51 GB's whilest they are no longer there.
What can i do about this in order to speed up the synchronization?
View 2 Replies
View Related
Jun 5, 2008
Mysql is restarting all the time, but when I look at the log file, I got the following error message. Anyone has any idea about this issue?
080604 22:48:45 InnoDB: Started; log sequence number 0 1304279005
080604 22:48:45 [Warning] mysql.user table is not updated to new password format; Disabling new password usage until mysql_fix_privilege_tables is run
080604 22:48:45 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.45-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
080604 22:48:46 [Note] /usr/sbin/mysqld: Normal shutdown
080604 22:48:46 InnoDB: Starting shutdown...
080604 22:48:49 InnoDB: Shutdown completed; log sequence number 0 1304279005
080604 22:48:49 [Note] /usr/sbin/mysqld: Shutdown complete
View 11 Replies
View Related
May 7, 2008
My MySQL server take too much time to start. I moved the data folder to its own hard disk, but still no improvement.
# uptime;date;service mysqld start;date;uptime;service httpd start
05:46:15 up 5 days, 1:24, 2 users, load average: 0.24, 1.07, 1.23
Wed May 7 05:46:15 CDT 2008
Starting MySQL: [ OK ]
Wed May 7 06:04:21 CDT 2008
06:04:21 up 5 days, 1:42, 1 user, load average: 1.77, 1.65, 1.50
Starting httpd: [ OK ]
#
You see MySQL take 18 minutes to start.
This happens whenever i restart the server or restart mysql.
Here is the process while MySQL starts
# ps aux|grep mysql
root 23549 0.0 0.0 4448 1168 pts/0 S+ 05:24 0:00 /bin/sh /sbin/service mysqld start
root 23556 0.0 0.0 4628 1272 pts/0 S+ 05:24 0:00 /bin/bash /etc/init.d/mysqld start
root 23613 1.5 7.5 157668 154580 pts/0 D+ 05:24 0:01 chown -R mysql:mysql /backup/mysql
root 23780 0.0 0.0 3896 664 pts/1 S+ 05:26 0:00 grep mysql
#
It is chown that make the MySQL startup slow.
MySQL data size is about 11 GB.
View 2 Replies
View Related
Mar 5, 2007
how to setting mysql data / time?
server have -9 H from our
We have setting under WHM for time server but we also need to setting mysql
View 1 Replies
View Related
Apr 8, 2009
We have a dedicated server and we host 4 news portals based on e107 and joomla.
My partner on Sunday has upgraded mysql from version 4 to 5. Now the server experiences very high CPU usage and query time on portals has been increased very much.
We used to have query times lower than 1 sec for the main page of [url](which is a site that receives about 2000 visits/day) and now query times are 5-15sec !
Does anybody know if this is makes sense ?
Below is the server Status from WHM :
-------------------------------------
cpdavd up
cpsrvd up
exim (exim-4.69-15.1_cpanel_maildir) up
ftpd up
httpd (2.2.11 (Unix)) up
imap up
interval up
mysql (5.0.67-community-log) up
named (9.3.4) up
pop up
rsyslogd up
spamd up
syslogd up
Server Load 6.97 (1 cpu)
Memory Used 49.4 %
Swap Used 0.23 %
Disk /dev/hda3 (/tmp) DMA+ 70 %
Disk /dev/hda5 (/) DMA+ 22 %
Disk /dev/hda1 (/boot) DMA+ 14 %
Below is the Server Information from WHM :
------------------------------------------
Processor #1 Vendor: GenuineIntel
Processor #1 Name: Intel(R) Core(TM)2 Duo CPU E4600 @ 2.40GHz
Processor #1 speed: 2394.068 MHz
Processor #1 cache size: 2048 KB
Memory Information
Memory: 2064420k/2087424k available (2091k kernel code, 21752k reserved, 846k data, 236k init, 1169920k highmem)
System Information
Linux server.aktoweb.biz 2.6.20-1.2319.fc5 #1 Mon May 21 19:52:13 EDT 2007 i686 i686 i386 GNU/Linux
Physical Disks
hda: WDC WD3200AAJB-00TYA0, ATA DISK drive
hda: hw_config=600d
hda: hw_config=600d
hda: max request size: 512KiB
hda: 625142448 sectors (320072 MB) w/8192KiB Cache, CHS=38913/255/63<6>hda: hw_config=600d
hda: cache flushes supported
Current Memory Usage
total used free shared buffers cached
Mem: 2066428 1756324 310104 0 339576 486636
-/+ buffers/cache: 930112 1136316
Swap: 1052248 2428 1049820
Total: 3118676 1758752 1359924
Current Disk Usage
Filesystem Size Used Avail Use% Mounted on
/dev/hda5 288G 60G 213G 22% /
/dev/hda1 99M 13M 82M 14% /boot
tmpfs 1009M 0 1009M 0% /dev/shm
/dev/hda3 494M 215M 254M 46% /tmp
Below is the CPU/Memmory/Mysql Usage from WHM :
-------------------------------------------------
mysql42.707.300.0
Top Process%CPU 42.7/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
Top Process%CPU 42.6/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/server.aktoweb.biz.pid --skip-external-locking
giaprakigiapraki.com2.7012.111.7
Top Process%CPU 1.3httpd [urll] [/e107_plugins/pm/pm.php?inbox]
Top Process%CPU 1.1httpd [url] [/e107_plugins/forum/forum_viewforum.php?87]
Top Process%CPU 1.0httpd [url] [/e107_plugins/chatbox_menu/chatbox_iframe.php]
adsnetadsnet.gr1.177.900.7
Top Process%CPU 0.5httpd [adsnet.gr] [/www/delivery/lg.php?bannerid16&campaignid4&zoneid5&chan]
Top Process%CPU 0.4httpd [adsnet.gr] [/www/delivery/lg.php?bannerid50&campaignid6&zoneid15&cha]
Top Process%CPU 0.3httpd [adsnet.gr] [/www/delivery/lg.php?bannerid183&campaignid77&zoneid1&ch]
r40r40.gr1.073.340.0
Top Process%CPU 1.1httpd [r40.gr] [/index.php?optioncom_fireboard&Itemid188&funcshowcat&cat]
Top Process%CPU 0.5httpd [r40.gr] [/images/fbfiles/avatars/s_64.png]
Top Process%CPU 0.3httpd [r40.gr] [/index2.php?optioncom_jim&taskxml&no_html1]
root0.278.532.0
Top Process%CPU 0.2[kjournald]
alex123alexandroupoli.net0.030.270.0
Top Process%CPU 0.1httpd [alexandroupoli.net] [/e107_images/banners/banner468x60-alexandroupolinet.gif]
galfasgalfas.gr0.030.270.0
Top Process%CPU 0.1httpd [galfas.gr] [/racing/images/galfas_R40_banner.jpg]
eximstats0.000.000.3
nobody0.001.100.0
mailnull0.000.000.0
unauthenticated0.000.000.0
named0.000.10
View 8 Replies
View Related
Jan 6, 2007
MySQL didn't work well on my server so I had a look at the err file. It indicates that MySQL is getting started and stopped all the time. After it has started it will stop and then start again etc:
070106 14:40:25 InnoDB: Started; log sequence number 5 959534492
/usr/sbin/mysqld: ready for connections.
Version: '4.1.21-standard' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Communi$
A mysqld process already exists at Sat Jan 6 14:40:28 CST 2007
070106 14:40:38 [Note] /usr/sbin/mysqld: Normal shutdown
070106 14:40:38 [ERROR] /usr/sbin/mysqld: Sort aborted
070106 14:40:40 InnoDB: Starting shutdown...
070106 14:40:41 InnoDB: Shutdown completed; log sequence number 5 959534492
070106 14:40:41 [Note] /usr/sbin/mysqld: Shutdown complete
070106 14:40:42 mysqld ended
070106 14:40:42 mysqld started
070106 14:40:42 InnoDB: Started; log sequence number 5 959534492
View 4 Replies
View Related
Mar 21, 2008
After 2 years of application hosting on ixwebhosting.com i have overloaded their mysql servers for the forth time and now if i overload them again i'll get banned.
Each time i got overloaded My database was taken away for a almost a week and i had to beg everyone / write a letter to the CEO so they'll return the database.
I now need to sireously move to a VPS / Dedicated server
or my database will be deleted permenantly including all my 10 gigabytes of usergenerated data and content heh.
The wrost thing is i can't even monitor these overloads and ixwebhosting just take away your databases and say "STOP, you overloaded!" that's it - you're screwed.
I really modified my scripts these 2 days so i won't overload them again and get the final booting (that's after i paid 2 years upfront - 260$), but guess what, they can't even tell me if i'm now overloading the servers after i done all the tweaking.
Guess it's time to get all the data to my comuter before they say i have overloaded again and all my 12 my sites get blown away.
I need to switch fast i don't have much time as it seems and my most important site has 8k unique visitors per day - that's why the over loading occurs, heh, because im just too big - UNLIMITED MY ARSE.
I've been looking for a host and the best i found (after 2 days of forum readings and google searching ) where:
1. inmotionhosting VPS.
2. rackforce.com DDS.
3. Iweb.com
Please any suggestion / comments to where should i go to host will save my buissness, my main concern is my 8k per day site with 2.5 page views per user and 2 mysql queries per page.
looking for a good company with managed everything (I know nothing about hardware managment - i'm a php / mysql geek at the most) and technical support with great uptime and a good ping / connection to israel's area is a big plus.
View 16 Replies
View Related
Nov 5, 2014
I have this error when i put import to mysql database
Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<script></script><p>ERROR: Maximum execution time of 300 seconds exceeded (Util.' at line 244
I have in domain > doemainname >
max_execution_time
Standaard
Geef een aangepaste waarde op 0
and insert in
usr/local/psa/admin/htdocs/domains/databases/phpmyadmin in the file config.sample.inc.php following command
$cfg['ExecTimeLimit'] = 70000;
but it will not work...
View 2 Replies
View Related
Nov 11, 2008
This is a rare issue i have on a RHEL 5.2 + cPanel server.
Server time is:
Tue Nov 11 17:02:51 CST 2008
Squirrelmail time show:
Code:
Last Refresh:
Tue, 5:02 pm
So, that is correct too..
But email arrives with -4 hours time, example:
webmaster@xxx.com 1:03 pm testing email
I already rebooted httpd, exim, and imap server, and the server itself too.. and problem stills.
View 11 Replies
View Related
Jan 6, 2008
I got report from webceo that I have some issues. May someone help me fix this?
DNS Lookup: 0.22 sec
Connect time: 0.33 sec
Host ping: 0.10 sec
That mean too slow with the other sites!
View 4 Replies
View Related
Sep 25, 2008
I can't get access to a certain site. I always get the page with:
network time out - server at *** takes to long to respons. More people have noticed this and apparently it only happens to people with certain specific providers. And not all the time. Some times they DO get access eventy to they belong to the same ISP. So I guess an ISP isn't blocking access to it otherwise it would be permenantly/The site administrator insists that certain ISP's are blocking his site. He's hosting it on his own server. The domain belongs is registered at namecheap.com.
If an ISP is blocking this site (if that's possible?), that would lead to that 'network timeout' page wouldn't it?
What is the most likely reason for getting a timeout page anyway?
View 7 Replies
View Related
Aug 9, 2007
I have a dedicated server specs: AMD 3500+ 64 Bit CPU, 1 GB Ram, 160 GB Sata Drive. For 1 month, CPU load average reaches 40-50 value. This happens about 5-6 times in a day. When I stop httpd service for 30 seconds everything goes normal. I think this is not a DoS attack because it comes systematic, I dont believe no one makes this regularly except bots.
Maybe its a system service or a cronjob but it stops when I turn off httpd service?
How can I be sure about what's making this regularly load?
I also did set up a script which mail me when load average of system goes crazy and restart httpd service. But instant restart is not working to stop load increase.
View 12 Replies
View Related
Feb 6, 2013
The server is going down from time to time, every 12 days or so the site hosted there is no longer accesible, everything starts with the site slowing don and down and then is not longer reachable, what we do is to request a power cycle, and with this we start all over again till next power cycle, so on so on, of course, here are my server details and more info on this:
- MySQL - 5.1.41-3ubuntu12.10
- Apache - 2.2.14-5ubuntu8.4
- PHP - 5.3.2-1ubuntu4.9
- operating system: Ubuntu Server 10.04 LTS
After some time emailing the support guys to barely check about what's going on, we received an email with a few things:
1.- found a few errors that likely would cause issues with Apache. The first error is:
[Mon Feb 04 05:03:10 2013] [error] mod_fcgid: fcgid process manager died, restarting the server and the next error is:
[Mon Feb 04 14:32:34 2013] [error] server reached MaxClients setting, consider raising the MaxClients setting ...
Both these errors seem to indicate that you have a process that is running out of control on your server. We were unable to determine what script on your site is running caused your connections to be maxed out however it does appear that before these errors were generated there was a WordPress plugin referenced in your access logs...
2.- Additionally during our review we did find that your error log for mercadodedinerousa.com is 45 GB's which is excessively large and can cause problems when Apache is trying to write a such a large file.
3.- The majority of the errors being logged are:
[Wed Feb 06 12:12:31 2013] [error] [client 200.76.90.5] Options FollowSymLinks or SymLinksIfOwnerMatch is off which implies that RewriteRule directive is forbidden: /var/www/vhosts/mercadodedinerousa.com/httpdocs/index.pl, referer: [URL]
View 6 Replies
View Related
Aug 27, 2008
Signed up and paid the first month for a 'Linux Entry' + 1 GB mySQL around 4:45PM today. It's now 11:21PM and I have not heard anything or received any Emails for remote access. Does it usually take this long?
Reading thru this site they seemed to be one of the best if your on a $30/month budget.
Maybe setting up the Linux stuff takes longer for them than Windows?
View 10 Replies
View Related
Jul 17, 2007
root@server [~]# replace ns3.host.com ns1.host.com -- /var/named/*
-bash: /usr/bin/replace: Argument list too long
How can I work past this?
Using Centos 4.5 / cpanel
View 4 Replies
View Related
Apr 16, 2007
I bought a VPS its taken 18 hours still no setup is this normal?
View 11 Replies
View Related
Oct 31, 2007
If you have a vps, how long does the 'burst' actually last?
View 5 Replies
View Related
Apr 3, 2008
How long does it normally take to get a shared account setup with a hosting provider? I am now in my 5th day and still have not had the account setup. I have made my DNS changes and I just keep getting email responses that it is coming. Should I be worried or is a week the normal response time in a shared environment?
View 14 Replies
View Related
Jul 28, 2008
I recently read around here and people had their VPS setup within 5 minutes in some cases. I've ordered a VPS from VirPus and I'm not sure how long it usually takes to setup. I'm nearing the 24 hour mark so I'm not sure. How long on average is an acceptable waiting time? or how long would you say it should take?
View 7 Replies
View Related
