Quote:
Originally Posted by Pandaman
MySQL crashes whenever I try to see how many items there actually are in the PEQ database, which causes the problem of me creating custom items to be quite a task.
Could someone please respond with the # of items in the PEQ database so I can go off of that?
|
Try these queries instead:
Code:
mysql> SELECT SQL_NO_CACHE COUNT(id) FROM items;
+-----------+
| COUNT(id) |
+-----------+
| 76214 |
+-----------+
1 row in set (0.00 sec)
Code:
mysql> SELECT SQL_NO_CACHE MAX(id) FROM items;
+---------+
| MAX(id) |
+---------+
| 119462 |
+---------+
1 row in set (0.03 sec)