Move Annotations into their own table

At the moment annotations are saved in the Option table into a single row per site (see \Piwik\Plugins\Annotations\AnnotationList::save). This approach seems to cause DB performance problems when annotations are added in bulk due to constant serialization and locks for updating on a single row.

An approach to cleanly solve this problem would be to create a dedicated DB table for the annotations rather than the single row serialization. This would require a new model/schema and a migration of the current data, but would be a good way to future proof and solve this performance problem.

Your Environment

• Matomo Version: 4.10.1
• PHP Version: 8
• Server Operating System: Mac
• Additionally installed plugins: