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
Am 14.08.2013 19:31, schrieb Simone Martina:
Hi at all,
recently I got troubles with the Bacula's DB (mysql 5.0.77). Trying to
restore a file from a very huge backup (500GB and 846532 files) the
InnoDB occupies one core for many hours before to let me select the
target files.
on our
Hello,
For the number of files in your backup, it is clear to me that either
you are running with modified indexes on your catalog (unlikely) or
your MySQL is not properly tuned. I am not a MySQL expert, but from
what you show below, the memory sizes you are giving it are probably
way too small.
Hi at all,
recently I got troubles with the Bacula's DB (mysql 5.0.77). Trying to
restore a file from a very huge backup (500GB and 846532 files) the
InnoDB occupies one core for many hours before to let me select the
target files.
During these days I've builded index for File, Filename and Path,
Where's my mistake? Could you suggest me some optimization.
Hi,
only one little suggestion from me - upgrade to MySQL 5.5.
azur
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free
On 08/14/2013 01:13 PM, azurIt wrote:
Where's my mistake? Could you suggest me some optimization.
Hi,
only one little suggestion from me - upgrade to MySQL 5.5.
I didn't have much luck with postgres on a single-cpu (I think 6-core or
maybe 4) and 8 or 12GB RAM (it's off at the moment
On 8/14/2013 2:41 PM, Dimitri Maziuk wrote:
On 08/14/2013 01:13 PM, azurIt wrote:
Where's my mistake? Could you suggest me some optimization.
Hi,
only one little suggestion from me - upgrade to MySQL 5.5.
I didn't have much luck with postgres on a single-cpu (I think 6-core or
maybe 4) and
On 08/14/2013 02:54 PM, Josh Fisher wrote:
We put the db on Intel 710 series SSD a while ago and it made a HUGE
difference even without upgrading cpu or ram.
I expect it would. Still, if you're looking at JOINs on millions of
rows, you'd want a grown-up db engine with enough resources to do
Zitat von Dimitri Maziuk dmaz...@bmrb.wisc.edu:
On 08/14/2013 01:13 PM, azurIt wrote:
Where's my mistake? Could you suggest me some optimization.
Hi,
only one little suggestion from me - upgrade to MySQL 5.5.
I didn't have much luck with postgres on a single-cpu (I think 6-core or
maybe