Re: inserting BLOB data
Daniel Kasak <[email protected]> Fri, 14 Dec 2007 08:07:19 +1100
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Organization | NUS Consulting |
| Message-ID | <[email protected]> |
On Wed, 2007-12-12 at 20:57 -0500, Patrick Galbraith wrote: > Daniel, > > Very interesting. Do you also use replication? No. We're happy enough with nightly ( full ) backups, and the transaction logs. But there is often talk of replication in the DBMail mailing list, so certainly others are doing it. > What storage engine are your tables using? Mostly InnoDB. DBMail uses InnoDB for everything, and this is by *far* the biggest user of MySQL now ( 20 GB of email, compared to 2 GB of everything else ). I also use InnoDB for larger tables ( we ran into record-locking problems with MS Access and MyISAM, which disappeared completely when we converted tables to InnoDB. We've since largely moved away from Access, but we're happy with InnoDB's performance ). We use MyISAM for limited use tables, or read-only tables. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [email protected] website: http://www.nusconsulting.com.au -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]