169 reputation
11
bio website database-architect.com
location Vancouver, Canada
age 32
visits member for 2 years, 2 months
seen Jul 31 at 17:30

Database architecture

We're offering database architecture and SQL performance optimization services. Technologies:

  • Oracle
  • MySQL

Feel free to request a quote if you are interested.

Best regards


Aug
6
awarded  Tumbleweed
Jul
30
revised Can I reuse the same agent for 2 different Oracle Enterprise Manager servers?
added 85 characters in body
Jul
30
asked Can I reuse the same agent for 2 different Oracle Enterprise Manager servers?
Jul
24
asked How to verify that a certain commit has been transmitted to standby
Jul
18
comment RAC, data guard, physical stand by and impdp
Do you think the slowdown would be that consequent even though standby and primary are on 2 different servers?
Jul
12
comment A single, simple update takes 10+ seconds
nb2: your edit4 makes me think that it must be a lock problem
Jul
12
comment A single, simple update takes 10+ seconds
nb: you should not use commas around integers when they are handled as so in the database.
Jul
12
comment Datatype for different categories in a database
Why would you put all this in 3 different tables to begin with? Are they totally different concept, from the way your business uses it perspective? Something sounds weird by reading them. Maybe you should have only one table, I'm not sure
Jul
11
awarded  Editor
Jul
9
comment Disable procedures for data load in MySql using Innodb engine
You mean triggers? You can disable them, you don't have to drop them
Jul
9
accepted RAC, data guard, physical stand by and impdp
Jul
9
comment RAC, data guard, physical stand by and impdp
Thank you, I really needed a confirmation that dropping users and impdp would reflect to the standby database.
Jul
9
comment Building a Trending query
If you don't care about days with 0 inspections, just use a regular sum/group by query. Otherwise you'll need interval and windowed functions
Jul
9
comment Question on MySQL insert race condition
you're right! forums.mysql.com/read.php?21,37304,37308#msg-37308
Jul
9
comment Question on MySQL insert race condition
- I don't have documentation to back it up, but to my experience all mysql calls from php are synchronous. Imagine the consequences otherwise... - I don't know any setting in mysql that would say otherwise. - I don't think the table engine has anything to do here. - Caching is a possible problem. Try using SELECT SQL_NO_CACHE * ... instead.
Jul
9
comment RAC, data guard, physical stand by and impdp
We are setting up a MAA dataguard configuration on 2 different Oracle ODA, as explained in this document oracle.com/technetwork/database/features/availability/…
Jul
9
asked RAC, data guard, physical stand by and impdp
Jun
25
comment RMAN backups, incremental, not compressed: estimate size?
What about incremental backup? Everyday we´ll add up, right? How to anticipate the size of it?
Jun
24
asked RMAN backups, incremental, not compressed: estimate size?
Feb
10
comment mysql forbidden database names
Hi Paul, my app is a dynamic hosting system including databases, I have a job in the background doing all that kind of stuff. My users need their own database that's why I have to perform this check... Thanks!