# Other MySQL® Questions **URL:** https://forums.percona.com/c/mysql-mariadb/other-mysql-questions/7.md?page=2 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 3 --- ## [Change character set and collation](https://forums.percona.com/t/change-character-set-and-collation/23325)
**Author:** [@Venkat](https://forums.percona.com/u/Venkat)\ **Replies:** 2\ **Last updated:** [July 4, 2023, 8:36pm UTC](https://forums.percona.com/t/change-character-set-and-collation/23325 "2023-07-04T20:36:30Z")
Hello, We are upgrading from MySQL 5.7 to MySQL 8. As part of the process, we would like to change utf8 (utf8mb3) to utt8mb4 collation utf8mb4\_0900\_ai\_ci. There are two ways to do it: ALTER TABLE \ CONVERT … --- ## [What are various MySQL 8.6+ Cluster options/products with least change in DB schema](https://forums.percona.com/t/what-are-various-mysql-8-6-cluster-options-products-with-least-change-in-db-schema/23289)
**Author:** [@surinder\_singh](https://forums.percona.com/u/surinder_singh)\ **Replies:** 1\ **Last updated:** [July 3, 2023, 3:05pm UTC](https://forums.percona.com/t/what-are-various-mysql-8-6-cluster-options-products-with-least-change-in-db-schema/23289 "2023-07-03T15:05:16Z")
What are various MySQL 8 Cluster options/products with least change in DB schema? If someone can give a pointer to comparison done from aspect of minimum DB schema changes and ease of maintaining with max stability --- ## [MySQL showing randomly poor performance with nested loop antijoin](https://forums.percona.com/t/mysql-showing-randomly-poor-performance-with-nested-loop-antijoin/22604)
**Author:** [@Agniva\_De\_Sarker](https://forums.percona.com/u/Agniva_De_Sarker)\ **Replies:** 4\ **Last updated:** [June 30, 2023, 4:27am UTC](https://forums.percona.com/t/mysql-showing-randomly-poor-performance-with-nested-loop-antijoin/22604 "2023-06-30T04:27:45Z")
I have a very simple query which is randomly performing poorly in production. I have the EXPLAIN ANALYZE outputs for both the good case and the bad case. MySQL version is 8.0.31. This is the query: SELECT COUNT(disti… --- ## [Audit log can't log 'db' information](https://forums.percona.com/t/audit-log-cant-log-db-information/22659)
**Author:** [@spihiker](https://forums.percona.com/u/spihiker)\ **Replies:** 3\ **Last updated:** [June 9, 2023, 1:54am UTC](https://forums.percona.com/t/audit-log-cant-log-db-information/22659 "2023-06-09T01:54:04Z")
Hi: After install audit\_log plugin,all work well but database information can’t log. thanks for you help. eg: {“audit\_record”:{“name”:“Query”,“record”:“4894\_2023-06-08T06:38:10”,“timestamp”:“2023-06-08T07:04:53Z”,“co… --- ## [Mysql is not using Index](https://forums.percona.com/t/mysql-is-not-using-index/22044)
**Author:** [@Andre1976](https://forums.percona.com/u/Andre1976)\ **Replies:** 6\ **Last updated:** [May 16, 2023, 6:39am UTC](https://forums.percona.com/t/mysql-is-not-using-index/22044 "2023-05-16T06:39:07Z")
Hello Guys I have a mysql 5.7 performing almost ( Full Table scan ) on the select below. So, I have a question. If I have the indexes below why have I getting full table scan on table cp\_rawcdr ? Shoud I create comp… --- ## [Audit plugin - audit\_log\_policy=query for some users but login for all users - possible?](https://forums.percona.com/t/audit-plugin-audit-log-policy-query-for-some-users-but-login-for-all-users-possible/21368)
**Author:** [@darren](https://forums.percona.com/u/darren)\ **Replies:** 5\ **Last updated:** [April 13, 2023, 7:12pm UTC](https://forums.percona.com/t/audit-plugin-audit-log-policy-query-for-some-users-but-login-for-all-users-possible/21368 "2023-04-13T19:12:39Z")
Hi, I am interested in figuring out a way to log all connection attempts for all users but only queries from users not in the audit\_log\_exclude\_accounts list. Would that be at all possible? cheers Darren --- ## [Enterprise MySQL to Percona MySQL](https://forums.percona.com/t/enterprise-mysql-to-percona-mysql/20329)
**Author:** [@micheal\_bollinger](https://forums.percona.com/u/micheal_bollinger)\ **Replies:** 5\ **Last updated:** [April 5, 2023, 4:21pm UTC](https://forums.percona.com/t/enterprise-mysql-to-percona-mysql/20329 "2023-04-05T16:21:52Z")
Hi Team, We are thinking of migrate MySQL Enterprise to Percona. Trying to find some blog about pros and cons but don’t see any.Can some one look into this. Thanks Michael --- ## [Interpreting mysql EXPLAIN ANALYZE](https://forums.percona.com/t/interpreting-mysql-explain-analyze/20675)
**Author:** [@Sreeni](https://forums.percona.com/u/Sreeni)\ **Replies:** 1\ **Last updated:** [March 17, 2023, 2:43pm UTC](https://forums.percona.com/t/interpreting-mysql-explain-analyze/20675 "2023-03-17T14:43:27Z")
Would like to have a complete explanation of the below output from EXPLAIN ANALYZE: -\> Sort row IDs: users.userid (actual time=32773.650..32801.255 rows=7747 loops=1) -\> Table scan on \ (cost=0.00..0.50… --- ## [Last\_IO\_Error: Got fatal error 1236](https://forums.percona.com/t/last-io-error-got-fatal-error-1236/2782)
**Author:** [@systemali](https://forums.percona.com/u/systemali)\ **Replies:** 10\ **Last updated:** [March 17, 2023, 5:49am UTC](https://forums.percona.com/t/last-io-error-got-fatal-error-1236/2782 "2023-03-17T05:49:26Z")
Hello Everyone, My ‘master’ and the ‘replication’ server both restarted yesterday because of power outage. Now after the things coming back to normal, My ‘replication’ server is not able to connect to the master and wh… --- ## [Error 1025 (errno -1 unknown error -1) on Alter Table Command](https://forums.percona.com/t/error-1025-errno-1-unknown-error-1-on-alter-table-command/4247)
**Author:** [@paacharon3](https://forums.percona.com/u/paacharon3)\ **Replies:** 7\ **Last updated:** [March 17, 2023, 5:46am UTC](https://forums.percona.com/t/error-1025-errno-1-unknown-error-1-on-alter-table-command/4247 "2023-03-17T05:46:25Z")
Hi, I’ve been trying to alter a Table named import\_permit, adding about 12 new columns for it, using the alter statements: ALTER TABLE eips2live.import\_permit ADD \`closed\_by\_id\` bigint(20) DEFAULT NULL; ALTER TABLE eip… --- ## [The Tar ball names are not unification](https://forums.percona.com/t/the-tar-ball-names-are-not-unification/20168)
**Author:** [@azuryy](https://forums.percona.com/u/azuryy)\ **Replies:** 1\ **Last updated:** [February 18, 2023, 6:11pm UTC](https://forums.percona.com/t/the-tar-ball-names-are-not-unification/20168 "2023-02-18T18:11:32Z")
There are name difference of Percona software family. such as Percona-Server-8.0.27-18-Linux.x86\_64.glibc2.17-xxxxx.tar.gz Percona-XtraDB-Cluster\_8.0.30-22.1\_Linux.x86\_64.glibc2.17-xxxx.tar.gz There are all start wit… --- ## [Copy Back Database with new name?](https://forums.percona.com/t/copy-back-database-with-new-name/20021)
**Author:** [@dillip](https://forums.percona.com/u/dillip)\ **Replies:** 10\ **Last updated:** [February 16, 2023, 10:54am UTC](https://forums.percona.com/t/copy-back-database-with-new-name/20021 "2023-02-16T10:54:50Z")
Hi, I have a backup of a database, called ‘test\_db\`, and would like to restore it on the same server but under a different database name. If I have a DB test\_db i need to create a replication of it with a new name test… --- ## [Unable to get query in Query Analytics (MYSQL) taking time more than 5min](https://forums.percona.com/t/unable-to-get-query-in-query-analytics-mysql-taking-time-more-than-5min/18706)
**Author:** [@sawan\_singh](https://forums.percona.com/u/sawan_singh)\ **Replies:** 4\ **Last updated:** [January 6, 2023, 12:50pm UTC](https://forums.percona.com/t/unable-to-get-query-in-query-analytics-mysql-taking-time-more-than-5min/18706 "2023-01-06T12:50:27Z")
Hi, I am unable to get few query in Query Analytics. I have created a script which calculates the bad query and in results gives the querry taking more than 5 minutes, but in PMM those query were supposed to be QAN. I wa… --- ## [Replication to slave stops with "Error: Duplicate entry"](https://forums.percona.com/t/replication-to-slave-stops-with-error-duplicate-entry/1163)
**Author:** [@paulchoi](https://forums.percona.com/u/paulchoi)\ **Replies:** 0\ **Last updated:** [May 1, 2009, 12:07pm UTC](https://forums.percona.com/t/replication-to-slave-stops-with-error-duplicate-entry/1163 "2009-05-01T12:07:00Z")
Replication to the slave keeps on failing. Even if I delete the conflicted entry on the slave and issue START SLAVE, the error pops up after a few seconds. The slave is not being used for anything right now, not even fo… --- ## [Replication stuck: Relay\_Log\_Pos not increasing](https://forums.percona.com/t/replication-stuck-relay-log-pos-not-increasing/18776)
**Author:** [@larryschul](https://forums.percona.com/u/larryschul)\ **Replies:** 9\ **Last updated:** [November 28, 2022, 10:23pm UTC](https://forums.percona.com/t/replication-stuck-relay-log-pos-not-increasing/18776 "2022-11-28T22:23:24Z")
about 2 days ago relay\_log\_pos stopped increasing. i have 2 read replicas and both stopped at the same place… Relay\_Log\_Pos: 826986907 looking at a show replica status i am seeing this Source\_Log\_File: binlog.0… --- ## [Converting json timestamp to different timezone](https://forums.percona.com/t/converting-json-timestamp-to-different-timezone/18460)
**Author:** [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Replies:** 2\ **Last updated:** [November 9, 2022, 6:17pm UTC](https://forums.percona.com/t/converting-json-timestamp-to-different-timezone/18460 "2022-11-09T18:17:31Z")
I am trying to convert a json timestamp to a different timezone. if i put the literal date it works fine but returns a null when i use a json\_extract nested inside the convert\_tz. Is it possible to nest the json\_extrac… --- ## [InnoDB Tools updated version available?](https://forums.percona.com/t/innodb-tools-updated-version-available/18344)
**Author:** [@Ben\_Gladstone](https://forums.percona.com/u/Ben_Gladstone)\ **Replies:** 0\ **Last updated:** [November 3, 2022, 6:56am UTC](https://forums.percona.com/t/innodb-tools-updated-version-available/18344 "2022-11-03T06:56:46Z")
Is there an updated version of InnoDB tools to parse innodb files? Specifically constraints\_parser? I’m trying to use the older innodb tools on an ibdata file created with mariadb 10.6, and since the innodb tools is from… --- ## [MySQL- InnoDB Inefficient Memory Allocation - Percona Server](https://forums.percona.com/t/mysql-innodb-inefficient-memory-allocation-percona-server/18031)
**Author:** [@vasanths20](https://forums.percona.com/u/vasanths20)\ **Replies:** 3\ **Last updated:** [October 17, 2022, 3:49pm UTC](https://forums.percona.com/t/mysql-innodb-inefficient-memory-allocation-percona-server/18031 "2022-10-17T15:49:30Z")
Greetings team. Below is how InnoDB allocates memory in the data dictionary. However, upon changing the order of allocation, this memory can be hugely reduced. This is explained in detail below. In Percona Server, have y… --- ## [Sync\_binlog=0 on a replication slave](https://forums.percona.com/t/sync-binlog-0-on-a-replication-slave/17712)
**Author:** [@larryschul](https://forums.percona.com/u/larryschul)\ **Replies:** 6\ **Last updated:** [October 4, 2022, 5:39pm UTC](https://forums.percona.com/t/sync-binlog-0-on-a-replication-slave/17712 "2022-10-04T17:39:10Z")
Hi I have been troubleshooting replication lag on a mysql8 server… setting sync\_binlog=0 HELPED… at lot… but i am kinda scared of doing this… i have found a ton of articles talking about why not to do this on a stand… --- ## [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)](https://forums.percona.com/t/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock-2/6215)
**Author:** [@petter5](https://forums.percona.com/u/petter5)\ **Replies:** 3\ **Last updated:** [October 2, 2022, 10:25pm UTC](https://forums.percona.com/t/cant-connect-to-local-mysql-server-through-socket-var-lib-mysql-mysql-sock-2/6215 "2022-10-02T22:25:18Z")
I’m trying to login to my percona installation to add a new database. - Ubuntu 16.04. The system is running fine, and my current website seems to work fine so the problem is to login from termian using mysql --host=local… --- ## [MySQL instrumentation unit mystery](https://forums.percona.com/t/mysql-instrumentation-unit-mystery/17770)
**Author:** [@Venkatesh\_Naicker](https://forums.percona.com/u/Venkatesh_Naicker)\ **Replies:** 2\ **Last updated:** [September 30, 2022, 4:20pm UTC](https://forums.percona.com/t/mysql-instrumentation-unit-mystery/17770 "2022-09-30T16:20:23Z")
I read MySQL manual and here is what I see on our system: select \* from performance\_schema.setup\_timers; ±------------±------------+ | NAME | TIMER\_NAME | ±------------±------------+ | idle | MICROSEC… --- ## [Out of memory error and duplicate entry error (in error log)](https://forums.percona.com/t/out-of-memory-error-and-duplicate-entry-error-in-error-log/446)
**Author:** [@JGilbert](https://forums.percona.com/u/JGilbert)\ **Replies:** 2\ **Last updated:** [September 29, 2022, 6:53am UTC](https://forums.percona.com/t/out-of-memory-error-and-duplicate-entry-error-in-error-log/446 "2022-09-29T06:53:00Z")
(root)\>cat mysql-err.log 070911 14:29:12 InnoDB: Started; log sequence number 88 3327321420 /usr/sbin/mysqld: Out of memory (Needed 950109184 bytes) /usr/sbin/mysqld: Out of memory (Needed 712581120 bytes) /usr/sbin/… --- ## [MySQL 5 cannot allocate memory](https://forums.percona.com/t/mysql-5-cannot-allocate-memory/1576)
**Author:** [@Bono](https://forums.percona.com/u/Bono)\ **Replies:** 9\ **Last updated:** [September 29, 2022, 6:35am UTC](https://forums.percona.com/t/mysql-5-cannot-allocate-memory/1576 "2022-09-29T06:35:02Z")
Hi, i’m running 32bit RedHat version 5 and after long uptime I always ran in problems with RedHat, I never had such problems with Debian which I normally use. Long uptime: 00:10:01 up 347 days, 21:33, 1 user, load aver… --- ## [Audit plugin excluded accounts still being logged](https://forums.percona.com/t/audit-plugin-excluded-accounts-still-being-logged/17596)
**Author:** [@Hamza\_Fareed](https://forums.percona.com/u/Hamza_Fareed)\ **Replies:** 1\ **Last updated:** [September 26, 2022, 1:13pm UTC](https://forums.percona.com/t/audit-plugin-excluded-accounts-still-being-logged/17596 "2022-09-26T13:13:43Z")
Hi, I am having issues excluding users from Percona’s audit plugin. Users are added to my.cnf via the audit\_log\_exclude\_accounts system variable but still show in the audit log. audit\_log\_policy=ALL audit\_log\_format=J… --- ## [Mysql Database performance issue](https://forums.percona.com/t/mysql-database-performance-issue/12772)
**Author:** [@pkelaska](https://forums.percona.com/u/pkelaska)\ **Replies:** 4\ **Last updated:** [September 22, 2022, 5:00am UTC](https://forums.percona.com/t/mysql-database-performance-issue/12772 "2022-09-22T05:00:43Z")
Hello, A month ago (on September 28th), we migrated an application to AWS. Our previous environment was run with a MySQL 5.6 database. We have several database issues on which we would like your support: Much longe… --- ## [Percona monitoring and management not showing query from databases](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276)
**Author:** [@joseph\_lama](https://forums.percona.com/u/joseph_lama)\ **Replies:** 8\ **Last updated:** [September 21, 2022, 12:16pm UTC](https://forums.percona.com/t/percona-monitoring-and-management-not-showing-query-from-databases/17276 "2022-09-21T12:16:05Z")
I have set up pmm-server in docker , and pmm2 agent from apt repositories , pmm agent is running at the background but the database queries from the applicatoin are not being displayed in the query analytics of percona m… --- ## [Install Percona on KUbuntu Desktop?](https://forums.percona.com/t/install-percona-on-kubuntu-desktop/1677)
**Author:** [@dlsniper](https://forums.percona.com/u/dlsniper)\ **Replies:** 3\ **Last updated:** [September 21, 2022, 9:04am UTC](https://forums.percona.com/t/install-percona-on-kubuntu-desktop/1677 "2022-09-21T09:04:20Z")
Hello, I’m trying to install Percona 5.5 on a KUbuntu Desktop machine? I’ve tried installing it like installing it on a server, adding the repo to /etc/apt/sources.list but when doing: apt-get install percona-server-ser… --- ## [Does pt-table-checksum require replication to be setup?](https://forums.percona.com/t/does-pt-table-checksum-require-replication-to-be-setup/17420)
**Author:** [@Fiyin\_Lamidi](https://forums.percona.com/u/Fiyin_Lamidi)\ **Replies:** 6\ **Last updated:** [September 14, 2022, 8:19pm UTC](https://forums.percona.com/t/does-pt-table-checksum-require-replication-to-be-setup/17420 "2022-09-14T20:19:09Z")
I have a use case where 2 identical mysql servers with similar schemas need to be checksummed, like a dev and stage environment. There is no replication setup between both servers, does dsns work without replication and … --- ## [PMM tool open table and open cache miss ratio tune](https://forums.percona.com/t/pmm-tool-open-table-and-open-cache-miss-ratio-tune/17243)
**Author:** [@Pavanmysql](https://forums.percona.com/u/Pavanmysql)\ **Replies:** 1\ **Last updated:** [September 1, 2022, 3:52pm UTC](https://forums.percona.com/t/pmm-tool-open-table-and-open-cache-miss-ratio-tune/17243 "2022-09-01T15:52:32Z")
Hi Percona Team, Does i need to tune any MySQL related parameter as PMM shows below graph in red color (Percentage of open table definitions to table definition cache and open cache miss ratio)? How to tune this? … --- ## [MySQL Router - Active Connections not getting cleaned up/removed](https://forums.percona.com/t/mysql-router-active-connections-not-getting-cleaned-up-removed/17070)
**Author:** [@devdewboy](https://forums.percona.com/u/devdewboy)\ **Replies:** 0\ **Last updated:** [August 17, 2022, 8:28pm UTC](https://forums.percona.com/t/mysql-router-active-connections-not-getting-cleaned-up-removed/17070 "2022-08-17T20:28:07Z")
Hello. MySQL Routers (MR) are on a VM, load balanced and traffic routed to the physical DB Servers. On a MR, I have Active Connections that keep increasing and don’t get cleaned up. I eventually have to restart the rou… [Previous page](https://forums.percona.com/c/mysql-mariadb/other-mysql-questions/7.md?page=1) [Next page](https://forums.percona.com/c/mysql-mariadb/other-mysql-questions/7.md?page=3)