Re: MySQL hang after select count()

After I replace with this DDL mysql back normaly, the load average 13 if i change max_connection=150 and table_cache=96 using the second DDL. mysqler expert please analyze this, i would know why. the query just result total of record: 1st query: +--+ | COUNT(*) | +--+ |350

Re: MySQL hang after select count()

Hi. Please post the result of EXPLAIN for the two queries. Bye, Benjamin. On Wed, Nov 28, 2001 at 12:50:21PM +0700, [EMAIL PROTECTED] wrote: > I dont understand mysql eat system 13 load average after that mysql hang while > runing query via web using DBD-Mysql and DBI. > Everyone help

Re: MySQL hang after select count()

its took a long time. --process list-- +-+-+---+-+-+--+---+- -+ | Id | User| Host | db | Command | Time | State |

MySQL hang after select count()

I dont understand mysql eat system 13 load average after that mysql hang while runing query via web using DBD-Mysql and DBI. Everyone help me for your experience how to tuning mysql for this solution. Thanks -Abu- kernel-2.4.9-6 on rh 7.1 mysql-3.23.36-1 mysql-devel-3.23.36-1 mysql-server-3.23.