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 rea
On Tue, Jan 13, 2009 at 6:06 PM, Dan wrote:
> On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
> 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
On Tue, Jan 13, 2009 at 7:07 PM, Baron Schwartz 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 versions
> 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 new
On Tue, 13 Jan 2009 18:34:44 -0600, Andrew Garner
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 specify it as an option on
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
ht
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 dbna
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 investigat
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 2>>bkp.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 redirecti
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.
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
^ |
|
On Tue, Jan 13, 2009 at 12:32 PM, Frank Becker
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 --- Master1 --- Master2
>
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 r
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 P
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 identificatio
15 matches
Mail list logo
