I have some old software that use MyISAM tables on Mariadb 10.6 When I am checking query digest from pt-query-digest Percona Toolkit, I always see execution time from 100ms. What can be wrong here? Innodb tables show lower time. This…
I'm having troubles with my MySql server. It's used mainly for storing production logs, but unfortunately it seems like it it too slow and i dont know if there is something i could do to improve it.Sometimes there is even…
I have a simple question. I have a mysql databases. I have 2 tables, that uses MYISAM, I want to change to INNODB, one of the table has 1.000 rows, if I do this this change, is there a risk…
The information found in the official MySQL documentation at https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-file-removal.html does not match the information shown in the manual at https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html for version 8. First link says that the 64kb limit was dropped, the 2nd link says it exists. It…
I know that this MariaDB version 5.5.68 is really out of date, but I have to stay with this old version for a while. Is there a way to prevent toxic selects, possibly blocking MyISAM tables for a longer time…
I've seen many threads about this error, but the solutions I've found don't seem to be applicable in my case. I've received a rather large (~150Go) dump file from an Oracle database. I converted it to a MySQL one, using…
I have MyISAM engine running in my cPanel server ,the server does not support InnoDB Engine, i only have MyISAM engine. When i try to create a table column of type timestamp with a default value of (current time +…
My 'invoices' table: CREATE TABLE `invoices` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `invoice_id` int(11) NOT NULL, PRIMARY KEY (`id`,`invoice_id`), UNIQUE KEY `invoice_id` (`invoice_id`), KEY `order_id` (`order_id`) ) ENGINE=MyISAM AUTO_INCREMENT=115 DEFAULT CHARSET=utf8 When I try the query : mysqli_query($conn, "LOCK…
Actually, I would like to switch the engine of my tables. There are in InnoDB and I want to set them to MyISAM because of this ALTER TABLE `xxx_db`.`yyy` ADD FULLTEXT `ft_modele` ( `anno_modele` ) Error : Documentation #1214 -…