Search only postmeta

Look log in database:

| 4075156 | db_name | server_name | db_name | Query | 22316 | statistics | SELECT SQL_CALC_FOUND_ROWS bodb_posts.*, wpftsi_t.relev FROM bodb_posts LEFT JOIN bodb_term_relat | 0 | 0 |
| 4075478 | m1418_usrsbacego | server_name | m1418_sbacegodbnew | Sleep | 327 | | NULL
i blokowane przez to tabele, np:
| 4267803 | db_name | server_name | db_name | Query | 7919 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs
| 0 | 0 |
| 4267999 | db_name | server_name | db_name | Query | 7903 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs
| 0 | 0 |
| 4268449 | db_name | server_name | db_name | Query | 7866 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs
| 0 | 0 |
| 4268497 | db_name | server_name | db_name | Query | 7859 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs
| 0 | 0 |
| 4268935 | db_name | server_name | db_name | Query | 7823 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs
| 0 | 0 |
| 4269855 | db_name | server_name | db_name | Query | 7758 | Waiting for table metadata lock | delete from wpftsi_vectors, wpftsi_docs using wpftsi_vectors
inner join wpftsi_docs

@bolus150 Okay, as I can see, the reason can be because you have very large values for interactive_timeout and wait_timeout.

Could you please read this topic and try to set up these values smaller (for example 10 seconds) to see whether this fixes an issue or not.

If this will be successful, I will add the solution directly to WPFTS.

Hi, my host does not allow setting such values. Do you have another idea?

Do you have any idea to solve this?

Hello, @bolus150

I have the idea, we could try to change these values for the current MySQL connection, using PHP script. I hope your provider allows this.

May you send me your email to [email protected] so I can send you a modified version of WPFTS to check?

Of course, [email protected]