Re: Could somebody tell me how to get the time of a database?

2008-05-12 Thread Iñigo Medina García
Hi Moon's Father, :-) what about through filesystem? $ ls -la /path-mysql-databases or something like that. Iñigo I want to know the create time of a database,but I can not find a way till now. Any reply is appreciated. -- Iñigo Medina García Librería

Re: Could somebody tell me how to get the time of a database?

2008-05-12 Thread Iñigo Medina García
PM, Iñigo Medina García [EMAIL PROTECTED] wrote: Hi Moon's Father, :-) what about through filesystem? $ ls -la /path-mysql-databases or something like that. Iñigo I want to know the create time of a database,but I can not find a way till now. Any reply is appreciated

Block size of filesystem

2008-05-09 Thread Iñigo Medina García
that could be good? Any experience? Iñigo -- Iñigo Medina García Librería Díaz de Santos [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Block size of filesystem

2008-05-09 Thread Iñigo Medina García
, 2008 at 12:01 AM, Iñigo Medina García [EMAIL PROTECTED] wrote: Hi friends, we're developing a new web application that works with a db around 1gb and 30 tables. We work with linux, and I'm evaluating the benefit of making an specific partition (ext3) for mysql in order to have a bigger

Re: Block size of filesystem

2008-05-09 Thread Iñigo Medina García
file system on RAID, look for 'stride': http://insights.oetiker.ch/linux/raidoptimization.html Ben Iñigo Medina García wrote: Hi friends, we're developing a new web application that works with a db around 1gb and 30 tables. We work with linux, and I'm evaluating the benefit

Re: Block size of filesystem

2008-05-09 Thread Iñigo Medina García
Duo on kernel 2.6.21-1 and i386 by now. Do you think it could be better to change the architecture in order to get the advantages of 8 kb blocks size? Iñigo Iñigo Medina García wrote: Hi friends, we're developing a new web application that works with a db around 1gb and 30 tables. We

Re: Block size of filesystem

2008-05-09 Thread Iñigo Medina García
/ and expand the *wspifmd* link read more of InnoDB Features: database page sizes configurable, from 4 to 64 kB, default 16 kB. Iñigo -Aaron On Fri, May 9, 2008 at 12:01 AM, Iñigo Medina García [EMAIL PROTECTED] wrote: Hi friends, we're developing a new web application that works with a db

Re: InnoDB Log Optimisation

2008-05-09 Thread Iñigo Medina García
. * -- Iñigo Medina García Librería Díaz de Santos Madrid (Spain) [EMAIL PROTECTED] [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql