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