Re: Innodb as its default storage engine for Mysql 5.0 / 5.1

2011-05-25 Thread Hal�sz S�ndor
2011/05/25 10:53 +0200, Reindl Harald if there is no good reason i will never enable innodb because MyISAM is enough for most web-apps And also MyISAM supports auto-increment in a lesser part of a primary key and InnoDB not--but although it is of interest, I have not tryed it.

Re: Joining tables from different Instances

2011-05-25 Thread Rik Wasmus
On 2011-05-25 13:50:32 Ramesh wrote: > I have a different schemas in different instances. > > I would like to join the tables in different instances for the required > result. > > Is it possible? > > Example > = > > Server I - table_1a, table_2b > Server II - table_2a,table_2b. > > I want

Re: Joining tables from different Instances

2011-05-25 Thread Reindl Harald
Am 25.05.2011 13:50, schrieb Ramesh: > Hi > > I have a different schemas in different instances. > > I would like to join the tables in different instances for the required > result. > > Is it possible? > > Example > = > > Server I - table_1a, table_2b > Server II - table_2a,table_2b. >

Joining tables from different Instances

2011-05-25 Thread Ramesh
Hi I have a different schemas in different instances. I would like to join the tables in different instances for the required result. Is it possible? Example = Server I - table_1a, table_2b Server II - table_2a,table_2b. I want to join the table_1a with table_2b. Is is possible?

Re: After long semaphore waits MySQL becomes unresponsive.

2011-05-25 Thread Johan De Meersman
- Original Message - > From: "Rik Wasmus" > > A plugin what for? Also time, money, effort. I didn't get hired as a > MySQL-plugin writer here, and my list of pet-projects for my personal time > is rather full at the moment :) For keeping track of various interesting variables like query

Re: After long semaphore waits MySQL becomes unresponsive.

2011-05-25 Thread Rik Wasmus
On 2011-05-25 12:24:37 you wrote: > > Cacti does store a lot of things by snmp, that's the way I know > > memory, CPU usage & average load never showed a hitch, all's well > > according to the OS, only MySQL is slowly dying... > > So what stops you from writing MySQL plugins? Probably plenty out t

Re: MySQL server has gone away

2011-05-25 Thread Aveek Misra
Nothing in the error log or the slow query log that suggests that the query size is too large or us taking too much time to execute. Thanks Aveek On May 25, 2011, at 3:53 PM, Rik Wasmus wrote: >> failed to execute "SELECT * FROM cluster_info WHERE cluster = ?": >> MySQL server has gone

Re: After long semaphore waits MySQL becomes unresponsive.

2011-05-25 Thread Johan De Meersman
- Original Message - > From: "Rik Wasmus" > > Cacti does store a lot of things by snmp, that's the way I know > memory, CPU usage & average load never showed a hitch, all's well according to > the OS, only MySQL is slowly dying... So what stops you from writing MySQL plugins? Probably pl

Re: MySQL server has gone away

2011-05-25 Thread Rik Wasmus
> failed to execute "SELECT * FROM cluster_info WHERE cluster = ?": > MySQL server has gone away > > The error "MySQL server has gone away" is the error from the db handle. Can > anyone give me any pointers on why that happens? I looked up the > documentation in MySQL docs and the most com

MySQL server has gone away

2011-05-25 Thread Aveek Misra
Hi, We are seeing intermittent errors of the type: failed to execute "SELECT * FROM cluster_info WHERE cluster = ?": MySQL server has gone away The error "MySQL server has gone away" is the error from the db handle. Can anyone give me any pointers on why that happens? I looked up the

Re: Innodb as its default storage engine for Mysql 5.0 / 5.1

2011-05-25 Thread Reindl Harald
Am 25.05.2011 10:35, schrieb Brent Clark: > Hiya > > I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its > default storage engine. > > The question I would like to ask is. For those still running Mysql 5.0 / 5.1. > Have any of you set the mysql default > variable to be / use

Re: Innodb as its default storage engine for Mysql 5.0 / 5.1

2011-05-25 Thread Rik Wasmus
On 2011-05-25 10:35:45 Brent Clark wrote: > I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its > default storage engine. > > The question I would like to ask is. For those still running Mysql 5.0 / > 5.1. Have any of you set the mysql default variable to be / use Innodb? Yes,

Innodb as its default storage engine for Mysql 5.0 / 5.1

2011-05-25 Thread Brent Clark
Hiya I think I read somewhere that Mysql 5.5 is defaulting on Innodb as its default storage engine. The question I would like to ask is. For those still running Mysql 5.0 / 5.1. Have any of you set the mysql default variable to be / use Innodb? Regards Brent Clark -- MySQL General Mailing

Re: After long semaphore waits MySQL becomes unresponsive.

2011-05-25 Thread Rik Wasmus
On 2011-05-24 18:25:07 Johan De Meersman wrote: > > OK, but that would mean that the answer to the question: > > > > "I may be wrong here, but I tend to interpret this as > > '140054029002496' is trying to get an exclusive lock on 0x78733f8, on > > which it already has an exclusive lock, and hence