[MDEV-30512] mysqldump.exe not working with 'innodb_flush_method=unbuffered' Created: 2023-01-30 Updated: 2023-01-31 Resolved: 2023-01-30 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Scripts & Clients |
| Affects Version/s: | 10.7.7 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Mitchell Lee | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Windows 11 22H2 |
||
| Issue Links: |
|
||||||||
| Description |
|
C:\Program Files\MariaDB\bin\mysqldump.exe: unknown variable 'innodb_flush_method=unbuffered' Fix it. -------------- |
| Comments |
| Comment by Daniel Black [ 2023-01-30 ] | ||
|
While Mariabackup will take several innodb variables because it directly interacts with the database files directly, mysqldump.exe/mariadb-dump.exe purely interacts with the server via SQL and as such doesn't support any storage engine variables. All mysqldump.exe interactions with the server rely on the server settings. | ||
| Comment by Mitchell Lee [ 2023-01-31 ] | ||
|
Now understand the behavior why the messages occured, | ||
| Comment by Daniel Black [ 2023-01-31 ] | ||
|
Hi Sir, Ignoring incorrect options would be inconsistent with the existing handling of options server wide. An error provides the ability to correct a misspelling or understand why the option isn't there. If an ignore is required there is the --loose prefix that can apply to any option. This will produce an ignored warning like:
I see you've had a series of fairly serious bugs you have reported (much appreciated). As a former DBA I empathize with the pain this has caused. I apologize if my standard of prompt responses falls short of your standards. I suspect the commercial support offering have staff that will offer a attitude you find more agreeable. I am trying to improve the quality with bug fixes (like | ||
| Comment by Mitchell Lee [ 2023-01-31 ] | ||
|
Appreciate for the reply. Truly. |