Can you give me some kind of guide for import old version mysql db to the latest instance?

Memory per connection & 5k user how connection works?

You have only 150 connections at maximum now configured.

Yes but how innodb buffer pool size distributed for connections/users?

no it is common for allusers

if i increase innodb buffer 14GB will it helpful ??

no

In this scenario query take long time to load report? Which parameter i have to check??

you should check query plan first of all

Ok

I have multiple database in mysql with 8GB + 8GB both are running then innodb buffer used for both database??

MySQL can only run ONE database.

Two and more databases are not possible

Excuse me, what do you call “database” there?

these are schemes, all they use one same database, one same buffer pool

PG supports multi ))

But doesn’t support 4-byte charset encoding inside varchars )))

Ok then i have to calculate size of all schema & increase buffer pool size?

Hello I need help, with this error, I am trying to implement a module in a call server: this query: CREATE TRIGGER add_sip_routing AFTER INSERT ON sip_devices FOR EACH ROW BEGIN INSERT INTO sip_device_routing (sip_device_id) VALUES (NEW.id); END; D;

Don’t you need to redefine delimiter

Here I show you the complete error that the platform gives me when I try to install that module specifically:
Copying file to web directories …
Copy process completed for web directories !!

Copying file for freeswitch CDR …
Copy process completed for freeswitch CDR directories !!

Copying file for freeswitch call scripts …
Copy process completed for freeswitch directories !!

Importing database queries …
Error Code: 1359
Error Message: Trigger already exists
Error in this query: CREATE TRIGGER add_sip_routing AFTER INSERT ON` sip_devices` FOR EACH ROW BEGIN INSERT INTO sip_device_routing (sip_device_id) VALUES (NEW.id); END
Back

Trigger already exists

Have you tried to change name?

exact, but I already connect in bd delete the tregger and follow the same problem.

Have you commited?

yes

How did you delete trigger?

https://dev.mysql.com/doc/refman/8.0/en/faqs-triggers.html

What do you see here INFORMATION_SCHEMA.TRIGGERS ???

Drop your trigger before creation

mysql -Nse ‘show tables’ DATABASE_NAME | while read table; do mysql -e “truncate table $table” DATABASE_NAME; done

Only one by one

https://www.youtube.com/watch?v=efi7ZVy2fXs&ab_channel=MugheesAhmed

Hello. Can you give me some kind of guide for import old version mysql db to the latest instance?