do i have to restart the mysql server when i change some global variables?

hi as the title thanks -- - Lin Chun

Re: do i have to restart the mysql server when i change some global variables?

unless and until if the variable is read-only, you don't need Lin. On Mon, May 31, 2010 at 3:17 PM, Lin Chun franks1...@gmail.com wrote: hi as the title thanks -- - Lin Chun -- Thanks Suresh Kuna MySQL DBA

Re: do i have to restart the mysql server when i change some global variables?

Yes and No. Its depend on the type of variable you have changed. If its Dynamic , MySQL restart not required, else its required. System variables can be set at server startup using options on the command line or in an option file. Most of them can be changed dynamically while the server is

Re: Strange behavior by MySQL Stored Procedure

mysql Version :- 5.1.42-community-log mysql Connector/J Version :-  mysql-connector-java-5.1.6-bin.jar   Sample Java Code Which Calls stored procedure :-    //get the connection to database Connection dbConnection = getConnection();   //create the call for procedure String procedureCallStmtStr =

ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it

Hi All, I am getting following error when I am trying to run one stored procedure on table which has 30 rows in it. Table Type id MyIsAM. ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it How to debug this error? I mean I tried to increase

Re: ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it

This kind of error usually means you ran out of disk space on your tmp_dir drive. Walter On Mon, May 31, 2010 at 13:30, Manasi Save manasi.s...@artificialmachines.com wrote: Hi All, I am getting following error when I am trying to run one stored procedure on table which has 30 rows in

Re: ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_66b0_0.MYI'; try to repair it

Dear Walter,   Thanks for quick response.   But When I try to remove my tmp files related to mysql. I am not allowed to remove them. How should I make more space in that case.   and We have allocated 2GB space for /tmp dir. and current size of folder is showing as 60M. Still I am getting this

ANN: Debugger for MySQL 1.2 released

Dear Sir! We are glad to announce the new version of Debugger for MySQL 1.2. You can download the new version with this link: http://www.mydebugger.com/download.php Briefly about the product: Debugger for MySQL is a handy framework to develop, test and debug MySQL procedures and functions.

Re: Strange behavior by MySQL Stored Procedure

Stored procedures are not executed like a query.  They are executed thru a Call { procedure} method. Please check the same or let us know how you are executing the Query/Calling the Procedure. Regards, VR Venugopal Rao --- On Fri, 28/5/10, Manasi Save manasi.s...@artificialmachines.com wrote: