On Wed, Aug 14, 2013 at 08:13:39PM +0200, azurIt wrote: > >Where's my mistake? Could you suggest me some optimization. > > Hi, > > only one little suggestion from me - upgrade to MySQL 5.5. > > azur >
Or go straight to MariaDB. Another important question is how big is your file table, i.e. how many rows do you have in it? Have you checked for corrupted tables / indices recently? You might also want to up your innodb buffer pool to 3GB or thereabouts, as a rule of thumb it should be about half the physical memory on a dedicated mysql box. Cheers, Uwe -- NIONEX --- Ein Unternehmen der Bertelsmann SE & Co. KGaA ------------------------------------------------------------------------------ Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
