Replication testing?

Hi All One of the managers requested me to find out about the replication testing on MySQL as one of our clients need this to be done soon. Basically what they want to do is the following: . Currently a master slave replication is in place. .

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 wrote: From: Manasi Save Subject: Stran

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. Wh

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 erro

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 wrote: > 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. > > ERR

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 tmp_table_

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 =

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 run

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 wrote: > hi > > as the title > > thanks > > -- > - > Lin Chun > -- Thanks Suresh Kuna MySQL DBA

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

hi as the title thanks -- - Lin Chun