Re: Create Schema and repeatable import of XML

You can have a look at XMLPipeDB. http://sourceforge.net/projects/xmlpipedb/ Iñigo On 03/09, Sayth Renshaw wrote: > Hi > > Hoping someone can help me work some information or direction to a good > resourc

RE: query tuning

Good advices indeed. Thanks for sharing. iñ On Wed, 14 Nov 2012, Rick James wrote: A PRIMARY KEY is a KEY, so the second of these is redundant: PRIMARY KEY (`zzk`), KEY `zzk` (`zzk`), "Compound" indexes are your friend. Learn from http://mysql.rjweb.org/doc.php/index1 `zzr_Status

Re: How to create new mysql instance

Can any body help me how to create new instance at the same mysql databas server in 5.0.85 community version ? You might find useful: http://code.openark.org/blog/mysql/manually-installing-multiple-mysql-instances-on-linux-howto At least i used that last time i had to set 2 instances on my m

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

, May 12, 2008 at 2:57 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 wan

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

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. -- -

Re: InnoDB Log Optimisation

ation No GB 449 3582 17 > Registered in England No: 02017435, Registered Address: Charter Court, > Midland Road, Hemel Hempstead, Hertfordshire, HP2 5GE. > * > -- Iñigo Medina García

Re: Block size of filesystem

innodb/features/ 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]&

Re: Block size of filesystem

l Core 2 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 arou

Re: Block size of filesystem

the stripe size of your raid system, might work well > aligning them if you can. This URL also gives some tips for an ext3 > file system on RAID, look for 'stride': > > http://insights.oetiker.ch/linux/raidoptimization.html > > Ben > > Iñigo Medina García wrote

Re: Block size of filesystem

ny that this is > actually true. > > -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 around 1gb >> and 30 tables.

Block size of filesystem

you think 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.