table getting locked

hi

really need help urgently the folowing query runs on mysql server and locks up the whole site. Please tell me what it is and how I can fix it. Please

SELECT\t`sys_acl_levels_members`.IDLevel as ID,\n\t\t\t\t`sys_acl_levels`.Name as Name,\n\t\t\t\tUNIX_TIMESTAMP

thank

Quote · 19 Jun 2010

increase your execution time for a sql query to run would be a place to start. where is this hosted? what are the specs on the machine? basically you need to tune your machine to run dolphin if you are locking up on a simple query.

hi

really need help urgently the folowing query runs on mysql server and locks up the whole site. Please tell me what it is and how I can fix it. Please

SELECT\t`sys_acl_levels_members`.IDLevel as ID,\n\t\t\t\t`sys_acl_levels`.Name as Name,\n\t\t\t\tUNIX_TIMESTAMP

thank

Regards,

DosDawg

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 19 Jun 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.