Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Performance of a database with a lot of tables [message #696] Fri, 09 February 2007 03:58  Kynlem Messages: 11 Registered: February 2007 Location: Ukraine Junior Member Hello, I am working on hosting solution for a popular open source script, where users can sign up and get an own forum. We use InnoDB, and each user has an own set of tables (around 30); there are currently around 500 users registered. Despite the large count of tables, database is small, around 50 MB. Server is dual Xeon with 4GB of RAM and MySQL uses all memory, available on the server, so there's even nothing left for Apache. As the user base is growing, what steps would you suggest me to do, in order to keep good database performance and make it more efficient on RAM usage? The former is more important. ------------------------ Olexandr Melnyk, http://omelnyk.net/ Report message to a moderator

	Performance of a database with a lot of tables By: Kynlem on Fri, 09 February 2007 03:58
	Re: Performance of a database with a lot of tables By: Peter on Fri, 09 February 2007 08:08
	Re: Performance of a database with a lot of tables By: Kynlem on Fri, 09 February 2007 08:52
	Re: Performance of a database with a lot of tables By: Peter on Fri, 09 February 2007 10:05
	Re: Performance of a database with a lot of tables By: Kynlem on Fri, 09 February 2007 13:20
	Re: Performance of a database with a lot of tables By: Peter on Fri, 09 February 2007 16:54
	Re: Performance of a database with a lot of tables By: Kynlem on Sat, 10 February 2007 15:33
	Re: Performance of a database with a lot of tables By: Peter on Sat, 10 February 2007 17:03
	Re: Performance of a database with a lot of tables By: Kynlem on Sun, 11 February 2007 10:13
	Re: Performance of a database with a lot of tables By: Peter on Sun, 11 February 2007 11:52
	Re: Performance of a database with a lot of tables By: Kynlem on Thu, 15 February 2007 15:09
	Re: Performance of a database with a lot of tables By: Peter on Thu, 15 February 2007 16:34
	Re: Performance of a database with a lot of tables By: Kynlem on Fri, 16 February 2007 00:33
	Re: Performance of a database with a lot of tables By: Peter on Fri, 16 February 2007 08:23
	Re: Performance of a database with a lot of tables By: al.james on Fri, 16 February 2007 09:45
	Re: Performance of a database with a lot of tables By: Kynlem on Mon, 26 February 2007 02:37
	Re: Performance of a database with a lot of tables By: Peter on Mon, 26 February 2007 05:49
	Re: Performance of a database with a lot of tables By: Kynlem on Mon, 26 February 2007 10:39

Previous Topic:	varchar index killing csv import
Next Topic:	ORDER BY … LIMIT Performance Optimization

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]