@robocoder opened this Issue on December 12th 2012 Contributor

The ArchiveProcessing test using Mysqli is passing when using LOAD DATA INFILE, so it isn't a MySQL / AppArmor configuration issue. (I also checked that the "piwik" db user has the FILE privilege.)

On the VM, the mysqli.so and pdo_mysql.so extensions both appear to use libmysqlclient. On dev6, our 5.3.x builds used the new mysqlnd (native driver) extension.

So, this points to a pdo_mysql bug ... i.e.,

@robocoder commented on December 12th 2012 Contributor

(In [7600]) fixes #3605 - add detection for mysqlnd

@robocoder commented on December 12th 2012 Contributor

(In [7601]) refs #3605 - correct information in phpdocs

@mattab commented on December 12th 2012 Member

All in all, what is the minimum recommended php version? is the latest 5.3.x enough to enjoy LOAD DATAINFILE. Since it's a big improvement boost, we could add it in the system check list as a "warning" - high traffic users will want to know this setting.

Otherwise this ticket cna be closed since tests pass? Thanks so much for finding this info it was doing my head in! we are going green

@robocoder commented on December 12th 2012 Contributor

Minimum:

  • 5.2.1+ with mysqli
  • 5.3.9+ with pdo_mysql using mysqlnd

Maximum:

  • 5.2.8 with pdo_mysql using libmysqlclient
@mattab commented on December 13th 2012 Member

Thanks added comment in: #2122

@mattab commented on December 16th 2012 Member

@vipsoft I would like to follow up [7600] and add a warning if box is Jenkins AND isBulkInsertTestable() returns false (since we should know when jenkins stops running these tests). how could we detect if the current server is Jenkins?

@mattab commented on December 21st 2012 Member

(In [7677]) Fixes #3605 Marking the test as "skipped" even if it's not testable.

This will be annoying to always see it in the test output so I probably disable it for jenkins later

@mattab commented on December 21st 2012 Member

(In [7678]) refs #3605 #2122 Claryfying mesage when load data in file not working

This Issue was closed on December 21st 2012
Powered by GitHub Issue Mirror