Re: Error message I am getting today. All help appreciated.

2012-10-16 Thread Dehua Yang
Hi There many reasons to lose connection to MySQL server. And what's more , the important thing is that you should provide the error code to us. If you got the error code , you can check it by perror X Anymore detail information would be appreciate ! On Wed, Oct 17, 2012 at 10:32 AM, ad...@cana

Re: Possible to copy the key field to another on INSERT?

2012-10-17 Thread Dehua Yang
select LAST_INSERT_ID() ; Under high concurrency , it would return other threads value to you. On Wed, Oct 17, 2012 at 2:23 PM, W. D. wrote: > When creating a record, the first field (KeyField)... > > KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT > > ...is it possible to copy t

Re: Possible to copy the key field to another on INSERT?

2012-10-17 Thread Dehua Yang
Hello Shawn Thanks for your tips. We send the " select LAST_INSERT_ID() " by our data middle ware. I'll ask the middle ware team to check it out. On Wed, Oct 17, 2012 at 9:33 PM, Shawn Green wrote: > Hello Dehua, > > > On 10/17/2012 3:33 AM, Dehua Yang wrote: &

Re: Unexpected gradual replication log size increase.

2012-10-18 Thread Dehua Yang
Hi Kent How did you found the snmp traps ? Would you give me some tips that how did you locate this problem? On Thu, Oct 18, 2012 at 5:37 PM, Kent Ho wrote: > Thanks for the replies. > > After examining the logs carefully. We found several devices sending snmp > traps to the application m

Re: Table crashed error

2012-10-18 Thread Dehua Yang
MyISAM storage tables also have this kind of problem. I have try serval solutions for this problem , but can't work very well. If your application isn't very import , you can let your application auto repair this problem. Just like this : When your application catch this error information , run

Re: Table crashed error

2012-10-19 Thread Dehua Yang
dl Harald wrote: > > > Am 19.10.2012 08:42, schrieb Dehua Yang: > > MyISAM storage tables also have this kind of problem. > > > > I have try serval solutions for this problem , but can't work very well. > > > > If your application isn't very import , you

Re: Schemas for storing and reporting on hashtags

2012-10-19 Thread Dehua Yang
Hi Hank I just can think like this table CREATE TABLE xyz ( hashtag VARCHAR(...) NOT NULL, comment_id ... NOT NULL, user_id bigint unsigned not null, PRIMARY KEY (hashtag, comment_id), INDEX(comment_id, hashtag), index idx_user_id(user_id) ) ENGINE = InnoDB; one user want to check all his comm