Truncate stream_logs hanging on execute

[ahabib]

Hello Guys

I have try this:

mysql -u root -p'' -h localhost xtream_iptvpro -e "truncate table \`xtream_iptvpro\`.\`stream_logs\`"

also this:

mysql -u root -e "truncate table xtream_iptvpro.stream_logs;"

but the truncate execution only hanging out, and i have wait more than 10min nothing happen.

I think it is too big data to truncate.

this is the data:

stream_logs InnoDB 30442806 7857504256 957399040


any idea or workaround?

 

[chamekh]

restart mysql and problem will be resolved

 

[urgodfather]

1) Please learn to use BBcodes.
2)The first one is requesting password
3)The second one, no need to specify user if on Ubuntu 18

 

[ahabib]

Hello

@urgodfather
the other works with this command without any issues:

mysql -u root -e "truncate table xtream_iptvpro.client_logs;"

mysql -u root -e "truncate table xtream_iptvpro.user_activity;"

 

[ahabib]

@chamekh

Thanks a restart has work