Dimitre Radoulov

less info
174 reputation
10
bio website
location Milan, Italy
age 39
visits member for 1 year, 8 months
seen 9 hours ago
stats profile views 5

Mar
16
awarded  Popular Question
Mar
12
awarded  Popular Question
Mar
3
awarded  Popular Question
Nov
29
comment Does mysqld wait for init-script code to complete before opening the instance?
Thank you very much, Rolando! My test with your loop using now() + interval prove that mysqld actually waits for the code to complete before opening the instance! So, we need to be very careful when using the init-file parameter! Thanks again!
Nov
29
accepted Does mysqld wait for init-script code to complete before opening the instance?
Nov
28
comment Does mysqld wait for init-script code to complete before opening the instance?
Completely agreed, however I don't see how a procedure is different from a plain SQL - the code will be executed with the higher possible privileges anyway. And even if the procedural code would potentially present higher security risks, I would expect that fact to be documented. Anyway thank you for sharing your thoughts!
Nov
28
comment Does mysqld wait for init-script code to complete before opening the instance?
Rephrasing the question: why calling a procedure via init-script behaves differently compared to manual invocation?
Nov
28
comment Does mysqld wait for init-script code to complete before opening the instance?
Note that the sleep seems to be skipped only when invoking the procedure using the init-file. It works just fine When I invoke the procedure interactively (using the mysql cli).
Nov
28
comment Does mysqld wait for init-script code to complete before opening the instance?
Unfortunately the output from the statements in the init-file don't appear in the error log.
Nov
28
revised Does mysqld wait for init-script code to complete before opening the instance?
added 42 characters in body
Nov
28
awarded  Commentator
Nov
28
comment Does mysqld wait for init-script code to complete before opening the instance?
Hi @RolandoMySQLDBA, thanks for replying! Do you have an idea why the sleep call seems to be skipped in the test case I posted?
Nov
28
revised Does mysqld wait for init-script code to complete before opening the instance?
deleted 78 characters in body
Nov
28
revised Does mysqld wait for init-script code to complete before opening the instance?
added 8 characters in body
Nov
28
asked Does mysqld wait for init-script code to complete before opening the instance?
Jun
8
awarded  Caucus
Mar
30
comment why is MySQL 5.1 on ubuntu 10.10 not starting?
Hi @vinny, check /var/log/mysql/error.log.
Feb
23
comment Running multiple instances on the same host
Thanks for the link!
Nov
15
accepted When are we supposed to set default-character-set for the client?
Nov
15
comment When are we supposed to set default-character-set for the client?
Hi @RolandoMySQLDBA, I was hopping there was a better way :) Thank you for your reply!