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 : > Hello John, > > There was a joke in russian PHP club:

Re: Is table_open_cache a private cache of a session?

, together with innodb_file_per_table. I guess this does not affect the bug, which occurs at sql/mysqld.cc. :-P 2010/2/2 Wagner Bianchi : > Sorry, *open_files_limit... > > 2010/2/1 Wagner Bianchi >> >> Is FD_SETSIZE regards to an open_file_limit? >> >> WB >> &g

Re: Is table_open_cache a private cache of a session?

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 : > > On Mon, Feb 1, 2010 at 4

Re: Is table_open_cache a private cache of a session?

"I've had one occurrence where it grew to 26.000 open tables" ) seems to show there must be something wrong with my understanding, Hmm... :-( 2010/2/1 Johan De Meersman : > On Mon, Feb 1, 2010 at 2:21 PM, Cui Shijun wrote: >> >> "To minimize the problem with

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 usin

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 u

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

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: http://lists

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 : > hi, >  I tried this in mysql 5.1.22

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 | +---++

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: 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 : > hi, >

Re: the max length of one SQL statement

hi, According to the transfer limit, ... 16M? 2009/3/20 raid fifa : > 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. > > *^_^* > > > _

copy blob between tables may get in consistent data?

LE1. So 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 M

Re: Replica questions

hi, #2. try adding the information of master into my.cnf then restart the server. thanks 2009/3/12 Bryan Irvine : > 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 and then it b

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: http://lists.mys

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 n

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 Gen

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) ==15827=

Re: how to get text SQL log

n another 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 : > Hi, > > On Mon, Feb 23, 2009 at 11:10 PM, Cui Shijun wrote: >> hi, >>  I've been usin

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 mysq