Hi Baron,
If, I have started mysql server with --slave-skip-errors=1048 then this
error will be logged into mysql error file or not.
Thanks,
Prajapati
Krishna Chandra Prajapati
--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road, Secu
Sounds like you already know the score. Yeah, we use slaves as
'backup-capable' servers too... sometimes to the point of having a
separate slave who's sole purpose in life is to be taken down and
backed up. :)
As it happens, I worked with mk-table-checksum and mk-table-sync some
today. On a ~11GB
Jed Reynolds wrote:
If you are using LVM, you might consider snapshotting, however, doing
a live snapshot without stopping mysql server would only work if you
were copying only myisam tables. Mysql-hot-copy would probably be
better, but either way, you need to flush your tables, which will
bri
Claudio,
please provide details:
Which engine (InnoDB or MyISAM) are you running?
Which MySQL version are you running?
What is the OS?
What is the files system?
Regards
Theo
-Original Message-
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Tuesday, 6 January 2009 10:05
hi wm.
take this for what it's worth!
i think you're trying to solve an issue that's already been solved. why
don't you do some quick/dirty research on companies that either issue/manage
isbn numbers, or companies who sell solutions for online/brick-mortar
bookstores. explain that you're thiking
On Tue, January 6, 2009 13:30, PJ wrote:
> My comments, questions & explanations inserted below
>
> mos wrote:
>> At 09:55 AM 1/6/2009, you wrote:
>>
>>> >-Original Message-
>>> >From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>>> >Sent: Tuesday, January 06, 2009 9:47 AM
>>> >To: mysql@lists.m
My comments, questions & explanations inserted below
mos wrote:
> At 09:55 AM 1/6/2009, you wrote:
>
>> >-Original Message-
>> >From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>> >Sent: Tuesday, January 06, 2009 9:47 AM
>> >To: mysql@lists.mysql.com
>> >Subject: RE: how to design book db
>> >
Yes you're right. I went off on a complete tangent with my thoughts on this
and it does not do what you wanted at all...Sorry!
I can't think of any way to do this via sql only as it's almost a
group_limit_by that you'd want. It seems much more like a procedural call,
so I'd expect you'd need some
>-Original Message-
>From: freedc@gmail.com [mailto:freedc@gmail.com] On Behalf Of
>Phil
>Sent: Tuesday, January 06, 2009 3:41 PM
>To: Jerry Schwartz
>Cc: mysql@lists.mysql.com
>Subject: Re: Limit within groups
>
>How about something like
>
>select account,customer,max(total) from
How about something like
select account,customer,max(total) from (select
account,customer,sum(sale_amount) as total from group by
customer) as y group by account;
Seems to work in my test case..
Regards
Phil
On Tue, Jan 6, 2009 at 3:13 PM, Jerry Schwartz
wrote:
> Here's a bit of business t
Here's a bit of business that is baffling me, and probably shouldn't. My
table looks like this:
account
customer
sale_amount
Each account has multiple customers, and each customer has multiple sales. I
want to get the top 20 customers for each account.
If I simply do "GROUP BY accoun
First, Thank You all guys, I really appreciate your great answers.
Second in my experience this is one of the most challenging and frequent
things with mysql on production servers,
once you have the slave practically you have online backups
I will try to answer one by one.
Jake Maul wrote:
If
Claudio Nanni wrote:
All, Happy New Year, and let's hope somebody tries to stop the killing in
gaza.
I need to setup a replication slave off a master that is currently
production and not stoppable or lockable(possibly).
If you are using InnoDB, there is a --single-transaction method backup
Jim Ginn wrote:
Jed:
Are you using an in-network IP to access the database ie:
127.0.0.1
192.168.98.##
or are you using a public IP or full domain name ie:
DB001.MY-DOMAIN.COM
...
A very reasonable question. I'm connecting using IP addresses.
$servers = array( '192.168.44.84','192.168.
At 09:55 AM 1/6/2009, you wrote:
>-Original Message-
>From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>Sent: Tuesday, January 06, 2009 9:47 AM
>To: mysql@lists.mysql.com
>Subject: RE: how to design book db
>
>
>Just theories here:
>
>
>
>The same book re-issued by another publisher might ha
On Tue, January 6, 2009 07:55, Jerry Schwartz wrote:
>
>>-Original Message-
>>From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>>Sent: Tuesday, January 06, 2009 9:47 AM
>>To: mysql@lists.mysql.com
>>Subject: RE: how to design book db
>>
>>
>>Just theories here:
>>
>>
>>
>>The same book re-issue
Hi,
I'm writing a stats script that monitors, among other things, the MyISAM key
cache usage. As per the mysql.com docs, I plot Key_blocks_used as the
high-watermark line, but on some of my servers, this is quite a bit lower
than current usage.
Googling reveals that I'm not the only one to see th
Use the first option (1 table) and index column place
Olaf
On 1/5/09 4:42 PM, "Ahmet DÜLGAR" wrote:
>
> hi everyone
> my question is about tables
> i have lots of records
> i want to learn that if i slip my record. are the select run more fast
> for example
> table1
> name surname place
> aaa
We get asked to do this a lot :) There's a bunch of different cases.
What storage engines are you using? Do you have LVM with free space
on the volume group, or another way to take snapshots such as a SAN?
Sometimes there are clever ways to get around various limitations, but
I'll wait till you r
If you're making backups of the DB, it might be possible to use the
backup data as a replication snapshot for kickstarting the slave. You
would need to be recording the master log file and position at the
time the backups are made as well, however (usually easy to hack in if
you're not already reco
>-Original Message-
>From: c...@l-i-e.com [mailto:c...@l-i-e.com]
>Sent: Tuesday, January 06, 2009 9:47 AM
>To: mysql@lists.mysql.com
>Subject: RE: how to design book db
>
>
>Just theories here:
>
>
>
>The same book re-issued by another publisher might have a different
>ISBN.
>
>
>
>A book
Just theories here:
The same book re-issued by another publisher might have a different ISBN.
A book with an insert (e.g., CDROM) may have a different ISBN, but be the
"same" for some purposes.
And mistakes can be made...
Ultimately, I suspect that the uniqueness of ISBN to what norma
Jed:
Are you using an in-network IP to access the database ie:
127.0.0.1
192.168.98.##
or are you using a public IP or full domain name ie:
DB001.MY-DOMAIN.COM
...
Jim
> I've started logging how long my php application takes to login to
> mysql, and often it's well below 1 millisecond. Howeve
All, Happy New Year, and let's hope somebody tries to stop the killing in
gaza.
I need to setup a replication slave off a master that is currently
production and not stoppable or lockable(possibly).
Do you have any idea on how to setup the slave with minimum or no impact on
the master?
The datab
24 matches
Mail list logo
