Re: inserting BLOB data

Daniel Kasak wrote:

>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.
>
>  
>
Daniel,

One other question - do you use fulltext indexes on your blobs/text 
columns for searches?

regards,

Patrick

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


-- 
Patrick Galbraith, Senior Programmer 
Grazr - Easy feed grazing and sharing
http://www.grazr.com 

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]