hello, I would like to set that option in mysql 5.0.45 on my slave server:
|master-retry-count=800
my slave status:
Slave_IO_State: Queueing master event to the relay log
Master_Host: xx.xx.xx.xx
Master_User: fmRepl
Master_Port: 3306
Hello, I'm having some problems to figure out how I could handle my
problem with innodb.
my table is innodb engine:
CREATE TABLE `videos_innodb` (
`video_id` int(10) unsigned NOT NULL auto_increment,
`client_id` int(10) unsigned default NULL,
`client_id_upload` int(11) NOT NULL default '0',
n't want the second session to hang and wait,
then you need to tell it to lock different rows.
It might help if you explain what you're trying to accomplish. It
sounds like you're trying to build a message queue or something, which
is a problem that has been solved already.
On F
ELECT FOR UPDATE
On Feb 4, 2008 4:58 PM, Frederic Belleudy <[EMAIL PROTECTED]> wrote:
Hi there, I'm new with innodb and I'm not sure it's good to go with
innodb for my personnal goals.
Ok, let's assume I 've a table and want to select the first 10 rows fro
Hi there, I'm new with innodb and I'm not sure it's good to go with
innodb for my personnal goals.
Ok, let's assume I 've a table and want to select the first 10 rows from
that table but I want to be sure that no other scripts will select the
same rows I've previously got by the first script.
return a set of
results? Any idea?
Tks
--
Frederic Belleudy
Programmer
PWIdeas
ICQ #: 253-372-030
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi steve, you just have to double quotes your insert!
On 5/18/06, Steve <[EMAIL PROTECTED]> wrote:
Hi everyone...
how do I enter html code into my database???
Hi all!
server version: 5.0.18
I attempted to create a trigger with statement and update, it does like
this:
CREATE TRIGGER update_trans AFTER UPDATE ON main_trans
FOR EACH ROW
BEGIN
IF OLD.trans_status='INITIAL' and OLD.trans_state='INITIAL' THEN
update trans set trans_status=NEW.trans_status, t
