tinue to use the slave while restoring the master.
Assuming you use only transaction-safe tables, of course.
(You should.)
--
-- Matthias Urlichs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi,
I have the following table and two concurrent jobs,
trying to insert data into it. They deadlock on accessing an index which
shouldn't collide (the date is part of the index, and the jobs process
data for different dates).
This is mysql 5.0.51a-24+lenny1~bpo40+1-log.
Any ideas? Is this likel
On Thu, 14 Aug 2008 10:27:29 +0530, Krishna Chandra Prajapati wrote:
> Please help me that what should i do.
Nothing. It's just multi-threaded. Everything's fine.
--
Matthias Urlichs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
Hi, Tom Cunningham wrote:
> I have a funny problem: I'm getting thousands of "Data Truncated"
> warnings when I insert a single row of data into a table, using an
> INSERT...SELECT.
I bet that the columns you're joining on have different sizes.
--
Matthias Urlich
> '$val'")
> }
runs almost instantly. MySQL should be able to do that optimization, it's
rather obvious (ten million rows, and IP has less than 100 different
values).
--
Matthias Urlichs | {M:U} IT Design @ m-u-it.de | [EMAIL PROTECTED]
--
MySQL General Mailin
it.
NB, the script needs unique indices (duh ;-) and update timestamps on all
tables. (It works without a timestamp, but obviously *way* slower.)
--
Matthias Urlichs | {M:U} IT Design @ m-u-it.de | [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists
Hi,
gerald_clark:
> > KEY `Trap` (`IP`,`Type`,`epoch`),
> > KEY `IP` (`IP`)
> >
> Your second key is redundant.
True (there's a UNIQUE missing in there).
Deleting the first key, however, doesn't change anything.
--
Matthias Urlichs | {M:U} IT Design @
*long* time and obviously scans the whole table.
Ideas, anybody?
MyISAM vs. InnoDB behave identically.
4.0 or 4.1.5 also didn't make a difference; I didn't test 5.0, as this
is supposed to be a production system.
--
Matthias Urlichs | {M:U} IT Design @ m-u-it.de | [EMAIL PROTECTED]
be more
appropriate.
- --
Matthias Urlichs|noris network AG|http://smurf.noris.de/
- --
Mercedes vermietet jetzt den Unterboden der A-Klasse als Werbefläche.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQE+adRR8+hUANcKr/kRAnXNAKCnyhJ5E/T9/wdLEDg8vQp33nM/
Hi,
is it possible to have a column which does NOT have a default value, i.e.
an INSERT query should fail if no value is given..?
The obvious idea, i.e.
"CREATE TABLE foo (bar integer not null default null);"
doesn't work.
--
Matthias Urlichs | noris network AG
At 15:17 -0700 2010-05-02, Angela Neff wrote:
>I have tried numerous methods as instructed in the mySQL listerserv
>e-mail to get off this list
>but am still on it. Can somebody help me out? I got 779 e-mails today.
Set your date correctly and try again..!
--
Matthia
Hi,
>
>The article mentions that the Web site will confuse new users, but I
>think this one will confuse them even more:
>http://mysql.net/
>(for non-Japanese users that is).
Korean, actually.
--
Matthias Urlichs (being exceedingl
shouldn't -- all tests which
are not table-specific should work with all tables, and those that
are should explicitly specify the table type they need.
--
Matthias Urlichs
-
Before posting, please check:
http://www.mysq
by checking the index on the ID, so it's not a fast solution
at present.
=> Hello MySQL developers: Please add that. Same for the equivalent
"... ORDER BY id DESC LIMIT 1"
--
Matthias Urlichs
-
Before pos
amples: Commas. Line breaks. The start of the actual data. If
you really want words, use "rlike" and \<...\> (assuming that MySQL
can do egrep-like escapes). But it'll be dirt slow compared to the
fulltext index.
--
Matthias Urlichs
---
ers,
though -- they can't do (some? I forget) binary operations in a
SELECT right, and our customers _do_ have some reasonable
expectations about SQL compatibility.
--
Matthias Urlichs
-
Before posting, please check:
Hi,
Sinisa Milivojevic:
> And what happens if you put quotes ??? ... id = '123'...
>
Then it works, of course. But the nice thing about the numeric select is
that it also accepts values like 123x45 or 123-45-67 (but not 1234),
which is why I wanted to use it.
--
that
select * from ticketid where id like "123%"
correctly uses the above index, but a more restrictive query, i.e.
select * from ticketid where id like "123%" and id = 123
doesn't. This is _not_ the expected result.
--
Matthias Urlichs | noris net
ticketid 1 ticket 2 seq A
ticketid 1 sender_i1 sender A
> Third --with-debug is slower then without.
>
But not that much slower...
--
Matthias Urlichs | noris n
iler problem; Rh 7.0 used a rather buggy gcc :-(
and the version
--
Matthias Urlichs | noris network AG | http://smurf.noris.de/
--
If wishes were horses, then beggars would be thieves.
-
Before posting, p
Errors like duplicate entries?
Those aren't "minor". They're serious data inconsistency problems.
--
Matthias Urlichs | noris network AG | http://smurf.noris.de/
--
Once you've tried to change the world you
find it'
MySQL to only use malloc'ed fd_sets.
Until then, setting the fd limit to >1024 is a Bad Idea.
--
Matthias Urlichs | noris network AG | http://smurf.noris.de/
--
Californians do it laid back.
-
Before post
at
can be searched while being updated.
I rather like the relevancy algorithm. The insistence on only indexing
full words is more problematic, however.
--
Matthias Urlichs | noris network AG | http://smurf.noris.de/
--
Most people ignore most poetry
because
most poetry ignores mo
23 matches
Mail list logo
