explain delete...:
+----+--------------------+--------+------------+------+---------------+------+---------+------+------+----------+-------------+
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
+----+--------------------+--------+------------+------+---------------+------+---------+------+------+----------+-------------+
| 1 | DELETE | table1 | NULL | ALL | NULL | NULL | NULL | NULL | 1179 | 100.00 | Using where |
| 2 | DEPENDENT SUBQUERY | table2 | NULL | ALL | NULL | NULL | NULL | NULL | 4601 | 1.00 | Using where |
+----+--------------------+--------+------------+------+---------------+------+---------+------+------+----------+-------------+
show create table-ben semmit extra, utf8-as InnoDB pár oszloppal.
my.cnf custom része:
innodb_buffer_pool_size = 1G
query_cache_type = 1