Welcome to Geeklog, Anonymous Friday, December 01 2023 @ 04:52 am EST

Comments for Geeklog 1.3.10rc1

Geeklog 1.3.10rc1 | 28 comments | Create New Account

The following comments are owned by whomever posted them. This site is not responsible for what they say.

Geeklog 1.3.10rc1

Authored by: LWC on Thursday, October 21 2004 @ 10:06 am EDT

What advantages would InnoDB tables give me over MyISAM? And would they make "database backups somewhat more complicated" even with PhpMyAdmin?

Geeklog 1.3.10rc1

Authored by: Dirk on Thursday, October 21 2004 @ 04:19 pm EDT

Well, if you have to ask, then you shouldn't be using InnoDB tables ...

The guys with the really big Geeklog sites have had some issues with table locking under heavy traffic and recommended using InnoDB tables in that case. We're talking about sites with 6-digit numbers of users here or sites that are slashdotted on a regular basis.

The downside of InnoDB tables is that it's difficult to create a consistent backup. You'll either have to lock the database for the time of the backup or buy innodb.com's solution ...

In other words: If in doubt, don't.

bye, Dirk

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks