Table Level Lock

Getting a ton of open connections slowing down my server, each with the same entry:

| Query   | xx   | Waiting for table level lock | UPDATE `Profiles` SET `DateLastNav` = NOW() WHERE `ID` = 'xxxxx'

xxxxx is different user ids

Give us some details; what Dolphin version, server details, etc.

When database engine is MyISAM then when table record is updated the whole table is locked. If you have high load website I would suggest to covert all tables into InnoDB, then when record is updated then only record is locked and table continue to functioning.

Also after changing you need to disable FULLTEXT search if it's enabled in Admin Panel > Settings > Advanced Settings > General > "Disable Full-Text Search" is ON 

Thanks!

We increased the time a query has to complete and things have been running smooth since then, but I will look at AlexT's advice as well.

Now we're getting "creating sort index" hangups:

661983 | db524dmdol7 | localhost | db524dmdol7 | Query   | 0    | Creating sort index | SELECT

                        IF(`SenderID` = 67798, `SenderStatus`, `RecipientStatus`) AS `Status` |

| 661987 | db524dmdol7 | localhost | db524dmdol7 | Sleep   | 1    |                     |                                                                                                      |

| 662003 | db524dmdol7 | localhost | db524dmdol7 | Query   | 0    | Creating sort index | SELECT

                        IF(`SenderID` = 47314, `SenderStatus`, `RecipientStatus`) AS `Status` |

| 662017 | db524dmdol7 | localhost | db524dmdol7 | Query   | 0    | Creating sort index | SELECT

                        IF(`SenderID` = 57460, `SenderStatus`, `RecipientStatus`) AS `Status` |

| 662022 | db524dmdol7 | localhost | db524dmdol7 | Sleep   | 0    |                     |                                                                                                      |

| 662026 | db524dmdol7 | localhost | db524dmdol7 | Query   | 0    | Creating sort index | SELECT

                        IF(`SenderID` = 70898, `SenderStatus`, `RecipientStatus`) AS `Status` |

| 662106 | db524dmdol7 | localhost | db524dmdol7 | Sleep   | 20   |                     |                                                                                                      |

| 662153 | db524dmdol7 | localhost | db524dmdol7 | Query   | 0    | statistics          | SELECT

                        IF(`SenderID` = 54883, `SenderStatus`, `RecipientStatus`) AS `Status` |

| 662154 | db524dmdol7 | localhost | db524dmdol7 | Sleep   | 6    |                     |                                                                                                      |

| 662272 | db524dmdol7 | localhost | db524dmdol7 | Sleep   | 0    |                     |                                                                                                      |

| 662315 | db524dmdol7 | localhost | db524dmdol7 | Query   | 0    | Creating sort index | SELECT

                        IF(`SenderID` = 69105, `SenderStatus`, `RecipientStatus`) AS `Status` |

| 662340 | db524dmdol7 | localhost | db524dmdol7 | Query   | 0    | Creating sort index | SELECT

                        `ID`, `Sender`, `Type`

                    FROM

                      |

| 662360 | db524dmdol7 | localhost | db524dmdol7 | Query   | 0    | Creating sort index | SELECT

                        IF(`SenderID` = 75692, `SenderStatus`, `RecipientStatus`) AS `Status` |

| 662363 | db524dmdol7 | localhost | db524dmdol7 | Query   | 0    | Creating sort index | SELECT

                        IF(`SenderID` = 71352, `SenderStatus`, `RecipientStatus`) AS `Status` |

I would suggest to optimize mysql settings, you can use these tools:

- http://mysqltuner.pl script

- phpMyAdmin as root > Status > Advisor