[TYPO3] 2 Questions on MySQL for Typo3

Corrado support at eeos.biz
Thu May 10 15:12:54 CEST 2007


Yes Ries it is me! :)

I was answering to a question by Großberger, but what you say it is very
interesting. I also was referring to other databases in my answer, I should
have said so.

What is the RDBMS server you are using?

Best,

Corrado

Ries van Twisk wrote:

> hey Corraddo (eeos on #typo3?),
> I am not much of a MySQL guru and I know more about other databases
> and it's tuning.
> 
> However a lot of databases allow you to create table spaces, you
> should check if
> MySQL also supports tablespaces. Using table spaces you can create
> different
> locations for your databases and indices.
> 
> This is my setup on a nonmysql database.
> 
> I have two RAID 1 sets 2 controllers and 4 HD's (each have a hot spare).
> 
> One one RAID1 set I store my root FS and my dataset, and on the other
> I store my indices.
> 
> So my indices and dataset is physically separated. Then the RDMB can
> do it's
> lookup's on the indices and fetch data from the other array and send
> it to the application.
> 
> To give you an idea of speed.
> 
> A join of 5 tables where the largest table is 450.000 records, 3
> tables are 50.000 records
> and a couple of small tables of 500 records, where the result is a
> couple of hundred records
> takes about 250ms to return data directly after the RDBM is started.
> Additional requests to
> the same data set get's done in around 5ms. Additional requests are
> non-cached from teh RDBM's
> perspective and only because data is already found in disk caches.
> 
> So if you really have the need for speed... check if you can separate
> your indices from your data storage
> on MySQL. Dmitry is a MySQL guru might now how to do that.
> 
> 
> Ries

-- 
eeos communications (technical support)
http://www.eeos.biz


More information about the TYPO3-english mailing list