2009/3/29 Oscar :
> Hi all-
>
> I want to know what the difference between IN and OR is under the hood.
>
> select * from dummy_table where id in (2, 3, 4, 5, 6, 7);
>
> select * from dummy_table where id=2 or id=3 or id=4 or id=5 or id=6 or
> id=7;
I've have thought once the query is compiled, th
Hi All,
How do I create a mysql data dump from a slave to seed another slave?
Using --master-data with mysqldump from my existing slave sets the
master to the slave I was dumping, not the real master.
Many Thanks,
Ian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/my
when - back
to being in sync.
Why these defaults changed on a minor mysql release update is beyond me,
however I suspect this is gentoo's fault, not MySQLs.
--
Ian P. Christian ~ http://pookey.co.uk
signature.asc
Description: OpenPGP digital signature
Ian P. Christian wrote:
> I upgraded my slave server a few weeks ago, and the slave failed, with
> an error similar to the one shown below.
I have figured out what happened here now - and I'm part of the way
though fixing it.
It turned out the defaults had changed somewhere, and
deas/suggestions welcome, reseeding the slave will literally take days.
--
Ian P. Christian ~ http://pookey.co.uk
signature.asc
Description: OpenPGP digital signature
stem?
Yes - I've been doing this for some time, works fine.
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ve). Then "INSERT INTO newtable SELECT * FROM
> oldtable WHERE primarykey in ( your 50,000 keys )", then "DELETE FROM
> oldtable WHERE primarykey in ( your 50,000 keys )", then COMMIT, which
> will cause your insertions and deletions to be truly atomic.
Ah of cours
hange because any
new records would get included in the LIMIT.
Will it not always use the natural order of the table in
selects/deletes, and therefore return results in the order in which they
were inserted?
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives:
(if I don't limit to small numbers in the LIMIT, I/O gets too high, so
I'm moving data slowly in batches)
Thanks,
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
a, and remember to never store the CVV number.
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
his:
http://forums.mysql.com/read.php?30,14020,14020
which honestly, I've not read - but you might want to :)
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Neil Tompkins wrote:
I'm looking to use MD5() to encrypt credit card numbers. How do I
unencrypt this when reading the value ?
you can't.
Google for MD5, or better still look at wikipedia, I'm sure they will
have something
--
Ian P. Christian ~ http://pookey.co.uk
-
Filip Krejci wrote:
> Hi,
>
> I suppose this is really I/O problem.
>
You're right, it looks like it was just an I/O problem - your suggestion
was spot on. I've now managed to dump my master data, and can get my
slave back online!
Thanks a lot for your suggestion,
--
I
eue
2 read views open inside InnoDB
Main thread process no. 23228, id 2367634320, state: sleeping
Number of rows inserted 356882, updated 1963990, deleted 293832, read
875872021
2.05 inserts/s, 10.32 updates/s, 0.21 deletes/s, 48500.03 reads/s
Thanks again,
--
Ian P. Christian ~ http://pookey.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ldump --host x.x.x.x --master-data
--single-transaction > dump.sql) which cause separating writes on
another box?
I did do this under the assumption it could simply be an I/O problem -
however the problem persists. It might be because the network
connection between the two hosts is pretty fast
Marcus Bointon wrote:
Hi Marcus :)
> On 7 Mar 2007, at 08:44, Ian P. Christian wrote:
>
> --single-transaction doesn't _do_ the dump as a transaction, it simply
> wraps the dump in begin/commit statements so it's atomic when restoring.
>
> If the dump is to preserve
site
remained live, and took the site down for 15 minutes whilst the dump
ran. As I'm sure you'll understand I'm not too keen on taking the
website down again.
Any suggestions as to why my database is stopping (could be I/O related
maybe? it's on a good RAID setup
17 matches
Mail list logo
