# Can't see prepared queries in percona monitoring query analytics with MariaDB **URL:** \ **Category:** PMM 2.x\ **Created:** [May 23, 2023, 9:02pm UTC](https://forums.percona.com/t/cant-see-prepared-queries-in-percona-monitoring-query-analytics-with-mariadb/22268 "2023-05-23T21:02:23Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![DarkGL](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/darkgl/32/10718_2.png) [@DarkGL](https://forums.percona.com/u/DarkGL)\ **Post date:** [May 23, 2023, 9:02pm UTC](https://forums.percona.com/t/cant-see-prepared-queries-in-percona-monitoring-query-analytics-with-mariadb/22268/1 "2023-05-23T21:02:23Z")
I am currently experiencing an issue with the visibility of prepared queries in my query analytics tool for an application using the nodejs mysql2 library and MariaDB. Application is using the execute method for performing queries. All these operations are working perfectly fine. However, these prepared queries are not visible in percona query analytics. Performance schema in MariaDB is enabled. MariaDB configuration ```auto performance_schema=ON performance_schema_instrument='statement/%=ON' performance_schema_instrument='wait/%=ON' performance_schema_instrument='memory/%=ON' performance-schema-instrument='stage/%=ON' performance-schema-consumer-statements-digest=ON performance-schema-consumer-events_stages_current=ON performance-schema-consumer-events_stages_history=ON performance-schema-consumer-events_stages_history_long=ON performance_schema_consumer_events_statements_current=ON performance_schema_consumer_events_statements_history=ON performance_schema_consumer_events_statements_history_long=ON performance-schema-consumer-events_transactions_current=ON performance-schema-consumer-events_transactions_history=ON performance-schema-consumer-events_transactions_history_long=ON performance-schema-consumer-events_waits_current=ON performance-schema-consumer-events_waits_history=ON performance-schema-consumer-events_waits_history_long=ON innodb_monitor_enable=all userstat=1 ``` I know this is too much but I was just trying everything to make it work. Mysql2 example query: ```auto const pool = mysql.createPool({ host: 'localhost', user: 'root', database: 'test' }); pool.execute( 'SELECT * FROM `table` WHERE `name` = ? AND `age` > ?', ['Rick C-137', 53], function(err, results, fields) { } ); ``` NodeJS Version: 20.2.0 Mysql2 Version: 3.3.1 MariaDB Version: 10.11.2 ---
**Author:** ![Roma\_Novikov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roma_novikov/32/1161_2.png) [@Roma\_Novikov](https://forums.percona.com/u/Roma_Novikov)\ **Post date:** [May 24, 2023, 7:26am UTC](https://forums.percona.com/t/cant-see-prepared-queries-in-percona-monitoring-query-analytics-with-mariadb/22268/2 "2023-05-24T07:26:38Z")
Hello @DarkGL! I appreciate your interest in PMM. Unfortunately, per [[PMM-6578] Prepared statements support in PMM - Percona JIRA](https://jira.percona.com/browse/PMM-6578), prepared statements support in PMM hasn’t been implemented yet. ---
**Author:** ![Spinner97](https://avatars.discourse-cdn.com/v4/letter/s/439d5e/32.png) [@Spinner97](https://forums.percona.com/u/Spinner97)\ **Post date:** [July 26, 2023, 7:36am UTC](https://forums.percona.com/t/cant-see-prepared-queries-in-percona-monitoring-query-analytics-with-mariadb/22268/3 "2023-07-26T07:36:18Z")
Hello @Roma_Novikov and @DarkGL, I’m encountering the same issue with Percona Server mySQL Database receiving queries from Gorm (Go applications). Is there any update or any workaround to make it work in PMM? I cannot use the slow query log since the Percona Server is in a docker container ---
**Author:** ![DarkGL](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/darkgl/32/10718_2.png) [@DarkGL](https://forums.percona.com/u/DarkGL)\ **Post date:** [July 26, 2023, 2:53pm UTC](https://forums.percona.com/t/cant-see-prepared-queries-in-percona-monitoring-query-analytics-with-mariadb/22268/4 "2023-07-26T14:53:50Z")
I don’t think anything is happening. Status of the task on Jira is currently on hold. [[PMM-6578] Prepared statements support in PMM - Percona JIRA](https://jira.percona.com/browse/PMM-6578) ---
**Author:** ![Spinner97](https://avatars.discourse-cdn.com/v4/letter/s/439d5e/32.png) [@Spinner97](https://forums.percona.com/u/Spinner97)\ **Post date:** [July 27, 2023, 6:57am UTC](https://forums.percona.com/t/cant-see-prepared-queries-in-percona-monitoring-query-analytics-with-mariadb/22268/5 "2023-07-27T06:57:44Z")
Thanks @DarkGL, did you find any workaround for your need? I’m afraid I may have to instrument the application instead ---
**Author:** ![DarkGL](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/darkgl/32/10718_2.png) [@DarkGL](https://forums.percona.com/u/DarkGL)\ **Post date:** [July 27, 2023, 7:35am UTC](https://forums.percona.com/t/cant-see-prepared-queries-in-percona-monitoring-query-analytics-with-mariadb/22268/6 "2023-07-27T07:35:22Z")
Unfortunately, I didn’t find anything ☹ ---
**Author:** ![Spinner97](https://avatars.discourse-cdn.com/v4/letter/s/439d5e/32.png) [@Spinner97](https://forums.percona.com/u/Spinner97)\ **Post date:** [July 27, 2023, 7:37am UTC](https://forums.percona.com/t/cant-see-prepared-queries-in-percona-monitoring-query-analytics-with-mariadb/22268/7 "2023-07-27T07:37:51Z")
That’s sad ☹ It seems that no database monitoring tool is able to work with prepared statements in that way ---
**Author:** ![DarkGL](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/darkgl/32/10718_2.png) [@DarkGL](https://forums.percona.com/u/DarkGL)\ **Post date:** [August 7, 2023, 10:06am UTC](https://forums.percona.com/t/cant-see-prepared-queries-in-percona-monitoring-query-analytics-with-mariadb/22268/8 "2023-08-07T10:06:02Z")
I would suggest upvoting issues here [Issue Navigator - Percona JIRA](https://jira.percona.com/browse/PMM-7237?jql=labels%20%3D%20%22qan-survey%2Fprepared-statements%22)