Dear all,
I'm usually not prone to responding to posts w/r to
"DB religions", but OTOH I believe that most of the mysql problems may
have resulted from historical issues, like using myisam as the storage
backend, *not* using mariadb and so on.
We run 5 bacula instances, all backed by mariadb (5.
On 01/06/17 14:49, Petar Kozić wrote:
Yes, how to use ?
dbcheck checks the integrity of the databases, not the tuning of them.
With regard to tuning of mysql
- bear in mind that I'm saying this from the point of view of having
spent years doing exactly that for Bacula.
DON'T DO IT.
I
Yes, how to use ?
On Jun 1, 2017 2:35 PM, "Josip Deanovic" wrote:
> On Thursday 2017-06-01 05:14:14 Petar Kozić wrote:
> > Thank you for answer but I wish to stay on MySQL.
> > I was alredy tuning mysql, I don’t need that.
> >
> > I was read somewhere in bacula documentation, that bacula have so
On Thursday 2017-06-01 15:49:03 Petar Kozić wrote:
> Yes, how to use ?
If you have a time window when no backup is performed I suggest
you run it during that time.
As a precaution I also like to stop the bacula-sd and bacula-dir
every time I do manual modifications on the database or on the
volume
On Thursday 2017-06-01 05:14:14 Petar Kozić wrote:
> Thank you for answer but I wish to stay on MySQL.
> I was alredy tuning mysql, I don’t need that.
>
> I was read somewhere in bacula documentation, that bacula have some
> script for mysql optimization.
>
> My question is for that. Thank you.
Thank you for answer but I wish to stay on MySQL.
I was alredy tuning mysql, I don’t need that.
I was read somewhere in bacula documentation, that bacula have some script
for mysql optimization.
My question is for that. Thank you.
*—*
*Petar Kozić*
System Administrator
On June 1, 2017 at 11:34
Change the DB to PostgreSQL maybe ?
MySQLtuner.pl Script ?
What's the size of the DB?
J.
2017-06-01 10:38 GMT+02:00 Petar Kozić :
> Hi,
>
> My bacula servers works now about 2 months with about 3 TB backuped data,
> on about 10 servers.
> I see it a little slowed down, and much backup job is
Hi,
My bacula servers works now about 2 months with about 3 TB backuped data,
on about 10 servers.
I see it a little slowed down, and much backup job is in queue.
I want to do optimize mysql.
What is the safest way to do that ?
Thank you in advanced.
*—*
*Petar Kozić*
System Administrator
--
