Try a union instead of an or condition.
http://dev.mysql.com/doc/refman/5.0/en/union.html
Johnny Withers wrote:
I have the following tables:
Customer: id,ssn
Customer_Id: id,customer_id,id_num
The customer table holds customers along with their SSN and the customer_id
table holds
MySQL University: Low-Level Locking in mysqld and InnoDB
Happy New Year!
MySQL University sessions are starting again after the winter break.
This Thursday, we're beginning with Tim Cook's presentation on low-level
locking in mysqld and InnoDB – the good, the bad, and the ugly. Tim
works in the
Hello together,
I have successfully set up a master-master-replication between two
servers. My question is: It is possible to set up such a replication
between three (or more) servers? Like this
Master3 --- Master1 --- Master2
|
Master4
Thanks for your feedback
Best
On Tue, Jan 13, 2009 at 12:32 PM, Frank Becker
computersac...@beckerwelt.de wrote:
Hello together,
I have successfully set up a master-master-replication between two
servers. My question is: It is possible to set up such a replication
between three (or more) servers? Like this
Master3 ---
In the topology you just illustrated, you need to be specific about your scheme
using arrows. Here are some examples:
==
Example 1: This is MultiMaster Replication among 4 servers
Master1---Master2
^ |
|
Hello Baron, thanks for your response.
These types of questions can always be answered by asking: does my
proposed setup require any server to have more than one master? If
so, it's currently not possible.
What I want to do is the following:
eGroupware is a enterprise-groupware solution. I
On Tue, 2009-01-13 at 12:19 +0530, Chandru wrote:
Hi,
Did u try using this command
mysqldump --opt db_name db_name.sql -p 2bkp.err
Not quite. Firstly, I had to alter the normal backup cron job, and that
doesn't happen until late at night.
Secondly, yes I added the redirection to
At 09:17 PM 1/12/2009, you wrote:
Why would delay_key_writes require a table rebuild? It's not
modifying the data. Reloading tens of millions of rows for several
hours seems to be a waste of time.
It probably flips a bit in the .frm file or something like that, but I
have not investigated it
This sounds like you need to raise max_allowed_packet for mysqldump
(and possibly mysqld) - these are separate settings for both the
client and the server. You can do this via the my.cnf (or ~/.my.cnf)
or specify it as an option on the command line mysqldump --opt ...
--max_allowed_packet=1G
Do you have an index on id_num? What sort of explain output do you
get when you don't use a query hint? Your USE INDEX hint may be
causing MySQL to ignore a better strategy.
If you have separate indexes on ssn and id_num, MySQL may be able to
efficiently use an index merge optimization . See
On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
andrew.b.gar...@gmail.com wrote:
This sounds like you need to raise max_allowed_packet for mysqldump
(and possibly mysqld) - these are separate settings for both the
client and the server. You can do this via the my.cnf (or ~/.my.cnf)
or
If you have separate indexes on ssn and id_num, MySQL may be able to
efficiently use an index merge optimization . See
http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html.
This is only in 5.0+ - on older versions of MySQL you may find a union
more efficient.
And in newer
On Tue, Jan 13, 2009 at 7:07 PM, Baron Schwartz ba...@xaprb.com wrote:
If you have separate indexes on ssn and id_num, MySQL may be able to
efficiently use an index merge optimization . See
http://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html.
This is only in 5.0+ - on older
On Tue, Jan 13, 2009 at 6:06 PM, Dan d...@entropy.homelinux.org wrote:
On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
andrew.b.gar...@gmail.com wrote:
This sounds like you need to raise max_allowed_packet for mysqldump
(and possibly mysqld) - these are separate settings for both the
On Tuesday 13 January 2009 07:23:52 am Krishna Chandra Prajapati wrote:
Hi Scott,
I believe something wrong with innodb parameters. It should be optimum. In
your case it might be too high or too low. Take a look at log file size.
Please send your show variables and show status data to reach
15 matches
Mail list logo
