talkli...@newgeo.com (Scott Haneda) writes:
> Hello, I am confused about repliction setup. Reading a config file,
> and the docs, leads me to believe this is an either code choice, pick
> #1 or #2. If that is the case, why would I want to use #1 over #2?
>
> My confusion comes from several onli
Hello, I am confused about repliction setup. Reading a config file,
and the docs, leads me to believe this is an either code choice, pick
#1 or #2. If that is the case, why would I want to use #1 over #2?
My confusion comes from several online references where there is a
combination of #1
Check to make sure the binary log index is not out-of-sync.
Here is how you can do this:
Run 'SHOW BINARY LOGS;'
Look to see if any of the entries reports a zero length in it or includes a
binary log that does not exist.
Every time you shutdown mysqld, mysqld writes what it has in its memory ra
Hi,
I'm having a strange problem with table locking. I have written a stored
procedure that only accesses a single table. Before executing the
procedure, I'm trying to lock the table in question for writing. The
LOCK TABLE command succeeds, but when I execute the stored procedure it
tells me
i tried this one
PURGE { BINARY | MASTER } LOGS
{ TO '*log_name*' | BEFORE *datetime_expr* }
but for some reason it didn't purge any bin file.. so i tried our expired...
on the my.cnf waited for a while and it was deleted...
is there a requirement to use "purge" i have "5.0.51a-0.rhel4" run
Hello - I was ask to install Mysql version 5.0.x on Solaris 10 (a T2000). I
can not find a good how-to on this. I would really appreciated if someone can
point me in the right direction.
I'm also looking for tuning and performance tips.
Downloaded from: http://dev.mysql.com/downloads/mysql/5.0.
in your code, you can define ranges of say if the model year being
looked for is 2002, then present model years 2000 thru 2004.
--Curtis
blackwater dev wrote:
Thanks but doing it in code would require me to pull in the entire car table
and process it. With potentially tons of rows, seems li
not if you did it in a stored procedure. Given that it's gonna be pretty
hard to use indices on this anyway (I think), you're gonna scan the entire
table anyway. That's what you get for fuzzy searches.
On Tue, May 12, 2009 at 6:55 PM, blackwater dev wrote:
> Thanks but doing it in code would requ
Thanks but doing it in code would require me to pull in the entire car table
and process it. With potentially tons of rows, seems like I should be able
to use the db to get those.
On Tue, May 12, 2009 at 12:23 PM, Johan De Meersman wrote:
> you *could* go with if-statements, returning a numerica
blackwater dev wrote:
I have a hold car data such as color, model, make, year, etc. I want to
allow the user to answer some questions and I'll present them with the car
that 'best' matches their criteria. How do I do this? I still want to
return ones that don't match exactly but want the close
you *could* go with if-statements, returning a numerical weight for each
criterion if match and 0 if not; summing those and sorting by the sum
column.
I would do it in code, though - it may or may not be less efficient, but
it'll be easier to maintain and read.
On Tue, May 12, 2009 at 5:50 PM, b
I have a hold car data such as color, model, make, year, etc. I want to
allow the user to answer some questions and I'll present them with the car
that 'best' matches their criteria. How do I do this? I still want to
return ones that don't match exactly but want the closer matches ordered at
the
Mysql List,
I have a crash that has occured a number of times on a production CentOS 4.4
machine. It occurs when using a product called Interspire Email Marketer and
doing an import of some 30,000 email addresses. Unfortunately, I have not
been able to reproduce the crash myself (I have tried nume
13 matches
Mail list logo
