Dealing With Max_user_connections In SQL

Jun 13, 2007

I've had an issue come up recently that I haven't had to deal with before. I'm starting to get regular errors during peak traffic times saying that I have more then the max_user_connections allowed.

I tried setting this to a higher number using ini_set. Unfortunately my host overrides this. I've talked with the host and they cannot up the 15 user maximum.

I've been with this host a while and they have great support and really great service. I understand their need to limit this because it is a shared environment.

I'm wondering if there's anything I can do on my end to help avoid this problem.

Is the only option switching somewhere that lets me have more maximum connections? At the rate I'm going this problem will continue to grow, so it needs to be solved quickly.

View 4 Replies


ADVERTISEMENT

Dealing With Bad Connections

Jun 20, 2008

I've had a problem a couple of times where there is a bad ftp connection to a host. A trace reveals that there is a node timing out. What is a good way to work around this. Web based ftp client or other solution?

View 0 Replies View Related

Dealing With Log Files

Jan 21, 2007

I have apache rotate the logs daily and keep them in the users home directory in /logs/, however; these logs pile up over time and I need to delete them by hand. What is the best way to automate deletion of these log files? For example, i'd like to delete the logs after 7 days of logging. Can I do this with newsystemlog or somethign similar? Or do I need a shell script?

View 2 Replies View Related

Max_user_connections

Mar 20, 2007

I wonder what is good parameter to set for max_user_connection on shared hosting.
I see that some hostings set it to 20 and on some other hostings it is set to to 30 respectively 40?

View 5 Replies View Related

Dealing With A DDoS Attack

Feb 8, 2008

I've got CSF setup, but the problem is, I can't seem to keep the SYN Attack blocked without blocking all my legit hits.

View 5 Replies View Related

Dealing With A Persistent Hacker

Aug 25, 2007

I was checking my business server's IIS errors logs when I ran across the following error:

2007-05-19 08:21:10 00.000.000.00 2243 00.000.000.000 80 HTTP/1.1 GET

/w00tw00t.at.ISC.SANS.DFind 400 - Hostname -

Additional information about the those responsible for the hack attempts are as follows

(retrieved from domaintools.com):

CustName: ----------------(hidden by me)
Address: Private Address
City: Plano
StateProv: TX
PostalCode: 75075
Country: US
RegDate: 2005-08-27
Updated: 2005-08-27

Apparently this person was trying to use the dfind hacker tool to find vulnerabilities on my server. The IP address belongs to AT&T Yahoo; and I've already contacted them by email. I believe that subsequent hack attempts have originated from this IP, however, the IP address has been masked by the use of proxies. I think that this may be someone I know because the IP is only about an hours drive from me. I'm starting to suspect a disgruntled former client who has friends living where that IP's from.

Has anyone here had any similar experiences?

What do you think AT&T Yahoo's response will be?

Is there anything else I can do or should not do?

I am also considering reimaging my server because of system issues but I am concerned that would erase any information needed for investigative purposes. I have saved my log files, though, on a CD but I'm thinking that AT&T Yahoo or whoever investigates this needs the server as it is.

View 8 Replies View Related

Max_user_connections Recurring

Aug 7, 2007

I keep getting this error once in a while for my forum.

Quote:

SQL ERROR [ mysql4 ]

User xxxxx_xxxx has already more than 'max_user_connections' active connections [1203]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

I've contact support team from my Hosting provider and they have help me to increase the value of max_user_connection to 50. I have made to understand by them that this problem can be resolved by using VPS or Dedicated server. As a newbie, I just want some assurance would the problem permanently resolve if I'm using VPS or Dedicated server? Which one should I use? VPS or dedicated server?

View 6 Replies View Related

Increasing Max_user_connections

Jun 3, 2007

any problem increasing max_user_connections ? (for example 600)

View 2 Replies View Related

Dealing With Strange File Names

Apr 30, 2007

I have a spider that is saving a few images files everyday on my servers. Due to the fact that the images are dynamically created the spider is not only saving them without an extention, but also using charachters from the link to create those file names.

I end up with:

0&Y=0
1&Y=0
2&Y=0
3&Y=0
.... and so on.

(there is no problems browsing those image files

What I need is to copy those files or move them to file names with an extention (png) for protection reasons.

I failed using cp, mv in doing so. it seams that the OS doesn't see those files as files.

That is how those files appear in ssh:

0&Y=0
1&Y=0
2&Y=0 ...

View 3 Replies View Related

More Than 'max_user_connections' Active Connections

Jun 1, 2007

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

View 4 Replies View Related

More Than 'max_user_connections' Active Connections

Apr 29, 2007

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.

View 7 Replies View Related

Dealing With A Distributed Spam Attack (exim)

May 16, 2007

We've been seeing sluggish performance on our mail gateways, and so I started doing some digging in the logs. It looks like we are filling up with messages like:

2007-05-16 12:22:16 Connection from [xx.xx.xx.xx] refused: too many connections

We have our max connections set to 20 (total, not host-specific) in exim4. So I started tailing the logs, and sure enough, we are getting bombarded with requests to randomstring@ourdomain.com coming from all over the map. The requests are getting denied of course, but that doesn't help the connection issue since they are consuming all of them, preventing real mail (for the most part) from getting through.

What is the proper way to deal with something like this? I could certainly just up the max connections value from 20 to 40 or 50 or whatever, but I'm not sure what kind of performance impact that will have on the rest of the traffic going through our gateways.

Since the spam attempts are coming from all over the place, it doesn't seem like I can just firewall out a few addresses and be done with it.

This particular rack is a cluster of web and database servers behind two gateway boxes, which handle the mail traffic (so this problem is on the gateways, the actual mail server itself sits behind the gateways and never actually sees these fake emails).

View 1 Replies View Related

MySQL Host - Max_user_connections Exceeded

Oct 30, 2008

I am getting the error "max_user_connections exceeded" for database user "xxxx". So every time this happens I have to feed a new database admin login to my script.
There is nothing wrong with the script since it is very popular membership script. I think my host just allows low number of "max_user_connections". please advice me on a host that allows higher number of "max_user_connections"

View 14 Replies View Related

How To Change 'max_user_connections' In A Dedicated Server

Nov 7, 2008

I have purchased a dedicated server because my existing host gives me a database error during high traffic. the error is

Code:

"Cannot connect to MySQL: User admin0506 has already more than 'max_user_connections' active connections"

Now in my dedicated server I have root access and a Plesk control panel with admin access. I have created a database but I don't know how to change the parameter "max_user_connections". Please help me because I am loosing lot of business due to this issue.

View 6 Replies View Related

Dealing With ThePlanet Sales Staff Is Like A Trip To The Dentist

Apr 17, 2008

I've been pretty happy with my servers with theplanet/ev1servers for the past, err, 5 years. But the OSes were out of date and it seemed like I could stand to get some significantly improved hardware for what I'm paying now (or, comparable hardware for a lot less).

I put in a RFQ from ThePlanet to see what I could do as far as upgrading my current server, hoping for something a little better than buying a new server while the old one is up and moving everything over, and also hopefully avoiding re-paying a one-time fee I had for a secondary hard drive.

Now I have no problem whatsoever with the result -- that my only option is to buy a new server, they won't migrate my HDs, and they won't upgrade my current server, and they won't give me any kind of credit for the second hard drive or let me transfer it to a new server. I get where they're coming form, even though it might make sense to figure out something a little better for a customer of 5 years that's dropped about $25k over that time period.

The problem is their sales staff. I'm surprised that theplanet (at least theplanet I remember from when I signed up) would have sales people so apathetic and basically useless.

Getting information I requested in my initial ticket took back-and-forth with a sales rep over the span of over 24 hours (and I still haven't really gotten an answer on one part, about my secondary hard drive). Actually looking at the ticket now, the initial response was over 24 hours after I opened a ticket (and it was opened during working hours).

Heck, the first two responses didn't even include a price for the hardware he wanted me to buy, just if I wanted to proceed and buy it.

Figuring it beats waiting I did one of their instant chats and before answering my questions I was told to be sure to give the guy credit for the servers I order. In fact, him telling me his contact information and to choose him were the only complete sentences I got, and roughly 80% of the communication I received.

I haven't needed support on my server recently, so I can't speak to if this is the quality of their support department now. I don't think I'll be around to find out though.

(Executive summary: Hello SoftLayer!)

View 5 Replies View Related

Is 40 Max_user_connections For MySql Typical In A Shared Hosting Environment

Mar 17, 2008

Is 40 max_user_connections for MySql typical in a Shared Hosting environment? Or are there Shared Hosts out there that allow more than 40 max_user_connections per account?

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved