145 reputation
7
bio website
location Virginia
age 31
visits member for 3 years, 6 months
seen Jul 12 at 19:11

Jun
25
comment mysql database restore takes long time
@Ramesh if you don't have one, that means MySQL is probably using the default. You can just add one.
Apr
30
awarded  Critic
Mar
5
comment Database growing like crazy - what do I do?
@SimonRigharts That's go-live to present, and only one data point, so exponential growth can't be inferred. Could just be growing linearly at 130GB/yr which is quite sustainable (disks are growing in size exponentially, so linear growth in disk needed can be very sustainable).
Feb
6
comment MyISAM table keeps crashing. What are my options?
Multiple concurrent reads (or even writes) shouldn't crash a table. What do your error logs say? Additionally, if you're not on the latest MySQL, you may want to go through changelogs and see if any relevant bugs have been fixed.
Jan
3
revised How do I have Oracle ASM scan for and repair uncorrectable ECC errors (bad sectors)?
update on (lack of) progress I've made so far.
Dec
5
comment How do I have Oracle ASM scan for and repair uncorrectable ECC errors (bad sectors)?
Actually, the 11.2 docs tell me remap marks blocks unusable... which wouldn't be a good thing for a whole disk.
Dec
5
comment How do I have Oracle ASM scan for and repair uncorrectable ECC errors (bad sectors)?
I've tried 'check all', it does nowhere near enough I/O to be scanning the disks. Docs seem to say that just does metadata. Remap seems to require I already have block numbers (or do I just issue a remap for each disk, for every block on the disk?). Also, I should make clear that ASM hasn't hit these errors on its own; e.g., maybe that data hasn't been accessed recently. Or maybe its free space. I know about them from SMART surface scan.
Dec
5
awarded  Student
Dec
5
awarded  Tag Editor
Dec
5
revised oracle-asm wiki description
added 832 characters in body
Dec
5
revised oracle-asm wiki excerpt
added 124 characters in body
Dec
5
suggested suggested edit on oracle-asm tag wiki excerpt
Dec
5
suggested suggested edit on oracle-asm tag wiki
Dec
5
wiki created oracle-asm description
Dec
5
wiki created oracle-asm excerpt
Dec
5
awarded  Citizen Patrol
Dec
5
asked How do I have Oracle ASM scan for and repair uncorrectable ECC errors (bad sectors)?
Nov
7
awarded  Scholar
Nov
7
accepted In a two-server dataguard setup, can I store the recovery catalog in the same database?
Nov
4
awarded  Supporter