Im running MySQL 5.0.32 on a Debian Etch server. I recently moved a couple sites from a Debian Sarge (with MySQL 4.1) server over, and now MySQL has become very unstable.
Every few hours mysql just hangs on a query. All the following queries are queued and never get executed. The only way to get things running again is forcefully killing and restarting the mysql process. After that things work again...for a few hours.
The logs (error and query log) show nothing exceptional. When it hangs and I do a 'show processlist;' I noticed that everytime a SELECT....IN (a,b,c) query is holding up everything. Could the 'IN ()' be the reason for mysql not completing the query and holding up the rest?
Another option might be to temp. go back to MySQL 4.1...but that is going to be a real problem on Debian Etch
I seem to be having troubles getting yum to run. The problem occurs when I try to run yum via ssh using putty or install perl modules through whm.
When I try to run it, I generally get: Loading "fastestmirror" plugin And nothing after that, even if I wait a while. This happens when I run: yum update yum install imagemagick (my current reason for trying to get yum to run) yum clean all (probably other yum commands) If I run yum with --noplugins, it just skips putting out the fastestmirror message. Some info on my system: CENTOS Enterprise 5.2 Kernel Version: 2.6.18-92.el5 Intel C2D e6750 WHM 11.23.2 cPanel 11.23.6-R27698
I have a script that does a PHP Curl call where it downloads a large file (~20meg) to the local server.
While its doing the Curl Call, I open up a new window and keep working with the site, (ie. opening a simple image) and the browser keeps saying "Waiting for reply". As soon as the Curl Call stops, then the server works again.
What could course this?
The server is dedicated and only me using it: Intel Core2Quad Q6600 2GB DDR RAM Linux - CentOS 5 32bit
While its doing the curl call, I ran uptime and the load is 0.0 0.0 0.0.
From my PHPINFO:
Code: Apache Version Apache/1.3.39 (Unix) mod_ssl/2.8.30 OpenSSL/0.9.8b Apache Release 10339100 Apache API Version 19990320 Hostname:Port localhost:80 User/Group apache(100)/500 Max Requests Per Child: 1000 - Keep Alive: off - Max Per Connection: 100 Timeouts Connection: 120 - Keep-Alive: 1 Server Root /etc/httpd Loaded Modules mod_php5, mod_ssl, mod_setenvif, mod_so, mod_headers, mod_expires, mod_auth_anon, mod_auth, mod_access, mod_rewrite, mod_alias, mod_userdir, mod_actions, mod_imap, mod_asis, mod_cgi, mod_dir, mod_autoindex, mod_include, mod_info, mod_status, mod_negotiation, mod_mime, mod_log_referer, mod_log_agent, mod_log_config, mod_env, mod_vhost_alias, http_core HTTP_CONNECTION Keep-Alive php.ini
Code: max_execution_time = 1000 ; Maximum execution time of each script, in seconds max_input_time = 1000 ; Maximum amount of time each script may spend parsing request data ;max_input_nesting_level = 64 ; Maximum input variable nesting level memory_limit = 128M ; Maximum amount of memory a script may consume (128MB) [MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = Off
; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1
; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1
httpd.conf
Code: MinSpareServers 5 MaxSpareServers 10 StartServers 5 MaxClients 150 MaxRequestsPerChild 1000 httpd-mpm.conf - changing this made no difference
i have a serious problems with my shoutcast accounts the last 2 months...i create in my ports 8002,8004,8006,8008,8010,8012 some shoutcast accounts via cast control...every 3-4 hours some of my accounts is crashing....i can't understand why....so every 3 hours i am going to cast control panel to start again the shoutcast server of the account which which crashed....i don 't know what to do any more...my hands up...
i found these script which i can use via cron job to check if each shoutcast server is up
#!/bin/bash
dte=`date +%d%b%Y` cd /where/ever/you/run/stuff/
##-->> Check to see if sc_serv is running <<--## ps -ef|grep -v grep|grep sc_serv >sc_serv_ok
if [ -s sc_serv_ok ] then ##-->> Everything looks good, remove the file and exit <<--## rm -f sc_serv_ok exit 0 else
##-->> Log the error <<--## echo "Possible abend of sc_serv" > sc_serv_prob_log.$dte
##-->> Email the log <<--## mail -s "sc_trans" your-email@domain-name.com <sc_serv_prob_log.$dte
##-->> Restart sc_serv <<--## cd /path/to/shoutcast/ ./sc_serv
the problem is that i can't found the conf file for each account...where exactly CAST CONTROL creates it..i have the free version of cast sontrol 1.4...
I am currently running DA on my VPS and have about 15-20 accounts on it. We are upgrading to a dedicated running plesk while we need it, but I have not found a tool or an easy way to transfer DA accounts to plesk without problems. Because of this, I feel it would be easiest to transfer the accounts to a cPanel VPS, then to plesk. I know hosts are not supposed to PM here, but if you can offer me a cPanel VPS sometime within the next week for 24-48 hours for under $5-7, that would be great. This may seem like a little amount of money, but realistically it is a good amount in comparison to the pricing for a whole month of service.
I attached new backup harddrive with system and enable increment backup so that it can generate server backup on backup harddrive which was new,
I notice it takes 20 hours upto now and still working becoz i seen some command like rsync running on top and using alot of resources of server but when i checked backup harddrive then it almost copy all data into it but what about this rsync which running on system from 3 hours and still going .?
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 28045 root 35 19 42788 38m 168 S 63.8 1.0 42:59.51 rsync 28023 root 34 19 42680 39m 552 R 26.6 1.0 23:47.98 rsync 28024 root 34 19 42528 38m 312 S 19.9 1.0 10:25.91 rsync 944 nobody 15 0 167m 142m 10m S 5.0 3.5 0:09.26 httpd 1579 nobody 15 0 167m 143m 11m S 5.0 3.5 0:09.34 httpd 2471 nobody 15 0 167m 138m 7032 S 4.0 3.4 0:01.12 httpd 1528 nobody 16 0 167m 139m 7436 S 1.7 3.4 0:10.20 httpd 76 root 15 0 0 0 0 S 1.3 0.0 14:14.62 kswapd0 2194 nobody 15 0 167m 138m 7188 S 1.3 3.4 0:03.47 httpd 2386 nobody 15 0 167m 139m 7608 S 1.3 3.4 0:03.02 httpd 2452 nobody 15 0 167m 138m 7184 S 1.3 3.4 0:02.01 httpd 3054 mysql 16 0 747m 294m 2892 S 1.0 7.3 431:01.86 mysqld 18358 root 15 0 0 0 0 S 1.0 0.0 0:27.59 pdflush 665 nobody 15 0 167m 139m 7656 S 1.0 3.4 0:18.77 httpd 1917 nobody 15 0 167m 139m 7816 S 1.0 3.4 0:08.64 httpd
I'm not a direct client of Leaseweb, but it's not a secret that my domain is pointing at their servers.
I purchased a shared hosting plan from a reseller and since more than 43 hours my domain is down! My provider (the reseller) said he's waiting for Leaseweb support... according to my informations, in more than 24 hours they just made a reboot of the server!
I'm really bored of waiting with no chance of intervention! My provider says he can't do anything from his side, i can't contact Leaseweb cause i'm not a client... please, help, what can i do?
like to clarify this is not a post to bash liquidweb.
I have been a loyal customer of LW for the past 2 years (almost)
My websites have been down since Thursday 3:00 a.m due to "DDos Attack"
on Friday night, the network engineer told me the "DDos Attack" has stopped and problem should have been resolved. However, no websites were accessible.
On Saturday, I ensure you I have made many phone calls to Liquidweb dedicated server support and try to resolve this issue. (Never once did I raise my voice and they were being very polite.)
I believe the server admins that were helping was at the end of their shifts and every time I try to make a phone call to the person that was assisting me to get an update, liquidweb would tell me that he has gone home. Every time the server admin finishes his shift, the support ticket is not assigned to anyone else that is working until I make a phone call to them stating my problem.
I own quite a few large sites that generate over 3 millions hits per day and every hour of downtime means I will be losing valuable clients and revenue. That is why I am extremely frustrated with the 63 hours downtime as it seems like the results of working hard for the past 2 years is slipping away from me as the clock keeps ticking.
I am sorry, I am just trying to share this with fellow webmasters as I really need a place to express my feeling. (None of my friends will understand online business.)
Again, I am not bashing liquidweb...I must have really bad luck myself.
To start please take this in mind I have servers colo'd at FDC and have 0 problems, so i'm still all for fdc servers.
Here is my 24 hours review on my new vps server from FDC setup was quick less than 5hours after paying my invoice.
Now down to my problems. Off peak hours last night my VPS server was great 10 / 20mbits solid speed on sending data from the box today I am unable to get over 150kb/sec.
This doesn't help me since the nature of my business I need to transfer files fast between servers. The VPS speeds of 150kb/sec will be no use for my business if anything make our job harder.
These tests were taken using the internal fdc network transferring from the new vps to one of my 1gig fdc colos and other various servers I have on the FDC network.
After contacting fdc support about this speed issue they logged in and checked the speeds they did a download of the speedtest file from the fdc website around 30 - 40mbits. But they didn't test the outgoing from the server.
I received the response that I am sharing bandwidth on the node so speeds could vary so on there 100mbit unmetered vds package they are saying 150kb/sec is acceptable.
So basically after that my last response is if 150kb/sec are the speeds i can expect from a VDS then please cancel my server at the end of the billing period as the VDS will be no use to me.
So now I have been transferred to billing to cancel the vps at the end of the billing period.
So to sum it up, vps setup was fast and the vps runs great but don't expect the speeds you can get from one of there dedicated servers.
Is Nick Laws here? Someone knows where to call him or managemybox.com?
I have 3 servers with them. One of them is down for almost 16 hours now, and it has been 4 hours without notice. Tech replied saying is a harddrive crash and they will replace it, I have lost a lot of dollars because all important clients on this server are running out.
Now, can someone help me contact Nick? I sent him a message a minutes ago, but his techs are nto replying and one of my clients is really in a bad mood saying he will take legal actions against me.
Anyone can say a word? This is really bad and I dont get even a reply, just a word last night saying a few hours.
This is the ticket: Dear Felipe,
ssh down too, will have a tech reboot and clear firewall, will take about 15 minutes
Thank you for choosing ManageMyServices, we appreciate your business!
Administrator: managedservices Ticket Department: Sysadmin Ticket Category: ALL Assigned Administrator: ALL Importance: Urgent Company Area: ManageMyBox-Dedicated Ticket Status: closed Reply By felweb - 26-06-2008 01:57 Any news from your end on this ticket, or at least on the other 2?
This is taking way too long and it is affecting this a lot ....
I thought I should share my feelings on FutureHosting even though we have only been on their server for 48 hours.
Background --------- I started having my sites hosted back in 1990's and have had about a dozen hosts since then. (Started with Pair.net when they were like maybe 2 of the 3 hosts on the planet, LOL) 90% of the time, I have needed to find a host due to my former host being acquired or some other non-technical reason. So you could say that I tend to stick with a host for as long as possible. I have moved from shared hosting, to reseller hosting, to dedicated hosting, and now to VPS hosting. I started my VPS adventures with PowerVPS.
This was about 3 years ago if I recall. Like most here, I did a great deal of homework, read and lurked. PowerVPS was in my top 5 final list. I selected PowerVPS and was extremely happy to put the headaches of dedicated servers behind me. For two years the VPS was very stable. That changed about one year ago. I was told I was hitting resource max and asked to upgrade. Oddly, my sites' traffic was about 1/2 of what it was in the first two years. ie my VPS should have less resources needed. PowerVPS moved many of its legacy VPS users to new hardware. I don't recall they informed me, though they said they did. They did inform me that they would make a decision on the remaining legacy users in terms of billing promotions -- they never did. Downtime continued. I began to notice that their newer techs did not share the same ability of communication and skills as past/founding techs. Answers were curt and became more and more unhelpful. We have all seen this pattern before where a host starts out so well (2 or 3 guys/gals), and as it grows, they add remote staff that just don't have the same passion of the founders, or language skills. (Disclaimer: English isn't my native, so no excuse for lack of communications in business IMHO).
Thus, I began my search for a new VPS here. FutureHosting was in my top 5 along with KnownHost, SolarVPS, Jaguar. Actually, I rated them 3 or 4 in my final list. I tested all of these hosts' sales responses and went through the shopping process just before clicking 'sign-me up'. (I work in Ecommerce so I like to see that process). SolarVPS answered my questions the best. KnownHost a close second. I am sure there are a few other good VPS companies like ServInt, Lunar and HostNexus, but their prices just don't reflect the marketplace IMHO.
Due to my needs and budget though, I selected FutureHosting as they seem to offer the best balance -- competitiveness and support.
FutureHosting - 48 hours ------------------- As my data was on PowerVPS with Plesk, selecting another provider with Plesk was important. Actually, I have always been a Plesk fan having used all the CPs (I just wish they would stop trying to offer 1,000 products and spin off a CP-only company like they were.)
FutureHosting (FH) started the migration on Saturday night. Sunday morning I notice that all sites hadn't been moved. I checked my inbox and read the many emails awaiting me. It seemed Plesk was having a hard time using its server migration tool (typical of Plesk that they introduce a feature that doesn't work 100% of the time.) FH informed me they would migrate my VPS (domains, etc) manually.
While this was going on, another tech worked on some requests I had related to SSH, root access, etc.
What I found in the last 48 hours was what I had hoped for... Techs that received my tickets, and replies that stated WHAT they were doing. I felt informed during the entire process. In some cases, CLEAR explanations were given. In some cases, SIMPLE answers were given -- where I couldn't grasp the why. The level of service was what I experienced in my first year with PowerVPS. And now, a really important point -- EVERY tech that worked on my tickets displayed the same level of competence. All too often, I have felt in the past that the level and ability of techs ranged so much. This became more apparent as of late on PowerVPS (are they contracting out support? No idea.) It was a real pleasure to deal with each tech. I think I counted 5 different names! What I REALLY appreciate was that it was obvious that each tech taking over a ticket READ the entire ticket thread. Too often when a tech takes over due to moving it a tier or shift change, I felt like I needed to explain everything from the start. Gah!! I don't have time or patience for that.
Hardware wise, I moved from (PowerVPS) AMD Opteron(tm) Processor 246 to Intel(R) Xeon(R)CPU E5420 @ 2.50GHz (Future Hosting). In the case of PowerVPS, my VPS was on an old legacy machine that a few of us unlucky ones were still on (We were asked to bump up $$ to go to the new machines, I refused.) I don't know which server is better, but thus far my sites feel much more snappy. I also notice that my former VPS used burst RAM approach vs. SLM. (See my other post http://www.webhostingtalk.com/showthread.php?t=896249). I should also state that perhaps PowerVPS uses this in their new machines. No idea.
Overall, I am paying the same amount for my new VPS, the sites are loading much faster and most importantly, the service has been top rate. I was a little worried at first because I heard such great reviews of Knownhost and SolarVPS (I am sure they are warranted), but based on the past 48-hours, I must say my selection was right for me in many ways. I'm crossing my fingers that this level of service will continue 3, 5 or more years down the road. If they do, I won't hesitate to recommend FutureHosting to the MANY developers I come into contact with. (I have sent a great deal of leads/business to every host I have been at.) I will need to revisit this thread on my anniversary to see if things continue in such a great manner.
My dedi server have been down over 30 hours, I have create a ticket 30 hours back and also sent many messages to you via skype since 10 hours back, No supporter get back to me. Over 30 hours, NO one. I knew there some ones in this forum is Leaseweb staff and they visited this forum a short time back,
I want to setup a crontab to delete a file every 24 hours, I am not the best in crontab so was wondering if one of you could please give me the command I should use?
Somebody posted a video in my website which got viral. Many big websites (like gizmodo) embeded it and I've maxed out my 100mbit/s connection. Traffic is increasing and my website started crashing.
I want to move that video to other server ASAP so my website would stop crashing.
Do you know any host which would set up server or VPS fast (up to 1-2 hours)?
Aug 17, 2007 01:06:16 PM VPS is locked at the moment. It may take some time.(locked) VPS is up and running now.running Aug 17, 2007 01:06:10 PM VPS is locked at the moment. It may take some time.(locked,mounted) VPS is locked at the moment. It may take some time.(locked,running) Aug 17, 2007 01:06:04 PM VPS is mounted now. It is not running and some operations are not available.mounted VPS is locked at the moment. It may take some time.(locked) Aug 17, 2007 01:05:49 PM VPS is up and running now.running VPS is mounted now. It is not running and some operations are not available.mounted Aug 17, 2007 12:46:10 PM VPS is locked at the moment. It may take some time.(locked) VPS is up and running now.running Aug 17, 2007 12:46:04 PM VPS is mounted now. It is not running and some operations are not available.mounted VPS is locked at the moment. It may take some time.(locked) Aug 17, 2007 12:45:16 PM VPS is up and running now.running VPS is mounted now. It is not running and some operations are not available.mounted Aug 17, 2007 09:37:13 AM VPS is starting up at the moment. It may take some time.(starting) VPS is up and running now.running Aug 17, 2007 09:37:10 AM VPS is stopping now. It may take some time.(stopping) VPS is starting up at the moment. It may take some time.(starting) Aug 17, 2007 09:36:52 AM VPS is up and running now.running VPS is stopping now. It may take some time.(stopping) Aug 17, 2007 08:51:46 AM VPS is locked at the moment. It may take some time.(locked) VPS is up and running now.running Aug 17, 2007 08:51:25 AM VPS is up and running now.running VPS is locked at the moment. It may take some time.(locked) Aug 16, 2007 03:00:18 PM VPS is locked at the moment. It may take some time.(locked) VPS is up and running now.running Aug 16, 2007 03:00:03 PM VPS is mounted now. It is not running and some operations are not available.mounted VPS is locked at the moment. It may take some time.(locked) Aug 16, 2007 02:59:39 PM VPS is up and running now.running VPS is mounted now. It is not running and some operations are not available.mounted Also I'm receiving emails with ftpd, exim, cpsrvd failed when that happens:
Code: ftpd failed @ Fri Aug 17 09:37:26 2007. A restart was attempted automagically.
BoxVPS seems to be have support problems judging from the threads here about BoxVPS. Furthermore, from my personal experience with BoxVPS in the last few days I can affirm this. My VPS went down about 2 days ago and the ticket with the request to look into it and reboot/start if necessary got no reaction. As BoxVPS has still no VPS control panel after HyperVM fiasco this is a BIG NO NO! ...
My entire experience with Gigenet has been very bad. I will post a 30 day review once I have completed my first and only billing cycle with them. This topic will be solely focused on the way Gigenet handled my server being down for 17 hours and 50 minutes. I have paid Gigenet for 30 days of service, one billing cycle. My account is set to be terminated on the 7th of June.
I pay Gigenet to actively monitor my server. These services are called "NOC Response from Monitoring" and "Host Ping (ICMP) and TCP Service Monitoring". The extra "service" cost $10/mo.
I realized that my server was down after 7 hours of downtime. I sent in a "critical" support ticket at about 3 AM.
Here is a timeline of my support ticket with Gigenet
Quote:
Originally Posted by ME - 05 Jun 2009 03:11 AM
My Server is down. Any reason for the down time?
Quote:
Originally Posted by ME - Posted On: 05 Jun 2009 03:24 AM
Can I at least get a confirmation that this issue is being worked? It's 3:32 AM...I have to work tomorrow morning and would prefer to get some sleep.
Thanks...
* Note: I am not exactly clear why the time stamp and the time mentioned by me in the ticket don't line up.
Quote:
Originally Posted by Gigenet - Posted On: 05 Jun 2009 03:24 AM
I'm looking into your issue now, all updates will be posted here.
Quote:
Originally Posted by ME - Posted On: 05 Jun 2009 03:29 AM
I have server monitoring. Can you also explain to me how SEVEN HOURS of down time was over looked by your "server monitoring"?
Quote:
Originally Posted by Gigenet - Posted On: 05 Jun 2009 03:37 AM
This server has been marked for cancellation.
I see that the date set was for June 7th and today is the 5th, I will need to speak to a Billing representative before I can re-enable this device. The Billing Department will not be in until 10am, I will leave this ticket open and I will speak to them first chance I get.
* Note my server is still down at this point.
Quote:
Originally Posted by ME - Posted On: 05 Jun 2009 03:44 AM
Yes, because canceling my service two days earlier makes a lot of sense. I paid Gigenet for 30 days, I should get all 30 days. Maybe I'm misunderstanding something?
Please respond so I can get to bed...
Quote:
Originally Posted by Gigenet - Posted On: 05 Jun 2009 03:55 AM
I understand your concern, but your server port was administratively shutdown and I was able to find the cancellation ticket. I need to speak with someone from Billing concerning this issue. This looks to be a mistake on our end, but I don't have all the details in front of me. I will attempt to contact my manager and get this straightened out. All further updates will be posted here.
It was nearly 4:00 AM at this point. I had to be at work by 6:30 AM. My server was still down, so I went to bed.
The next day I received this response:
Quote:
Originally Posted by Gigenet Posted On: 05 Jun 2009 01:43 PM
Hello,
Your server should be back online until the 7th. We're very sorry for the inconvenience. I've confirmed the server's availability via ping from my workstation. Please let us know if you have problems accessing it and we'll take another look.
At this point in time my server was restored. The total downtime was 17 hours and 50 minutes. I monitor my server with a third-party service called "HyperSpin".
Seeking an answer to explain nearly 18 hours of downtime; I sent this response.
Quote:
Originally Posted by ME - Posted On: 05 Jun 2009 04:14 PM
What is the reason for the downtime? Is 17 hours and 50 minutes of unexplainable downtime something that I should expect from Gigenet?
Quote:
Originally Posted by Gigenet -Posted On: 05 Jun 2009 04:22 PM
Hello,
Unfortunately I' not exactly sure what happened. I think the server may have been prematurely canceled, but I'm not totally certain. The server should be back up and I've put in the necessary ticket to make sure it stays on until the 7th, as you requested. We're very sorry for this inconvenience.
So, the best I can get out of Gigenet is that my server may have been shutdown prematurely. I don't understand why Gigenet can not fully explain nearly 18 hours of downtime. No one seems to know exactly what happened...
