Hi all
I have a MySQL installation running on a Pentium3 based system with 2GB RAM... The
database primarily uses MyISAM tables with 60% SELECT statements. The database is used
as a backend for a PHP web application.
Do the following values make any sense?
set-variable= key_buffer=200M
set-
Hi all
I'm working on a book database with some special requirements. Each book is associated
with some keywords and put into a category. Category 0 is special, as this is
"Unsorted", i.e. not associated with a category (which most books are at the moment).
For thei query, let's simplify the st
Does somebody know, how the LIMIT statement does affect the query caching mechanism of
MySQL 4.x?
Is
select * from examples LIMIT 0,30
and
select * from examples LIMIT 30,30
treated the same, therefore does the caching improve performance or are these queries
considered to be two sepper
