How much memory can mysql 5.1 take advantage of?

2009-01-20 Thread webtek2001-mysql
While specing out a new server, I was wondering if there is any limit to how much memory can be allocated to mysql 5.1. If a server has 16GB of ram, can mysql take advantage of that much ram (minus a reserved amount for the OS obviously)? Is there any limit such as those imposed by 32-bit

Can these two queries be combined into one?

2008-01-30 Thread webtek2001-mysql
Hi, I'm currently using 2 queries to obtain some data and would like to know if I can combine these two queries into one query. I have a database with 3 tables: 1. A category table 2. A product table 3. A normalized catproduct table that is used to determine which product is in which