Question on MySQL database structure: Why 3 MyISAM tables?

jamesbond
Bear Rating Trainee
Bear Rating Trainee
Posts: 11
Joined: 12 Aug 2013, 01:42

Question on MySQL database structure: Why 3 MyISAM tables?

Postby jamesbond » 12 Aug 2013, 02:17


AngryChris
Bear Rating Master
Bear Rating Master
Posts: 135
Joined: 08 Apr 2013, 02:42

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby AngryChris » 12 Aug 2013, 04:01


User avatar
erikbennett
Bear Rating Trainee
Bear Rating Trainee
Posts: 20
Joined: 17 Mar 2013, 03:08
Location: Seattle, WA

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby erikbennett » 12 Aug 2013, 10:50

I'm using 1.9 (release, not trunk) and actually just recreated my database for other, unrelated reasons. I can confirm that they are still present in my database.

feader
Bear Rating Master
Bear Rating Master
Posts: 160
Joined: 26 Dec 2012, 20:03

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby feader » 17 Aug 2013, 02:56


jamesbond
Bear Rating Trainee
Bear Rating Trainee
Posts: 11
Joined: 12 Aug 2013, 01:42

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby jamesbond » 09 Sep 2013, 21:36

The fact that both types of tables (MyISAM and InnoDB) are used concerns me because it makes creating backups of the database quite complicated. With MySQL, there are different approaches to backup both types of tables (mysqldump needs different parameters) as discussed and .

It would be much easier if only one type of tables was be involved.

User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby fox » 09 Sep 2013, 22:11

You don't need to backup counters and tbqh I never had this problem, mysqldump always seemed to backup everything correctly for me.

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby sleeper_service » 09 Sep 2013, 22:21


User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby fox » 09 Sep 2013, 22:37

I'd like to post an obligatory lol @ dealing with mysql while caring about any sort of data integrity whatsoever.

User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby sleeper_service » 09 Sep 2013, 22:48


jamesbond
Bear Rating Trainee
Bear Rating Trainee
Posts: 11
Joined: 12 Aug 2013, 01:42

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby jamesbond » 10 Sep 2013, 01:20


User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby sleeper_service » 10 Sep 2013, 02:11


AngryChris
Bear Rating Master
Bear Rating Master
Posts: 135
Joined: 08 Apr 2013, 02:42

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby AngryChris » 10 Sep 2013, 02:31


User avatar
sleeper_service
Bear Rating Overlord
Bear Rating Overlord
Posts: 884
Joined: 30 Mar 2013, 23:50
Location: Dallas, Texas

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby sleeper_service » 10 Sep 2013, 05:24

isn't there a way to convert a myisam table to innodb?

AngryChris
Bear Rating Master
Bear Rating Master
Posts: 135
Joined: 08 Apr 2013, 02:42

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby AngryChris » 10 Sep 2013, 07:17


User avatar
fox
^ me reading your posts ^
Posts: 6318
Joined: 27 Aug 2005, 22:53
Location: Saint-Petersburg, Russia
Contact:

Re: Question on MySQL database structure: Why 3 MyISAM table

Postby fox » 10 Sep 2013, 08:38

I'll update the schema files for those tables to use innodb. Keeping those tables as isam is not required or anything, I just figured it would be a bit faster.

e: Since myisam is not specified explicitly in the dable definition, I'm not sure if making a migration for this is a good idea - what if it's innodb already or something? We don't want database upgrade scripts to break, this is confusing for people.


Return to “Everything else”

Who is online

Users browsing this forum: No registered users and 2 guests