'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 AT lists.sourceforge DOT net
>https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
Med venlig hilsen / Best Regards

Henrik Johansen
henrik AT scannet DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users