Re: Which test suites are valid for --extern option in mysql-test-run?

2012-11-26 Thread Eric Bergen
Those tests are typically used by people developing the mysqld server. The packages distributed have already had the tests ran on them. I'm not sure how much value it will provide unless you're modifying mysqld. I don't have a great answer but my best guess is that extern can't be used with tests

RE: Query Plan Analyzer

2012-11-26 Thread Rick James
Yes and no. It takes a lot of experience to get beyond what EXPLAIN gives us. EXPLAIN says what it does, but usually one wants to know "what to do". To that end, I have written some tips: http://mysql.rjweb.org/doc.php/ricksrots http://mysql.rjweb.org/doc.php/index1 But if you have one of the

Re: Innodb, MySQL 5.5.28 - Would an incorrect setting in my.cnf cause mysqld to randomly crash on high load?

2012-11-26 Thread Manuel Arostegui
Hi Tom, I am assuming nothing relevant shows up in dmesg, right? I have experienced random crashes like that and most of them turned to be HW issues - hard disk and memory banks related. Is it a HW RAID? Have you tried looking at the controller logs? (Megacli). And yes, corrupted tables would f

RE: Innodb, MySQL 5.5.28 - Would an incorrect setting in my.cnf cause mysqld to randomly crash on high load?

2012-11-26 Thread Rick James
Nothing looks bad. 96G for the buffer_pool is bigger than I have experienced, but I know of no reason for it to fail (given that you have 128GB of RAM). > -Original Message- > From: Tom [mailto:livefortheda...@gmail.com] > Sent: Wednesday, November 21, 2012 5:17 PM > To: mysql@lists.mysql

Re: Why configuration directives are all case sensitive?

2012-11-26 Thread Johan De Meersman
- Original Message - > From: "Eric Bergen" > > Anger and OS religious arguments the real answer is that is just how > the option parsing code works. It doesn't always have to make sense. Ye gods, it's an outbreak of common sense! Someone quarantine that man before it spreads! In all se