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

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 since

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 one