'Alan Brown' wrote: >Mikael Fridh wrote: > >> Tuning's not going to get any of those 50 million traversed rows >> disappear. Only a differently optimized query plan will. > >This applies across both mysql and postgresql... > >>> This is an Ubuntu Linux server running MySQL v5.1.41. The mysql data is on >>> an >>> MD software RAID 1 array on 7200rpm SATA disks. The tables are MyISAM >>> (which I >>> had understood to be quicker than innodb in low concurrency situations?). >>> The >>> tuner script is suggesting I should disable innodb as we're not using it >>> which >>> I will do though I wouldn't guess that will make a massive difference. >> >> No, it will not help. > >Disbling innodb won't help right now, but switching to innodb would be a >good idea in the near future as myISAM runs into problems around the 50 >million entry mark (assuming Oracle don't remove innodb from future >versions of Mysql, as looks increasingly likely...)
InnoDB is the default storage engine for MySQL 5.5 > > > >------------------------------------------------------------------------------ >Centralized Desktop Delivery: Dell and VMware Reference Architecture >Simplifying enterprise desktop deployment and management using >Dell EqualLogic storage and VMware View: A highly scalable, end-to-end >client virtualization framework. Read more! >http://p.sf.net/sfu/dell-eql-dev2dev >_______________________________________________ >Bacula-users mailing list >Bacula-users@lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/bacula-users -- Med venlig hilsen / Best Regards Henrik Johansen hen...@scannet.dk Tlf. 75 53 35 00 ScanNet Group A/S ScanNet ------------------------------------------------------------------------------ Centralized Desktop Delivery: Dell and VMware Reference Architecture Simplifying enterprise desktop deployment and management using Dell EqualLogic storage and VMware View: A highly scalable, end-to-end client virtualization framework. Read more! http://p.sf.net/sfu/dell-eql-dev2dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
