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.
I have a CentOS server running WHM/cPanel and have just had a recent problem pop up:
My SMTP server will only accept connections if the client has their SMTP settings set to use SSL. It won't accept regular, non-SSL connections. Ordinarily I'd welcome the added encryption, however, most of my users who rely on the SMTP server have their mail clients set not to use SSL.
Is this a setting somewhere? If so, can someone direct me as to where it would be, because I've been looking for hours and can't find a thing!
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)
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.
On one of my sites, mysql uses most of the resources of the dedicated server. I'm thinking of putting multiple mysql servers at home and the rest in the data centre. Having mysql servers at home does not require much bandwidth does it? would a dsl line work ok?
My PHP application is starting to reach max mysql server user connections limit (currently set to 60). I listed mysql process list in phpmyadmin and found there lot of queries with status "LOCKED" these hang there for a long time(not always just sometimes - twice a day) and then connection limit is reached. It causes load average about 40 for as long as 10 - 20 minutes
I think it may be bacause of query structure. There are some queries with many inner joins...
Here is typical situation from phpmyadmin's process list:
1. select ... from table_1 inner join table_2 inner join table_3 inner join table_4 inner join table_5 This show status : "Copying to tmp table" in phpmyadmin
2. update table_2 set ....
This shows status: Locked
3. select ... from table_2
This shows status: Locked
Seems then when temp table is being created the table_2 is locked and it cannot make update to table_2. or maybe it's locked because of just that update on table_2.
I want to avoid of creating temp tables... Can it help if I'll make separate selects without large table joins ?
I'm currently using MySQL 4.1.12 for Windows 2003, and I need to know how much possible connections can MySQL achieve? I'm currently around 650. I'm having 4 new servers online, and that will bring my total concurrent connections to 1000+.
from what I view, wait_timeout is used for disconnecting connections. However, it applies to tcp/ip connection only. So, in my database connection, if I am using mysql server as localhost, that variable is not applied? In that case, how can I close connections automatically after xxx seconds?
i have a small cluster (one web and one db) setup and i host a rather popular group of 4-5 sites that allow users to dynamicly create their own mobile chat communitys automaticly. each site gets its own mysql db created and populated automaticly.
this is all fine,
but in the last 24hours weird things have begun happening, previously i had the sql max_connections set to 500 and this was perfectly adquate for the demand but now even when i set the connection to 4000+ they are all maxxed out within 5-10 minutes, and mysql processlist shows thousands of unauthenticated user connections sitting at login status,
i have gone through the sites and all their mysql configs are fine so i cant see what the issue is.
server specs below
db server: dual amd opteron 246 8GB ram 120gb hd(64gb free) 33gb swap (rarly used but their for emergencys) centos 5 64bit. direct 100mbit lan to web serv only mysql,ssh and webmin running, no other apps installed
unfortunately my server crashes a lot recently. What happens is that some application creates a MySQL connection which hangs and then MySQL gets overloaded and takes the whole server down.
My question:
1. How do I configure MySQL to time out even on active connections ? I.e. after 30 seconds kill the process no matter if it is still active or not. Is that possible ?
This has happened twice now. I have my wait_timeout variable set to 60 seconds, but occasionally my database gets overloaded with "locked" queries. Here's an example of my processlist:
This continues on with locked queries all the way up to my limit of 450 connections, then the whole server goes down. Note the time spent processing these queries, 35483 seconds and counting! Surely the wait_timeout is supposed to prevent this from happening?!
Also, this appears to start with queries in the State "statistics". Then the State for the following queries becomes "locked". Does anyone know what these mean? Can I get them to timeout normally? Queries which never timeout are guaranteed to bring your server down eventually, surely this is not the desired behaviour.
for a linux web host that has extremely fast mysql connections, 100GB of bandwidth, and the amount of space has to be at least 1GB. Price doesn't really matter.
I am looking to add a mysql external source to my plesk. So far no difficulty.
My question is if I remove the mysql server where the currently plesk. I have to say to the panel get the information (psa, roudcube, horde) on the remote mysql to invez mysql local server?
I have 2 servers both have cpanel. I want to use 2nd server's mysql in my site which is on 1st server. I think thats not that hard. I don't wanna do clustering as this is temproary.
I'm selling downloads of music files. The zip files are quite large. I've had several people complain that they get a message that the server resets their connection before the download finishes.
I have a very strange problem. Yesterday morning I got a "server down" alert. Restarted httpd and everything run ok ... until today morning, the same problem again.
Symptoms:
1. The webserver did not stop working, it just took too much time to respond.
2. I cannot find anything suspicious in the logs.
3. I started to log the number of apache processes in 4 minutes interval, it did not increase during the failure but remained at a very reasonable number.
4. Now, almost 3 hrs from the last failure, there are 36 apache processes, each eating 14M RAM, server has 4GB ram total, no swapping, almost 3GB are free (cached).
The question is. How should I prepare for the expected tommorow failure, to be able finaly localise the problem?
I have 3 servers ServerA(Web, mail), ServerB(MySQL+Master replication), ServerC(Mysqlslave+web)
It happens that my website stops responding for few mins and then it comes back again automatically. I checked the server logs but I couldn't find any suspicious.
Also, while the website is not accessible when I try to connect internally from ServerC to ServerA or ServerB using SSH. It takes lots of time (approx more than 60 seconds) to connect. When website starts working SSH is also working fine.
This is very complicated for me. Can anyone let me know what should be the problem or how can I find root cause of this problem?
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 have a VPS on which i host one of my Proxy site and nothing else (no databases, no emails, just the usual proxy files needed).
just today it stopped working it is showing the Centos Page .the URL is [url]
here are the steps that i have taken till now without success: 1. restarted the server 2. stopped and restarted some critical services like httpd etc. 3. restarted my free crappy control panel also Ravencore
but all without success
if u feel that u can help me out then can tell u my webmin root password also via PM (u must be a reputed member).
we've been with Softlayer for a little over a year. The service has been good but their support has been a nightmare for us. There was a time that we were under a dos attack and they refused to do anything about it which is what forced us to switch.
But that's not the reason I'm here. My billing ends on the 12th, their terms require you cancel the server 3 days before billing ends. I pay manually each month by pay pal. I tried to cancel the server today, what I assumed was 3 days before the 12th and they told me I couldn't do it. That I had to pay for another full month. So I told them I just won't pay and they threatened me with a late fee. Is there anything legally these people can actually do to me if I don't pay? All they have is my contact information, I don't think they could submit to collections over that without my social security number.
I am providing consultancy for a SOHO type of organization - 6-10 employees. The budget is not much for hosting. So we can't go high end. The current hosting company, in a way addresses more than 60% of the needs. However 1 important need is for users to be able to change their password for their email account. The current host says that DirectAdmin and CPanel fall short on this and nothing can be done. Any suggestions for hosts that address this need?
This is what the current package looks like:
* Directadmin control panel * Apache web server * Exim smtp server * PHP5 scripting language * PHPMyAdmin database control * Unlimited subdomains * SSI server side includes * Centos linux OS * Great uptime * Squirrelmail web mail * MySQL 5 database server * PERL private CGI-BIN * Unlimited domain pointers * Webalizer statistics * 1,000 megabytes of space * 5,000 megabytes of transfer * Unlimited POP3 and FTP * Unlimited mySQL databases * Unlimited sub domains
I ran a shell server on FreeBSD 4.x and was able through (if I recall...) a kernel option to allow users to only see their own processes. For example, if a user ran top it only showed their processes and no others.
I'm racking my brain trying to remember what I did to make that happen and I'm not having much luck with google.
Any other FreeBSD folks here that are familiar with this and care to remind me?
