search

splitbrain / dokuwiki-plugin-statistics

Gather usage/view statistics of a DokuWiki
http://www.dokuwiki.org/plugin:statistics
6 stars 17 forks source link

DELAYED option not supported #43

Open sanctus17 opened 7 years ago

sanctus17 commented 7 years ago

Hi!

Using the statistics plugin on my dokuwiki always gives me the following error:

DB Error: DELAYED option not supported for table 'stats_logins' INSERT DELAYED INTO stats_logins SET dt = NOW(), type = 'o', ip = ...

I'm using the latest DokuWiki, PHP 7.0 and MySQL 5.6.35.

Any idea why this isn't working? Thank you very much for your help!

Cheers.

doobidoo commented 9 months ago

The DELAYED keyword in MySQL's INSERT statement was used to improve the performance of insert operations by delaying the actual insertion of rows into a table. When a client used INSERT DELAYED, the server immediately returned an okay response, and the row was placed in a queue to be inserted when the table was not in use by any other threads. This feature was useful in certain scenarios, such as when inserting large amounts of data into a table, as it allowed the client to continue working without waiting for the insertion to complete. It also reduced the impact of insert operations on the overall performance of the database, as the actual insertion was delayed until the server had more resources available. However, the DELAYED keyword had some limitations and potential issues, such as the risk of data loss if the server crashed before the delayed rows were inserted. As a result, it was deprecated in MySQL 5.6.6 and removed in MySQL 8.0.