Menu
▾
▴
Re: [Bacula-devel] base-jobs: mysql extremely slow, postgres OK
|
From: Philipp S. <phi...@da...> - 2010-02-22 08:34:22
|
Hello Eric, how can we go on to solve the problem with mysql and base jobs? Like it behaves now, it is unusable. Unfortunately, I do not have much skills in database tuning, but there has to be a big problem for mysql with the mentinoned INSERT: INSERT INTO BaseFiles (BaseJobId, JobId, FileId, FileIndex) SELECT B.JobId AS BaseJobId, 2 AS JobId, B.FileId, B.FileIndex FROM basefile2 AS A, new_basefile2 AS B WHERE A.Path = B.Path AND A.Name = B.Name ORDER BY B.FileId the problem can be easily reproduced. regards, Philipp Am Sonntag 21 Februar 2010 22:41:30 schrieb Eric Bollengier: > Hi, > > This index was giving this result on postgres and sqlite > > http://sourceforge.net/apps/wordpress/bacula/2009/09/28/performance-issue-w > ith-a-useless-index-on-postgresql/ > > It should do the same with MySQL... > > Bye > > Le Dimanche 21 Février 2010 10:00:35, Philipp Storz a écrit : > > Update: > > > > I tried the suggestion posted by Dan Langille > > > > (CREATE INDEX FilenameId_2 ON File (FilenameId, PathId);) > > ,but unfortunately this did not help in my case. > > > > regards, > > Philipp > > --------------------------------------------------------------------------- > --- Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > Bacula-devel mailing list > Bac...@li... > https://lists.sourceforge.net/lists/listinfo/bacula-devel > -- Philipp Storz phi...@da... dass IT GmbH Phone: +49.221.3565666-92 http://www.dass-IT.de/ Fax : +49.221.3565666-10 Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRB52500 GF: Stephan Dühr, Maik Außendorf, Jörg Steffens, Philipp Storz |