maatkit-discuss Mailing List for Maatkit
Brought to you by:
daniel_nichter
Menu
▾
▴
maatkit-discuss — General discussion, feedback etc for MySQL Toolkit
You can subscribe to this list here.
| 2007 |
Jan
|
Feb
|
Mar
|
Apr
(4) |
May
(2) |
Jun
(4) |
Jul
(1) |
Aug
|
Sep
(4) |
Oct
(17) |
Nov
(12) |
Dec
(15) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
(2) |
Feb
(1) |
Mar
(2) |
Apr
(13) |
May
(3) |
Jun
(5) |
Jul
(6) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: Baron S. <ba...@xa...> - 2008-07-18 19:59:37
|
I'm moving the entire project to Google Code so I can be more productive. The mailing list is going here: http://groups.google.com/group/maatkit-discuss The new project homepage is here: http://code.google.com/p/maatkit/ I have sent an invitation to current list members to join that new group. Regards, Baron -- Baron Schwartz, Consulting Team Lead, Percona Inc. Tel: +1 888 401 3401 ext 507 24/7 Emergency Line +1 888 401 3401 ext 911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/ |
|
From: Baron S. <ba...@xa...> - 2008-07-09 12:55:53
|
On Wed, Jul 9, 2008 at 2:42 AM, Neil Lunn <nei...@tr...> wrote: > Baron Schwartz wrote: >> >> Will changing the column to a TIMESTAMP and setting the connection's >> timezone solve this? >> > > Could work. I should not be trusting the sysadmin on this. > > It makes sense that what should be received over replication is the sql > statement and not the data, but this would appear to be coming over as the > result of the function for a datetime column type. Not the expert here but a > timestamp could transmit differently. > > I know that this would work under a direct connection from a different TZ > but I am not sure about the situation under MySQL replication. I think it should work. Give it a try and report back :-) You can create a second heartbeat table for the trial if you don't want to mess up your current monitoring. |
|
From: Baron S. <ba...@xa...> - 2008-07-09 02:04:27
|
Will changing the column to a TIMESTAMP and setting the connection's
timezone solve this?
On Tue, Jul 8, 2008 at 7:18 PM, Neil Lunn <nei...@tr...> wrote:
> Just wondering if there has ever been any consideration of this when
> monitoring replication to a slave in a different timezone.
>
> Seems to be the quick fix is to replace now() references with
> UTC_TIMESTAMP()[including UNIX_TIMESTAMP(UTC_TIMESTAMP()) but this is
> not exactly portable.
>
> Second consideration here is to use a:
>
> strftime("%Y-%m-%d %H:%M:%S",gmtime)
>
> and similar comparisons or include dependancies to other Modules to
> handle time comparisons.
>
> Thoughts?
>
> Neil
>
> -------------------------------------------------------------------------
> Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
> Studies have shown that voting for your favorite open source project,
> along with a healthy diet, reduces your potential for chronic lameness
> and boredom. Vote Now at http://www.sourceforge.net/community/cca08
> _______________________________________________
> maatkit-discuss mailing list
> maa...@li...
> https://lists.sourceforge.net/lists/listinfo/maatkit-discuss
>
--
Baron Schwartz, Consulting Team Lead, Percona Inc.
Tel: +1 888 401 3401 ext 507
24/7 Emergency Line +1 888 401 3401 ext 911
Our Services: http://www.percona.com/services.html
Our Blog: http://www.mysqlperformanceblog.com/
|
|
From: Neil L. <nei...@tr...> - 2008-07-08 23:18:46
|
Just wondering if there has ever been any consideration of this when
monitoring replication to a slave in a different timezone.
Seems to be the quick fix is to replace now() references with
UTC_TIMESTAMP()[including UNIX_TIMESTAMP(UTC_TIMESTAMP()) but this is
not exactly portable.
Second consideration here is to use a:
strftime("%Y-%m-%d %H:%M:%S",gmtime)
and similar comparisons or include dependancies to other Modules to
handle time comparisons.
Thoughts?
Neil
|
|
From: Tim M. <ti...@as...> - 2008-07-03 09:10:28
|
When I looked at the EXPLAIN output it turned out that the server was
making the wrong index choice when I had the additional entries in the
SELECT clause, i.e.
SELECT COUNT(*) FROM ...
uses the index on (`time`), but
SELECT COUNT(*), <crc_expression> FROM ...
chooses instead to use the index on (`key`). The latter hits an
estimated 48 million rows, which probably isn't too clever.
I hacked the code to put the necessary FORCE INDEX line in and it works,
albeit slowly. I may work up a patch to make this configurable as a
command-line parameter.
Thanks for your help,
Tim
Baron Schwartz wrote:
> So if you run that query by hand, it does the same thing? What does
> EXPLAIN show for the query that causes the problem? What about the
> COUNT(*) query?
>
> Please use the \G terminator so I can read the output easily , e.g.
> EXPLAIN SELECT .....\G
>
> Thanks!
> Baron
>
> On Tue, Jul 1, 2008 at 9:05 AM, Tim Martin <ti...@as...> wrote:
>> I'm trying to sync a relatively large InnoDB table with mk-table-sync.
>> It runs for a short time and then dies with the following error message:
>>
>> The total number of locks exceeds the lock table size at line 1212 while
>> doing <table_name>
>>
>> I've been able to pin this down to the checksum query on the first chunk
>> (using BIT_XOR and the chunk sync method):
>>
>> SELECT /*dbname.tablename:1/243371*/ 0 AS chunk_num, COUNT(*) AS cnt,
>> LOWER(CONCAT(LPAD(CONV(BIT_XOR(CAST(CONV(SUBSTRING(@crc, 1, 16), 16, 10)
>> AS UNSIGNED)), 10, 16), 16, '0'),
>> LPAD(CONV(BIT_XOR(CAST(CONV(SUBSTRING(@crc := MD5(CONCAT_WS('#', `key`,
>> `field1`, `field2`, `field3`, `time`)), 17, 16), 16, 10) AS UNSIGNED)),
>> 10, 16), 16, '0'))) AS crc
>> FROM `dbname`.`tablename` WHERE (`key` < 117710311) AND (`time` >
>> '2008-05-01' AND `time` <= '2008-06-01') LOCK IN SHARE MODE
>> I don't seem to get the same problem with a simplified query, e.g.
>>
>> SELECT COUNT(*)
>> FROM `dbname`.`tablename` WHERE (`key` < 117710311) AND (`time` >
>> '2008-05-01' AND `time` <= '2008-06-01') LOCK IN SHARE MODE
>>
>> returns quite quickly (the row count is 14). I'm not sure that I
>> understand what's going on here - the more complex query will obviously
>> take longer, but I don't see why it's holding any additional locks on
>> the table.
|
|
From: Tim M. <ti...@as...> - 2008-07-01 13:06:06
|
I realise this may not be specifically a maatkit problem, but I'm
grateful for any insight people on the list can provide.
I'm trying to sync a relatively large InnoDB table with mk-table-sync.
It runs for a short time and then dies with the following error message:
The total number of locks exceeds the lock table size at line 1212 while
doing <table_name>
I've been able to pin this down to the checksum query on the first chunk
(using BIT_XOR and the chunk sync method):
SELECT /*dbname.tablename:1/243371*/ 0 AS chunk_num, COUNT(*) AS cnt,
LOWER(CONCAT(LPAD(CONV(BIT_XOR(CAST(CONV(SUBSTRING(@crc, 1, 16), 16, 10)
AS UNSIGNED)), 10, 16), 16, '0'),
LPAD(CONV(BIT_XOR(CAST(CONV(SUBSTRING(@crc := MD5(CONCAT_WS('#', `key`,
`field1`, `field2`, `field3`, `time`)), 17, 16), 16, 10) AS UNSIGNED)),
10, 16), 16, '0'))) AS crc
FROM `dbname`.`tablename` WHERE (`key` < 117710311) AND (`time` >
'2008-05-01' AND `time` <= '2008-06-01') LOCK IN SHARE MODE
The restriction (`time` > '2008-05-01' AND `time` <= '2008-06-01') was
set by me from the command line, as I want to sync a particular section
of the table.
I don't seem to get the same problem with a simplified query, e.g.
SELECT COUNT(*)
FROM `dbname`.`tablename` WHERE (`key` < 117710311) AND (`time` >
'2008-05-01' AND `time` <= '2008-06-01') LOCK IN SHARE MODE
returns quite quickly (the row count is 14). I'm not sure that I
understand what's going on here - the more complex query will obviously
take longer, but I don't see why it's holding any additional locks on
the table.
Tim
|
|
From: Olaf S. <ola...@na...> - 2008-06-26 14:08:46
|
Hi All, I sent this yesterday already, I am not just including one more thing: I am having some issues with mk-table-checksum. I get this error when using it on some of my databases: DBD::mysql::db selectrow_hashref failed: fetch() without execute() at /usr/bin/mk-table-checksum line 1485. Which is this line in the code: my $href = $dbh->selectrow_hashref($sql); The SQL statement is "show create table [tablename]". As it seemed that this is random I broke the selectrow_hashref up and now I am getting this message from the execute statement: DBD::mysql::st execute failed: Got packet bigger than 'max_allowed_packet' bytes at /usr/bin/mk-table-checksum line 1491. The smallest table I found where this happens has 176 columns and pretty long column names, another table with 186 columns and short column names works fine. My max_allowed_packet is set to 128M, which should be plenty, I tried higher values anyway and it makes no difference. Can anyone point me in the right direction? Thanks Olaf ------------------------- Olaf Stein DBA Battelle Center for Mathematical Medicine Nationwide Children's Hospital, The Research Institute 700 Children's Drive phone: 1-614-355-5685 cell: 1-614-843-0432 email: ola...@na... ----------------------------------------- Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. |
|
From: Olaf S. <ola...@na...> - 2008-06-25 13:30:33
|
Hi All, Sorry for sending this again but it said I am not a member with the first email and I did sign up. I am having some issues with mk-table-checksum. I get this error when using it on some of my databases: DBD::mysql::db selectrow_hashref failed: fetch() without execute() at /usr/bin/mk-table-checksum line 1485. Which is this line in the code: my $href = $dbh->selectrow_hashref($sql); As it seemed that this is random I broke the selectrow_hashref up and now I am getting this message from the execute statement: DBD::mysql::st execute failed: Got packet bigger than 'max_allowed_packet' bytes at /usr/bin/mk-table-checksum line 1491. The smallest table I found where this happens has 176 columns and pretty long column names, another table with 186 columns and short column names works fine. My max_allowed_packet is set to 128M, which should be plenty, I tried higher values anyway and it makes no difference. Can anyone point me in the right direction? Thanks Olaf ------------------------- Olaf Stein DBA Battelle Center for Mathematical Medicine Nationwide Children's Hospital, The Research Institute 700 Children's Drive phone: 1-614-355-5685 cell: 1-614-843-0432 email: ola...@na... ----------------------------------------- Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. |
|
From: Olaf S. <ola...@na...> - 2008-06-25 13:16:13
|
Hi All, I am having some issues with mk-table-checksum. I get this error when using it on some of my databases: DBD::mysql::db selectrow_hashref failed: fetch() without execute() at /usr/bin/mk-table-checksum line 1485. Which is this line in the code: my $href = $dbh->selectrow_hashref($sql); As it seemed that this is random I broke the selectrow_hashref up and now I am getting this message from the execute statement: DBD::mysql::st execute failed: Got packet bigger than 'max_allowed_packet' bytes at /usr/bin/mk-table-checksum line 1491. The smallest table I found where this happens has 176 columns and pretty long column names, another table with 186 columns and short column names works fine. My max_allowed_packet is set to 128M, which should be plenty, I tried higher values anyway and it makes no difference. Can anyone point me in the right direction? Thanks Olaf ----------------------------------------- Confidentiality Notice: The following mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. The recipient is responsible to maintain the confidentiality of this information and to use the information only for authorized purposes. If you are not the intended recipient (or authorized to receive information for the intended recipient), you are hereby notified that any review, use, disclosure, distribution, copying, printing, or action taken in reliance on the contents of this e-mail is strictly prohibited. If you have received this communication in error, please notify us immediately by reply e-mail and destroy all copies of the original message. Thank you. |
|
From: Tim M. <ti...@as...> - 2008-06-25 12:54:09
|
Hi all, First of all, my thanks to all contributors on mk-table-sync, it's an extremely useful script! I think I've spotted a flaw in it when using it on a table with an index on substrings of columns - the column names get split down incorrectly and it gives an error message "No such column '(100),'". The problem is that e.g. if the key definition is `surname`(20),`firstname`(20) it first of all splits on "`", which leaves "(20)," as a bogus entry in the list. I've attached a patch that seems to work well enough to get me working again, in case it's useful to anyone. I'm no perl programmer though, so I wouldn't trust my code. Tim |
|
From: Baron S. <ba...@xa...> - 2008-06-02 04:42:33
|
This release is a bugfix and maintenance release. Many of the changes are minor tweaks to shared code. I've also partially moved to a new documentation system that will ensure the embedded documentation is authoritative and accurate. You can download Maatkit at http://sourceforge.net/project/showfiles.php?group_id=189154 Also, Maatkit has a new website, in case you haven't seen: http://www.maatkit.org/ You can nominate Maatkit for Sourceforge.net project of the year! Just click on this link: http://sourceforge.net/awards/cca/?group_id=189154 Changelog for mk-archiver: 2008-06-02: version 1.0.9 * Updated common code. Changelog for mk-deadlock-logger: 2008-06-02: version 1.0.10 * Generate command-line options from POD. Changelog for mk-duplicate-key-checker: 2008-06-02: version 1.1.6 * Updated common code. Changelog for mk-find: 2008-06-02: version 0.9.11 * Updated common code. Changelog for mk-heartbeat: 2008-06-02: version 1.0.9 * Get command-line options from POD. * --check output contained leading whitespace which broke Cacti. Changelog for mk-parallel-dump: 2008-06-02: version 1.0.8 * System commands did not use double quotes on Windows (bug #1949922). * Added --stopslave to run STOP SLAVE during the dump (bug #1923627). * --ignoreengine worked only when --tab was specified (bug #1851461). Changelog for mk-parallel-restore: 2008-06-02: version 1.0.7 * .trg files were sometimes rejected from loading. * Command-line options are generated from the POD. Changelog for mk-query-profiler: 2008-06-02: version 1.1.10 * Generate command-line options from POD. Changelog for mk-show-grants: 2008-06-02: version 1.0.10 * Create command-line options from POD. Changelog for mk-slave-delay: 2008-06-02: version 1.0.7 * Updated the documentation to use POD. * The slave could wait forever if the I/O thread was stopped. * The slave could wait forever on the master's last event (bug #1959496). Changelog for mk-slave-find: 2008-06-02: version 1.0.1 * Updated common code. Changelog for mk-slave-move: 2008-06-02: version 0.9.1 * Command-line parsing was removing an expected DSN (bug #1960142). * The slave was not stopped before CHANGE MASTER TO (bug #1960142). * DSNs without a port caused a crash (bug #1960142). * Converted to use POD for command-line options. Changelog for mk-slave-prefetch: 2008-06-02: version 1.0.2 * Add the --progress option. * Add more error reporting and the --errors option. * Abstract USE queries when fingerprinting them. * mysqlbinlog errors were not detected. * Handle queries of the form INSERT ... VALUE(). * Strip comments from queries when normalizing them. Changelog for mk-slave-restart: 2008-06-02: version 1.0.7 * Updated common code. Changelog for mk-table-checksum: 2008-06-02: version 1.1.27 * Update documentation, generate command-line options from POD. * Added --trim to compare pre-5.0 and 5.0+ VARCHAR values consistently. Changelog for mk-table-sync: 2008-06-02: version 1.0.7 * Added NO_AUTO_VALUE_ON_ZERO to @@SQL_MODE (bug #1919897). * Added --trim to compare pre-5.0 and 5.0+ VARCHAR values consistently. Changelog for mk-visual-explain: 2008-06-02: version 1.0.8 * Updated common code. -- Baron Schwartz, Consulting Team Lead, Percona Inc. Tel: +1 888 401 3401 ext 507 24/7 Emergency Line +1 888 401 3401 ext 911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/ |
|
From: Baron S. <ba...@xa...> - 2008-05-16 03:10:28
|
Hi Kenny, I lost your email because you replied to me off-list :-) tsk, tsk. I'm not sure when I'll get to it -- hopefully soon, but it might take a little bit. Regards Baron On Wed, May 14, 2008 at 5:47 AM, Kenny Gryp <ke...@ne...> wrote: > Baron, > > Thanks for the reply. > > I have filed a bug report #1960142 for the first problem some days ago. > > Can you have a look? > > Kind Regards, > > Kenny Gryp > -- System/Network/Database Engineer > > NETLOG NV > Emile Braunplein 18 > B-9000 Gent > http://corporate.netlog.com/ > Tel +32 2 400 43 21 > Fax +32 2 400 43 20 > > ke...@ne... > http://netlog.com/gryp > GSM +32 476 780 692 > > On 06 May 2008, at 03:07, Baron Schwartz wrote: > >> You have found two separate bugs and I have fixed one of them in the >> source code already. Please file a bug report on the uninitialized >> string, with as much information about the server as you possibly can. >> Please comment out these lines in the source code with hash # signs >> to fix the second bug you found, and re-run with MKDEBUG=1 to gather >> info on the first bug: >> >> 1321 # { s => 'resume|R', >> 1322 # d => 'Resume replication after moving the slave' }, >> >> Regards >> Baron >> >> On Mon, May 5, 2008 at 11:47 AM, Kenny Gryp <ke...@ne...> wrote: >>> >>> Hi, >>> >>> I'm trying to use the new script mk-slave-move, but I get errors while >>> running it. >>> >>> ./mk-slave-move --slave-of-uncle h=unclehost,D=db,u=root,p=**** >>> h=currentslavethatneedstobechanged,D=db,u=root,p=**** >>> h=originalmasterhost,D=db,u=root,p=**** >>> === >>> Use of uninitialized value in concatenation (.) or string at ./mk- >>> slave-move line 1087. >>> >>> === >>> Running it with MKDEBUG I get something totally different >>> >>> # /usr/bin/perl 5.008008 >>> # Linux monitor01 2.6.24.2-x850-incrowd #1 SMP Mon Mar 10 12:11:52 CET >>> 2008 x86_64 GNU/Linux >>> # ./mk-slave-move Ver 0.9.0 Distrib 1877 Changeset 1874 line 514 >>> # OptionParser:126 20260 Option setvars has a default >>> # OptionParser:116 20260 Option slave-of-sibling type: d >>> # OptionParser:116 20260 Option slave-of-uncle type: d >>> # OptionParser:116 20260 Option m type: m >>> # OptionParser:126 20260 Option m has a default >>> # OptionParser:228 20260 Participants for Specify one and only one of >>> --sibling-of-master, --slave-of-sibling, --slave-of-uncle, or -- >>> detach: sibling-of-masterslave-of-siblingslave-of-uncledetach >>> # OptionParser:142 20260 sibling-of-masterslave-of-siblingslave-of- >>> uncledetach are mutually exclusive >>> # OptionParser:146 20260 sibling-of-masterslave-of-siblingslave-of- >>> uncledetach require at least one >>> The following command-line options are unused: R The following are >>> undefined: at ./mk-slave-move line 185. >>> >>> Any idea what I am doing wrong? >>> I'm getting different results with both with and without debug. The >>> manual isn't that clear to me. >>> >>> >>> Kenny Gryp >>> -- >>> System/Network/Database Engineer >>> >>> NETLOG NV >>> Emile Braunplein 18 >>> B-9000 Gent >>> http://corporate.netlog.com/ >>> Tel +32 2 400 43 21 >>> Fax +32 2 400 43 20 >>> >>> ke...@ne... >>> http://netlog.com/gryp >>> GSM +32 476 780 692 >>> >>> >>> ------------------------------------------------------------------------- >>> This SF.net email is sponsored by the 2008 JavaOne(SM) Conference >>> Don't miss this year's exciting event. There's still time to save $100. >>> Use priority code J8TL2D2. >>> >>> http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone >>> _______________________________________________ >>> maatkit-discuss mailing list >>> maa...@li... >>> https://lists.sourceforge.net/lists/listinfo/maatkit-discuss >>> >> >> >> >> -- >> >> Baron Schwartz, Senior Consultant, Percona Inc. >> Tel: +1 888 401 3401 ext 507 >> 24/7 Emergency Line +1 888 401 3401 ext 911 >> Our Services: http://www.percona.com/services.html >> Our Blog: http://www.mysqlperformanceblog.com/ > > -- Baron Schwartz, Senior Consultant, Percona Inc. Tel: +1 888 401 3401 ext 507 24/7 Emergency Line +1 888 401 3401 ext 911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/ |
|
From: Karanbir S. <mai...@ka...> - 2008-05-07 15:17:18
|
hi guys. I am in the process of getting maatkit into the CentOS-Extras repositories. The first step for that is that every package needs to go into a CentOS-Testing repo and feedback is required from the project and users on its stability / usability and packaging quality. maatkit-1887 is now available in the CentOS-Testing[*] repo's and as soon as we can get some feedback ( needs to be 5 different people, none of whom can be CentOS Developers ) - the packages will move into the main repository so that all users can get access. I'd appreciate it if people on this were able to give those packages a go and let me know if there are any issues. You can leave feedback : - here on this list or - on the centos-devel list ( http://lists.centos.org ) or - http://bugs.centos.org/ against category 'maatkit' Regards, - KB *] : Info about the Testing repo and howto set it up on your machine : http://wiki.centos.org/Repositories -- Karanbir Singh : http://www.karan.org/ : 2522219@icq |
|
From: Kenny G. <ke...@ne...> - 2008-05-05 15:47:58
|
Hi, I'm trying to use the new script mk-slave-move, but I get errors while running it. ./mk-slave-move --slave-of-uncle h=unclehost,D=db,u=root,p=**** h=currentslavethatneedstobechanged,D=db,u=root,p=**** h=originalmasterhost,D=db,u=root,p=**** === Use of uninitialized value in concatenation (.) or string at ./mk- slave-move line 1087. === Running it with MKDEBUG I get something totally different # /usr/bin/perl 5.008008 # Linux monitor01 2.6.24.2-x850-incrowd #1 SMP Mon Mar 10 12:11:52 CET 2008 x86_64 GNU/Linux # ./mk-slave-move Ver 0.9.0 Distrib 1877 Changeset 1874 line 514 # OptionParser:126 20260 Option setvars has a default # OptionParser:116 20260 Option slave-of-sibling type: d # OptionParser:116 20260 Option slave-of-uncle type: d # OptionParser:116 20260 Option m type: m # OptionParser:126 20260 Option m has a default # OptionParser:228 20260 Participants for Specify one and only one of --sibling-of-master, --slave-of-sibling, --slave-of-uncle, or -- detach: sibling-of-masterslave-of-siblingslave-of-uncledetach # OptionParser:142 20260 sibling-of-masterslave-of-siblingslave-of- uncledetach are mutually exclusive # OptionParser:146 20260 sibling-of-masterslave-of-siblingslave-of- uncledetach require at least one The following command-line options are unused: R The following are undefined: at ./mk-slave-move line 185. Any idea what I am doing wrong? I'm getting different results with both with and without debug. The manual isn't that clear to me. Kenny Gryp -- System/Network/Database Engineer NETLOG NV Emile Braunplein 18 B-9000 Gent http://corporate.netlog.com/ Tel +32 2 400 43 21 Fax +32 2 400 43 20 ke...@ne... http://netlog.com/gryp GSM +32 476 780 692 |
|
From: Baron S. <ba...@pe...> - 2008-04-21 18:43:30
|
> Hi Baron > > The command mk-slave-restart says slave restart. if i need to restart slave > is it through > mysql -u root -p test -e "slave stop" > mysql -u root -p test -e "slave start" The tool should be restarting the slave for you if needed. I don't understand what you need help with. Can you clarify please? Baron -- Baron Schwartz, Senior Consultant, Percona Inc. Tel: +1 888 401 3401 ext 507 24/7 Emergency Line +1 888 401 3401 ext 911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/ |
|
From: Kaushal S. <kau...@gm...> - 2008-04-21 17:02:07
|
any updates
---------- Forwarded message ----------
From: Kaushal Shriyan <kau...@gm...>
Date: Mon, Apr 21, 2008 at 5:34 PM
Subject: mk-slave-restart
To: maa...@li...
Hi ,
when i run the command MKDEBUG=1 mk-slave-restart -u replication -p slave2
-h 10.0.0.1.The details are as below:- it keeps on saying
# MasterSlave:962 14713 SHOW SLAVE STATUS
# MasterSlave:962 14713 SHOW SLAVE STATUS
vhost-02 mysql # MKDEBUG=1 mk-slave-restart -u replication -p slave2 -h
10.0.0.1
# /usr/bin/perl5.8.8 5.008008
# Linux vhost-0095-02 2.6.20-xen-r3 #2 SMP Wed Oct 31 05:41:34 Local time
zone must be set--see zic x86_64 Dual-Core AMD Opteron(tm) Processor 2212 HE
AuthenticAMD GNU/Linux
# /usr/bin/mk-slave-restart Ver 1.0.6 Distrib 1877 Changeset 1871 line 515
# OptionParser:117 14713 Option e type: h
# OptionParser:127 14713 Option M has a default
# OptionParser:127 14713 Option m has a default
# OptionParser:127 14713 Option r has a default
# OptionParser:127 14713 Option sentinel has a default
# OptionParser:127 14713 Option setvars has a default
# OptionParser:127 14713 Option k has a default
# OptionParser:127 14713 Option s has a default
# OptionParser:117 14713 Option t type: m
# OptionParser:127 14713 Option v has a default
# OptionParser:349 14713 Treating option e as a list
# OptionParser:349 14713 Treating option t as a list
# DSNParser:638 14713 Setting setvars property
# DSNParser:730 14713
DBI:mysql:;host=10.10.50.41;mysql_read_default_group=mysql
# DSNParser:745 14713
DBI:mysql:;host=10.10.50.41;mysql_read_default_group=mysql replication
slave2 {mysql_enable_utf8=>0, AutoCommit=>1, RaiseError=>1, PrintError=>0}
# DSNParser:763 14713 DBI::db=HASH(0xb40da0): SET wait_timeout=10000
# DSNParser:766 14713 DBH info: DBI::db=HASH(0xb40da0)$VAR1 = {'@@hostname'
=> 'vhost-0094-02','VERSION()' => '5.0.54-log','DATABASE()' =>
undef,'CONNECTION_ID()' => '227'}; Connection info: 10.10.50.41 via TCP/IP
Character set info: $VAR1 = [{Value => 'utf8',Variable_name =>
'character_set_client'},{Value => 'utf8',Variable_name =>
'character_set_connection'},{Value => 'utf8',Variable_name =>
'character_set_database'},{Value => 'binary',Variable_name =>
'character_set_filesystem'},{Value => 'utf8',Variable_name =>
'character_set_results'},{Value => 'utf8',Variable_name =>
'character_set_server'},{Value => 'utf8',Variable_name =>
'character_set_system'},{Value => '/usr/share/mysql/charsets/',Variable_name
=> 'character_sets_dir'}]; $DBD::mysql::VERSION: 4.005 $DBI::VERSION: 1.55
# MasterSlave:843 14713 Connected to h=10.10.50.41,p=...,u=replication
# MasterSlave:851 14713 SELECT @@SERVER_ID
# MasterSlave:853 14713 Working on server ID 1
# MasterSlave:962 14713 SHOW SLAVE STATUS
# main:1563 Watching server h=10.0.0.1,p=...,u=replication forked=
# VersionParser:542 14713 5.0.54-log parses to 005000054
# VersionParser:542 14713 4.0.5 parses to 004000005
# VersionParser:553 14713 005000054 ge 4.0.5: 1
# MasterSlave:962 14713 SHOW SLAVE STATUS
# MasterSlave:962 14713 SHOW SLAVE STATUS
# MasterSlave:962 14713 SHOW SLAVE STATUS
# MasterSlave:962 14713 SHOW SLAVE STATUS
Am i missing something
Thanks and Regards
Kaushal
|
|
From: Kaushal S. <kau...@gm...> - 2008-04-21 12:04:59
|
Hi ,
when i run the command MKDEBUG=1 mk-slave-restart -u replication -p slave2
-h 10.0.0.1.The details are as below:- it keeps on saying
# MasterSlave:962 14713 SHOW SLAVE STATUS
# MasterSlave:962 14713 SHOW SLAVE STATUS
vhost-02 mysql # MKDEBUG=1 mk-slave-restart -u replication -p slave2 -h
10.0.0.1
# /usr/bin/perl5.8.8 5.008008
# Linux vhost-0095-02 2.6.20-xen-r3 #2 SMP Wed Oct 31 05:41:34 Local time
zone must be set--see zic x86_64 Dual-Core AMD Opteron(tm) Processor 2212 HE
AuthenticAMD GNU/Linux
# /usr/bin/mk-slave-restart Ver 1.0.6 Distrib 1877 Changeset 1871 line 515
# OptionParser:117 14713 Option e type: h
# OptionParser:127 14713 Option M has a default
# OptionParser:127 14713 Option m has a default
# OptionParser:127 14713 Option r has a default
# OptionParser:127 14713 Option sentinel has a default
# OptionParser:127 14713 Option setvars has a default
# OptionParser:127 14713 Option k has a default
# OptionParser:127 14713 Option s has a default
# OptionParser:117 14713 Option t type: m
# OptionParser:127 14713 Option v has a default
# OptionParser:349 14713 Treating option e as a list
# OptionParser:349 14713 Treating option t as a list
# DSNParser:638 14713 Setting setvars property
# DSNParser:730 14713
DBI:mysql:;host=10.10.50.41;mysql_read_default_group=mysql
# DSNParser:745 14713
DBI:mysql:;host=10.10.50.41;mysql_read_default_group=mysql replication
slave2 {mysql_enable_utf8=>0, AutoCommit=>1, RaiseError=>1, PrintError=>0}
# DSNParser:763 14713 DBI::db=HASH(0xb40da0): SET wait_timeout=10000
# DSNParser:766 14713 DBH info: DBI::db=HASH(0xb40da0)$VAR1 = {'@@hostname'
=> 'vhost-0094-02','VERSION()' => '5.0.54-log','DATABASE()' =>
undef,'CONNECTION_ID()' => '227'}; Connection info: 10.10.50.41 via TCP/IP
Character set info: $VAR1 = [{Value => 'utf8',Variable_name =>
'character_set_client'},{Value => 'utf8',Variable_name =>
'character_set_connection'},{Value => 'utf8',Variable_name =>
'character_set_database'},{Value => 'binary',Variable_name =>
'character_set_filesystem'},{Value => 'utf8',Variable_name =>
'character_set_results'},{Value => 'utf8',Variable_name =>
'character_set_server'},{Value => 'utf8',Variable_name =>
'character_set_system'},{Value => '/usr/share/mysql/charsets/',Variable_name
=> 'character_sets_dir'}]; $DBD::mysql::VERSION: 4.005 $DBI::VERSION: 1.55
# MasterSlave:843 14713 Connected to h=10.10.50.41,p=...,u=replication
# MasterSlave:851 14713 SELECT @@SERVER_ID
# MasterSlave:853 14713 Working on server ID 1
# MasterSlave:962 14713 SHOW SLAVE STATUS
# main:1563 Watching server h=10.0.0.1,p=...,u=replication forked=
# VersionParser:542 14713 5.0.54-log parses to 005000054
# VersionParser:542 14713 4.0.5 parses to 004000005
# VersionParser:553 14713 005000054 ge 4.0.5: 1
# MasterSlave:962 14713 SHOW SLAVE STATUS
# MasterSlave:962 14713 SHOW SLAVE STATUS
# MasterSlave:962 14713 SHOW SLAVE STATUS
# MasterSlave:962 14713 SHOW SLAVE STATUS
Am i missing something
Thanks and Regards
Kaushal
|
|
From: Kaushal S. <kau...@gm...> - 2008-04-21 08:34:05
|
On Sat, Apr 19, 2008 at 4:40 AM, Baron Schwartz <ba...@pe...> wrote: > Yes. You do not have the PROCESS privilege on the MySQL server. The > user you're connecting as needs it. Use GRANT to add it. > > Baron > > On Fri, Apr 18, 2008 at 4:27 AM, Kaushal Shriyan > <kau...@gm...> wrote: > > Hi > > > > when i run the below command I get the below information. > > > > #mk-slave-find -u root -p test > > You do not have the PROCESS privilege at /usr/bin/mk-slave-find line > 808. > > > > Am i missing something > > > > Thanks and Regards > > > > Kaushal > > > > > > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by the 2008 JavaOne(SM) Conference > > Don't miss this year's exciting event. There's still time to save $100. > > Use priority code J8TL2D2. > > > > > http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone > > _______________________________________________ > > maatkit-discuss mailing list > > maa...@li... > > https://lists.sourceforge.net/lists/listinfo/maatkit-discuss > > > > > > > > -- > > Baron Schwartz, Senior Consultant, Percona Inc. > Tel: +1 888 401 3401 ext 507 > 24/7 Emergency Line +1 888 401 3401 ext 911 > Our Services: http://www.percona.com/services.html > Our Blog: http://www.mysqlperformanceblog.com/ > Hi Baron #MKDEBUG=1 mk-slave-find -u root -p test ################################################################################################ # /usr/bin/perl5.8.8 5.008008 # Linux host-00-01 2.6.20-xen-r3 #2 SMP Wed Oct 31 05:41:34 Local time zone must be set--see zic x86_64 Dual-Core AMD Opteron(tm) Processor 2212 HE AuthenticAMD GNU/Linux # /usr/bin/mk-slave-find Ver 1.0.0 Distrib 1877 Changeset 1874 line 471 # OptionParser:83 10832 Option print has a default # OptionParser:83 10832 Option setvars has a default # DSNParser:550 10832 Setting setvars property # DSNParser:642 10832 DBI:mysql:;;mysql_read_default_group=mysql # DSNParser:657 10832 DBI:mysql:;;mysql_read_default_group=mysql root test {mysql_enable_utf8=>0, AutoCommit=>1, RaiseError=>1, PrintError=>0} # DSNParser:675 10832 DBI::db=HASH(0xa3d210): SET wait_timeout=10000 # DSNParser:678 10832 DBH info: DBI::db=HASH(0xa3d210)$VAR1 = {'@@hostname' => 'vhost-0094-02','VERSION()' => '5.0.54-log','DATABASE()' => undef,'CONNECTION_ID()' => '47'}; Connection info: Localhost via UNIX socket Character set info: $VAR1 = [{Value => 'utf8',Variable_name => 'character_set_client'},{Value => 'utf8',Variable_name => 'character_set_connection'},{Value => 'utf8',Variable_name => 'character_set_database'},{Value => 'binary',Variable_name => 'character_set_filesystem'},{Value => 'utf8',Variable_name => 'character_set_results'},{Value => 'utf8',Variable_name => 'character_set_server'},{Value => 'utf8',Variable_name => 'character_set_system'},{Value => '/usr/share/mysql/charsets/',Variable_name => 'character_sets_dir'}]; $DBD::mysql::VERSION: 4.005 $DBI::VERSION: 1.55 # MasterSlave:755 10832 Connected to p=...,u=root # MasterSlave:763 10832 SELECT @@SERVER_ID # MasterSlave:765 10832 Working on server ID 1 # MasterSlave:798 10832 Looking for slaves on p=...,u=root # MasterSlave:812 10832 SHOW PROCESSLIST # DSNParser:562 10832 Parsing h=10.0.0.2 # DSNParser:573 10832 Finding value for A # DSNParser:581 10832 Copying value for A from defaults # DSNParser:573 10832 Finding value for F # DSNParser:581 10832 Copying value for F from defaults # DSNParser:573 10832 Finding value for S # DSNParser:581 10832 Copying value for S from defaults # DSNParser:573 10832 Finding value for u # DSNParser:577 10832 Copying value for u from previous DSN # DSNParser:573 10832 Finding value for p # DSNParser:577 10832 Copying value for p from previous DSN # DSNParser:573 10832 Finding value for h # DSNParser:573 10832 Finding value for D # DSNParser:581 10832 Copying value for D from defaults # DSNParser:573 10832 Finding value for P # DSNParser:581 10832 Copying value for P from defaults # MasterSlave:858 10832 Found 1 slaves # MasterSlave:787 10832 Recursing from p=...,u=root to h=10.0.0.2 ,p=...,u=root # DSNParser:642 10832 DBI:mysql:;host=10.0.0.2;mysql_read_default_group=mysql # DSNParser:657 10832 DBI:mysql:;host=10.0.0.2;mysql_read_default_group=mysql root test {mysql_enable_utf8=>0, AutoCommit=>1, RaiseError=>1, PrintError=>0} # DSNParser:675 10832 DBI::db=HASH(0xa1ed20): SET wait_timeout=10000 # DSNParser:678 10832 DBH info: DBI::db=HASH(0xa1ed20)$VAR1 = {'@@hostname' => 'vhost-0095-02','VERSION()' => '5.0.54-log','DATABASE()' => undef,'CONNECTION_ID()' => '59'}; Connection info: 10.0.0.2 via TCP/IP Character set info: $VAR1 = [{Value => 'utf8',Variable_name => 'character_set_client'},{Value => 'utf8',Variable_name => 'character_set_connection'},{Value => 'utf8',Variable_name => 'character_set_database'},{Value => 'binary',Variable_name => 'character_set_filesystem'},{Value => 'utf8',Variable_name => 'character_set_results'},{Value => 'utf8',Variable_name => 'character_set_server'},{Value => 'utf8',Variable_name => 'character_set_system'},{Value => '/usr/share/mysql/charsets/',Variable_name => 'character_sets_dir'}]; $DBD::mysql::VERSION: 4.005 $DBI::VERSION: 1.55 # MasterSlave:755 10832 Connected to h=10.0.0.2,p=...,u=root # MasterSlave:763 10832 SELECT @@SERVER_ID # MasterSlave:765 10832 Working on server ID 2 # MasterSlave:798 10832 Looking for slaves on h=10.0.0.2,p=...,u=root # MasterSlave:812 10832 SHOW PROCESSLIST # MasterSlave:838 10832 SHOW SLAVE HOSTS DBD::mysql::db selectall_arrayref failed: Access denied; you need the REPLICATION SLAVE privilege for this operation at /usr/bin/mk-slave-find line 839. ################################################################################################ when i see mk-show-grants #mk-show-grants -u root -h localhost -p test -D SMSWEB | grep "REPLICATION" GRANT REPLICATION SLAVE, SUPER ON *.* TO 'replication'@'10.0.0.2' IDENTIFIED BY PASSWORD '*51125B3597BEE0FC43E0BCBFEE002EF8641B44CF'; Am I missing something Thanks and Regards Kaushal |
|
From: Kaushal S. <kau...@gm...> - 2008-04-21 08:31:05
|
On Sat, Apr 19, 2008 at 4:44 AM, Baron Schwartz <ba...@pe...> wrote: > Hi, > > On Fri, Apr 18, 2008 at 6:53 AM, Kaushal Shriyan > <kau...@gm...> wrote: > > > > On Fri, Apr 18, 2008 at 5:03 PM, Kaushal Shriyan < > kau...@gm...> > > wrote: > > > > > Hi, > > > > > > when i run the below command, I believe it works, but how will i come > to > > know the MySQL Slave has been restarted. > > > > > > mk-slave-restart -u root -p test -h 192.168.0.2 > > > > > > Thanks and Regards > > > > > > Kaushal > > > > > > > > > > > > > Hi again > > > > I could see the restart in tail -f /var/log/mysql/mysqld.err file while > > doing slave stop and slave start at mysql> prompt,but when i use > > mk-slave-restart -u root -p test -h localhost --verbose. it gets hung. > > > > Define "gets hung." If you need to debug, use MKDEBUG=1 > mk-slave-restart... > > -- > > Baron Schwartz, Senior Consultant, Percona Inc. > Tel: +1 888 401 3401 ext 507 > 24/7 Emergency Line +1 888 401 3401 ext 911 > Our Services: http://www.percona.com/services.html > Our Blog: http://www.mysqlperformanceblog.com/ > Hi Baron when i do #MKDEBUG=1 mk-slave-restart -u root -p test -h 10.0.0.2 ################################################################################################ # /usr/bin/perl5.8.8 5.008008 # Linux host-00-01 2.6.20-xen-r3 #2 SMP Wed Oct 31 05:41:34 Local time zone must be set--see zic x86_64 Dual-Core AMD Opteron(tm) Processor 2212 HE AuthenticAMD GNU/Linux # /usr/bin/mk-slave-restart Ver 1.0.6 Distrib 1877 Changeset 1871 line 515 # OptionParser:117 10915 Option e type: h # OptionParser:127 10915 Option M has a default # OptionParser:127 10915 Option m has a default # OptionParser:127 10915 Option r has a default # OptionParser:127 10915 Option sentinel has a default # OptionParser:127 10915 Option setvars has a default # OptionParser:127 10915 Option k has a default # OptionParser:127 10915 Option s has a default # OptionParser:117 10915 Option t type: m # OptionParser:127 10915 Option v has a default # OptionParser:349 10915 Treating option e as a list # OptionParser:349 10915 Treating option t as a list # DSNParser:638 10915 Setting setvars property # DSNParser:730 10915 DBI:mysql:;host=10.0.0.2;mysql_read_default_group=mysql # DSNParser:745 10915 DBI:mysql:;host=10.0.0.2;mysql_read_default_group=mysql root test {mysql_enable_utf8=>0, AutoCommit=>1, RaiseError=>1, PrintError=>0} # DSNParser:763 10915 DBI::db=HASH(0xb40d20): SET wait_timeout=10000 # DSNParser:766 10915 DBH info: DBI::db=HASH(0xb40d20)$VAR1 = {'@@hostname' => 'vhost-0095-02','VERSION()' => '5.0.54-log','DATABASE()' => undef,'CONNECTION_ID()' => '64'}; Connection info: 10.0.0.2 via TCP/IP Character set info: $VAR1 = [{Value => 'utf8',Variable_name => 'character_set_client'},{Value => 'utf8',Variable_name => 'character_set_connection'},{Value => 'utf8',Variable_name => 'character_set_database'},{Value => 'binary',Variable_name => 'character_set_filesystem'},{Value => 'utf8',Variable_name => 'character_set_results'},{Value => 'utf8',Variable_name => 'character_set_server'},{Value => 'utf8',Variable_name => 'character_set_system'},{Value => '/usr/share/mysql/charsets/',Variable_name => 'character_sets_dir'}]; $DBD::mysql::VERSION: 4.005 $DBI::VERSION: 1.55 # MasterSlave:843 10915 Connected to h=10.0.0.2,p=...,u=root # MasterSlave:851 10915 SELECT @@SERVER_ID # MasterSlave:853 10915 Working on server ID 2 # MasterSlave:962 10915 SHOW SLAVE STATUS # main:1512 Not watching h=10.0.0.2,p=...,u=root because DBD::mysql::st execute failed: Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation at /usr/bin/mk-slave-restart line 963. # main:1543 Child PIDs: # Active dbh: DBI::db=HASH(0xb40d20) Use of uninitialized value in string eq at /usr/bin/mk-slave-restart line 799. ~ # ################################################################################################ when i do a mk-show-grants, I am able to see the privilege #mk-show-grants -u root -h localhost -p test -D SMSWEB | grep "REPLICATION" GRANT REPLICATION SLAVE, SUPER ON *.* TO 'replication'@'10.0.0.2' IDENTIFIED BY PASSWORD '*51125B3597BEE0FC43E0BCBFEE002EF8641B44CF'; am i missing something Thanks and Regards Kaushal |
|
From: Kaushal S. <kau...@gm...> - 2008-04-18 13:53:29
|
On Fri, Apr 18, 2008 at 5:03 PM, Kaushal Shriyan <kau...@gm...> wrote: > Hi, > > when i run the below command, I believe it works, but how will i come to > know the MySQL Slave has been restarted. > > > > mk-slave-restart -u root -p test -h 192.168.0.2 > > Thanks and Regards > > Kaushal > > > Hi again I could see the restart in tail -f /var/log/mysql/mysqld.err file while doing slave stop and slave start at mysql> prompt,but when i use mk-slave-restart -u root -p test -h localhost --verbose. it gets hung. Any clue # mk-slave-restart -u root -p test -h localhost Exiting on SIGINT. # Thanks and Regards Kaushal |
|
From: Kaushal S. <kau...@gm...> - 2008-04-18 11:33:36
|
Hi, when i run the below command, I believe it works, but how will i come to know the MySQL Slave has been restarted. mk-slave-restart -u root -p test -h 192.168.0.2 Thanks and Regards Kaushal |
|
From: Kaushal S. <kau...@gm...> - 2008-04-18 11:29:51
|
Hi, when i run the below command, it goes on indefinetly, I mean it does not come to the # prompt #mk-heartbeat -u root -p test -D ABCWEB --update -h localhost Am i missing something Thanks and Regards Kaushal |
|
From: Kaushal S. <kau...@gm...> - 2008-04-18 11:27:53
|
Hi when i run the below command I get the below information. #mk-slave-find -u root -p test You do not have the PROCESS privilege at /usr/bin/mk-slave-find line 808. Am i missing something Thanks and Regards Kaushal |
|
From: Kaushal S. <kau...@gm...> - 2008-04-17 10:53:05
|
Hi
when i run mk-table-checksum h=10.1.0.41,u=root,p=test h=localhost
--databases=ABCWEB {where h=10.1.0.41 is master server}
I get
DBI connect(';host=10.1.0.41;mysql_read_default_group=mysql','root',...)
failed: Access denied for user 'root'@'10.10.50.42' (using password: YES) at
/usr/bin/mk-table-checksum line 1139
Am i missing something
Thanks and Regards
Kaushal
|
|
From: Dane M. <da...@gr...> - 2008-04-07 17:46:09
|
Baron Schwartz wrote: > Thanks! Would you mind also submitting a bug report to add a pid file > to all of the daemonize-able tools in Maatkit? Done. Bug request ID is 1936942. Dane |
