On 10/17/17 05:05, Alan Brown wrote: > The reason it's taking so long is that you not tuned your mysql > properly. Out of the box it is only setup for 32MB (yes, MB) systems. As > a result it is writing hundreds of temporary files when deleting records.
> MySQL is good at what it's designed for (small databases), but > attempting to push it beyond its design criteria is unwise as the > maintenance and system load goes up dramatically. If your DB is 13GB > then you're well beyond its design criteria. Please stop spreading this FUD. It is flatly NOT TRUE and you are doing a disservice by spreading it. Yes, MySQL and its MyISAM legacy storage engine were *originally designed* to perform acceptably well on small, shared systems in days when a large dedicated server might have an entire 32MB of RAM. But that's like telling people not to buy a Ford and then justifying it by telling them the specs of the Model A. It has not been true in probably 20 years. "Out of the box" MySQL has individual BUFFERS that default to larger than 32MB. Shall we talk about "new" features that PostgreSQL only added after MySQL had had them for over ten years? Shall we talk about features MySQL and its derivatives have that PostgreSQL not only doesn't have but isn't even in sight of having? No, we won't, because this isn't the place for it. But please stop misleading users by bashing MySQL with claims based on its ancient history. That first paragraph of yours quoted above is complete and utter rubbish, and a cursory glance at the defaults of any MySQL branch released in the last ten years would show it. You might as well tell people they shouldn't use Unix because its design had to to fit into 64K of memory. Sorry for the digression, Kern. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: +1.603.293.8485 Mobile: +1.603.998.6958 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
