196 reputation
9
bio website abemiester.com
location Sacramento, CA
age 31
visits member for 1 year, 10 months
seen Dec 24 '13 at 16:54

Software Engineer specializing in .NET and SQL Server.


Dec
24
awarded  Popular Question
Sep
24
comment MySQL memory usage issues?
Immediately after it started: 191 used/1811 free. Now: 514 used/1488 free.
Sep
24
comment MySQL memory usage issues?
Hey @Michael-sqlbot, I updated my question with the requested information. FYI I rebooted last night to free up memory so these queries were run after that.
Sep
24
revised MySQL memory usage issues?
added 327 characters in body
Sep
23
asked MySQL memory usage issues?
Aug
15
revised “Cannot add or update a child row” when deleting a record?
deleted 24 characters in body
Jun
28
awarded  Commentator
Jun
28
comment “Cannot add or update a child row” when deleting a record?
Ok, the names in my question should accurately reflect the names that are in my database now. Again, sorry for the confusion.
Jun
28
revised “Cannot add or update a child row” when deleting a record?
deleted 202 characters in body
Jun
28
comment “Cannot add or update a child row” when deleting a record?
It has a different name because I manually changed it in a failed attempt to avoid confusion. I was attempting to keep the names synched up, until my UPDATE #2. It sounds like it's confusing people so I will update so the table names are synched up again.
Jun
28
comment “Cannot add or update a child row” when deleting a record?
Hi @Michael-sqlbot, the sentences under my UPDATE #2 explains the difference in table names.
Jun
28
comment “Cannot add or update a child row” when deleting a record?
Hey Michael, I ran your query and no rows returned. I went ahead and included the create table statements in my original question. innodb_version is 1.1.8 and version is 5.5.28
Jun
28
comment “Cannot add or update a child row” when deleting a record?
@ypercube - yes, take a look at my second update.
Jun
28
revised “Cannot add or update a child row” when deleting a record?
added 4479 characters in body
Jun
27
revised “Cannot add or update a child row” when deleting a record?
edited body
Jun
27
comment “Cannot add or update a child row” when deleting a record?
Thanks for the response Michael. I went ahead and updated my question with some more details based on the direction you pointed me. I also double checked and there is no trigger magic happening so that is out.
Jun
27
revised “Cannot add or update a child row” when deleting a record?
added 2117 characters in body
Jun
26
asked “Cannot add or update a child row” when deleting a record?
May
29
comment Executing local scripts against remote server?
Looks like I was way off, thanks for the help!
May
29
accepted Executing local scripts against remote server?