MySQL Is Frequently Down
Jun 21, 2009
I have a VPS with following features: Dual Xeon, 512MB Ram (up to 1GB), CentOS.
Unfortunately MySQL is frequently down, about once per day, and it takes time to set up again. to change mysql config to resolve this issue?
my.cnf:
PHP Code:
[mysqld]
skip-bdb
max_connections = 250
max_user_connections = 30
thread_concurrency = 1
key_buffer = 128M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 1M
record_buffer = 1M
max_allowed_packet = 8M
table_cache = 200
thread_cache_size = 64
wait_timeout = 10
connect_timeout = 10
interactive_timeout = 10
max_connect_errors = 10
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 8M
skip-locking
safe-show-database
#log-slow-queries = /var/log/mysqld.slow.log
#long_query_time = 2
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 32M
read_buffer = 16M
write_buffer = 16M
View 4 Replies
ADVERTISEMENT
Dec 25, 2008
I have a VPS with 2GB RAM. The load is always around 0.5 - 0.7. It's Xen VPS, and I see the VPS doesn't use swap yet. However, Apache is going down frequently. Might be 3-4 times per day, and DA informs me about the downtime when trying to restart Apache.
In apache error_log, I haven't seen any special error. Just few lines like this
Quote:
[Thu Dec 25 21:53:03 2008] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Thu Dec 25 21:53:03 2008] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Thu Dec 25 21:53:03 2008] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
[Thu Dec 25 21:53:04 2008] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Thu Dec 25 21:53:04 2008] [warn] RSA server certificate CommonName (CN) `localhost' does NOT match server name!?
[Thu Dec 25 21:53:04 2008] [notice] Apache/2.2.11 (Unix) mod_ssl/2.2.11 OpenSSL/0.9.8b DAV/2 PHP/5.2.8 configured -- resuming normal operations
I wonder why Apache is going down frequently, and how to fix it?
View 5 Replies
View Related
Jan 16, 2007
I have a cpanel server with 2GB of ram. For the last two weeks , we are experiencing problems with apache in the server. Apache goes down frequently in the server and we had to manually restart the service everytime. chkservd do nothing for a restart. I had
recompiled apache using easyapache script.
Strangely i can see some entries like the following in apache error logs
host: isc_socket_create: not enough free resources
I compiled it one more time but the errors still exist.
View 8 Replies
View Related
Jun 10, 2007
I have a server from FDCservers
My server is down at least 2 times a day causing downtime of 10 minutes to hours!
Configuration:
Core2DUO E6600
1 GB RAM
400 GB HDD
100 mbit port
cPanel/WHM/Fantastico/Rvskin
CentOS 4.5 32 bit
They swapped the RAM many times but still it sisnt resolved
I asked PSM to look why it crashes, they said that its working fine and tweaked settings. Please open a ticket again if it goes down again.
I am not going to open a ticket again and again everytime when it goes down since I am not online everytime.
When it crashes(or whatever) it responds to ping requests but not to http ssh ftp or anything else including cPanel/WHm.
View 14 Replies
View Related
Apr 28, 2009
This is the Strange problem i face. my blog goes down while the server is up, comes back automatically after some time.
I can access the Cpanel without a problem, can anyone tell whats wrong?
Code:
C:Documents and SettingsGaurish>ping [url]
Ping request could not find host [url] Please check the name
d try again.
C:Documents and SettingsGaurish>ping [url]
[url][67.228.104.181] with 32 bytes of data:
Reply from 67.228.104.181: bytes=32 time=495ms TTL=50
Reply from 67.228.104.181: bytes=32 time=468ms TTL=50
Reply from 67.228.104.181: bytes=32 time=500ms TTL=50
Reply from 67.228.104.181: bytes=32 time=515ms TTL=50
Ping statistics for 67.228.104.181:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 468ms, Maximum = 515ms, Average = 494ms
During this i don't change any setting, so less chance misconfiguration
View 14 Replies
View Related
Jan 11, 2009
My Awstats is updating every other day and I would like it to up date daily.
I am in my third month of hosting and in about first 2 months, Awstats would update every day.
I have searched and read where it is possible to get Awstats to update manualy but it seems that my scenario isn't the same as everyone else's.
I am accessing my Awstats through CPanel and there is no way that I see to modify when Awstats updates.
View 7 Replies
View Related
Oct 3, 2008
I've been running 3 Xen servers for the last few months in a production environment, and facing a strange problem with one of them.
Server 1 and 2 run a couple of DomU's and are running just fine.
Server 3 runs one DomU and takes care of all the backups for the DomU's of Server 1 and 2
The DomU on Server 3 is crashing every night, right when the backups are being made.
DomU becomes inaccessible, but keeps appearing at xm list with state ------
When I try to connect to the console it wont let me connect. The only way to get the DomU back up is by using xm destroy and xm create again.
For the back-up I use NFS where the DomU on Server 3 is the host, and the other DomU's of Server 1 and 2 connect to it through an internal bridge.
Below you'll find some information about Server 3:
Hardware:
HP ProLiant DL380 G5
10Gb Memory
( 8 x 146G SAS10k in RAID 5 )
Dom0:
CentOS 5 kernel 2.6.18-92.1.10.el5xen
Booting params: dom0_mem=1024M
DomU:
CentOS 5 kernel 2.6.18-92.1.10.el5
Booting params: acpi=off clock=pit
The last qemu-dm log on Dom0:
char device redirected to /dev/pts/1
qemu_map_cache_init nr_buckets = 4000
shared page at pfn bffff
buffered io page at pfn bfffd
xs_read(/vm/a8af3ec4-19d4-774e-af65-0902374dc616/rtc/timeoffset): read error
I/O request not ready: 0, ptr: 0, port: 0, data: 0, count: 0, size: 0
Triggered log-dirty buffer switch
I/O request not ready: 0, ptr: 0, port: 0, data: 0, count: 0, size: 0
I/O request not ready: 0, ptr: 0, port: 0, data: 0, count: 0, size: 0
xs_write(/vm/a8af3ec4-19d4-774e-af65-0902374dc616/rtc/timeoffset, rtc/timeoffset): write error
View 3 Replies
View Related
May 1, 2008
this is getting out of control. I have a dedicated server that is "unmanaged" meaning, I manage it
I typically can make my way around a server and do most things - but in this case I'm stuck. I host a number of websites on this box and have went over a year with little problems. The past month or so it seems as though the server crashes daily or every other day. It will be running just fine, then all of a sudden the processes and loads will go out of control until the server is just unusable.
What do I need to provide here for you to be of any help to me? I watch the processes using "top -ci" and it's typically small output - but when it's getting ready to crash it's like a ton of processes get backed up and continue running.
View 14 Replies
View Related
Jan 17, 2008
I am running shoutcast on a spare dedicated system, for some reason it has been buffering a little to often for my liking.
I am running 64 kbps for 300 listeners and buffering problems become frequent around 150 listeners.
Is there anyway I can reduce the frequent buffering (be it hardware or software doesnt matter).
Latency seems very high (1100ms)
Would the fact that the server has been running continuously for 6 days have anything to do with it?
View 4 Replies
View Related
Oct 30, 2009
globichen can explain about this.
ping timeout happen frequently.
this is the 2nd time happen in a week
i've submit a ticket regarding about this
customer service replies with server is online.
i'm not bashing their service but frequently ping timeout really makes my business down lately.
Loading website takes a few min & even couldn't access to server due to ping timeout.
View 14 Replies
View Related
Apr 11, 2008
Many a times websites hosted on my Red Hat Linux server would not open even though Apache and everthing else is up and running. When i hit reload on browser 4-5 times the website would load or i have to restart Apache and everything starts working normally.
Today when this problem resurfaced i did not restart Apache and looked for in apache logs and saw this strange entry in apache Error Log;
[client my.ip.xx.xx] script '/my/website/httproot/mdqt.php' not found or unable to stat
The above was in apache Error Log, above is my ip address, and i never requested a file named mdqt.php, in fact no file by the name mdqt.php even exist on my entire server.
I then looked for mdqt.php in error logs and saw several requests made for this file and from various IP addresses.
i understand this is what causes my http to die.
View 9 Replies
View Related
May 16, 2007
Code:
Kernel Version2.6.18-4-686 (SMP)
Distro Name Debian 4.0
Model Intel(R) Pentium(R) 4 CPU 2.40GHz
I've installed the default apache 2, mysql, php using aptitude.
The server load is not at all high, around 1-1.5 max. The apache processes running are at an avg 60-80. It has 1GB ram and Disk Swap usage is 0kB
My server keeps rebooting every now and then. These are the messages I get in the ssh session just before the reboot..
Code:
Message from syslogd@xxx at xxx
kernel: Bad page state in process 'apache2'
kernel: page:c17bc0a0 flags:0xc0000000 mapping:00800040 mapcount:0 count:0
kernel: Trying to fix it up, but a reboot is needed
kernel: Backtrace:
View 8 Replies
View Related
May 8, 2009
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
View 4 Replies
View Related
Jan 21, 2007
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View 1 Replies
View Related
Jun 16, 2008
For some reason mysql wont start, i have tried restarting mysql but it wont, it says FAILED. The mysql.sock file seems to have disappeared and i cannot find it anywhere.
View 5 Replies
View Related
Feb 11, 2008
I recently had a harddrive failure and luckliy I can still access certain directories on this failed drive. I can still access the /var/lib/mysql/ directory which holds all the users databases and have backed all these up separately using tar.
Now what I need to know is how do you restore these database files to another server? I tried simply untar'ing one of these to the new servers /var/lib/mysql/ direcotry and it stuffed Mysql up - it went offline. I had to get a cpanel tech to bring Mysql back online.
how can I get these database files to fully work on a new server?
View 2 Replies
View Related
Jan 17, 2008
Can someone recommended me some one with knowledge of mysql exploit or mysql injection, it seem to our VB forum have issue with database load..
View 5 Replies
View Related
Jan 15, 2007
I've been racking my brains with this problem for the last couple of months and have made zero progress. I've asked a lot of people if they know what might be wrong here, but none of them have any idea.
Basically, the problem is that any sort of service monitor I put on my server shows MySQL as being down/offline, even when I know for sure it's up and running perfectly fine. All other services report a green light.
The mysqld service is running on port 3306, which is open both inbound and outbound on my APF config, so as far as I can tell it's nothing to do with the firewall (I won't rule that out though).
The other odd thing is that MySQL shows a green light within WHM, but not anywhere else.
Does anyone know what might be wrong here? Am I missing something entirely fundamental and obvious?
View 11 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
Mar 28, 2007
I've rented a dedicated server that comes with Red Hat Enterprise Linux 4 and MySQL 3.23 but I need at least MySQL 4.1 or higher. My knowledge about GNU/Linux is very limited, so I've read some documents at mysql.com and now I think I have to follow these steps:
1. Uninstall MySQL 3.23 with this command line:
shell> rpm -e mysql-*.rpm
2. Install the server and client RPMs of MySQL 5.0:
shell> rpm -i MySQL-server-VERSION.i386.rpm
shell> rpm -i MySQL-client-VERSION.i386.rpm
View 2 Replies
View Related
Jun 13, 2007
I have a number of web sites on a dedicated server. Some of these web sites are a few years old. Are there any issues upgrading from MySQL 4.1 to 5.x? Are there web sites that may have compatibility issues?
View 6 Replies
View Related
Dec 18, 2007
I keep getting this error :
MySQL Error : MySQL server has gone away
How do I fix it?
my.cnf contents
Quote:
[mysqld]
safe-show-database
old_passwords
back_log = 75
skip-innodb
max_connections = 800
key_buffer = 48M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 3000
thread_cache_size = 128
wait_timeout = 90
connect_timeout = 30
tmp_table_size = 128M
max_heap_table_size = 64M
max_allowed_packet = 256M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_user_connections = 500
[mysqld_safe]
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
View 5 Replies
View Related
Jun 27, 2009
I have recently upgraded mysql server from 5.0.75 to 5.1.31 on my Ubuntu server 9.04 32 bit. After that when I am running phpmyadmin it is printing a warning :
Your PHP MySQL library version 5.0.75 differs from your MySQL server version 5.1.31.
View 2 Replies
View Related
Jun 3, 2008
I'm trying to upgrade from MySQL 4 to MySQL 5 for performance reasons. MySQL 4 was working great so I decided to just go ahead and upgrade to MySQL 5 via CPanel. The upgrade appeared to go fine however I now get this error when trying to start MySQL.
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
I went ahead and did a forced re-install of MySQL 5, but that didn't help. Apache has been updated as well since then, but that did no good, and the MySQL process isn't starting at all.
Its CENTOS with PHP5.
View 1 Replies
View Related
Jun 21, 2007
I am not sure what difference between --with-mysql and --with-mysql=/usr to compile php 4.4.7
because I get error message when I use --with-mysql=/usr
the error message is like Mysql header can not be found or similar thing.
it ok when I use --with-mysql
so, I am afraid that can I use php and mysql without problem by using --with-mysql?
View 1 Replies
View Related
Jan 20, 2007
I'd like to upgrade my current mysql 4.1 version to mysl 5, but i can't find a good tutorial or explenation! I've been searching for hours now without any good results.
I've downloaded the lastest stable mysql 5 .rpm, and tried to install it with rpm -i mysql.version.rpm, but it says the following:
# rpm -i MySQL-server-standard-5.0.27-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL conflicts with mysql-4.1.20-1.RHEL4.1.i386
MySQL-server conflicts with mysql-server-4.1.20-1.RHEL4.1.i386
I guess that means i have to uninstall mysql 4.1 first.
ok...
# rpm -e mysql-server-4.1.20-1.RHEL4.1.i386
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
Let's try to install it now.
# rpm -i MySQL-server-standard-5.0.27-0.rhel4.i386.rpm
warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
MySQL conflicts with mysql-4.1.20-1.RHEL4.1.i386
Ok, let's remove that.
# rpm -e mysql-4.1.20-1.RHEL4.1.i386
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.22.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) php-mysql-4.3.9-3.22.i386
mysql = 4.1.20-1.RHEL4.1 is needed by (installed) mysql-devel-4.1.20-1.RHEL4.1.i386
Does upgrade work?
# rpm -Uvh MySQL-server-standard-5.0.27-0.rhel4.i386.rpm warning: MySQL-server-standard-5.0.27-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
error: Failed dependencies:
libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386
libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.22.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) dovecot-0.99.11-4.EL4.i386
libmysqlclient.so.14(libmysqlclient_14) is needed by (installed) php-mysql-4.3.9-3.22.i386
Clearly not.
How do i upgrade mysql?
View 1 Replies
View Related
Feb 16, 2007
I have a big issue importing 4.0 databases with mysql 5.0.27.
I did a mysqldump -pxxxxx --force --all-databases > file.sql on server with mysql 4.0
But when I tried to import the file on server with mysql 5.0, this is what I got:
ERROR 1064 (42000) at line 2: 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 'database' at line 1
I even tried to force import and I got:
ERROR 1046 (3D000) at line x: No database selected for every database.
I checked sql file and CREATE DATABASE xx and USE xx were both added.
I tried this with a single database and worked but with all not
View 6 Replies
View Related
Jun 1, 2007
loading a phpinfo() shows that the mysql variable "Client API version" on my server doesn't match the version of mysql installed ( 4.0.20 when mysql version is 4.1.21).
Can this cause trouble and php or mysql errors on scripts i'm running?
View 0 Replies
View Related
Nov 28, 2008
What are the files in this directory - /var/lib/mysql/
Files like
#sql_2a6c_0.MYD
#sql_2a6c_2.MYD
etc
etc
I have a stack of them all 200MB plus in size
I need to cleanup /var as its 99% full, what else can I clean up?
View 11 Replies
View Related
Nov 28, 2008
MySQL 5.1 GA
Has anyone tried to migrate already?
View 6 Replies
View Related
Apr 15, 2008
Mysql usage is very high now and most time server load is high.
Where is issue and how can resolve this?
View 11 Replies
View Related