Hi Neil,
If you use MySQL Cluster then you have synchronous replication between the 2
data nodes which means that if one should fail you're guaranteed that the other
contains the effects of every committed transaction and that the change has
already been applied and so there is no delay while
Hi List
I have a table with a primary key with type binary(16) and a few columns.
I'd trying to create a view that looks up all rows with a particular key,
i.e. something like
CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';
I use the
2013/4/30 Richard Reina gatorre...@gmail.com
I have a few slaves set up on my local network that get updates from
my main mysql database master. I was hoping to turn one into a master
while keeping it a slave so that I can set up a chain. Does anyone
know where I can find a how to or other
Or
SELECT ... \G
(replace ';' with '\G')
-Original Message-
From: h...@tbbs.net [mailto:h...@tbbs.net]
Sent: Wednesday, April 24, 2013 9:55 AM
To: mysql list
Subject: Re: how to list record in column (instead of a row)
2013/04/24 09:06 -0700, Rajeev Prasad
this table has
Please provide
SHOW CREATE TABLE cdsem_event_message_idx \G
EXPLAIN SELECT * FROM cdsem_event_message_idx where event_id in () \G
SHOW VARIABLES LIKE 'autocommit';
These can impact DELETE speed:
* secondary indexes
* whether event_id is indexed.
* disk type and speed --
OR would not show dups.
WHERE duespaid AND cat1 OR cat2
means
WHERE (duespaid AND cat1) OR cat2
That is probably not what you wanted -- add parens like
WHERE duespaid AND (cat1 OR cat2 ...)
But...
That is not a good way to build a schema. What will happen when you add
category9?
Plan A:
See also Percona XtraDB Cluster.
Will you nodes be in the same physical location? If so, what about floods,
earthquakes, etc?
Clouds are ephemeral; data wants to persist
-Original Message-
From: Andrew Morgan [mailto:andrew.mor...@oracle.com]
Sent: Tuesday, April 30, 2013 12:36 AM
WHERE id = UNHEX('36a461c81cab40169791f49ad65a3728')
-Original Message-
From: Martin Koch [mailto:m...@issuu.com]
Sent: Tuesday, April 30, 2013 8:18 AM
To: mysql@lists.mysql.com
Subject: Long integer constant problem in views
Hi List
I have a table with a primary key with
2013/04/30 17:17 +0200, Martin Koch
CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';
Try this: _binary X'36a461c81cab40169791f49ad65a3728'
SHOW CREATE VIEW is the command for the client.
--
MySQL General Mailing List
For list