head	1.2;
access;
symbols
	pkgsrc-2022Q3:1.1.0.12
	pkgsrc-2022Q3-base:1.1
	pkgsrc-2022Q2:1.1.0.10
	pkgsrc-2022Q2-base:1.1
	pkgsrc-2022Q1:1.1.0.8
	pkgsrc-2022Q1-base:1.1
	pkgsrc-2021Q4:1.1.0.6
	pkgsrc-2021Q4-base:1.1
	pkgsrc-2021Q3:1.1.0.4
	pkgsrc-2021Q3-base:1.1
	pkgsrc-2021Q2:1.1.0.2
	pkgsrc-2021Q2-base:1.1;
locks; strict;
comment	@# @;


1.2
date	2022.11.02.17.02.11;	author jperkin;	state dead;
branches;
next	1.1;
commitid	DOgyfL7l8eHVj90E;

1.1
date	2021.05.13.15.25.20;	author jdolecek;	state Exp;
branches;
next	;
commitid	VM2QlICeU94R20TC;


desc
@@


1.2
log
@mysql80: Update to 8.0.31.

Includes a number of pkgsrc cleanups, removing nonsense that has been
cargo-culted since the MySQL 3.23.x days(!).  Stop shipping mysql-test, it's
absolutely huge and unnecessary.  Add XXX to undocumented patches that we
should probably just drop, and make others easier to maintain.

Upstream changes are far too numerous to include here, so here are the links to
the corresponding release notes for each since 8.0.24:

  https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-31.html
  https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-30.html
  https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-29.html
  https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-28.html
  https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-27.html
  https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-26.html
  https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-25.html

Tested on SmartOS, I'll monitor bulk build reports for any fallout on other
platforms (it takes ages to build).
@
text
@===========================================================================
$NetBSD: MESSAGE.sphinx,v 1.1 2021/05/13 15:25:20 jdolecek Exp $

To install the SphinxSE MySQL plugin, log into your MySQL console
and issue the following query:

  INSTALL PLUGIN sphinx SONAME 'ha_sphinx.so';

You can verify it has been loaded properly by checking whether
it shows up in the list when list your engines:

  SHOW ENGINES;

===========================================================================
@


1.1
log
@import mysql80-client and mysql80-server packages from pkgsrc wip

package is experimental right now - it was confirmed working on NetBSD
and compile on macOS only for now

8.0 brings many improvements over 5.7, following is shortened list, more details
are available on https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html

- transactional data dictionary
- atomic DDL
- integrated upgrade procedure
- security and account management improvements
- resource groups and threads (thread affinity needs some work for NetBSD)
- table encryption management
- loads of innodb enhancements
- default character set utf8mb4
- JSON enhancements
- CTE, Window functions
- lateral derived tables
- reworked regular experssion support
- internal temporary tables
- HASH JOIN optimization
- EXPLAIN ANALYZE
- time zone support for TIMESTAMP and DATETIME
- optimizer hints for FORCE INDEX, IGNORE INDEX
- XML enhancements
- single preparation of statements
- single RIGHT JOIN as LEFT JOIN handling
- derived condition pushdown optimization

Number of features were also deprecated, check the release notes for that
@
text
@d2 1
a2 1
$NetBSD: MESSAGE.sphinx,v 1.1 2016/09/16 06:49:12 adam Exp $
@