Re: partitioning of a table

[Rick James]

PARTITIONing will _not_ speed up INSERTs.

Let's see SHOW CREATE TABLE for tblghdeb and tblart. If they don't have suitable indexes, then that would explain sluggish INSERTs.

Are there lengthy SELECTs/UPDATEs/DELETEs happening when the INSERTs are slow??

Otherwise, there is no good reason for INSERT to take more than a fraction of a second. How long is it taking.

> `debart_week` int(10) DEFAULT '0',
Consider TINYINT UNSIGNED; consider NOT NULL.

> `debart_jaar` int(10) DEFAULT '0',
Consider YEAR; consider NOT NULL.

What is the value if innodb_buffer_pool_size? It should be 70% of available RAM.

Are the INSERTs inside a transaction?

Do you do multiple INSERTs at the "same time"?

> Each week i insert 25000 rows

If you had said "Each _minute_", then there would be a serious performance concern. Even "Each _hour_" should not be a problem.

> And to run queries.

Let's see the queries that are slow. For SELECTs, provide us with EXPLAIN SELECT ...;

Also, provide
SHOW VARIABLES LIKE 'query_cache%';