Is it possible to configure MySQL to have different max_connections
limit based on either user or host which is connecting to server?
I mean, suppose we have max_connections=500, is it possible to say that
from all external clients there could be at max 490 connections, while a
single host or u
I get this error on the slave:
040614 10:19:07 Error reading packet from server: bogus data in log
event (server_errno=1236)
040614 10:19:07 Got fatal error 1236: 'bogus data in log event' from
master when reading data from binary log
040614 10:19:07 Slave I/O thread exiting, read up to log 'd
Misao wrote:
I have 4 MySQL 4.0.16 servers, all with Dual 3ghz Xeons and 4GB of RAM.
They use InnoDB for all tables, and the ibdata file is 70GB.
The DBs seem to be a little slow, and the darn thing is always using a huge
chunk of swap. I've tried increasing and decreasing what it's allowed to
use,
venkata ramana wrote:
Hi,
What is the maximum number of simulataneous connections
that can exist for MySQL. Can we change this limit? If yes please tell
me how to do this. I am using MySQL4.1 in Linux.
Thanks,
ramana.
look at max_connections in my.cnf
bye
a
--
"Imagination is more impo
Working around optimizing some queries, I tried to get a better key
improvement.
This is what I get:
mysql> explain select ID,reply,nome,email,dataora,titolo,testo,status,thread from board where
articolo=50966 AND status<2 and (thread<102741 and thread>101548) ORDER BY ID DESC;
+-+--
