Am 28.03.2013 12:09, schrieb Antonio Fernández Pérez:
Hi everybody,
Once I have done the defragmentation of MySQL tables, mysql-tunner.pl suggests
me do it again. Is this correct? I think that the idea is that in the
result of the script there are not fragmented tables ...
Any ideas?
Hi Reindl,
Thanks for your reply.
So, is it not necessary (not recommended) to defragment tables if I have a
lot of write operations (writing or deleting)?
Best regards,
Antonio.
Am 28.03.2013 12:28, schrieb Antonio Fernández Pérez:
So, is it not necessary (not recommended) to defragment tables if I have a
lot of write operations (writing or deleting)?
it is recommended but not permanently and not blindly
i use a daily cronjob which runs optimize table on tables with
Ok. Thank you very much.
Best regards,
Antonio.
Hello Manuel,
Exactly. My objective doing performance MySQL it isn't to free disk space
(it isn't the problem). I would like to get a good performance using cache
and setting good values to configuration variables.
I will defrag tables once per month.
Best regards,
Antonio.
Hello Antonio,
As Reindl said, it is recommended but it shouldnt be done just
everyday if your tables are quite big and you use query cache.
If you do have lot of writes and deletes (depending on what you
consider a lot), your table will indeed have lot of 'blank rows' which
eat disk space.
Hi Reindl,
I would like to implement your strategy of optimizing tables. Can you
please share how are running these scripts? Where does the
mysql-wrapper-class exist? And what parameters need to be passed?
Thanks
Bheem Aitha
MySQL and Oracle DBA
On Mar 28, 2013 4:43 AM, Reindl Harald
optimizeall() is simply called from a cron script
the mysql-wrapper does not exist in public but you get the table
overhead with SHOW TABLE STATUS as you can see below
Am 28.03.2013 16:59, schrieb Bheemsen Aitha:
I would like to implement your strategy of optimizing tables. Can you please
is irrelevant to this discussion.
-Original Message-
From: Bheemsen Aitha [mailto:pgb...@motorola.com]
Sent: Thursday, March 28, 2013 8:59 AM
To: Reindl Harald
Cc: mysql@lists.mysql.com
Subject: Re: Defragmentation of MySQL tables, how many times have I to
do it?
Hi Reindl,
I
Am 28.03.2013 19:43, schrieb Rick James:
I have never traced a performance issue in InnoDB to the need for OPTIMIZE.
but with files_per_table you can get back GIGABTYES of disk-space
depending on your backups this may be relevant
The Query Cache is irrelevant to this discussion
it is NOT
10 matches
Mail list logo