On Mon, Jan 23, 2012 at 11:13:30AM -0500, Phil Stracchino wrote:
> 
> If max_heap_table_size is 16M, then in-memory temporary tables are
> limited to 16M too.  Maximum in-memory temporary table size is the
> smaller of tmp_table-size and max_heap_table_size.  You only ever have a
> single DB connection; why are you allowing 151 connections?
> 
> Cut max_connections to 10, increase tmp_table_size and
> max_heap_table_size to 64M or even 128M, increase table_cache to 64,
> disable the query cache because you're going to have few if any
> frequently-repeated queries, update to MySQL 5.5, and seriously,
> seriously consider converting to InnoDB.  It is a MUCH higher
> performance storage engine than MyISAM.  Remember that MyISAM was
> designed to yield *acceptable* performance in shared installations on
> machines with less than 32MB of RAM.
> 

Hi Phil,

thanks much for your tuning hints, I'll give them a go and will report
back on how things work out. 

Cheers, Uwe 

-- 
uwe.schuerkamp AT nionex DOT net fon: [+49] 5242.91 - 4740, fax:-69 72
Hauptsitz: Avenwedder Str. 55, D-33311 Gütersloh, Germany
Registergericht Gütersloh HRB 4196, Geschäftsführer: H. Gosewehr, D. Suda
NIONEX --- Ein Unternehmen der Bertelsmann AG



------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users