Arch Linux

Please read this before reporting a bug:
https://wiki.archlinux.org/title/Bug_reporting_guidelines

Do NOT report bugs when a package is just outdated, or it is in the AUR. Use the 'flag out of date' link on the package page, or the Mailing List.

REPEAT: Do NOT report bugs for outdated packages!
Tasklist

FS#33935 - [mysql] Add support for BLACKHOLE/ARCHIVE storage engine

Attached to Project: Arch Linux
Opened by Sebastien Bariteau (numkem) - Tuesday, 19 February 2013, 14:15 GMT
Last edited by Bartłomiej Piotrowski (Barthalion) - Wednesday, 20 February 2013, 17:11 GMT
Task Type Feature Request
Category Packages: Extra
Status Closed
Assigned To Bartłomiej Piotrowski (Barthalion)
Architecture All
Severity Low
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 1
Private No

Details

Description:
The PKGBUILD explicitly remove the support of the BLACKHOLE and ARCHIVE engines which are useful for many situations.

Changing the lines from -DWITHOUT_ARCHIVE_STORAGE_ENGINE=1 and -DWITHOUT_BLACKHOLE_STORAGE_ENGINE=1 to

-DWITH_ARCHIVE_STORAGE_ENGINE=1
-DWITH_BLACKHOLE_STORAGE_ENGINE=1

makes both storage engines available :
mysql> show engines;
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| Engine | Support | Comment | Transactions | XA | Savepoints |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+
| CSV | YES | CSV storage engine | NO | NO | NO |
| InnoDB | DEFAULT | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |
| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
| ARCHIVE | YES | Archive storage engine | NO | NO | NO |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+


Steps to reproduce:
Once logged in to your MySQL instance, running "show engines;" shows that both BLACKHOLE and ARCHIVES are not present.
This task depends upon

Closed by  Bartłomiej Piotrowski (Barthalion)
Wednesday, 20 February 2013, 17:11 GMT
Reason for closing:  Implemented
Additional comments about closing:  mysql 5.5.30-4

Loading...