MySQL Database Service Stops From Running
Jan 4, 2008
I have a phpBB forum, which uses MySQl database.
For the last two months the forum has been going down every couple of days because the database service has been continuously stoped running on the server with no reason.
What can cause such a frequent database failures?
Can someone attack the forum/database/server in a way that will cause the above problem?
(there is a good reason I consider this possibility very seriously)
How can I prevent futher database failures?
View 2 Replies
ADVERTISEMENT
May 29, 2008
The problem is that it switches from running to mounted without me having anything to do with it. It seems to be quite randomly, for example this morning at 1.42 am. This happens once a day and stops my vps and therefore my website - which is quite annoying.
I checked for log files or anything, but there was nothing mentioning resources or anything.
Does anyone have a clue what this might be? If I cannot fix the problem there is still the opportunity to just start the vps once it goes to status mounted. How would I automate this?
I am using Virtuozzo and Plesk.
View 9 Replies
View Related
Jul 21, 2014
Out of nowhere apache stops working, and I have to restart the httpd service that restablesca
The message it throws is "Service Unavailable"
The server is a CentOS Linux Centos 6.5
It has 24 cores and 24 GB RAM
These are the values ​​that I have in httpd.conf
Timeout 60
KeepAlive Off
MaxKeepAliveRequests 100
KeepAliveTimeout 15
[Code]....
View 3 Replies
View Related
May 19, 2015
Since 15.05.2015 smtp experiencing problems.
Smtp service (qmail) stops responding on port 25:
# time telnet localhost 25
Trying 127.0.0.1...
quit
quit
Connected to localhost.localdomain (127.0.0.1).
Escape character is '^]'.
quit
quit
Connection closed by foreign host.
real 4m10.629s
user 0m0.000s
sys 0m0.002s
After server restart or sometimes apache stop or ixnetd restart its responding for a some random time, and then again it stops to respond. Plesk panel show it as stopped but qmail itself running in memory, and does other its work, it just stops responding at port 25, or responds with a huge delay.
I've tried change it to postfix, reconfigured with mchk, repaired with repair.sh -r, disabled and uninstalled parallels antivirus, antispam, dnsbl, disabled firewall, disabled smtp lock. Checked apache, dns. Enabled submission port which works when 25 port doesnt, but i need working 25 port.
Nothing solves problem, its just stops responding after some random time. There is no errors on maillog.
I think this problem occured after recent plesk microupdate, because i didn't do anything to server configuration in last months.
This article says it might be dnsbl [URL] .... but it disabled(from plesk panel) on my server, maybe there is way to focefully kill any relation to dnsbl?
Plesk info:
OS Red Hat Enterprise Linux Server 5.9 (Tikanga)
Panel version 11.5.30 Update #50, last updated at May 18, 2015 05:21 PM
The system is up-to-date; last checked at May 17, 2015 10:56 PM
update: xinetd restart is definitely brings smtp alive, but it goes off after random period of time (5min ~ couple hours)
View 1 Replies
View Related
Apr 3, 2008
Recently I've upgraded my MySQL server. I connect to it via a conection from NIC to NIC (Internal IP addresses). Since the upgrade/format, I've managed to get everything back to the way it was. Everything works fine for 15-20 minutes. Then the PHP server can no longer access the MySQL server.
I tried logging in from the PHP server, I get access denied. I then tried logging in locally, on the MySQL server and I get in fine...
It's not like it's a firewall issue though, it's strange...
I tried updating PHP/MySQL to a few releases, even the RC's to no avail...
Something to note is that when I try restarting MySQL it can take 4-5 minutes, sometimes not even complete.
View 2 Replies
View Related
Mar 29, 2009
I am having a very strange problem with 2 different cPanel accounts on a server with 500-600 accounts. For some reason after a day or two the mysql username/password stops working. We have tried changing the MySQL user and the password with no success. The log does not indicate that the MySQL password was changed in any way. Only these 2 accounts are affected and this problem occurred at least half dozen times each.
Again: these are two different accounts with 2 different MySQL users that after a while stop working (I am unable to determine if they stop working at the same time b/c they belong to different customers). When we reset the user (with the same pass) it works for a day or two. I have checked to connect not only from PHP but also from shell when it's down: it also doesn't work so this is a pure MySQL problem.
Also on the server we have Fantastico.
View 8 Replies
View Related
Dec 10, 2008
I am thinking of running a vpn service for a limited number of my clients, so that they can surf the web securely and anonymously through our VPS (routing all traffics through a vps). However I have no idea what features should I looking for, I mean how much BW or ram does it need.
Lets say I have 10~20 clients at all, Is a VPS with 300G monthly BW and 256(or 512)M of ram enough to have it work smoothly?
View 8 Replies
View Related
Mar 29, 2007
I want to run a php script in the background every 15 seconds (otherwise I would simply use cron)... Would anyone be able to tell me how I would set this up?
View 2 Replies
View Related
Jan 11, 2008
Does the iptables service need to be running in order for APF to function? If so, can APF act like it is running, when the iptables service is not running, thus giving you a false sense of security?
View 14 Replies
View Related
Apr 21, 2008
I am creating a software as a service product and I am going back and forth on a database design issue.
Should I create a separate database for each new customer, or create one big database and store all customers and do the standard relational database design idea.
The clear choice for me is create a new database for each new customer, but the only problem is rolling out schema updates and bug fixes. If I have 5000 customers and then 5000 databases, how to manage creating a new table, editing a column name or data type, editing a stored procedure, or creating a new trigger on 5000 separate customer databases?
So, there are many benefits for making a new database for each customer that I can think of:
With separate databases, customer’s data are each separate entities, it is the whole encapsulation/modular design idea. It is impossible to get data out of a different customer databases. With one large database a query that forgets to include the WHERE clause selecting a customer_id can cause havoc.
With one large database all customers are located in one, actually maybe a few, files. So many of the selects, inserts, deletes will scan all customers data, when all they ever need or care about is their own data. Even with indexes, inserts and deletes become slower with one large database as the size of the database increases.
What happens if you have one large database with 100,000 customers and say a table with 30 million records? Then you need to spilt the database across multiple servers, a cluster, because one machine inst cutting it. With a single database design, cluttering becomes a headache. With multiple databases, no problem, just setup a new server and start adding new databases.
Also, last thing is database integrity. With one large database if you database gets corrupt or accidentally deleted, or modified in a way which causes unwanted results all your customers are screwed. With multiple databases problems only effect the one single customer, again each customer is a separate entity.
The only problem of course with multiple databases, and the root of my question; how do I manage database schema maintenance? How do I effectively roll out changes to each customer database schema?
View 6 Replies
View Related
Jul 27, 2007
I have a tiny MySQL database (10MB) and I'm looking for some remote backup service. Someting that will backup the database and let me recover it if the host is in trouble.
I strongly prefer something simple and fully automated.
View 5 Replies
View Related
Aug 10, 2007
I just got a new server and updated the OS etc. Since I am use to seeing the old top information I have questions about the new top data. Some of the differances
1. Many less processes (or task as it is now called) then before.
2. Mysql is only shown once with a long time value. Before I had serveral mysql task and time was short
3. In most cases I have only 1 process running but in the onld system it jumped around from 4 to 10
4. The HTTP task below shows a long time and I see very few. Before had at least 10 shown and the time was very short.
Any ideas if maybe I have a setting wrong that is allows less theads or processes to be created?
Apache 2.2
Plesk 8.2
Fedora Code 6
mysql 5
top - 07:56:45 up 28 days, 11:49, 1 user, load average: 0.18, 0.17, 0.17
Tasks: 121 total, 1 running, 120 sleeping, 0 stopped, 0 zombie
Cpu0 : 0.0%us, 0.0%sy, 0.0%ni, 97.0%id, 3.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 1.0%us, 0.3%sy, 0.0%ni, 97.0%id, 1.7%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 5.3%us, 0.7%sy, 0.0%ni, 94.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 3360708k total, 3203700k used, 157008k free, 220304k buffers
Swap: 2031608k total, 4208k used, 2027400k free, 2269484k cached
PID to kill:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1521 mysql 15 0 404m 90m 4576 S 6 2.8 245:28.29 mysqld
13298 apache 15 0 40532 12m 4380 S 0 0.4 0:03.31 httpd
14021 apache 15 0 40616 12m 4416 S 0 0.4 0:02.75 httpd
14462 apache 15 0 41216 13m 4452 S 0 0.4 0:03.05 httpd
16330 apache 15 0 40644 12m 4184 S 0 0.4 0:01.10 httpd
16558 root 15 0 2200 1016 796 R 0 0.0 0:01.68 top
1 root 15 0 2044 604 520 S 0 0.0 0:02.27 init
View 3 Replies
View Related
Apr 10, 2008
mysqq has a nice value of 6, is this fine? I read somewhere that it's better at a value of -5.
View 4 Replies
View Related
Mar 23, 2015
I have a single mysql process that never stops and running with 10-200% CPU load: URL....
I restart mysql => process coming back
I restart server => process coming back
I kill process => process coming back
I have run:
# mysqladmin -uadmin -p`cat /etc/psa/.psa.shadow` -i 1 processlist
but there was noting that runs >10min.
Code:
> SHOW FULL PROCESSLIST;
+------+-------+-----------+------+---------+------+-------+-----------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-------+-----------+------+---------+------+-------+-----------------------+
| 328 | admin | localhost | psa | Sleep | 56 | | NULL |
| 8110 | admin | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST |
+------+-------+-----------+------+---------+------+-------+-----------------------+
2 rows in set (0.00 sec)
I have strace the PID
Code:
# timeout 1m strace -f -c -p 5873
Process 5873 attached with 30 threads - interrupt to quit
Process 10499 attached (waiting for parent)
Process 10499 resumed (parent 5873 ready)
Process 10502 attached (waiting for parent)
Process 10502 resumed (parent 5873 ready)
Process 10503 attached (waiting for parent)
[code]....
I found with google a hint for high cpu URL....I have deinstalled "health monitor" module, but that was not the reason.I use plesk 12.0.18 Update #38 with CentOS 6.6 (Final).
View 2 Replies
View Related
Apr 29, 2008
i have subscribe server http uptime monitoring service. may i know any provider provide mysql monitoring service?
View 3 Replies
View Related
Apr 12, 2009
My vps is run well, then i reboot and i see mysql no longer working. I check in WHM
mysql (5.0.67-community) failed
And when restart (by WHM )
Restarting MySQL Server
whmappname='Restarting Service'; if (self['update_ui_status']) { update_ui_status('MySQL Server'); } Waiting for mysql to restart..............finished.
mysqld_safe (/bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/server.xxxx.com.pid) running as root with PID 5275
mysql has failed, please contact the sysadmin (result was "mysql has failed").
My VPS in unmanaged, i can't access mysql.
View 4 Replies
View Related
