Re: Why innodb can give the same X gap lock to two transactions?

r MySQL version is 4.1.18. Thx! -- Best regards, Leo Huang 2006/12/18, Heikki Tuuri <[EMAIL PROTECTED]>: Leo, 'gap' locks in InnoDB are purely 'inhibitive': they block inserts to the locked gap. But they do not give the holder of the lock any right to insert. Several transa

Why innodb can give the same X gap lock to two transactions?

same record. The MySQL Manual said that X lock is an exclusive lock. Why two transactions can get the same X lock? Any comment will be welcomed? Best regards, Leo Huang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can Innodb reuse the deleted rows disk space?

hi, Dan Nelson, Jochem van Dieten, and Chris Thx! I think I understand it after your replies. Regards, Leo Huang 2006/7/30, Dan Nelson <[EMAIL PROTECTED]>: In the last episode (Jul 29), Jochem van Dieten said: > On 7/28/06, Dan Nelson wrote: > >In the last episode (Jul 28),

Re: Can Innodb reuse the deleted rows disk space?

hi, Chris So, the deleted rows' disk space in tablespace can't re-use when I use Innodb, can it? And the tablespace is growing when we update the tables, even the amount of rows do not increase. Regards, Leo Huang 2006/7/28, Chris <[EMAIL PROTECTED]>: leo huang wr

Re: Can Innodb reuse the deleted rows disk space?

ve me more? Regards, Leo Huang 2006/7/27, Chris <[EMAIL PROTECTED]>: leo huang wrote: > hi, Chris > > Thank you for your advice! > > I know that Innodb use the logfiles circularly. Can Innodb re-use the > deleted rows' disk space in tablespace? I'm sure it w

Re: Can Innodb reuse the deleted rows disk space?

hi, Chris Thank you for your advice! I know that Innodb use the logfiles circularly. Can Innodb re-use the deleted rows' disk space in tablespace? Regards, Leo Huang 2006/7/26, Chris <[EMAIL PROTECTED]>: leo huang wrote: > hi, Dilipkumar > > Thank you very much! > &g

Re: Can Innodb reuse the deleted rows disk space?

hi, Dilipkumar Thank you very much! I think I know the fact: The Innodb can't reuse the deleted rows' disk space. And a solution is: dump the data; shutdown mysql; delete the files; restart mysql; import the data. Regards, Leo Huang 2006/7/24, [EMAIL PROTECTED] <[EMAIL PROTECTED

Can Innodb reuse the deleted rows disk space?

ickly. Any recommend will be welcome! Regards, Leo Huang -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Is the fsync() fake on FreeBSD6.1?

er_pool_size = 384M innodb_additional_mem_pool_size = 20M innodb_log_file_size = 100M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 regards, Leo Huang

Re: SELECT ALL and flag

hi, Peter Try this: select a.name, sum(if (b.table_a.id is NULL,0,1)) as indid from table_a a left join table_b b on(a.id=b.table_id.id) group by a.id; best regards, Leo Huang 2006/6/1, Peter Lauri <[EMAIL PROTECTED]>: Hi, I have a table table_a and table_b: table_a { id name } t

Re: mysql restart error

ysql and I got the error. Regards, Leo Huang 2006/3/28, [S] Dhandapani <[EMAIL PROTECTED] >: > > Hi Leo, > > check for cnf file for which port you have configured the port .If it is > in 3306 port then do netstat -an|grep LIST ,check for 3306 port is listening > on your syst

Re: mysql restart error

hi, Lakshmi The mysql process had ended. I get it from both mysql err log and ps output. regards, Leo Huang 2006/3/28, Lakshmi M P <[EMAIL PROTECTED]>: > > Run ps -ef | grep mysql and see any mysql process is running and if so > kill the same and try to start mysql.It

mysql restart error

s4.6479 FIN_WAIT_2 tcp4 0 0 bj.3306 s4.7873 FIN_WAIT_2 Our mysql version is 4.1.18. It is running on FreeBSD 4.9-RELEASE. Any comment will be great thankful! Regards, Leo Huang

Re: mySQL 5 and CPu at 99.99%

ze and key_buffer_size from this: http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html Best regards, Leo Huang 2006/2/28, Taiyo <[EMAIL PROTECTED]>: > Greetings, > > We are running a server and the CPU is a

How to keep account independent in replication

B's my.cnf and use the INSERT or DELETE statement in A to deal with the account management now. replicate-ignore-db=mysql As you can see, it is ugly and discommodious. Is there any better solution? Best regards, Leo Huang

Re: Same question, better example

Ariel, You can try this: mysql>select stri from prueba order by stri+0 desc; Leo Huang 2006/2/17, Ariel Sánchez Mora <[EMAIL PROTECTED]>: > > mysql> describe prueba; > +---+-+--+-+-+---+ > | Field | Type| Null

Re: selecting min, max

hi, I think the following link would be some help for you! http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html Leo Huang 2006/2/14, Octavian Rasnita <[EMAIL PROTECTED]>: > > Hi, > > From: "Rhino" <[EMAIL PROTECTED]> > ... >

Re: Viruses from the list

Al Bogner, Thanks for you info. Yes, I got quite a few as well. About Microsoft update stuff etc. But I think emails with viruses are quite common, my mail server captures around 2,000 emails with virus everyday. Also this is an old virus(relatively speaking), so it should be fine, I think. L

Re: Problem with DELETE USING

Bamelis, The error message doesn't seem to match your SQL... It only shows up to 'AND tblTest.URL = tblT' but your SQL is 'AND tblTest.Comment = tblTest2.Comment' Is that a problem?? An example from MySQL manual is 'DELETE FROM t1,t2 USING t1,t2,t3 WHERE t1.id=t2.id AND t2.id=t3.id' Leo

Re: Mysql Stoping

Hi Trevor, I suggest you to compile and reinstall MySQL from the source distribution. A suggested option is CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions \ -fno-rtti" ./configure --prefix=/usr/local/mysql --enable-assembler \ --with-mysqld-ldflags=-all-sta

Re: InnoDB Questions

t users from seeing other user's >data. like, you can assign a tablespace to a user and none else (ofcourse >other than root) can see the data. > >For more info, have a look at: >http://www.mysql.com/doc/en/InnoDB_File_space.html > >Enjoy >Nitin > > >- Orig

Re: InnoDB Questions

oss tablespaces. > >ib_logfile0, ib_logfile1 are log files, which are used to log sql statements >applied to database. these files are used to restore data in case of any >crash or mishap. > >for further info, have a look at: >http://www.mysql.com/doc/en/InnoDB_start.html >

Re: InnoDB Questions

I don't know. I will get some time this week, shutdown MySQL, backup my binary files, have a go as what Nitin said and see what's going on there. Leo Gabriel Ricard wrote: On Tuesday, November 4, 2003, at 07:58 AM, Leo Huang wrote: In InnoDB documentation, it suggests to add an

Re: InnoDB Questions

_files_in_group=3 set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 [mysql.server] user=mysql basedir=/usr [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid - - Original Message - From: "Nitin" <[EMAIL PROTECTED]> To: &quo

InnoDB Questions

Hello, I have a few questions about InnoDB. I am new to InnoDB, and just converted my MyISAM tables into InnoDB a few days ago. I notice that it generates these files -rw-rw1 mysqlmysql2560 Nov 2 13:07 ib_arch_log_00 -rw-rw1 mysqlmysql790626304 Nov 4