We have MyISAM table with 150 million rows. The data is being laoded from other system.
When I load data without indices, it is fast (30 minutes) but creating index is taking
15 hours.
Load data with indices is taking 30 hours (worse than the other option)
I am wondering if there is a way to
Does anyone know what is the meaning of value 'statistics' in state column of show
processlist?
It is displaying this state during a SELECT query.
I noticed lot of them in DB while our application is being run in a stress mode.
This is not documented in Mysql documentation for show processlist