Re: How do increase memory allocated to MySQL?

Hi Kevin, On Sat, Feb 5, 2011 at 6:00 AM, Kevin Spencer wrote: > When you use a leading wildcard symbol, MySQL will do a full table > scan regardless of any indexes you've created. > Is it also apply to regex lookup ? Regards, Feris

Re: How do increase memory allocated to MySQL?

2011/2/3 Yannis Haralambous : > > what am I doing wrong? > > the query was just > > SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%' When you use a leading wildcard symbol, MySQL will do a full table scan regardless of any indexes you've created. If you've got a MyISAM table, I recomme

RE: How do increase memory allocated to MySQL?

>-Original Message- >From: Yannis Haralambous [mailto:yannis.haralamb...@telecom-bretagne.eu] >Sent: Thursday, February 03, 2011 10:18 PM >To: David Brian Chait >Cc: mysql@lists.mysql.com; y...@mpi-inf.mpg.de >Subject: Re: How do increase memory allocated to MySQL? [J

Re: How do increase memory allocated to MySQL?

2011/2/4 Yannis Haralambous > SELECT * FROM wasfoundin WHERE yakoright LIKE '%geography%' > That won't use a regular index. Have a look at fulltext indexing. For the phpmyadmin, I personally feel it's an abomination, not to mention a disaster waiting to happen; but if you really want to keep us

RE: How do increase memory allocated to MySQL?

7:20 PM To: Yannis Haralambous Cc: David Brian Chait; mysql@lists.mysql.com; y...@mpi-inf.mpg.de Subject: Re: How do increase memory allocated to MySQL? You're query is doing a full table scan. 2011/2/3 Yannis Haralambous mailto:yannis.haralamb...@telecom-bretagne.eu>> just a single ta

Re: How do increase memory allocated to MySQL?

alambous [mailto:yannis.haralamb...@telecom-bretagne.eu] > Sent: Thursday, February 03, 2011 5:43 PM > To: mysql@lists.mysql.com > Cc: y...@mpi-inf.mpg.de > Subject: How do increase memory allocated to MySQL? > > Hi everybody, > > I have loaded a very big amount of data i

RE: How do increase memory allocated to MySQL?

. Thanks, David -Original Message- From: Yannis Haralambous [mailto:yannis.haralamb...@telecom-bretagne.eu] Sent: Thursday, February 03, 2011 5:43 PM To: mysql@lists.mysql.com Cc: y...@mpi-inf.mpg.de Subject: How do increase memory allocated to MySQL? Hi everybody, I have loaded a very big

How do increase memory allocated to MySQL?

Hi everybody, I have loaded a very big amount of data in my MySQL database (coming from the YAGO project): -rw-rw 1 yannis admin 65 3 fév 16:07 db.opt -rw-rw 1 yannis admin 6392030392 3 fév 21:35 wasfoundin.MYD -rw-rw 1 yannis admin 11085793280 4 fév 04:54 wasf