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.schuerk...@nionex.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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
