Re: 100% cpu usage on single cpu core

[Gus Lopez]

Thanks for prompt reply Rick.

Created other table (PUB_S_T) with
- Decimal(13,4)
- B_ID can not be NULL (thanks for the observation)

Tried the queries

WOW!!! What a time difference?
Why? Is it cached? How did you analyze this?


mysql> select max(query1.totalItems) from ( SELECT PUB_S_ID, count(T_ID) as totalItems from PUB_S_T group by PUB_S_ID) query1 ;
+------------------------+
| max(query1.totalItems) |
+------------------------+
| 32 |
+------------------------+
1 row in set (1 min 54.73 sec)

mysql> SELECT PUB_S_ID, count(*) as totalItems from PUB_S_T group by PUB_S_ID ORDER BY 2 DESC LIMIT 1 ;
+----------+------------+
| PUB_S_ID | totalItems |
+----------+------------+
| 9400997 | 32 |
+----------+------------+
1 row in set (3.82 sec)


But what I really need to speed up are the others. It's a matter of pride: Oracle Vs MySQL ;)
Thanks in advance
Gus