MySQL Forums - Install & Repo Forum for Installing and Configuring MySQL. https://forums.mysql.com/list.php?11 Sun, 12 Apr 2026 09:14:52 +0000 Phorum 5.2.23 https://forums.mysql.com/read.php?11,741621,741621#msg-741621 Mysql community edition upgrade from 8.0.36 to 8.4 (LTS) (no replies) https://forums.mysql.com/read.php?11,741621,741621#msg-741621
We are planning to upgrade from MySQL 8.0.36 (Community Edition) to MySQL 8.4, and before proceeding we would like confirmation/guidance from the MySQL community (or any official references) on the following:

Whether a direct in-place upgrade from 8.0.36 → 8.4 is supported (or if an intermediate upgrade step/version is recommended).

Any required pre-upgrade steps or mandatory fixes that should be completed prior to the upgrade.

Any known issues, upgrade advisories, or common pitfalls for this upgrade path.

Any deprecated or removed features in MySQL 8.4 that could impact existing workloads.

Environment details (for context):

Current version: MySQL 8.0.36 (Community)

Target version: MySQL 8.4 (Community)

Platform: [AWS EC2 ]

Application: Axway B2Bi (application layer already verified compatible with 8.4)

Thank you in advance for any guidance or links to relevant documentation.]]> Raja Pathri Install & Repo Thu, 12 Feb 2026 09:17:15 +0000 https://forums.mysql.com/read.php?11,741411,741411#msg-741411 Zeros in Dates (1 reply) https://forums.mysql.com/read.php?11,741411,741411#msg-741411
But is there any way to configure version 9 to allow dates with parts as zeros, globally for all databases?

Thanks for any help
Gary]]> Gary Luke Install & Repo Wed, 11 Feb 2026 16:54:28 +0000 https://forums.mysql.com/read.php?11,741366,741366#msg-741366 Debian 13 (trixie) repo / install instructions (no replies) https://forums.mysql.com/read.php?11,741366,741366#msg-741366
In the process of upgrading to Debian 13 (trixie) which is current stable release. I'm having some problems with it.


1. Documentation for APT install is out of date:

a) apt-key tool is no longer available as of Debian trixie.


Any old gpg keys installed with apt-key should be removed prior to upgrading or adding the new gpg key. Previous Debian versions try to use this key instead of the one specified in sources.list.d file.

If upgrading from Debian 11/12 (bullseye/bookworm), you may need to delete any old/current keys in deprecated trusted.gpg / /etc/apt/trusted.gpg.d (aka apt-key)

Debian changed their minds several times on file locations and what should/should not be in trusted.gpg. If you have old mysql keys before upgrade from previous installs, just delete them and add as below: 


$ sudo /usr/bin/apt-key del 467B942D3A79BD29
$ sudo /usr/bin/apt-key del B7B3B788A8D3785C

b) The docs suggest using keyserver pgp.mit.edu to get the key, but this server seems to be permanently broken and just returns an error when you try to fetch a key: 


$ sudo apt-key adv --keyserver pgp.mit.edu --recv-keys A8D3785C
Warning: apt-key is deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)).
Executing: /tmp/apt-key-gpghome.mimomkCxS8/gpg.1.sh --keyserver pgp.mit.edu --recv-keys B7B3B788A8D3785C
gpg: keyserver receive failed: No data


It is available via keyserver.ubuntu.com, however.

The following works on older versions of gpg, but NOT trixie / GnuPG 2.4.7: 


$ sudo gpg --homedir /tmp --no-default-keyring --keyring /usr/share/keyrings/mysql-apt-config.gpg --keyserver keyserver.ubuntu.com --recv-keys B7B3B788A8D3785C

# Add the repository to a `.list` file
echo "deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ trixie mysql-8.4-lts" | sudo tee /etc/apt/sources.list.d/mysql.list > /dev/null


- Unfortunately, importing this using gnupg no longer saves it in a format compatible with apt: 


Hit:2 http://repo.mysql.com/apt/debian trixie InRelease
Err:2 http://repo.mysql.com/apt/debian trixie InRelease
  Sub-process /usr/bin/sqv returned an error code (1), error message is: Error: Failed to parse keyring 
"/usr/share/keyrings/mysql-apt-config.gpg"  Caused by:     0: Reading "/usr/share/keyrings/mysql-apt-config.gpg": EOF
     1: EOF


To quote from https://manpages.debian.org/unstable/apt/apt-secure.8.en.html:

Quote

To generate keys suitable for use in APT using GnuPG, you will need to use the gpg --export-options export-minimal [--armor] --export command. Earlier solutions involving --keyring file --import no longer work with recent GnuPG versions as they use a new internal format ("GPG keybox database").


- Possible solutions to this:



Try updated options for gpg, and set permissions +r on the file so apt can read it: 

$ sudo gpg --homedir /tmp --no-default-keyring --no-permission-warning \
  --keyring gnupg-ring:/usr/share/keyrings/mysql-apt-config.gpg --keyserver keyserver.ubuntu.com \
  --recv-keys B7B3B788A8D3785C && sudo chmod +r /usr/share/keyrings/mysql-apt-config.gpg
gpg: key B7B3B788A8D3785C: "MySQL Release Engineering <mysql-build@oss.oracle.com>" 1 new signature
gpg: Total number processed: 1
gpg:         new signatures: 1


Another option is to use sq instead of gnupg:- 

# install sq if not present:
$ test ! -x /usr/bin/sq && sudo apt-get -y install sq
$ sudo sq network keyserver --server hkps://keyserver.ubuntu.com search "B7B3B788A8D3785C" \
   --overwrite --output /usr/share/keyrings/mysql-apt-config.asc

Found 1 certificate related to the query:

 - BCA43417C3B485DD128EC6D4B7B3B788A8D3785C
   - MySQL Release Engineering <mysql-build@oss.oracle.com> (UNAUTHENTICATED)
   - created 2023-10-23 17:26:50 UTC
   - found via: hkps://keyserver.ubuntu.com


- This will work as before, /etc/apt/sources.list.d/mysql.list something like:- 


deb [signed-by=/usr/share/keyrings/mysql-apt-config.asc] http://repo.mysql.com/apt/debian/ trixie mysql-apt-config
deb [signed-by=/usr/share/keyrings/mysql-apt-config.asc] http://repo.mysql.com/apt/debian/ trixie mysql-8.4-lts
deb [signed-by=/usr/share/keyrings/mysql-apt-config.asc] http://repo.mysql.com/apt/debian/ trixie mysql-tools
# deb-src [signed-by=/usr/share/keyrings/mysql-apt-config.asc] http://repo.mysql.com/apt/debian/ trixie mysql-8.4-lts


Another option is to just request the ascii key without using gpg and use that instead, then update sources to use that.
ASCII-armoured openpgp format is now supported by apt anyway.


- As mentioned in another post , For some reason the current pgp key is not available as a file like the previous key was at https://repo.mysql.com/RPM-GPG-KEY-mysql-2023.

It would be useful if the current key was also available. This gets it from keyserver.ubuntu.com: 


$ sudo curl -fsSL -o /etc/apt/keyrings/mysql-archive.asc "https://keyserver.ubuntu.com/pks/lookup?op=get&options=mr&search=0xB7B3B788A8D3785C";

# update repo if needed:
$ echo "deb [signed-by=/etc/apt/keyrings/mysql-archive.asc] http://repo.mysql.com/apt/debian/ trixie mysql-8.4-lts" | sudo tee /etc/apt/sources.list.d/mysql.list > /dev/null


2. For some reason the Packages file for trixie/ mysql-8.0 is blank:


https://repo.mysql.com/apt/debian/dists/trixie/mysql-8.0/binary-amd64/Packages


compare to:

https://repo.mysql.com/apt/debian/dists/bookworm/mysql-8.0/binary-amd64/Packages


- I'm not sure if that is intended, but this means after upgrading to trixie, apt will not install, for example , if you have this in your mysql.list: 


deb [signed-by=/usr/share/keyrings/mysql-apt-config.gpg] http://repo.mysql.com/apt/debian/ trixie mysql-8.0

# apt-get install mysql-community-client
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
E: Unable to locate package mysql-community-client


Using mysql-8.4-lts works though.


3. Although APT sources.list is still supported, it is recommended to use the new deb822-style format .sources file instead.

Example /etc/apt/sources.list.d/mysql.sources to replace /etc/apt/sources.list.d/mysql.list: 


Types: deb deb-src
URIs:  http://repo.mysql.com/apt/debian/
Suites: trixie
Components: mysql-8.4-lts mysql-tools
Enabled: yes
Signed-By: /usr/share/keyrings/mysql-apt-config.gpg


(Note: I've omitted mysql-apt-config because running this would put back the .list file and break apt.)]]> Robert Lister Install & Repo Mon, 10 Nov 2025 16:01:07 +0000 https://forums.mysql.com/read.php?11,741331,741331#msg-741331 mysql gpg key udpate (1 reply) https://forums.mysql.com/read.php?11,741331,741331#msg-741331 The mysql gpg key expired on October 22nd

~$ sudo curl -fsSL https://repo.mysql.com/RPM-GPG-KEY-mysql-2023 -o /tmp/fresh.asc -H "Cache-Control: no-cache"
~$ gpg --show-keys /tmp/fresh.asc
pub rsa4096 2023-10-23 [SC] [expired: 2025-10-22]
BCA43417C3B485DD128EC6D4B7B3B788A8D3785C
uid MySQL Release Engineering <mysql-build@oss.oracle.com>
sub rsa4096 2023-10-23 [E] [expired: 2025-10-22]

Are there any plans to update this new key in https://repo.mysql.com ? The previosu key was updated here also

Our current automation for builds pulls the current key from https://repo.mysql.com/RPM-GPG-KEY-mysql-2023

Thanks]]> Dayo Lasode Install & Repo Mon, 10 Nov 2025 16:35:28 +0000 https://forums.mysql.com/read.php?11,741317,741317#msg-741317 Expired public key for APT repo (no replies) https://forums.mysql.com/read.php?11,741317,741317#msg-741317
Following the docs here:
https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/

And pulling latest repo setup package from here:
https://dev.mysql.com/downloads/repo/apt/
mysql-apt-config_0.8.34-1_all.deb

Results in the same expired public key getting installed:
gpg --no-default-keyring --keyring /usr/share/keyrings/mysql-apt-config.gpg --list-keys

/usr/share/keyrings/mysql-apt-config.gpg
----------------------------------------
pub rsa4096 2023-10-23 [SC] [expired: 2025-10-22]
BCA43417C3B485DD128EC6D4B7B3B788A8D3785C
uid [ expired] MySQL Release Engineering <mysql-build@oss.oracle.com>


Am I missing something, or do we need an updated repo setup package for APT?

Thanks in advance.]]> Douglas Dietz Install & Repo Thu, 23 Oct 2025 17:07:31 +0000 https://forums.mysql.com/read.php?11,741211,741211#msg-741211 My SQL web community install failure - MFA? (no replies) https://forums.mysql.com/read.php?11,741211,741211#msg-741211
I have been installing mysql web community via a script for a long while now but this month it has started failing to install. This is due to MFA being required I believe with the mosuser and mospassword being used in installation.

Are there any workarounds for this does anyone know?

Thanks in advance,
Mark]]> Mark Prescott Install & Repo Tue, 16 Sep 2025 16:35:55 +0000 https://forums.mysql.com/read.php?11,741204,741204#msg-741204 when will Ubuntu Plucky repo be updated..?? (2 replies) https://forums.mysql.com/read.php?11,741204,741204#msg-741204 André verwijs Install & Repo Sun, 04 Jan 2026 10:13:59 +0000 https://forums.mysql.com/read.php?11,741168,741168#msg-741168 too many connections from haproxy ip (2 replies) https://forums.mysql.com/read.php?11,741168,741168#msg-741168 Let me start by saying that I'm a newbie and you might find something shocking below ;-)
I'm setting up a test environment with an InnoDB cluster of 3 nodes + 2 routers + 2 Haproxy instances with KeepAlived.....

The 3 instances replicate correctly and are individually accessible, and they connect to the primary router IP from the routers.....

But from the VIP or from the Haproxy IPs, I always get the error "too many connections from <haproxyIP>."

I've googled, chatgpted, expanded max_connections_error, max_conn, max_user_conn..... and various configurations in mysqlrouter.cfg / haproxy.cfg... and I can't make any progress.

The actual threads or connections to MySQL don't exceed 5-6 using just my user.

Does this sound familiar? Can you give me some guidance?

Thanks again, everyone.]]> Miguel Rodriguez Install & Repo Thu, 09 Oct 2025 10:32:50 +0000 https://forums.mysql.com/read.php?11,740986,740986#msg-740986 Configuring mySQL fails (no replies) https://forums.mysql.com/read.php?11,740986,740986#msg-740986
I'm trying to install mySQL on Gentoo Linux box.

Compi;ation went thru fine, however then I got following: 

WaylandGnome /home/igor # emerge --config dev-db/mysql


Configuring pkg...


 * Detected settings:
 * ==================
 * MySQL User:              mysql
 * MySQL Group:             mysql
 * MySQL DATA directory:        /var/lib/mysql
 * MySQL TMP directory:         /tmp
 * PID DIR:             /run/mysqld
 * Install db log:          /tmp/install_db.221119222.log
 * Install server log:          /tmp/install_mysqld.633921321.log
 * Trying to get password for mysql 'root' user from 'mysql' section ...
 * Trying to get password for mysql 'root' user from 'client' section ...

 * No password for mysql 'root' user was specified via environment
 * variable MYSQL_ROOT_PASSWORD and no password was found in config
 * file like '/root/.my.cnf'.
 * To continue please provide a password for the mysql 'root' user
 * now on console:
 * NOTE: Please avoid ["'\_%] characters in the password!
    >
 * Retype the password
    >

 * Initializing mysql data directory: /usr/sbin/mysqld --loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start --loose-skip-federated --loose-skip-ssl --loose-skip-log-bin --loose-skip-relay-log --loose-skip-slow-query-log --loose-skip-external-locking --loose-skip-log-slave-updates --initialize-insecure --init-file='/tmp/tz.222211327.sql' --basedir='/usr' --datadir='/var/lib/mysql' --tmpdir='/tmp' --log-error='/tmp/install_db.221119222.log' --user=mysql
/var/tmp/portage/dev-db/mysql-5.7.41/temp/environment: line 3774: /tmp/install_db.221119222.log: Permission denied
 * ERROR: dev-db/mysql-5.7.41::gentoo failed (config phase):
 *   Failed to initialize mysql data directory. Please review '/tmp/install_db.221119222.log'!
 * 
 * Call stack:
 *     ebuild.sh, line 136:  Called pkg_config
 *   environment, line 3777:  Called die
 * The specific snippet of code:
 *           die "Failed to initialize ${PN} data directory. Please review '${mysql_install_log}'!";
 * 
 * If you need support, post the output of `emerge --info '=dev-db/mysql-5.7.41::gentoo'`,
 * the complete build log and the output of `emerge -pqv '=dev-db/mysql-5.7.41::gentoo'`.
 * The complete build log is located at '/var/tmp/portage/dev-db/mysql-5.7.41/temp/build.log'.
 * The ebuild environment file is located at '/var/tmp/portage/dev-db/mysql-5.7.41/temp/environment'.
 * Working directory: '/var/tmp/portage/dev-db/mysql-5.7.41/empty'
 * S: '/var/tmp/portage/dev-db/mysql-5.7.41/work/mysql-5.7.41'

I'm trying to run it as system "root".

Some additional info: 

WaylandGnome /home/igor # ls -la /tmp/ins*
-rw-r--r-- 1 mysql root 0 Jul 16 21:10 /tmp/install_db.221119222.log
-rw-r--r-- 1 mysql root 0 Jul 16 21:10 /tmp/install_mysqld.633921321.log
WaylandGnome /home/igor #

As you can see the setup logs are created but the size of them are 0. 

WaylandGnome /home/igor # ls -la /
total 202248
drwxr-xr-x  21 root root      4096 Aug 21  2021 .
drwxr-xr-x  21 root root      4096 Aug 21  2021 ..
drwxr-xr-x   2 root root      4096 Apr  3  2024 bin
drwxr-xr-x   3 root root      4096 Jun 16  2024 boot
drwxr-xr-x  16 root root      3580 Jul 16 21:07 dev
drwxr-xr-x  79 root root      4096 Jul 16 21:07 etc
drwxr-xr-x   3 root root      4096 Aug 16  2021 home
drwxr-xr-x  12 root root      4096 Jun 24  2024 lib
drwxr-xr-x   6 root root      4096 Dec  8  2024 lib64
drwx------   2 root root     16384 Aug  9  2021 lost+found
drwxr-xr-x   2 root root      4096 Aug  8  2021 media
drwxr-xr-x   4 root root      4096 Aug 29  2021 mnt
-rw-r--r--   1 root root      9865 Aug 21  2021 modules_loaded
drwxr-xr-x   2 root root      4096 Aug  8  2021 opt
dr-xr-xr-x 243 root root         0 Jul 16 16:07 proc
drwx------   6 root root      4096 Jul 16 21:10 root
drwxr-xr-x  20 root root       680 Jul 16 21:08 run
drwxr-xr-x   2 root root      4096 Jun 24  2024 sbin
-rw-r--r--   1 root root 207004312 Aug  9  2021 stage3-amd64-openrc-20210808T170546Z.tar.xz
dr-xr-xr-x  13 root root         0 Jul 16 16:07 sys
drwxrwxrwt  10 root root      4096 Jul 16 21:10 tmp
drwxr-xr-x  12 root root      4096 Aug  8  2021 usr
drwxr-xr-x  10 root root      4096 Dec  8  2024 var
WaylandGnome /home/igor #

And as you can see above "/tmp" dir is "rwx" for everybody.

What could be the issue?

Thank you.]]> Igor Korot Install & Repo Thu, 17 Jul 2025 11:56:48 +0000 https://forums.mysql.com/read.php?11,740833,740833#msg-740833 Repository issues with HTTP (no replies) https://forums.mysql.com/read.php?11,740833,740833#msg-740833 Leigh Kennedy Install & Repo Wed, 18 Jun 2025 07:15:45 +0000 https://forums.mysql.com/read.php?11,740764,740764#msg-740764 Installation package ran, but did not upgrade? (1 reply) https://forums.mysql.com/read.php?11,740764,740764#msg-740764
A few apps and sites e.g. Wordpress require upgrade from my old mySql v5.7.26 to the current 8.0.42 or they will charge me more money!?!

So, I downloaded mysql-installer-web-community-8.0.41.0.msi, stopped the current mysql57 service and ran the .msi, then I started the service with a new name, but the old version persisted. I ran the .msi twice.

The mySql directory with the older version is still there! In dos cmd, I asked mySql which version, says old 5.7.28 and still working.


So what happened and how do I get the .msi to upgrade from 5.7 to 8.0.42 (or any other more current version)?]]> Arthur Chan Install & Repo Wed, 28 May 2025 23:13:28 +0000 https://forums.mysql.com/read.php?11,740681,740681#msg-740681 log-bin configiration (no replies) https://forums.mysql.com/read.php?11,740681,740681#msg-740681
I have the follow configuration.

# Logs Bin
log-bin = /devsqllog/binlog
binlog-format = MIXED
binlog_expire_logs_seconds = 3456000 # 40 dias em segundos
max_binlog_size = 5368709120 # 5GB em Bytes


My problem is that binlogs are not written to /devsqllog/binlog, they are written to /devsqllog.

xxxxxx@xxx-xxxxx-xxxx:~$ cd /devsqllog
xxxxxx@xxx-xxxxx-xxxx:/devsqllog$ ls -la
total 36
drwxr-x--- 4 mysql mysql 204 May 6 11:57 .
drwxr-xr-x 25 root root 4096 Apr 14 11:15 ..
drwxr-xr-x 2 mysql root 6 May 6 11:58 binlog
-rw-r----- 1 mysql mysql 181 May 6 11:28 binlog.000001
-rw-r----- 1 mysql mysql 181 May 6 11:30 binlog.000002
-rw-r----- 1 mysql mysql 181 May 6 11:32 binlog.000003
-rw-r----- 1 mysql mysql 181 May 6 11:36 binlog.000004
-rw-r----- 1 mysql mysql 181 May 6 11:37 binlog.000005
-rw-r----- 1 mysql mysql 181 May 6 11:38 binlog.000006
-rw-r----- 1 mysql mysql 158 May 6 11:57 binlog.000007
-rw-r----- 1 mysql mysql 175 May 6 11:57 binlog.index
drwxr-xr-x 3 mysql mysql 26 May 5 17:28 redolog01
xxxxxx@xxx-xxxxx-xxxx:/devsqllog$

What can be happening?]]> Jurandyr Fonseca Alves Jura Install & Repo Tue, 06 May 2025 17:08:29 +0000 https://forums.mysql.com/read.php?11,740680,740680#msg-740680 Enterprise MySQL 5.7 to 8.4 Upgrade (1 reply) https://forums.mysql.com/read.php?11,740680,740680#msg-740680 Sentient Energy Install & Repo Mon, 21 Jul 2025 12:22:54 +0000 https://forums.mysql.com/read.php?11,740624,740624#msg-740624 I can't change the place of binlog. (no replies) https://forums.mysql.com/read.php?11,740624,740624#msg-740624
I can't chenge the place of binlog.

I did this congirugarations.

# Bin Logs
log-bin=/devsqllog/databin
log-bin-index=/devsqllog/databin/binlog.index

I did shutdown in mysql than

cp /var/lib/mysql/binlog.* /devsqllog/databin/

than

start mysql

but I receive the error message

2025-04-25T14:23:15.397369Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.4.5) starting as process 923474
mysqld: File '/devsqllog/databin/binlog.index' not found (OS errno 13 - Permission denied)
2025-04-25T14:23:15.400597Z 0 [ERROR] [MY-010119] [Server] Aborting

drwxr-xr-x 6 mysql mysql 72 Apr 25 09:51 .
drwxr-xr-x 25 root root 4096 Apr 14 11:15 ..
drwxr-xr-x 2 mysql mysql 4096 Apr 25 11:13 databin
drwxr-xr-x 2 mysql mysql 6 Apr 24 16:36 redolog01
drwxr-xr-x 2 mysql mysql 6 Apr 24 16:36 redolog02
drwxr-xr-x 2 mysql mysql 6 Apr 24 16:36 redolog03mysql@hml-sian-a019:/devsqllog$ cd databin
mysql@hml-sian-a019:/devsqllog/databin$ ls -la
total 92
drwxr-xr-x 2 mysql mysql 4096 Apr 25 11:13 .
drwxr-xr-x 6 mysql mysql 72 Apr 25 09:51 ..
-rwxr-xr-x 1 mysql mysql 505 Apr 25 11:13 binlog.000001
-rwxr-xr-x 1 mysql mysql 181 Apr 25 11:13 binlog.000002
-rwxr-xr-x 1 mysql mysql 644 Apr 25 11:13 binlog.000003
-rwxr-xr-x 1 mysql mysql 158 Apr 25 11:13 binlog.000004
-rwxr-xr-x 1 mysql mysql 158 Apr 25 11:13 binlog.000005
-rwxr-xr-x 1 mysql mysql 158 Apr 25 11:13 binlog.000006
-rwxr-xr-x 1 mysql mysql 158 Apr 25 11:13 binlog.000007
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000008
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000009
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000010
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000011
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000012
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000013
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000014
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000015
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000016
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000017
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000018
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000019
-rw-r----- 1 mysql mysql 181 Apr 25 11:13 binlog.000020
-rw-r----- 1 mysql mysql 500 Apr 25 11:13 binlog.000021
-rw-r----- 1 mysql mysql 336 Apr 25 11:13 binlog.index
mysql@hml-sian-a019:/devsqllog/databin$

I don't seem permissions problems.

Can you help me please?

Thank's]]> Jurandyr Fonseca Alves Jura Install & Repo Fri, 25 Apr 2025 14:50:28 +0000 https://forums.mysql.com/read.php?11,740603,740603#msg-740603 Inconsistent SRPM index from certain edge servers (no replies) https://forums.mysql.com/read.php?11,740603,740603#msg-740603
I need to fetch the latest version of the RPM packages provided by repo.mysql.com. In other words, I want a reliable method to retrieve up‑to‑date package information rather than an outdated, edge‑cached directory listing.

## The problem I faced

Depending on which edge server handles the request, I sometimes receive an old index that does not include the newest release. For example, I expected to see mysql-community-8.0.42-1.el9, but when resolving to the edge at 23.47.146.211, it was missing:

```console
$ curl --resolve repo.mysql.com:443:23.47.146.211 \
https://repo.mysql.com/yum/mysql-8.0-community/el/9/SRPMS/

…
<IMG SRC="/icons/generic.gif" ALT="[FILE]">
<A HREF="mysql-community-8.0.41-1.el9.src.rpm">…mysql-community-8.0.41…</A>
…
</PRE><HR>
```

By contrast, another edge server (23.42.111.211) does list the latest package:

```console
$ curl --resolve repo.mysql.com:443:23.42.111.211 \
https://repo.mysql.com/yum/mysql-8.0-community/el/9/SRPMS/

…
<IMG SRC="/icons/generic.gif" ALT="[FILE]">
<A HREF="mysql-community-8.0.42-1.el9.src.rpm">…mysql-community-8.0.42…</A>
…
</PRE><HR>
```

## Steps I have tried

Assuming Akamai is in use, I added a timestamp query parameter for cache busting and confirmed that appending ?ts=<random> forces the edge to fetch the latest index.
ref: https://techdocs.akamai.com/api-definitions/docs/caching#cache-key-query-parameters

```console
$ curl https://repo.mysql.com/yum/mysql-8.0-community/el/9/SRPMS?ts=$(date +%s)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">
…
<IMG SRC="/icons/generic.gif" ALT="[FILE]">
<A HREF="SRPMS/mysql-community-8.0.42-1.el9.src.rpm">mysql-community-8.0.42-1.el9.src.rpm</A>
…
</PRE><HR>
```

## Request for help

Is there a more robust or officially recommended approach to ensure that I always retrieve the freshest SRPM list from all edge servers?]]> Takuya Kodama Install & Repo Tue, 22 Apr 2025 08:03:50 +0000 https://forums.mysql.com/read.php?11,740488,740488#msg-740488 cmake error regarding openssl (2 replies) https://forums.mysql.com/read.php?11,740488,740488#msg-740488
-- Could NOT find OpenSSL, try to set the path to OpenSSL root folder in the system variable OPENSSL_ROOT_DIR (missing: OPENSSL_CRYPTO_LIBRARY OPENSSL_INCLUDE_DIR)
-- Could NOT find OpenSSL, try to set the path to OpenSSL root folder in the system variable OPENSSL_ROOT_DIR (missing: OPENSSL_CRYPTO_LIBRARY OPENSSL_INCLUDE_DIR)
--
Could not find system OpenSSL
Make sure you have specified a supported SSL version.
Valid options are :
openssl[0-9]+ (use alternative system library)
yes (synonym for system)
</path/to/custom/openssl/installation>

I have tried every option for -DWITH_SSL=[option] I can think of, and am at my wits end. I hope someone here can suggest a solution.

I am trying to install mysql-8.4.4.
"openssl version" gives me "OpenSSL 3.4.1 11 Feb 2025 (Library: OpenSSL 3.4.1 11 Feb 2025)"
"cmake --version" gives me "cmake version 4.0.0-rc4"]]> David List Install & Repo Mon, 07 Apr 2025 17:00:44 +0000 https://forums.mysql.com/read.php?11,740445,740445#msg-740445 RPM's for MYSQL (1 reply) https://forums.mysql.com/read.php?11,740445,740445#msg-740445 We have Mysql 8.0.41 and like to upgrade to 8.4.4 (LTS).
I'm finding difficulty in getting the rpm's for this release.

These are the rpm's currently we have on our system.
Please suggest.

mysql Ver 8.0.41 for Linux on x86_64 (Source distribution) on Linux 8.10

mysql-errmsg-8.0.41-1.module+el8.10.0+90521+d5cc5c65.x86_64
mysql-server-8.0.41-1.module+el8.10.0+90521+d5cc5c65.x86_64
mysql-common-8.0.41-1.module+el8.10.0+90521+d5cc5c65.x86_64
mysql-8.0.41-1.module+el8.10.0+90521+d5cc5c65.x86_64

mysql-server-8.0.41-1.module+el8.10.0+90521+d5cc5c65.x86_64
mysql-errmsg-8.0.41-1.module+el8.10.0+90521+d5cc5c65.x86_64
mysql-8.0.41-1.module+el8.10.0+90521+d5cc5c65.x86_64
mysql-common-8.0.41-1.module+el8.10.0+90521+d5cc5c65.x86_64]]> Dhananjay Awale Install & Repo Sat, 05 Apr 2025 08:56:10 +0000 https://forums.mysql.com/read.php?11,740308,740308#msg-740308 Can't Start MySQL (no replies) https://forums.mysql.com/read.php?11,740308,740308#msg-740308 Trying to migrate an ACCESS DB to MySQL. I use upper and lower case in naming conventions like fkNameID or FirstName. Since I am on windows I want to change
lower_case_table_names=1 to lower_case_table_names=2 so I can preserve the case.
When I change the value to 2 service.msc give the error that the service is starting and then it stopped. I was going to include a screen shot from the command line but guess pictures aren't allowed.
Here is the text
"
C:\Windows\system32>net start mysql92
The MySQL92 service is starting.
The MySQL92 service could not be started.

The service did not report an error.

More help is available by typing NET HELPMSG 3534.


C:\Windows\system32>NET HELPMSG 3534

The service did not report an error.


C:\Windows\system32>net start mysql92
The MySQL92 service is starting.
The MySQL92 service was started successfully.


C:\Windows\system32>
"

Any insight would be great!
Thanks,
Dale]]> Dale Tabbert Install & Repo Fri, 21 Feb 2025 17:18:07 +0000 https://forums.mysql.com/read.php?11,740151,740151#msg-740151 Moving the MySQL 8.4 LTS database to external drive (MacOS) (no replies) https://forums.mysql.com/read.php?11,740151,740151#msg-740151
In the MySQL Preference Pane, I can stop the server, and in the Configuration tab, specify a new path for the data directory. But when I then apply this and try to start the server, it fails.

I'm wondering if this has something to do with permissions for the new folder. The new folder has me as the owner, instead of _mysql. I have tried to change the owner to _mysql (sudo chown _mysql data), and while I do not get an error, when I then check (ls -l), I am still the owner - it's as if chown didn't work.

Any assistance appreciated. I figure having my email archive in a well-known standard database is pretty good assurance for my being able to retrieve my email in the future.]]> Steve Epstein Install & Repo Fri, 24 Jan 2025 21:41:20 +0000 https://forums.mysql.com/read.php?11,740018,740018#msg-740018 New Install Problem - Please help (1 reply) https://forums.mysql.com/read.php?11,740018,740018#msg-740018
When using MySQL Configurator, at the section of Apply Configuration,

Initializing database (may take a long time) always fails. The relevant part of the log is as follows:

Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 9.1.0...
Starting process with command: C:\Program Files\MySQL\MySQL Server 9.1\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 9.1\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
Process for mysqld, with ID 8924, was run successfully and exited with code -1073741819.
Failed to start process for MySQL Server 9.1.0.
Database initialization failed. ,

this is a New Clean PC but always fails at that stage any idea how to solve this issue?

Thanks]]> Martin Lester Install & Repo Fri, 07 Mar 2025 09:37:36 +0000 https://forums.mysql.com/read.php?11,739857,739857#msg-739857 Multiple Server on one Windows machine (2 replies) https://forums.mysql.com/read.php?11,739857,739857#msg-739857
I wanted to install 2 MySQL servers on one windows machine.
One on port 3306 and the other on 3307.

This also worked with an older version of the MySQL Installer.
But with 8.0.20 if I run it again I can only change the already installed server, but cannot install a new one.

Thank you very much for the information
Thomas]]> Thomas Behrens Install & Repo Fri, 27 Dec 2024 12:42:29 +0000 https://forums.mysql.com/read.php?11,739826,739826#msg-739826 /etc/mysql/mysql.conf.d/ not included in /etc/mysql/my.conf (no replies) https://forums.mysql.com/read.php?11,739826,739826#msg-739826
Why does the installation procedure create this folder if it is not included? This often causes confusion. To whom and how should this omission be reported?

thank you]]> Antonello Alonzi Install & Repo Mon, 16 Dec 2024 14:46:45 +0000 https://forums.mysql.com/read.php?11,732931,732931#msg-732931 Initializing database error (2 replies) https://forums.mysql.com/read.php?11,732931,732931#msg-732931

Beginning configuration step: Initializing database (may take a long time)

Attempting to run MySQL Server with --initialize-insecure option...
Starting process for MySQL Server 9.1.0...
Starting process with command: C:\Users\kfir4\Downloads\mysql-9.1.0-winx64\mysql-9.1.0-winx64\bin\mysqld.exe --defaults-file="C:\ProgramData\MySQL\MySQL Server 9.1\my.ini" --console --initialize-insecure=on --lower-case-table-names=1...
Process for mysqld, with ID 3884, was run successfully and exited with code -1073741819.
Failed to start process for MySQL Server 9.1.0.
Database initialization failed.
Ended configuration step: Initializing database (may take a long time)


When trying to start MYSQL91 process by myself, it stops after a short time of "starting".

My PC specs:
Windows 11 Home, 24h2
ASUS UX430UAR
intel core i5-8250U]]> Kfir Pshititsky Install & Repo Wed, 08 Jan 2025 11:59:09 +0000 https://forums.mysql.com/read.php?11,732742,732742#msg-732742 mysql 5.7.16-10 compatible Linux redhat 8.6? (1 reply) https://forums.mysql.com/read.php?11,732742,732742#msg-732742 OS: Linux redhat 6.8
Mysql 5.7.16-10

We want to upgrade OS from Redhat 6.8 to Redhat 8.6, can we upgrade MYSQL without upgrading?]]> IT System Install & Repo Thu, 21 Nov 2024 14:43:06 +0000 https://forums.mysql.com/read.php?11,726769,726769#msg-726769 unable to start mysqld.service but command line works (11 replies) https://forums.mysql.com/read.php?11,726769,726769#msg-726769

$ journalctl -xeu mysqld.service ░░ Subject: A start job for unit mysqld.service has begun execution
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit mysqld.service has begun execution.
░░
░░ The job identifier is 62403.
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com mysqld[54841]: 2024-10-07T04:18:14.805170Z 0 [System] [MY-015015] [Server] MySQL Server - start.
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com mysqld[54841]: 2024-10-07T04:18:15.677007Z 0 [Warning] [MY-010091] [Server] Can't create test file /us>
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com mysqld[54841]: 2024-10-07T04:18:15.677320Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.>
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com mysqld[54841]: 2024-10-07T04:18:15.690841Z 0 [Warning] [MY-010091] [Server] Can't create test file /us>
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com mysqld[54841]: 2024-10-07T04:18:15.690869Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_n>
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com mysqld[54841]: 2024-10-07T04:18:15.728093Z 0 [ERROR] [MY-010187] [Server] Could not open file '/usr/lo>
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com systemd[1]: mysqld.service: Got notification message from PID 54841, but reception only permitted for >
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com systemd[1]: mysqld.service: Got notification message from PID 54841, but reception only permitted for >
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com mysqld[54839]: 2024-10-07T04:18:15.765776Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemo>
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com systemd[1]: mysqld.service: Got notification message from PID 54841, but reception only permitted for >
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com systemd[1]: mysqld.service: Got notification message from PID 54841, but reception only permitted for >
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com mysqld[54841]: 2024-10-07T04:18:15.729006Z 0 [ERROR] [MY-010119] [Server] Aborting
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com mysqld[54841]: 2024-10-07T04:18:15.795988Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown >
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com mysqld[54841]: 2024-10-07T04:18:15.796016Z 0 [System] [MY-015016] [Server] MySQL Server - end.
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com systemd[1]: mysqld.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ An ExecStart= process belonging to unit mysqld.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com systemd[1]: mysqld.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ The unit mysqld.service has entered the 'failed' state with result 'exit-code'.
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com systemd[1]: Failed to start mysqld.service - MySQL Server Documentation=man:mysqld(8).
░░ Subject: A start job for unit mysqld.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit mysqld.service has finished with a failure.
░░
░░ The job identifier is 62403 and the job result is failed.
Oct 06 21:18:15 jimfedoranew.prestoncomputerservice.com systemd[1]: mysqld.service: Consumed 1.201s CPU time.
░░ Subject: Resources consumed by unit runtime
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ The unit mysqld.service completed and consumed the indicated resources.
lines 674-722/722 (END)


The data directory is owned by mysql, group is mysql, user is member of mysql

Here is mysqld.service:

cat /usr/lib/systemd/system/mysqld.service
[Unit]
Description=MySQL Server Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
user=mysql
group=mysql
# Have mysqld write its state to the systemd notify socket
Type=notify
# Disable service start and stop timeout logic of systemd for mysqld
# service.
TimeoutSec=0
# Start main service
ExecStart=mysqld --defaults-file=/etc/my.cnf
$MYSQLD_OPTS
# Use this to switch malloc implementation
EnvironmentFile=-/etc/sysconfig/mysql
# Sets open_files_limit
LimitNOFILE = 10000 Restart=on-failure RestartPreventExitStatus=1
# Set environment variable MYSQLD_PARENT_PID. This is required for
# restart.
Environment=MYSQLD_PARENT_PID=1
PrivateTmp=false

Here is /etc/my.cnf:

cat /etc/my.cnf
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/8.4/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove the leading "# " to disable binary logging
# Binary logging captures changes between backups and is enabled by
# default. It's default setting is log_bin=binlog
# disable_log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
port=3306
log-error=/usr/local/mysql/data/localhost.err
pid-file=/usr/local/mysql/data/mysqld.pid
user=mysql
secure_file_priv=/usr/local/mysql/mysql-files
local_infile=off

[mysql]
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
port=3306
yet if I log in with root (or su) and run mysqld from command line server runs and writes to the data directory (/usr/local/mysql/data)

$ su
Password:
root# mysqld -u mysql -D
mysqld will log errors to /usr/local/mysql/data/localhost.err
mysqld is running as pid 60011

root# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.4.2 MySQL Community Server - GPL

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Any pointers would be greatly appreciated. I figure it has to be something simple, but I do not want to do a chmod 777 on the data directory just to make systemd happy.]]> James Preston Install & Repo Tue, 05 Nov 2024 23:33:45 +0000 https://forums.mysql.com/read.php?11,726509,726509#msg-726509 8.0.39 not available from 8.036 after RHEL 7 -> 8 upgrade (2 replies) https://forums.mysql.com/read.php?11,726509,726509#msg-726509
Then I upgraded to RHEL 8. dnf info shows 8.0.36 installed but 8.0.39 is no longer available.

Trying to figure out what I am supposed to do with the yum repos. I rpm installed the 8.4 package for el8 but that didn't help.

Generally, what are you supposed to do relative to MySQL repos when you upgrade Red Hat?]]> Jason Perrone Install & Repo Thu, 26 Sep 2024 07:04:54 +0000 https://forums.mysql.com/read.php?11,726473,726473#msg-726473 MySQL error (no replies) https://forums.mysql.com/read.php?11,726473,726473#msg-726473 3:20:48 PM [mysql] This may be due to a blocked port, missing dependencies,
3:20:48 PM [mysql] improper privileges, a crash, or a shutdown by another method.
3:20:48 PM [mysql] Press the Logs button to view error logs and check
3:20:48 PM [mysql] the Windows Event Viewer for more clues
3:20:48 PM [mysql] If you need more help, copy and post this
3:20:48 PM [mysql] entire log window on the forums




2024-09-22 15:05:54 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 21332
2024-09-22 15:05:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-09-22 15:05:54 0 [Note] InnoDB: Uses event mutexes
2024-09-22 15:05:54 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-09-22 15:05:54 0 [Note] InnoDB: Number of pools: 1
2024-09-22 15:05:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-09-22 15:05:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-09-22 15:05:54 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-22 15:05:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-09-22 15:05:54 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-09-22 15:05:54 0 [Note] InnoDB: Setting file 'C:\xampp1\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-09-22 15:05:54 0 [Note] InnoDB: File 'C:\xampp1\mysql\data\ibtmp1' size is now 12 MB.
2024-09-22 15:05:54 0 [Note] InnoDB: Waiting for purge to start
2024-09-22 15:05:54 0 [Note] InnoDB: 10.4.32 started; log sequence number 681714; transaction id 2058
2024-09-22 15:05:54 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp1\mysql\data\ib_buffer_pool
2024-09-22 15:05:54 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-22 15:05:54 0 [Note] InnoDB: Buffer pool(s) load completed at 240922 15:05:54
2024-09-22 15:05:54 0 [Note] Server socket created on IP: '::'.
2024-09-22 15:05:58 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 18732
2024-09-22 15:05:58 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-09-22 15:05:58 0 [Note] InnoDB: Uses event mutexes
2024-09-22 15:05:58 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-09-22 15:05:58 0 [Note] InnoDB: Number of pools: 1
2024-09-22 15:05:58 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-09-22 15:05:58 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-09-22 15:05:58 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-22 15:05:58 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-09-22 15:05:58 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-09-22 15:05:58 0 [Note] InnoDB: Setting file 'C:\xampp1\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-09-22 15:05:58 0 [Note] InnoDB: File 'C:\xampp1\mysql\data\ibtmp1' size is now 12 MB.
2024-09-22 15:05:58 0 [Note] InnoDB: Waiting for purge to start
2024-09-22 15:05:58 0 [Note] InnoDB: 10.4.32 started; log sequence number 681723; transaction id 2058
2024-09-22 15:05:58 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp1\mysql\data\ib_buffer_pool
2024-09-22 15:05:58 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-22 15:05:58 0 [Note] Server socket created on IP: '::'.
2024-09-22 15:07:50 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 22764
2024-09-22 15:07:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-09-22 15:07:50 0 [Note] InnoDB: Uses event mutexes
2024-09-22 15:07:50 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-09-22 15:07:50 0 [Note] InnoDB: Number of pools: 1
2024-09-22 15:07:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-09-22 15:07:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-09-22 15:07:50 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-22 15:07:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-09-22 15:07:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-09-22 15:07:50 0 [Note] InnoDB: Setting file 'C:\xampp1\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-09-22 15:07:50 0 [Note] InnoDB: File 'C:\xampp1\mysql\data\ibtmp1' size is now 12 MB.
2024-09-22 15:07:50 0 [Note] InnoDB: Waiting for purge to start
2024-09-22 15:07:50 0 [Note] InnoDB: 10.4.32 started; log sequence number 681732; transaction id 2058
2024-09-22 15:07:50 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp1\mysql\data\ib_buffer_pool
2024-09-22 15:07:50 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-22 15:07:50 0 [Note] Server socket created on IP: '::'.
2024-09-22 15:10:56 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 23456
2024-09-22 15:10:56 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-09-22 15:10:56 0 [Note] InnoDB: Uses event mutexes
2024-09-22 15:10:56 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-09-22 15:10:56 0 [Note] InnoDB: Number of pools: 1
2024-09-22 15:10:56 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-09-22 15:10:56 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-09-22 15:10:56 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-22 15:10:56 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-09-22 15:10:56 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-09-22 15:10:56 0 [Note] InnoDB: Setting file 'C:\xampp1\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-09-22 15:10:56 0 [Note] InnoDB: File 'C:\xampp1\mysql\data\ibtmp1' size is now 12 MB.
2024-09-22 15:10:56 0 [Note] InnoDB: Waiting for purge to start
2024-09-22 15:10:56 0 [Note] InnoDB: 10.4.32 started; log sequence number 681741; transaction id 2058
2024-09-22 15:10:56 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp1\mysql\data\ib_buffer_pool
2024-09-22 15:10:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-22 15:10:56 0 [Note] Server socket created on IP: '::'.
2024-09-22 15:12:12 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 8816
2024-09-22 15:12:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-09-22 15:12:12 0 [Note] InnoDB: Uses event mutexes
2024-09-22 15:12:12 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-09-22 15:12:12 0 [Note] InnoDB: Number of pools: 1
2024-09-22 15:12:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-09-22 15:12:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-09-22 15:12:12 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-22 15:12:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-09-22 15:12:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-09-22 15:12:13 0 [Note] InnoDB: Setting file 'C:\xampp1\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-09-22 15:12:13 0 [Note] InnoDB: File 'C:\xampp1\mysql\data\ibtmp1' size is now 12 MB.
2024-09-22 15:12:13 0 [Note] InnoDB: Waiting for purge to start
2024-09-22 15:12:13 0 [Note] InnoDB: 10.4.32 started; log sequence number 681750; transaction id 2058
2024-09-22 15:12:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-22 15:12:13 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp1\mysql\data\ib_buffer_pool
2024-09-22 15:12:13 0 [Note] Server socket created on IP: '::'.
2024-09-22 15:20:43 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 16072
2024-09-22 15:20:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-09-22 15:20:43 0 [Note] InnoDB: Uses event mutexes
2024-09-22 15:20:43 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-09-22 15:20:43 0 [Note] InnoDB: Number of pools: 1
2024-09-22 15:20:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-09-22 15:20:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-09-22 15:20:43 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-22 15:20:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-09-22 15:20:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-09-22 15:20:43 0 [Note] InnoDB: Setting file 'C:\xampp1\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-09-22 15:20:43 0 [Note] InnoDB: File 'C:\xampp1\mysql\data\ibtmp1' size is now 12 MB.
2024-09-22 15:20:43 0 [Note] InnoDB: Waiting for purge to start
2024-09-22 15:20:43 0 [Note] InnoDB: 10.4.32 started; log sequence number 681759; transaction id 2058
2024-09-22 15:20:43 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp1\mysql\data\ib_buffer_pool
2024-09-22 15:20:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-22 15:20:43 0 [Note] Server socket created on IP: '::'.
2024-09-22 15:20:46 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 19320
2024-09-22 15:20:46 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-09-22 15:20:46 0 [Note] InnoDB: Uses event mutexes
2024-09-22 15:20:46 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-09-22 15:20:46 0 [Note] InnoDB: Number of pools: 1
2024-09-22 15:20:46 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-09-22 15:20:46 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-09-22 15:20:46 0 [Note] InnoDB: Completed initialization of buffer pool
2024-09-22 15:20:46 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-09-22 15:20:46 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-09-22 15:20:46 0 [Note] InnoDB: Setting file 'C:\xampp1\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-09-22 15:20:46 0 [Note] InnoDB: File 'C:\xampp1\mysql\data\ibtmp1' size is now 12 MB.
2024-09-22 15:20:46 0 [Note] InnoDB: Waiting for purge to start
2024-09-22 15:20:46 0 [Note] InnoDB: 10.4.32 started; log sequence number 681768; transaction id 2058
2024-09-22 15:20:46 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp1\mysql\data\ib_buffer_pool
2024-09-22 15:20:46 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-09-22 15:20:46 0 [Note] Server socket created on IP: '::'.]]> Leonard Peh Install & Repo Sun, 22 Sep 2024 07:29:48 +0000 https://forums.mysql.com/read.php?11,725824,725824#msg-725824 CMake Error at /usr/local/src/mysql-8.4.2/mysys/verify_build_id.cmake:41 (MESSAGE) (3 replies) https://forums.mysql.com/read.php?11,725824,725824#msg-725824
CMake Error at /usr/local/src/mysql-8.4.2/mysys/verify_build_id.cmake:41 (MESSAGE):
Bad build id


make[2]: *** [mysys/CMakeFiles/build_id_test.dir/build.make:115: runtime_output_directory/build_id_test] error 1
make[2]: *** file 'runtime_output_directory/build_id_test'delete
make[1]: *** [CMakeFiles/Makefile2:15017: mysys/CMakeFiles/build_id_test.dir/all] error 2
make: *** [Makefile:166: all] error 2]]> echo bravo Install & Repo Thu, 06 Mar 2025 13:51:11 +0000 https://forums.mysql.com/read.php?11,725759,725759#msg-725759 MySQL Workbench missing from APT and YUM repos (3 replies) https://forums.mysql.com/read.php?11,725759,725759#msg-725759
Is there a reason the package is no longer available in the official repos?]]> David Frischknecht Install & Repo Wed, 28 Aug 2024 21:19:26 +0000 https://forums.mysql.com/read.php?11,725282,725282#msg-725282 Optimizing MySQL Performance for Video Data Management (no replies) https://forums.mysql.com/read.php?11,725282,725282#msg-725282
I'm working on a project that involves managing large video files, and I've been facing performance issues with my MySQL database. The database often slows down significantly during heavy video data processing and retrieval operations, which impacts the overall efficiency of my application.

To improve the quality and manageability of my video content, I started using the Wink video retouching tool. This tool has helped me optimize my videos before storing them in the database, which has slightly alleviated some performance issues.

However, I'm still encountering bottlenecks and slow performance during peak usage times. Has anyone else faced similar challenges with MySQL when dealing with large video files? What optimizations or configurations have you found effective in improving database performance for video data management?

I would appreciate any insights or recommendations you can provide.

Thanks,
Matt]]> Matthew Short Install & Repo Sun, 28 Jul 2024 11:08:17 +0000