Re^3: Much slower DBI on RHEL6

Replies are listed 'Best First'.
Re^4: Much slower DBI on RHEL6 by MPM (Novice) on Feb 05, 2014 at 22:23 UTC
They are different versions of DBI, DBD-MySQL, Perl, and MySQL but on each machine they are the versions that come with RHEL. I did not customize any of the packages, got them directly from RH.	[reply]
Re^5: Much slower DBI on RHEL6 by hippo (Archbishop) on Feb 05, 2014 at 23:18 UTC
Getting well off-topic now, but do bear in mind that newer versions of MySQL use InnoDB as the default storage engine, whereas older versions use MyISAM. Make sure that your tables on the different servers are using the same storage engine as that could account for big differences in times of operations.	[reply]
Re^5: Much slower DBI on RHEL6 by runrig (Abbot) on Feb 05, 2014 at 22:40 UTC
Well, then. On each machine, install the version of everything (or one thing at a time) mentioned above that exists on the other machine, and see if the programm gets faster or slower. Yes, it involves work.	[reply]
Re^6: Much slower DBI on RHEL6 by MPM (Novice) on Feb 05, 2014 at 23:25 UTC
Well, that would be great but I don't think I would be able to install the RPMs from RHEL6 on a RHEL4 and vice versa without a huge amount of RPM dependency issues... expecially with Perl.	[reply]
Re^7: Much slower DBI on RHEL6 by karlgoethebier (Abbot) on Feb 05, 2014 at 23:35 UTC
Re^5: Much slower DBI on RHEL6 by karlgoethebier (Abbot) on Feb 05, 2014 at 23:29 UTC
"They are different versions of DBI, DBD-MySQL, Perl, and MySQL..." :-) well, than, as runrig wrote ~~below~~... It would be nice to hear more about this issue. Please report. Regards, Karl ŤThe Crux of the Biscuit is the Apostropheť	[reply]