RE: date-IFNULL-sum bug?

2012-10-08 Thread hsv
2012/10/08 14:52 -0700, Rick James Do not use + for DATE arithmetic! Use, for example + INTERVAL 1 YEAR No, those operations are well defined. Amongst the timestamp-functions there is constant reference to numeric context, and character context--and well there is, because the

RE: date-IFNULL-sum bug?

2012-10-08 Thread Rick James
Do not use + for DATE arithmetic! Use, for example + INTERVAL 1 YEAR > -Original Message- > From: h...@tbbs.net [mailto:h...@tbbs.net] > Sent: Thursday, October 04, 2012 9:35 PM > To: mysql@lists.mysql.com > Subject: date-IFNULL-sum bug? > > Can anyone explain this to me? > The first o

RE: mysql 5.5.24/27 massive slow down since upgrade to solaris 10 u9 with 147440-19

2012-10-08 Thread Rick James
Are you I/O bound? XFS What "elevator" strategy? Compare settings. Especially innodb_flush_log_at_trx_commit . > -Original Message- > From: Gael Martinez [mailto:gael.marti...@gmail.com] > Sent: Sunday, October 07, 2012 5:46 PM > To: mysql > Subject: mysql 5.5.24/27 massive slow down si

Slow queries / inserts InnoDB

2012-10-08 Thread Adrián Espinosa Moreno
Hi. I have developed my first application with VB.NET at work (junior developer) and basically it reads several thousands of lines from X number of files, and inserts them into a mysql database. The application consists of several steps: 1) Dump all lines with all fields into a temp tab