| 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! |