Damien Hull wrote:

I see some instructions for snort include MySQL. Is there a good
reason to use MySQL with Snort?


Yeah, a better structured db against which to run queries. It's overkill
for some uses of snort, too, though. Depends what you intend to do with
snort's output.


--
Avi

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

Gilles Gravier wrote:

Note that since version 5.5 of MySQL, you get it installed (MySQL that
is) with InnoDB, the transactionnal datastore, enabled by default, this
means even better performance (and stability) than the original default
ISAM datastore in MySQL.


Ah yes. Unrecoverable by default. Thanks for that, MySQL.

--
Avi

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

Hi, Avi!

On 27/06/2011 09:53, Avi Greenbury wrote:
> Gilles Gravier wrote:
>> Note that since version 5.5 of MySQL, you get it installed (MySQL that
>> is) with InnoDB, the transactionnal datastore, enabled by default, this
>> means even better performance (and stability) than the original default
>> ISAM datastore in MySQL.
>
> Ah yes. Unrecoverable by default. Thanks for that, MySQL.
>

Explain "unrecoverable"?

Gilles

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

Gilles Gravier wrote:

Explain "unrecoverable"?


Well, perhaps not quite unrecoverable, but the difference in fun
following, say, a power failure on a MyISAM table versus an InnoDB one
leads me to always suggest MyISAM.


Wasn't there supposed to be a new storage engine by about now that fixes
all the performance penalties associated with MyISAM without the
automatic-embuggery of data that comes with Innodb?


--
Avi

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

Hi!

On Mon, Jun 27, 2011 at 10:30 AM, Avi Greenbury <lists@avi.co> wrote:

Gilles Gravier wrote:


Explain "unrecoverable"?




Well, perhaps not quite unrecoverable, but the difference in fun following, say, a power failure on a MyISAM table versus an InnoDB one leads me to always suggest MyISAM.



Wasn't there supposed to be a new storage engine by about now that fixes all the performance penalties associated with MyISAM without the automatic-embuggery of data that comes with Innodb?



That's the point of a transactionnal engine. In case of power failure, you just roll back the transaction journal and you are set. Same with a journaling file system like ZFS, EXT3, EXT4, REISER-FS.


Using InnoDB is a good way to survive what would kill an ISAM file when things go wrong...

Gilles.

--
Gilles Gravier - Gilles@Gravier.org
Using Google Apps web mail

--
ubuntu-users mailing list
ubuntu-users@lists.ubuntu.com
Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users