Hi, Haseena! On Nov 05, Haseena L. wrote: > Hi, > Now Iam trying to migrate from MySQL to MariaDB. > Why does the TRUNCATE TABLE statement hang sometimes? What are the > reasons for this type of issue? > This problem doesn't happen with MySQL, only with MariaDB. > The hanging statement is simply: > TRUNCATE TABLE sampledb.datatable; > What can cause this to happen, and how could I fix it? > Another one observation is if the table have some data, may be one or > two rows, then the truncate query works successfully. Else the table > have a lot of data, query becomes hang. > If the same table have more than one connetion, then the truncate table > query hangs. How I fix it??? Now Iam blocking. Engine I selected is > MyISAM.
What MySQL version you migrate from, and what MariaDB version you migrate to? What does SHOW PROCESSLIST say, what the hanged connection is doing? Regards, Sergei _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
