Mysql Overloaded - Time To Move To A Real Server / VPS
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
ADVERTISEMENT
Feb 27, 2008
I have an AMD Sempron(tm) Processor 3000+ machine thats running Linux - CentOS.
I was wondering if anyone could recommend a good server/hardware monitoring script or app that will allow monitoring of the following items in real time. Also I'd like to
log and view the historical data. A script that stores this data in mysql database would be ideal.
Processor Temperature
Hard Drive(s) Temperature
Ram Usage - Overall
Ram Usage for each running Process/Service
CPU Usage - Overall
CPU Usage for each running Process/Service
View 10 Replies
View Related
Jul 19, 2014
I'm trying to configure an custom access_log file for an custom file called "extra.php"
How I can make an log file that's log only "extra.php" ....
View 1 Replies
View Related
Apr 21, 2008
Is it possible to move my mysql database to another server?
View 9 Replies
View Related
May 24, 2007
how can i move mysql db from remote server ? (via SSH or most pratical way)
suppose that...
source server
domain : google.com
host : localhost
user : zode
pass : 123
db : source
destination server
domain : yahoo.com
host : localhost
user : hala
pass : 456
db: target
View 2 Replies
View Related
Aug 4, 2008
we have lots of web sites and traffic
our company needs real high bandwidth
we worked with layeredtech but it was not enough, too
do you have any advice? a real datacenter with real 1 or 2 gig real internet connection?
View 9 Replies
View Related
Jun 20, 2008
I can't find any straight answers when searching Google. I've been stuck in a what has become a nightmare server move for about 2 weeks now.
After finally getting a mysql.sock issue fixed I can get the MYSQL dbs over to the new server but it appears that their permissions need to be changed. Is there a way to handle this from the root level? I have roughly 120 dbs to process
I am moving from a VPS to a dedicated server - both have root access.
View 11 Replies
View Related
Sep 28, 2007
When it is the time for moving from shared hosting to VPS?
May I know the signal for it? Maybe space, bandwith or other things?
Yes, I know the shared hosting provider will give notification when the time has came.
But usually it is very close and I must upgrade to VPS asap. So I do not have time to look around to get better deal.
View 8 Replies
View Related
Oct 2, 2007
how to do this in myphpadmin
also got cpanel if it helps.
View 5 Replies
View Related
Apr 9, 2008
I dont believe any of these shared hosting providers are different from another except maybe pricing and 24/7 telephone/email support.
So putting to rest which one is the "best", when do u decide that it is time for u to move on to a vps or dedicated server. what is the daily bandwidth that should make you realize that u need to move on to a better server before they cut u down cos u r taking up "too many resources"
View 4 Replies
View Related
May 23, 2008
I own a filehosting site and i have had large files uploaded to the server (300-700mb) the server runs fine, but sometime it gets really slow and the site cannot be opened. I guess, its because the amount of people downloading?
I heard that download accelerators can really harm the server as they open alot of new connections with the server..
Well i am looking for some method that i can offer large files, and still keep the site online at all times.
I own my own dedicated server, with average CPU and 1gb ram.
View 14 Replies
View Related
Jun 26, 2008
I am a reseller and one on my clients is on a dedicated server (Dual Xeon 2.4Ghz, 2 GB RAM, 2x 160GB SATA Drives). His shop runs fine until he starts an ad campaign, at which point the server fails miserably. The average server load during those times is 20-25.
My host has looked at it and said there isn't anything to be done.
I realize there is a limit for any server but I'm hoping for a more definitive answer as to what the problem is. Is there some way to determine where the problem is, exactly?
For example, is it because the site is getting a 1,000 hits per hour or because those 1,000 hits are on one particular page that uses more resources than the others? Is there a test that can be ran to give such a profile?
Do I tell my client that his site is just too busy for the server? Is the above server not powerful enough? There is another dedicated server available that uses Dual Xeon 3.0Ghz and 4 MB Ram but it is $100/month more. If that is the solution, then I can explain that to the client. But if he moves to it and it still doesn't fix the problem, it will have just made him angrier.
View 10 Replies
View Related
Jun 26, 2008
what experiences other people have been having with loads on their servers from spam. I was doing some profiling of our machines and noticed that load actually a fairly significant part of the load on our servers, and its way worse than it used to be.
Looking at the numbers I suspect we could comfortably have way more accounts per server if we could deal with spam better.
View 2 Replies
View Related
Feb 15, 2008
how to trace or know who is overloading IIS in windows 2003 server?
When i check in the task manager , i saw sometimes w3wp.exe (IIS Worker Process) using high CPU usage for long time. That cause the server to be sluggish and sometime not responding.
Any tips or software that can tell which websites that cause the overload?
View 6 Replies
View Related
May 1, 2014
I moved my sites to new linux server of mine (apache, mysql, php).
From that time i experienced some bigger websites hanging for like 2-3 seconds before they start loading. I mean when im browsing thru my website i click link, submit something and it waits saying in status field like "Waiting for mywebsite.com"
So i want to ask what apache, php etc values, what to check on server?
NOTE: my server is NOT overloaded (I am checking "top -c" stats) so don't suggest me to upgrade etc.
I have impression that it is waited until website elements are loaded and then webpage load very quickly after mentioned 2-3 seconds delay..
View 1 Replies
View Related
Oct 26, 2008
what is the real meaning of RDNS or the real function?
Because i have an account with reseller, then i need to hide the Name servers of a shared IP into my own name server IP.
View 2 Replies
View Related
Apr 15, 2009
my /var partition is full,
im not sure if any files i can remove to get more free space on /var partition.
because there are more free space on /home,
i think if i can move all the /var/lib/mysql to /home/mysql,
if yes,howcan i move it and do any change,
can let the sql data do not lose,
andrun well in the feature ?
View 14 Replies
View Related
Apr 4, 2007
I'm not sure I really understand the ins and outs of upgrading MySQL and I'm afraid to mess it up. From the MySQL site I see there's a 4.1.22 RPM available [url] and I'm running 4.0.18 (Your MySQL connection id is 2763253 to server version: 4.0.18-Max-log)
I'm not sure I want to bump it up all the way to 5, but I would like to run 4.1, but I also would like to stick with the RPMS, even after reading whatever I can find, I'm still not sure I understand what RPMs to install, here's what I have currently.
Code:
>> rpm -qa | grep -i mysql
php-mysql-4.3.11-1.1.rhel3.ct
MySQL-shared-compat-4.0.18-0
MySQL-Max-4.0.18-0
libdbi-dbd-mysql-0.6.5-5
MySQL-server-4.0.18-0
perl-DBD-MySQL-2.1021-4.EL3
MySQL-python-0.9.1-6
MySQL-client-4.0.18-0
MySQL-devel-4.0.18-0
There doesn't seem to be anything newer on the up2date server I use:
Code:
>>up2date --showall | grep -i mysql
MySQL-python-0.9.1-6.i386
libdbi-dbd-mysql-0.6.5-5.i386
mod_auth_mysql-20030510-2.ent.i386
mysql-3.23.58-16.RHEL3.1.i386
mysql-bench-3.23.58-16.RHEL3.1.i386
mysql-devel-3.23.58-16.RHEL3.1.i386
mysql-server-3.23.58-16.RHEL3.1.i386
perl-DBD-MySQL-2.1021-4.EL3.i386
php-mysql-4.3.2-39.ent.i386
qt-MySQL-3.1.2-14.RHEL3.i386
View 5 Replies
View Related
May 18, 2009
does mod_cache use real disk space or real memory to locate "cache"? I mean if i use mod_cache, does my vps/server will use more disk space/memory?
Quote:
mod_cache implements an RFC 2616 compliant HTTP content cache that can be used to cache either local or proxied content. mod_cache requires the services of one or more storage management modules. Two storage management modules are included in the base Apache distribution:
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
Jul 12, 2007
I have two hard disks, and I would like to move all of my MySQL data onto the second drive. My dilema is this; what is the best way to go about doing this? The tutorial I followed last night had me use cp to copy the /var/lib/mysql folder over to the second drive. However, it took ages to move one of my databases. It's a forum hosting database which has tons and tons of tables. It ran for about 5 hours and still didn't finish because I decided to stop it right there. I know it was working; but still, it took forever and I had to put it back up.
What would you do? Do you recommend say, copying just the 'mysql' database that has the users, and then taking a dump of all databases with mysqldump and moving it that way?
Also, is there any way using the cp command to continue what I started last night, but not write a database file if it hasn't chnaged at all?
View 8 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
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
Jul 18, 2008
to stream rm files via rtsp , ie users will listen to songs using real audio player using rtsp://servername/...
I could find a free program but only with 10 licenses. Do you guys know how can I stream for free unlimited (atleast 100) streams. Helix ? Real Audio server ?
View 2 Replies
View Related
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
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
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
