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 ?
2. How do I exclude the root user from that?
i am having an website like a webdirectory. BUT i am getting this error after every 5-10 mintues :
Warning: mysql_pconnect() [function.mysql-pconnect]: User USERNAME
has already more than 'max_user_connections' active connections in
/FIELPATH on line 93
Database error: pconnect(localhost,bstitne_netclass, $Password)failed.
MySQL Error)
Session halted.
PLEASE suggest how can i solve this. May be it is an server issue
Since moving over to a new server, I have had to reboot my sql server about 5 times a day due to it crashing, and I always get the error:
Warning: mysql_connect() [function.mysql-connect]: User food_user has already more than 'max_user_connections' active connections in /home/food/public_html/includes/functions.php on line 9
Not connected : User food_user has already more than 'max_user_connections' active connections
I dont understand what is causing this...I used the tweaking guide as found on here and my.cnf file looks like this:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
query_cache_limit=8M
query_cache_size=256M
query_cache_type=1
max_connections=500
max_user_connections=10
interactive_timeout=20
wait_timeout=20
connect_timeout=6
thread_cache_size=128
key_buffer=16M
join_buffer=1M
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=2M
read_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M
#log-bin
server-id=1
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet=16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
[myisamchk]
key_buffer=32M
sort_buffer=32M
read_buffer=16M
write_buffer=16M
Through my WHM, i went to "Show Mysql Processes" and heres what it displays www.brinked.com/mysql.txt
This problem has also occured on another one of my websites on the same server that makes use of mysql. Am I doing something wrong here? I dont think its the script because it ran for years on another server just fine.
I'm having a bit of trouble here with MySQL, I don't know what to do. Centos 4.3, Mysql 4.1
Data is stored in /var/lib/mysql/
I'm looking to move that information to a second hard drive soon, and did a quick test of just copying it to another place on my existing drive. It won't start.
Quote:
[root@localhost ~]# service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
Error logs
Code:
071106 12:14:33 mysqld started
071106 12:14:33 [Warning] Can't create test file /var/lib/mysqltf/localhost.lower-test
/usr/libexec/mysqld: Can't change dir to '/var/lib/mysqltf/' (Errcode: 13)
071106 12:14:33 [ERROR] Aborting
071106 12:14:33 [Note] /usr/libexec/mysqld: Shutdown complete
071106 12:14:33 mysqld ended
071106 12:17:00 mysqld started
071106 12:17:00 [Warning] Can't create test file /var/lib/mysqltf/localhost.lower-test
/usr/libexec/mysqld: Can't change dir to '/var/lib/mysqltf/' (Errcode: 13)
071106 12:17:00 [ERROR] Aborting
071106 12:17:00 [Note] /usr/libexec/mysqld: Shutdown complete
071106 12:17:00 mysqld ended
I have tried even chmod 777ing the msyqltf folder (my copy) to no avail.
my.cnf
Code:
[mysqld]
datadir=/var/lib/mysqltf/
socket=/var/lib/mysqltf/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
I've tried moving it to different locations. I even tried moving the original folder and renaming it, and still get this problem.
I'm hosting about 6 private websites on my server, and some have problems.
My biggest website is a vb forum with 30.000 members and 1.5 million posts.
When i browse with firefox i see that vb forum loads fast, but phpads which is integrated on the top and footer loads very slow. When i browse with IE, it takes like 10 seconds before the whole site is loaded and sometimes IE even crashes.
When i try to login on another website / admin panel (oscommerce), i get a mysql gone away error, that means timeout. But why does it show that? I ran mysqlreport and can't find anything why it should display mysql gone away.
# ./mysqlreport
MySQL 5.0.15-standard uptime 3 19:36:47 Mon Feb 5 11:08:10 2007
__ Key _________________________________________________________________
Buffer usage 78.94M of 96.00M %Used: 82.23
Write ratio 0.60
Read ratio 0.00
__ Questions ___________________________________________________________
Total 19.61M 59.47/s
Slow 9 0.00/s %Total: 0.00 %DMS: 0.00
DMS 7.17M 21.74/s 36.56
__ Table Locks _________________________________________________________
Waited 7.57k 0.02/s %Total: 0.05
Immediate 16.50M 50.03/s
__ Tables ______________________________________________________________
Open 1.27k of 1800 %Cache: 70.56
Opened 1.82k 0.01/s
__ Connections _________________________________________________________
Max used 47 of 500 %Max: 9.40
Total 2.62M 7.95/s
__ Created Temp ________________________________________________________
Disk table 6.77k 0.02/s
Table 635.25k 1.93/s
File 50.37k 0.15/s
I can't find any problems on the server which may lead to this strange problem.
The server load is normal, around 1 to 1.5. No weird errors in the apache error log or system log.
This strange behaviour started 2 weeks ago, and appears 2 to 3 time a week.
The system is running:
centos 4.3 64-bit
kernel 2.6.16.17 #1 SMP
directadmin 1.29.0
mysql 5.0.15
php 5.2
apache 2
Zend optimizer 3.2.0
Eaccelerator 1.95
One thing i noticed is that every night when the directadmin cron finished, the server acts normal again.
The directadmin cronjobs are:
* * * * * root /usr/local/directadmin/dataskq
2 0-23/6 * * * root echo 'action=vacation&value=all' >> /usr/local/directadmin/data/task.queue;
#5 5 * * 0 root /sbin/quotaoff -a; /sbin/quotacheck -augm; /sbin/quotaon -a;
20 4 1 * * root echo 'action=reset&value=all' >> /usr/local/directadmin/data/task.queue
0 4 * * * root echo 'action=check&value=license' >> /usr/local/directadmin/data/task.queue
10 0 * * * root /usr/local/directadmin/plugins/awstats/hooks/cgi-bin/awstats_updateall.pl now -awstatsprog=/usr/local/directadmin/plugins/awstats/hooks/cgi-bin/awstats.pl && echo 'action=tally&value=all' >> /usr/local/directadmin/data/task.queue
I just installed mySQL server on a brand new dedicated server and am getting Timeout error occurred trying to start MySQL Daemon. I have uninstalled and reinstalled it a few times and am still getting the same error.
View 11 Replies View RelatedI am getting the error (as listed in the title) on my server. This is a BRAND NEW FRESH install on a brand new server...
OS: Unix Fedora
Kernel Version: Kernel 2.6.18-1/2798.fc6 on an i686
Hardware Information: Brand new Dell SC1435 Server
Software Version: MySQl 5
Control Panel: Nothing yet
Apache starts ok but when I go to strart MySQL I get the following error...
[root@server112]# /etc/rc.d/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon
Starting MySQL: [FAILED]
Does anyone have any ideas?
I did some pretty extensive searching...
Web Hosting Talk article that basically describes the same error. I followed everything as listed in his suggestion and it didn't change anything.
Also Checked here but this didn't work either.
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+.
how high it can go?
I notice that most hosting have limit of mySQL connections.
If the max mySQL connections is 50 and I run a forum on this hosting,about how many people can visit my website at one time?
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?
View 8 Replies View Relatedi 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
web server:
amd athlon 64 3800+
plesk 9.2.1
4gb ram
2x120gb hds
apache status onthe web server only shows 120ish http connections but the sql keeps climbing
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:
Code:
| 14773848 | db_name | localhost | db_name | Query | 35483 | statistics | SELECT COUNT... |
| 14776290 | db_name | localhost | db_name | Query | 35144 | statistics | SELECT COUNT... |
| 14778877 | db_name | localhost | db_name | Query | 34841 | statistics | SELECT COUNT... |
| 14790744 | db_name | localhost | db_name | Query | 33056 | Locked | UPDATE... |
| 14791275 | db_name | localhost | db_name | Query | 32977 | Locked | SELECT... |
| 14791395 | db_name | localhost | db_name | Query | 32960 | Locked | SELECT... |
| 14791556 | db_name | localhost | db_name | Query | 32929 | Locked | SELECT... |
| 14791603 | db_name | localhost | db_name | Query | 32924 | Locked | SELECT... |
| 14791757 | db_name | localhost | db_name | Query | 32900 | Locked | SELECT... |
| 14792209 | db_name | localhost | db_name | Query | 32815 | Locked | SELECT... |
| 14792355 | db_name | localhost | db_name | Query | 32786 | Locked | SELECT... |
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.
View 8 Replies View RelatedRecently 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.
how i can limit http and mysql connection limit on per domain basis.
View 2 Replies View Relatedat my logs, i can see this timeout error caused my mod_security at my rhes 4 server.
Code:
mod_security-message: Access denied with code 403. Error reading request body, error code 70007: The timeout specified has expired [severity "EMERGENCY"]
I didnt specify any mod sec rule about "timeout", what timeout is this about?
I have a message in queue for about 24 hours and checking the delivery log I found this.
LOG: MAIN
cwd=/usr/local/cpanel/whostmgr/docroot 4 args: exim -v -M 1INUw5-0007VU-DZ
delivering 1INUw5-0007VU-DZ
Connecting to mx.uol.xxx.br [xxx.xxx.com.br]:25 ... connected
SMTP<< 220 starfury20.xxx.com.br ESMTP
SMTP>> EHLO svr01.xx***********
SMTP<< 250-starfury20.xxx.com.br
250-PIPELINING
250-SIZE 20971520
250-VRFY
250-ETRN
250 8BITMIME
SMTP>> MAIL FROM: SIZE=3111
SMTP>> RCPT TO:
SMTP>> DATA
SMTP<< 250 Ok
SMTP<< 450 Client host rejected: cannot find your hostname, [74.86.12.2]
SMTP<< 554 Error: no valid recipients
SMTP>> QUIT
I have checked dnsreport for this domain and found this
WARNING: One or more of your mailservers is claiming to be a host other than what it really is (the SMTP greeting should be a 3-digit code, followed by a space or a dash, then the host name). If your mailserver sends out E-mail using this domain in its EHLO or HELO, your E-mail might get blocked by anti-spam software. This is also a technical violation of RFC821 4.3 (and RFC2821 4.3.1). Note that the hostname given in the SMTP greeting should have an A record pointing back to the same server. Note that this one test may use a cached DNS record.
***********.co claims to be host svr01.xx*********** [but that host is at 74.xx.xx.2 (may be cached), not 74.xx.xxx.13]. <br />
What should i do to correct this error? btw, I host about 100 sites on this server.
although mod_rewrite is active but htaccess i not read why?
and how can i know mod_rewrite is active or not?
(Plesk 7.x)
I am using Windows Server 2003 SP2 Standard Edition. I have installed Active directory and created users and their home folders. Everything works fine except a problem.
When a user from the domain uses the UNC to connect to the server, it shows the shared folder. The user can view and change all other users files, home directory etc. The user can browse all the folders.
I need it to be setup so that the user can only view his own home folder and files and not others. Also when using UNC to browse the server, I want an administrator authentication even if the user is from the same domain.
Here are my current permissions.
NTFS Root folder permission
=================================
Administrators - Full Control
CREATOR OWNER - Special Permission
System - Full Control
Domain Users - Read & Execute, List Contents, Read, Special Permissions.
Share permission of root folder
================================
Domain Users - Read
NTFS Permission for user home folders
=====================================
Created User - Full Control
Administrators - Full Control
CREATOR OWNER - Special Permission
System - Full Control
Domain Users - Read & Execute, List Contents, Read, Special Permissions.
Let's say you ordered new server,do you make active same moment(install httpd server and all other components)or you running test before like memory and hardware test? If yes,which programs you would recommend to test fully hardware?
View 2 Replies View RelatedI've been with Bluehost for over three years. I've really not had any big problems with them. But I've learned that people usually don't have problems with hosts unless they actually have a website that has good traffic.
Well, as my main site has grown, I think I'm outgrowing my host.
I have a forum (SMF) with over 1500 members and close to 80K posts. It's got a good core of very active members. Doing well. The main part of the site is on WP platform.
Friday, I try to bring up the forum and POOF! It's not there. Just a blank screen. No error, no nothing. Call support and they have no clue, but the support guy comments out a line in one of my SMF files and the site comes back up. Don't ask me how he knew to comment out that line or anything.
Things go fine for a few days, then yesterday P.M. I start getting "exceeding CPU" errors and then a 500 error. Keep in mind, I've done nothing to my site in these days to cause any of this or any changes to even make me suspect anything.
Called support two times last night and finally was told to submit a ticket to their scripting department. I could see the PHP errors in my CP and I knew it was something wrong on their end, but no one could figure it out. Well, I haven't heard from support but my site's back up today.
I'm just thinking it may be time to consider switching. Not sure I really want to deal with that, but I'm having more errors and glitches with them in the last year.
I know HostGator gets mostly great reviews. Will my experience there be any different though?
I know lots of people here ask for web host suggestions. I could really use some guidance, not just in companies, but the things I need to keep in mind about my site in particular that would help me choose one.
The server is currently live on /dev/sda and it was installed w/o raid. Now i have added a second HDD in, how do i RAID it?
It's Ubuntu 6.06
I currently have a server with CentOS 4x and cPanel with approximatley 100 active sites on.
I would like to change the hostname on this box, is this possible without causing any disruption to services on this machine?
Would I be correct in thinking its as simple as modifying /etc/hosts(Or doing it in cPanel) and then reactivating the cPanel License?
I've been trying to set an active desktop of a group of users that log into XP machines to an html webpage. So far I haven't had any luck getting the webpage to appear.
What exactly needs to be done in order for this to work correctly? The primary domain controller is running on windows 200 server.
I have active directory setup. Two users are in there that have exchange mailboxes. One has been deleted, but still gets mail on occasion. So, to keep things simple, bob@mydomain.com is a current user. tim@mydomain.com is the one that was deleted. Can I forward mail from tim's address to bob's address without a using a distrobution list?
I usually use contacts to forward mail, but that only appears to work for external addresses, and not for internal addresses (ie, mydomain.com)
Any ideas?
i hosted one server socket application in my dedicated server which is recving the data from different units(vehicle tracking system) through port no 4444.in dedicated machine i am keeping one active session always...that means my socket application exe is opened always in an active session ie sectionA.This session is not logged off insted i used to close the rdp for keeping this session active.Based on settings if userA accessing SessionA then userB cannot able to reach the active sessionA at the same time instead new sessionB will open for userB.
now my question is
if userB also opened socket application in SessionB with same portno ,then which soket application will recive data from the units...whther the applictaion from sessionA or from SessionB?