thread connected and thread cached

2011-12-26 Thread Jeff Pang
Hello, I got the two picutures attached from mycheckpoint's web graph. They are showing the threads_connected have been increasing from 24th. But threads_cached have been decreasing from the same day. What does this mean for my mysql? Thanks. -- MySQL General Mailing List For list archives: ht

add index to slave but not master

2011-10-31 Thread Jeff Pang
Hello, I have a question that, if I add the index to the table in slave, but don't do it in master, will it make problems? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master

2011-09-28 Thread Jeff Pang
Hello, In last day I inserted a SQL which is about 5M to the master, the max_allowed_packet in both master and slave was 4M at that time. Then the replication crached, and the info is below: 110928 23:31:53 [Note] Slave SQL thread initialized, starting replication in log 'mysql-bin.002730' at pos

hang up mysql shell

2007-07-16 Thread Jeff Pang
hello, When saying 'exit' in mysql shell,mysqld would release the lock which was made before. But if I do 'ctrl+z' under linux to hang up mysql shell,would mysqld also release the lock or not? Thank you. Viel oder wenig? Schnell oder langsam? Unbegrenzt surfen + telefonieren ohne Zeit- und Vol

best filesystem for mysql

2007-05-01 Thread Jeff Pang
hello list, I saw this article for the suitable filesystem for mysql. http://www.bullopensource.org/ext4/sqlbench/ >From what I saw,the best filesystem for MyISAM is ext3,the best filesystem for >InnoDB is Reiserfs. How about your thought on it?Thanks. 50€ AMAZON-Einkaufsgutschein bei Bestellun

how to query this sql?

2007-04-28 Thread Jeff Pang
Hello list, I want to get the counter for db-items by each day,so I wrote this sql: select count(*) as dd from items group by updatetime; But sorry "updatetime" is "datetime" type,not "date" type.Then I can't get the correct result. How can I do this?Thanks. 50€ AMAZON-Einkaufsgutschein bei