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
Thank you. I will try the different options and see how it performs.
On Fri, Feb 4, 2011 at 12:38 PM, Rolando Edwards
wrote:
> innodb_flush_log_at_trx_commit is the parameter to tweek
>
> The following is an excerpt from "MySQL 5.0 Certification Study Guide" (ISBN
> 0-672-32812-7)
> http://www.a
What columns do you have indexed on your event_log table? Can you post the
output from SHOW CREATE TABLE? How long does the query run for?
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Friday, February 04, 2011 10:29 AM
To: mysql list
Subject: Table/select p
Thanks Peter, exactly what I was hoping for!
andy
On 2/4/11 3:11 PM, Peter He wrote:
Are you using the strict SQL mode? Check your my.cnf file.
Peter
Date: Fri, 4 Feb 2011 14:08:01 -0800
From: awall...@ihouseweb.com
To: mysql@lists.mysql.com
Subject: Question about database value checking
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
Are you using the strict SQL mode? Check your my.cnf file.
Peter
> Date: Fri, 4 Feb 2011 14:08:01 -0800
> From: awall...@ihouseweb.com
> To: mysql@lists.mysql.com
> Subject: Question about database value checking
>
> So, a problem popped up today that has caused us no end of hair-pulling, an
So, a problem popped up today that has caused us no end of hair-pulling, and
it brought to mind a similar issue that I found very, well, wrong.
If you have a table defined:
CREATE TABLE `tester_table` (
`acnt`varchar(20) NOT NULL DEFAULT '',
`method` varchar(10) NOT NULL
innodb_flush_log_at_trx_commit is the parameter to tweek
The following is an excerpt from "MySQL 5.0 Certification Study Guide" (ISBN
0-672-32812-7)
http://www.amazon.com/MySQL-5-0-Certification-Study-Guide/dp/0672328127/ref=sr_1_1?ie=UTF8&qid=1296851778&sr=8-1
Chapter 29, Pages 429,430
InnoDB t
Interesting... we have a process that runs once a night to delete old data (we
are only
keeping events from the last 6 months).
And I believe you have described the primary issue exactly - the read is
locking the
table, so the writes get blocked. All inserts do happen at the end of the
table,
Do you delete data from the table ?
MyISAM will only grant a write lock when there are no locks on the table -
including implicit read locks. That may be your problem.
There is a single situation when concurrent reads and writes are possible on
MyISAM, however: when your table has no holes in the
InnoDB definitely has some parameters you can play with, but I've never
actually done so myself.
On Fri, Feb 4, 2011 at 8:09 PM, Vinubalaji Gopal wrote:
> Hi all,
> I wanted to know if Mysql allows me to configure it such that the
> writes to disk happen at a configurable time or after the buff
I had this same issue a while back and solved it by writing my events to
a disk-based file and periodically importing them into the event log
MyISAM table. This way, even if your select statements lock the table,
it won't affect the performance of your application. Of course, this
may require
Hi all,
I wanted to know if Mysql allows me to configure it such that the
writes to disk happen at a configurable time or after the buffers have
enough data. Say there are 10 clients connecting to mysql and each one
is inserting a row - I want to only write to disk when the buffer has
enough data
Greetings, all...
I'm having an issue with a SELECT in our system. We have an event log table,
with about 9 million rows in it. Inserts happen with some pretty high frequency,
and these selects happen periodically. The event_log table is MyISAM, the
rest of the tables are InnoDB.
What's happeni
>-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]
>
>the query was
Thanks, but how can I pass the current users value from the other query ?
On Thu, Feb 3, 2011 at 4:22 PM, Simcha Younger wrote:
> On Thu, 3 Feb 2011 13:55:36 +
> Tompkins Neil wrote:
>
> > SELECT DISTINCT(away_teams_id) AS teams_id
> > FROM fixtures_results
> > WHERE (fixtures_results.away_
Hi Travis,
That query kind of gives me the desired result. However, if is showing
me 1, 18, 11, 23, 3, 2010-11-14 17:18:17 record and not 2, 11, 10, 3, 6,
2010-12-20 22:17:13, which is when they changed teams. Any thoughts ?
Cheers
Neil
On Thu, Feb 3, 2011 at 10:32 PM, Travis Ard wrote:
> So
17 matches
Mail list logo
