On 02/23/11 17:42, Erik P. Olsen wrote:
> Thanks for the tip but unfortunately it didn't change anything when it comes 
> to 
> speed. I ran "sudo mysqlcheck -Aaov" and got among apparently normal messages 
> the following surfaced:
> 
> note     : The storage engine for the table doesn't support optimize
> 
> Does this mean that nothing has been optimised?

Nope; if that's the whole message, it means *one* of your tables did not
get optimized, probably meaning it uses an unusual storage engine.  If
the full message was this:

Table does not support optimize, doing recreate + analyze instead

then it basically just means you have InnoDB tables.  OPTIMIZE TABLE is
de-facto supported both on MyISAM and on InnoDB, although in different
ways - on MyISAM it's 'repair if necessary, then sort indexes if not
sorted, then update statistics if outdated', while on InnoDB it's
implemented as 'recreate table, then analyze'.

-- 
  Phil Stracchino, CDK#2     DoD#299792458     ICBM: 43.5607, -71.355
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT org
  Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
                 It's not the years, it's the mileage.

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users