I've vacillated about this, and used both on and off since innodb was made
available in mysql.
My opinion is that it is a DBA concern, but we might like to offer some
documentation on the subject to allow DBA's to make informed choices if we
have knowledge worth sharing.
d.
|---------+---------------------------->
| | Serge Knystautas |
| | <[EMAIL PROTECTED]|
| | l.com> |
| | |
| | 25/06/2005 18:23 |
| | Please respond to|
| | "James Developers|
| | List" |
|---------+---------------------------->
>---------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: server-dev@james.apache.org
|
| cc:
|
| Subject: Innodb better?
|
>---------------------------------------------------------------------------------------------------------------------------------|
After reading some tips on mysql optimization, I altered my email
table for James from myisam to innodb. The rational was that there is
a lot of concurrent writing happening, so it would greatly benefit
from row-level locking.
It seems like things are faster, though I haven't done any real tests.
For others who know MySQL well, does this make sense, and should we
alter the create scripts to use this table type?
--
Serge Knystautas
Lokitech >> software . strategy . design >> http://www.lokitech.com
p. 301.656.5501
e. [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
***************************************************************************
The information in this e-mail is confidential and for use by the addressee(s)
only. If you are not the intended recipient (or responsible for delivery of the
message to the intended recipient) please notify us immediately on 0141 306
2050 and delete the message from your computer. You may not copy or forward it
or use or disclose its contents to any other person. As Internet communications
are capable of data corruption Student Loans Company Limited does not accept
any responsibility for changes made to this message after it was sent. For
this reason it may be inappropriate to rely on advice or opinions contained in
an e-mail without obtaining written confirmation of it. Neither Student Loans
Company Limited or the sender accepts any liability or responsibility for
viruses as it is your responsibility to scan attachments (if any). Opinions and
views expressed in this e-mail are those of the sender and may not reflect the
opinions and views of The Student Loans Company Limit
ed.
This footnote also confirms that this email message has been swept for the
presence of computer viruses.
**************************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
