Consider a wiki that lets you edit rows in a db table. Each page is a
row in the table, and has fields that anyone can edit. Like all wikis,
it keeps a history of edits (including who made the edits), and lets
you revert an edit, or even delete a row (page) completely.
Has anyone implemented somet
Dear MySQL users,
MySQL Server 5.4.3-beta, a new version of the popular Open
Source Database Management System, has been released.
Bear in mind that this is a beta release, and as with any
other pre-production release, caution should be taken when
installing on production level systems or system
Use an etl tool like Talend to load the slow query log into a table. We do
something similar with the general query log very successfully with mysql 5
Even with 5.1 i would use this approach over the built in log tables as the
built in log tables impact performance quite significantly.
Regards
This issue pre-dates databases. It was chewed over during the days of simple
ISAM files. The big trade-off is between speed of retrieval and speed of
insertion. I don't recall that you gave us any specifics about that. If you
can afford the INSERT overhead, by all means index the date.
I see th
