Re: Alleggerire le procedure di backup

Il giorno 27/lug/2014, alle ore 14:16, Andrea Brancatelli <[email protected]> ha scritto:

> Ma più scusami perche il repair e optimize?
> 
> 

uso normalmente  mysqlcheck -s --auto-repair --optimize giusto per essere sicuro che le tabelle siano ok

> Mysqldump --opt --single-transaction non usa locking ed è coerente e tutto.
> 

--single-transaction 
                      Creates a consistent snapshot by dumping all tables in a
                      single transaction. Works ONLY for tables stored in
                      storage engines which support multiversioning (currently
                      only InnoDB does); the dump is NOT guaranteed to be
                      consistent for other storage engines. While a
                      --single-transaction dump is in process, to ensure a
                      valid dump file (correct table contents and binary log
                      position), no other connection should use the following
                      statements: ALTER TABLE, DROP TABLE, RENAME TABLE,
                      TRUNCATE TABLE, as consistent snapshot is not isolated
                      from them. Option automatically turns off --lock-tables.


Stando alla guida funziona solo con le tabelle InnoDB mentre io ho anche tabelle in MyISAM

—
RedFoxy Darrest
http://www.redfoxy.it

_______________________________________________
Esperti mailing list
[email protected]
http://mailman.gufi.org/mailman/listinfo/esperti