Re: how things get messed up

Hello Ilya, I think store files in DB has no complicated reasons, just for convenience. For example, I might make files automatically be backup-ed, and no budget for an independent backup solution. Thanks. Cui 2010/2/11 Ilya Kazakevich kazakev...@devexperts.com: Hello John, There was a

Is table_open_cache a private cache of a session?

hi, I'm a little confused by the document(http://dev.mysql.com/doc/refman/5.1/en/table-cache.html), which only says: To minimize the problem with multiple client sessions having different states on the same table, the table is opened independently by each concurrent session. Are sessions using

Re: Is table_open_cache a private cache of a session?

to 26.000 open tables ) seems to show there must be something wrong with my understanding, Hmm... :-( 2010/2/1 Johan De Meersman vegiv...@tuxera.be: On Mon, Feb 1, 2010 at 2:21 PM, Cui Shijun rancp...@gmail.com wrote: To minimize the problem with multiple client sessions having different states

Re: Is table_open_cache a private cache of a session?

at 4:51 PM, Cui Shijun rancp...@gmail.com wrote: I'm also confused by the difference relationship between open table and open file descriptor by the table cache. open table is a MySQL concept. Open file descriptor is an OS concept. A single table (MyISAM) consists of three files: the .frm

Re: Is table_open_cache a private cache of a session?

2010/2/1 Cui Shijun rancp...@gmail.com  Got your idea.  Thank you very much. Now I know how table cache works :-)  For the bug, yes, it's related to the value of FD_SETSIZE, which is limited to 1024 at my RedHat box. Maybe I should update it to a suitable value. 2010/2/2 Johan De Meersman

extend via table VS extend via database

hi, I'm using innodb engine. There are more and more rows in my table recently, and I've planned to extend the structure. Assume I have testdb, the database, and testTab, the table, in ONE mysql. There are two ways: * extend via table, that is, testTab - testTab_1 -

how to change the name(and the data dir) of a database?

hi, Is there an easier way to change the name of a database other than mysqldump? Can I physically move the database to another directory?( I've tried and it works, at least it seems like it works) Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: where is the stored functions STORED?

--triggers as a dump option Rolando A. Edwards MySQL DBA (CMDBA) 155 Avenue of the Americas, Fifth Floor New York, NY 10013 212-625-5307 (Work) 201-660-3221 (Cell) AIM : RolandoLogicWorx Skype : RolandoLogicWorx redwa...@logicworks.net -Original Message- From: Cui Shijun

where is the stored functions STORED?

hi, It seems that the stored functions isn't stored in a seperated file like trigger does. Where are them? If I copy the database directory from a server to another, can I get the same functions on the both servers? Thank you. -- MySQL General Mailing List For list archives:

checksum table incompatible change?

hi, I tried this in mysql 5.1.22: mysql create table t( value binary(16)) engine=innodb; Query OK, 0 rows affected (0.00 sec) mysql insert into t values( NULL ); Query OK, 1 row affected (0.00 sec) mysql checksum table t; +---++ | Table | Checksum | +---++ |

Re: checksum table incompatible change?

hi, Now I know it, sorry for the interruption :( The two mysql are compiled with different default character set parameters... It's easy to get confused for having NULL in utf8 != NULL in gbk, though. Thank you 2009/3/24 Cui Shijun rancp...@gmail.com: hi,  I tried this in mysql 5.1.22

safe enough if mysqlcheck has no more complain?

hi, I'm planning to upgrade my current mysql 5.1.22 to mysql 5.1.32. I did some experiments, which imply that if several steps taken, mysqlcheck mysql_upgrade will have no more complain: 1. first build a mysql-5.1.32 using source 2. copy the whole var directory to mysql-5.1.32 3. start

Re: the max length of one SQL statement

hi, According to the transfer limit, ... 16M? 2009/3/20 raid fifa raid_f...@yahoo.com.cn: Hi guys, Anybody knows that how many bytes the max length of on SQL statement can be in MySQL database? I know it's 64KB in Oracle. Thanks. *^_^*

Re: copy blob between tables may get in consistent data?

: log the BLOB data step 3: write the data into TABLE2 result: select hex(data) from TABLE1 is the same as what I've logged in step2 select hex(data) from TABLE2 is different with select hex(data) from TABLE2 Any suggestions? 2009/3/19 Cui Shijun rancp...@gmail.com: hi

copy blob between tables may get in consistent data?

what's going wrong? Thank you Cui Shijun -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

what will happen if the disk is full when mysql flush binlog to it

hi, What will happen if the disk is full when mysql flush binlog to it? If I use innodb engine(mysql-5.1.22) and turn on the binlog, is there any chance that mysql has data updated without binlog flushed? Will mysql return with fail when it fail on binlog? Thank you. -- MySQL General

Re: Replica questions

hi, #2. try adding the information of master into my.cnf then restart the server. thanks 2009/3/12 Bryan Irvine sparcta...@gmail.com: I've got 2 questions about my newly set up master-slave replica. 1 When I run load data from master; I get an error that I do not have RELOAD privileges

Re: Does binlog stay in memory when replication happens?

hi, Thank you for your reply :-) What does replication have to do with it? I wonder whether mysql will copy its binlog from memory( if it exists ) then send to slave. I haven't refer to the source codes yet... Slave's binlog?  The slave's binlog is not tied to the master's binlog.  I am not

Is binlog using WAL?

hi, It seems that mysql will call write interfaces(eg. bulk_update_row ha_update_row ...) of HANDLER before writing a binlog. Does this mean the time when binlog is written actually vary from engine to engine? Thank you. -- MySQL General Mailing List For list archives:

Does binlog stay in memory when replication happens?

hi, I wonder if it is safe to assume that binlog can stay in master's memory when replication happens. If not, when the binlog getts corruptted, will the slave's binlog also get corrupted? Is there way to make the slave's binlog survive even in master's disk failure? Thank you -- MySQL

invalid write of size 1 when execute mysql_real_query

hi, Valgrind reports that there are some errors in my test code, one of which seems like this: tests amysql::connector - blocking and asynchronous mutliple statement query: .==15827== Thread 2: ==15827== Invalid write of size 1 ==15827==at 0x40269F7: memcpy (mc_replace_strmem.c:402)

Re: how to get text SQL log

plain text log with simultaneous binlog-writes, the file could get corruptted with fairly close probability as binlog does... Do I miss something? 2009/2/24 Baron Schwartz ba...@xaprb.com: Hi, On Mon, Feb 23, 2009 at 11:10 PM, Cui Shijun rancp...@gmail.com wrote: hi,  I've been using mysql

how to get text SQL log

hi, I've been using mysql-5.1.22 in my project, which processes a lot of read operations but little write operations. I got the idea from some of my coworkers that binlog has a chance to be corrputed so that mysqlbinlog can't process it correctly. Is there any usable plain text SQL log in