Lock wait timeout

[Narasimhan Chengalvarayan]

Hi Team,

 

I am new to TokuDB.  I need a clarification , TokuDB will support row level locking?

If not what steps we have to do  to avoid lock wait timeout errors and dead lock errors.

We are using MySQL 5.5 -TokuDB 7.1.6 .

[jon....@percona.com]

Narasimahan,

TokuDB has row level locking. You can find more information on visualizing locks in tokudb be visiting the troubleshooting section in the documentation here

[Narasimhan Chengalvarayan]

Hi Team,

Thanks for the reply. How temporarary table is working on Tokudb .I can see .frm is being created on disk.

Is there any way option to fix this.

Many Thanks,

--

Regards,

 +91-9739123245

[Narasimhan Chengalvarayan]

Hi Team,

I Have set tmp_table_size and heap table size to 1GB.

I am having text :( column as well.

On Thursday, 5 November 2015 16:40:59 UTC+5:30, Narasimhan Chengalvarayan wrote:

Hi Team,

Thanks for the reply. How temporarary table is working on Tokudb .I can see .frm  , .MYD and .MYI   being created on disk.

Is there any way  to fix this.