~ How to install 3 instances of mysql~

Hi, I need to install 3 instances of mysqld server on a single machine. Can anyone let me know how this can be acheived ? It would be helpful if someone can send me some links and suggestions regarding the same. Also pls lemme know what kind of a configuration file i need to have in order to ache

Re: How could I know which transaction or thread hold the lock

Sheeri, Gu Lei, SHOW PROCESSLIST only knows about MySQL table locks. To list row locks, you need to use innodb_lock_monitor: http://dev.mysql.com/doc/refman/5.0/en/innodb-monitor.html Best regards, Heikki Oracle Corp./Innobase Oy InnoDB - transactions, row level locking, and foreign keys for

Re: mysqldump ignores auto_increment

Figured out what was causing it The /etc/my.cnf had a line in it, in the [mysqldump] section... compatible=mysql40 Comment that line out and it works - we need that when sending data to customers who are still running mysql40. Now I know whats causing it, I can work around it. Many thanks, Ia

Re: Optimizing SQL statement

2006/4/13, Puiu Hrenciuc <[EMAIL PROTECTED]>: > Hi, > > I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network traffic > data : > > record_time datetime - time when recording was added > ip char(15) - ip that generated the traffic > type tinyint(3) - traffic type ( 1 - local, 2 - inte

Re: replication, sort of (5.0.18)

2006/4/13, Duzenbury, Rich <[EMAIL PROTECTED]>: > Hi all, > > I have two servers that have production data on them, and then one > server where I would like to keep an active copy of the data. > > Currently, there is a job that runs in the middle of the night that > basically does a > mysqldump --h

Re: MySQL 3 to 5 upgrade

Hi, > Yeah - I think the playground is unlikely to happen. They certainly > haven't said anything about providing such a facility. If they don't give a test machine, or don't provide a smooth migration (like installing a new server, and keeping the old one running 3.23), you should consider compl

RE: MySQL 3 to 5 upgrade

At 8:32 -0700 13/4/06, paul rivers wrote: Going from 3 to 5 can break a number of important things. For example, join syntax semantics and precedence rules have changed since 3, and it is certainly possible this could break your code in important and dramatic ways. You should plan on spending

Re: Out of control connections

Hi Jeff. If you are the admin, then maybe you and only one or two others should have the 'Super' privilege. >From the 5.0.18 manual: 13.5.4.16. SHOW PROCESSLIST Syntax SHOW [FULL] PROCESSLIST SHOW PROCESSLIST shows you which threads are running. You can also get this information using the my

Out of control connections

Hello all, I've got a problem where a php web application is intermitantly making bursts of 500+ connections to a mysql database which then locks out all other connections. These connection don't apparently do anything query wise they just use up connections. The problem is when it happens I can

Trouble with aborted connections

Hello everybody, I'm using mysql in an clustered environment: Several loadbalanced webservers get the requests from the users' clients and query the needed information from several webservers. Every webserver connects to every database-server. So in this case the webservers are the mysql-clients.

bind-address question

Hi Everyone, I have been searching around for a while, but have had no luck as yet for this question. I am running debian with mysql 4.x on a x86 box. (2.6 series kernel). Anyhow, up until now, I have had a single bind-address option passed, however I need to add another address (so it binds

best use of index and missing values

Hi, I have one table : CREATE TABLE `ressources_summary` ( `res_type` tinyint(3) unsigned NOT NULL default '0', `res_id` int(10) unsigned NOT NULL default '0', `comment_count` smallint(5) unsigned NOT NULL default '0', `comment_last_timestamp` timestamp NOT NULL default '-00-00 00:00:0