201 reputation
211
bio website surveyplanet.com
location Sacramento, CA
age 32
visits member for 2 years, 6 months
seen Aug 29 at 16:16

Software Engineer specializing in .NET and SQL Server. Lately I've been spending most of my days working with coffeescript, node.js and MongoDB which has been a lot of fun.

80th recipient of the Gold SQL badge (pretty proud of that)

Hobbies include web application security and machine learning.


Oct
21
awarded  Popular Question
Aug
8
awarded  Yearling
Jul
21
awarded  Notable Question
Jul
2
awarded  Curious
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.