humm... I bet he have just run of space...
Some thing like tht...
On Tue, Oct 16, 2012 at 10:43 PM, Dehua Yang wrote:
> 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 err
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
It's actually much more complicated than a simple many-to-many
relationship. For instance, users may enter many hashtags in many
comments, and a user might want to see all the hashtags they've used,
and then find all the comments with those hashtags.
I'm not trying to re-create the specification
Many-to-many? That is, can a comment have many different hashtags? And a
hashtag can be associated with many comments?
Best practice for many-to-many:
CREATE TABLE xyz (
hashtag VARCHAR(...) NOT NULL,
comment_id ... NOT NULL,
PRIMARY KEY (hashtag, comment_id),
INDEX(comment_id, hashtag)
) ENGIN
Are there any established "best practices" or schemas for
incorporating twitter-like hashtags into a database ?
Let's say I have a blog with a commenting system, and I want to allow
people to add hashtags to the comments.
I could certainly create one on my own (it's not that difficult), but
I'd
Hi Reindl
I had tested your method serval months ago.
When i had a crash table, I added myisam-recover = "FORCE" to my.cnf
and restarted mysqld.
But it didn't work
So, finally, we just had to do this repairment by application code.
On Fri, Oct 19, 2012 at 4:59 PM, Reindl Harald wrote:
>
>
i mean ...do u connect just like
mysql -u -p
or
mysql -u -p -h hostname
On Thu, Oct 18, 2012 at 11:07 PM, kalin wrote:
>
> not sure i follow. what do you mean connect?!
>
> there is a server (mysqld) and a client (mysql). the client gets to the
> server via the socket. like on any other un
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 can let your application auto
> repair this problem.
> Just like this :
