Hi Uwe, Thanks for the response.
On Thu, 20 Feb 2014, Uwe Schuerkamp wrote: > On Wed, Feb 19, 2014 at 12:57:15PM -0500, r...@mbl.edu wrote: >> I've been running the MySQL sql-bench benchmarks on a number of different >> servers I have available and this server seems to be quite fast matching >> performance we get from our dedicated database servers with high speed >> enterprise disk arrays and 128G RAM. (Except when dropping tables, the >> dedicated systems are much faster than this server, but I don't believe >> that is related to the slow query problem I am seeing.) >> > > Hi Rich, > > how large is your File table ATM? 25 million doesn't seem too bad, our > File table blew up to 1,2 billon rows a year ago thanks to copy jobs > for a time and while it wasn't exactly fast (volume recycling took a > few hours), it wasn't as bad as you describe. Information_schema reports that table is now at 115 million rows. > Maybe an index has gone bad on you without noticing it? Have you > considered switching to MariaDB? What storage engine are you using > (hopefully not MyISAM)? I have switched to MariaDB for my home computers but haven't started using it at work, but I've never been convinced that MariaDB outperforms MySQL. Nor have I tested them to that end. It sounds like you might have contradicting information. I'm using InnoDB. I've also heard Postgres will work well in a similar situation so it seems I have some options to try if I decide to give up on MySQL. Thanks, Rich. -- Rich Fox Systems Administrator JBPC - Marine Biological Laboratory http://www.mbl.edu/jbpc 508-289-7669 - mbl-at-richfox.org ------------------------------------------------------------------------------ Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121054471&iu=/4140/ostg.clktrk _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
