Recently I was tasked with upgrade some MySQL instances from 5.5.16 to 5.5.32. The task seemed easy enough but when I started the process on one of the larger databases on the server (just under 1TB), it is made up of a lot smaller tables and most over 90% are 'myisam'. I ran into issues when I ran mysql_upgrade.
error : Table upgrade required. Please do "REPAIR TABLE `<name>`" or
dump/reload to fix it!
Oracle - Row duplicates in a table with a PK loaded by sql*loader
I had an interesting problem today. One of the developers told me a nightly job had stopped with an error. I check the usual things like has anything changed and was told no. The error was sent to me and was the following:
SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table REPORT_TEMP
ORA-01502: index 'PK_REPORT_TEMP' or partition of such index is in unusable state
SQL*Loader-926: OCI error while executing delete/truncate (due to REPLACE/TRUNCATE keyword) for table REPORT_TEMP
ORA-01502: index 'PK_REPORT_TEMP' or partition of such index is in unusable state
MySQL Enterprise Backup (MEB) Compress Option
I have used compression tools before and was interested to understand a little more about MEB's use of compression. Jumping straight in, here are a couple of points to consider:
- the backup compression feature only applies to InnoDB tables.
- when InnoDB tablespace files are compressed during backup, they receive the extension .ibz rather than the usual .ibd extension.
- you can only use the --compress option for full backups, not for incremental backups.
MySQL 5.6 Transportable Tablespaces Example
Transportable tablespaces allows copying individual
InnoDB tables from
one MySQL instance to another.Here is a basic example of it's usage.
Oracle and Flashback Retention
Interestingly, I had a database that was running a large load of data. I was running across issues with space.
MySQL Enterprise Backup (MEB) 3.8 and Tracing
The new 3.8 feature of tracing is very useful. I have been looking at where performance is worse and using tracing is very handy.
Running a SQL Script on Startup
Running sql on startup is something Oracle does via STARTUP trigger. This can also be done via my MySQL but requires some extra steps
MySQL Enterprise Backup (MEB) 3.8 and Parallel Performance
I am currently looking at the newest version of MEB. I have some experience of 3.7 and was keen to experiment the new version
SQL_MODE Parameter Change in 5.6
This setting has changed from 5.5 to 5.6, it includes
strict_trans_tables - sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES.
Mysql 5.6 upgrade (from 5.5) single and replicated instance.
I have been working on an upgrade path from 5.5. to 5.6. The MySQL documentation is good and explains what could be a muliple phase upgrade to get to 5.5 to then upgrade to 5.6, see
Here are few notes which I hope helps. There looks to be two ways to upgrade from 5.5 to 5.6.
- Import/Export
- Binary Upgrade
Subscribe to:
Posts (Atom)