Re: Myisam won't support replication in an MySQL Cluster environment

2012-05-04 Thread Reindl Harald
Am 04.05.2012 06:45, schrieb Brown: Does anyone have idea or experienced in MySQL Cluster configured for bi-directional replication. Please advise me if you have to use NDBcluster engine in order to get replication between the data nodes. I'm using MYISAM on several tables that will not

Re: mixing and matching mysql mssql whileloop within an if case

2012-05-04 Thread Rik Wasmus
I could suggest a number of ways around the if/else construct, such as creating a subclass for the various servers with a uniform interface and hiding the differences inside the class. This, but I'd prefer using one of the already available abstractions for PHP: - PDO: http://www.php.net/PDO

Free webinar about MySQL problem diagnosis

2012-05-04 Thread Baron Schwartz
I'll present a free webinar today about troubleshooting intermittent MySQL problems. These are often hard to pin down because they happen when you're not looking, so you can't reliably determine the symptoms or the cause. I've created some free tools (part of Percona Toolkit) to make this process

Re: Free webinar about MySQL problem diagnosis

2012-05-04 Thread Claudio Nanni
Thanks Baron! Very much valuable! Looking forward for it! Claudio 2012/5/4 Baron Schwartz ba...@xaprb.com I'll present a free webinar today about troubleshooting intermittent MySQL problems. These are often hard to pin down because they happen when you're not looking, so you can't reliably

RE: Myisam won't support replication in an MySQL Cluster environment

2012-05-04 Thread Brown, Charles
Hello Mr Reindl, Interestingly, over the years, I've been reading your postings and threads - without a doubt you're a major contributor. You've been very resourceful and helpful to your peers. We may never know what caused you to violently snap this time. However, I would encourage you to

Re: Myisam won't support replication in an MySQL Cluster environment

2012-05-04 Thread Reindl Harald
you did not get my point the problem is you are starting permanently NEW threads and you are not inclduing ANY informations in your posts I noticed that... as start is a bad joke you ahve to provide at least logs, configurations and describe HOW you notice things becasue others have no idea how

Re: InnoDB and Memory Allocation

2012-05-04 Thread Charles Cazabon
Johnny Withers wrote: I hope someone can help me out here. I'm having trouble with some new servers and memory allocation. Some basic specs on the servers: 32GB total mem 2GB swap 64-bit RHEL 64-bit mysqld overcommit_memory=2 mysql fails to start with 14GB innodb_buffer_pool_size

Re: InnoDB and Memory Allocation

2012-05-04 Thread Johnny Withers
Wow, I hope this hasn't been hanging out in the mysql list server for a year. I completely forgot about this problem. Thanks for the info though. I've been running this server with overcommit_memory=0 and a 42GB buffer pool for a while now. Thanks again! On Fri, May 4, 2012 at 9:38 AM, Charles