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

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_

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: 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 co

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 > 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

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 m

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/PD

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 no