-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?
[JS] snip
the query
2011/2/3 Yannis Haralambous yannis.haralamb...@telecom-bretagne.eu:
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
Hi Kevin,
On Sat, Feb 5, 2011 at 6:00 AM, Kevin Spencer ke...@kevinspencer.orgwrote:
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
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
.
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
]
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 in my MySQL database (coming from the
YAGO project):
-rw-rw 1 yannis admin
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
yannis.haralamb...@telecom-bretagne.eumailto:yannis.haralamb...@telecom
2011/2/4 Yannis Haralambous yannis.haralamb...@telecom-bretagne.eu
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