XF 2.1 What is the reason for xf_session_activity becoming full?

[Feanor]

I know the solution for this problem is to truncate the table, but what is the reason it gets full in the first place? I'm seeing about 18,000 rows in the table, which seems to be far more than usual.

 

[Paul B]

Most likely due to a massive influx of bots or other traffic.

Increase the max_heap_table_size value in mysql conf.

 

[Feanor]

Most likely due to a massive influx of bots or other traffic.

Increase the max_heap_table_size value in mysql conf.

I think you're right about a massive amount of bots because most rows in the table had user_id 0.

I see others have suggested (in this thread) to convert the table (and all other tables) to InnoDB. Do you think this would be a better solution than increasing max_heap_table_size?

 

[Paul B]

Changing table types is not something we would recommend.