Hello everyone,
We are using MySQL as the database backend on quite a big portal
page with about 50.000 users and 3 mio. PIs per day. MySQL is as well the
backend for the (php) session management. We are using a heap for that case
as well as for instance phpbb does.
Lately we are
Hello.
Are you sure that your server doesn't swap? Providing output
of 'SHOW STATUS', 'SHOW VARIABLES' and your table definition
could give more information for suggestions. Also, if you have
a hash index on a MEMORY table that has a high degree of key
duplication (many index entries
. Juli 2005 10:35
An: mysql@lists.mysql.com
Betreff: Re: Locks on Heap tables
Hello.
Are you sure that your server doesn't swap? Providing output
of 'SHOW STATUS', 'SHOW VARIABLES' and your table definition
could give more information for suggestions. Also, if you have
a hash index on a MEMORY table