e external net access.
Adding all the local machines to /etc/hosts solved the problem
immediately.
Chris Allen.
On Fri, Sep 16, 2005 at 01:30:34PM +0300, Gleb Paharenko wrote:
> Hello.
>
>
>
> What is SHOW PROCESSLIST reporting when the server is reaching the
&
On Wed, Dec 17, 2003 at 03:53:04AM +1100, Chris Nolan wrote:
> >
> >The DB is on a vanilla UFS partition. Do you have any references about
> >this? I couldn't find anything on the MySQL site...
> >
> >
> >
> There's nothing on the MySQL site but I do remember reading a comparison
> between Solar
On Tue, Dec 16, 2003 at 10:13:39PM +1100, Chris Nolan wrote:
> There are a few things that could be happening:
>
> Are you using persistant connections from your web servers,
Yes - with Apache::DBI under mod_perl
> 2. Which FS are you using? The native Solaris FS needs a bit of tuning
> to get
.
Can anybody suggest what might be the problem?
Many thanks,
Chris Allen.
Linux my.cnf:
[mysqld]
server-id = 2
skip-locking
set-variable= max_connections=400
set-variable= back_log=20
set-variable= key_buffer=150M
set-variable= table_cache=256
set-variable
I am running a mysql server on a stand-alone host that is queried
by a web server. I am currently seeing an average of 33 queries
per second, although this is often a lot higher.
The problem is, when large numbers of connections start
to arrive, the machine load gets very high - but MySQL doesn't
