MySQL Performance: MySQL => microslow patch for mysql-5.0.54

Members

Help

Home

Home » Performance » MySQL » microslow patch for mysql-5.0.54

Show: Today's Messages :: Show Polls :: Message Navigator

microslow patch for mysql-5.0.54 [message #2595]

Wed, 06 February 2008 01:47

ilys
Messages: 11
Registered: December 2007

Junior Member

Hi,

When will come new microslow patch for mysql-5.0.54?

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #2817 is a reply to message #2595 ]

Mon, 31 March 2008 04:38

ilys
Messages: 11
Registered: December 2007

Junior Member

Please answer - when?

And why already didn't released?

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #2823 is a reply to message #2595 ]

Tue, 01 April 2008 06:41

debug
Messages: 122
Registered: March 2008

Senior Member

You can find it here: http://www.mysqlperformanceblog.com/files/patches/patch-mysq l-5.0.54a-msl.diff

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #2824 is a reply to message #2823 ]

Tue, 01 April 2008 10:19

ilys
Messages: 11
Registered: December 2007

Junior Member

hmm...

I'm found source distribution for mysql-5.0.56 and patching failed on his:

$ patch -p1 < /home/umask/patch-mysql-5.0.54a-msl.diff
patching file include/my_time.h
patching file scripts/mysqldumpslow.sh
patching file sql-common/my_time.c
patching file sql/filesort.cc
Hunk #1 succeeded at 173 (offset 1 line).
Hunk #2 FAILED at 240.
Hunk #3 succeeded at 1072 (offset 8 lines).
1 out of 3 hunks FAILED -- saving rejects to file sql/filesort.cc.rej
patching file sql/log.cc
Hunk #1 succeeded at 2076 (offset 42 lines).
Hunk #2 succeeded at 2091 (offset 42 lines).
Hunk #3 succeeded at 2109 (offset 42 lines).
Hunk #4 succeeded at 2122 (offset 42 lines).
patching file sql/log_event.cc
patching file sql/my_time.c
patching file sql/mysql_priv.h
patching file sql/mysqld.cc
patching file sql/set_var.cc
Hunk #1 succeeded at 215 (offset -1 lines).
Hunk #2 succeeded at 281 (offset -1 lines).
Hunk #3 succeeded at 326 (offset -1 lines).
Hunk #4 succeeded at 682 (offset -1 lines).
Hunk #5 succeeded at 708 (offset -1 lines).
Hunk #6 succeeded at 739 (offset -1 lines).
Hunk #7 succeeded at 975 (offset -1 lines).
Hunk #8 succeeded at 1005 (offset -1 lines).
Hunk #9 succeeded at 1058 (offset -1 lines).
Hunk #10 succeeded at 1655 (offset 7 lines).
Hunk #11 succeeded at 3550 (offset 13 lines).
patching file sql/set_var.h
patching file sql/slave.cc
patching file sql/sql_cache.cc
patching file sql/sql_class.cc
Hunk #2 succeeded at 2190 (offset 1 line).
Hunk #3 succeeded at 2212 (offset 1 line).
Hunk #4 succeeded at 2271 (offset 1 line).
patching file sql/sql_class.h
patching file sql/sql_parse.cc
Hunk #3 succeeded at 2279 (offset 67 lines).
Hunk #4 succeeded at 5976 (offset 60 lines).
patching file sql/sql_select.cc
Hunk #1 succeeded at 6218 (offset 1 line).
Hunk #2 succeeded at 6237 (offset 1 line).
Hunk #3 succeeded at 9285 (offset 3 lines).
Hunk #4 succeeded at 10146 (offset 3 lines).
patching file sql/sql_show.cc
patching file sql/structs.h

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #2825 is a reply to message #2824 ]

Tue, 01 April 2008 21:54

debug
Messages: 122
Registered: March 2008

Senior Member

Ilys,

Well, it's possible, as you are trying to patch mysql 5.0.56 using patch for 5.0.54a..

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #2826 is a reply to message #2825 ]

Wed, 02 April 2008 00:55

ilys
Messages: 11
Registered: December 2007

Junior Member

> Well, it's possible, as you are trying to patch mysql 5.0.56 using patch for 5.0.54a..

Sad

yes.

Can you explain microslow patch release policy?

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #2827 is a reply to message #2826 ]

Wed, 02 April 2008 01:07

debug
Messages: 122
Registered: March 2008

Senior Member

Hmm, there is no special release policy, we just create patches when we need them, or when someone requests Smile

I will try to get patch for 5.0.56 tomorrow.

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #2836 is a reply to message #2595 ]

Thu, 03 April 2008 06:21

ilys
Messages: 11
Registered: December 2007

Junior Member

How your progress in writing a patch?

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #2837 is a reply to message #2595 ]

Thu, 03 April 2008 10:48

debug
Messages: 122
Registered: March 2008

Senior Member

http://www.mysqlperformanceblog.com/files/patches/patch-mysq l-5.0.56-msl.diff

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #3059 is a reply to message #2837 ]

Fri, 09 May 2008 15:17

ilys
Messages: 11
Registered: December 2007

Junior Member

what about 5.0.60?

$ patch -p1 < /usr/src/redhat/SOURCES/patch.slow-micro.mysql-5.0.56-msl.di ff
patching file include/my_time.h
patching file scripts/mysqldumpslow.sh
patching file sql-common/my_time.c
patching file sql/filesort.cc
Hunk #1 succeeded at 180 (offset 7 lines).
Hunk #2 succeeded at 239 (offset -1 lines).
Hunk #3 succeeded at 1079 (offset 7 lines).
patching file sql/log.cc
Hunk #1 succeeded at 2177 (offset 101 lines).
Hunk #3 succeeded at 2210 (offset 101 lines).
patching file sql/log_event.cc
Hunk #1 succeeded at 2039 (offset 1 line).
patching file sql/my_time.c
patching file sql/mysql_priv.h
Hunk #1 succeeded at 484 (offset 1 line).
Hunk #2 succeeded at 1384 (offset 8 lines).
patching file sql/mysqld.cc
Hunk #1 succeeded at 176 (offset 7 lines).
Hunk #2 succeeded at 495 with fuzz 2 (offset 269 lines).
Hunk #3 FAILED at 667.
Hunk #4 succeeded at 3381 (offset -141 lines).
Hunk #5 succeeded at 5036 (offset 264 lines).
Hunk #6 succeeded at 4722 (offset -141 lines).
Hunk #7 succeeded at 5518 (offset 264 lines).
Hunk #8 succeeded at 5782 (offset -141 lines).
Hunk #9 succeeded at 6975 (offset 264 lines).
Hunk #10 succeeded at 7033 (offset -141 lines).
Hunk #11 succeeded at 7779 (offset 264 lines).
1 out of 11 hunks FAILED -- saving rejects to file sql/mysqld.cc.rej
patching file sql/set_var.cc
patching file sql/set_var.h
patching file sql/slave.cc
Hunk #1 succeeded at 2925 (offset 17 lines).
patching file sql/sql_cache.cc
patching file sql/sql_class.cc
Hunk #2 succeeded at 2197 (offset 7 lines).
Hunk #4 succeeded at 2278 (offset 7 lines).
patching file sql/sql_class.h
patching file sql/sql_parse.cc
Hunk #2 succeeded at 1181 (offset -14 lines).
patching file sql/sql_select.cc
Hunk #1 succeeded at 6196 (offset -22 lines).
Hunk #3 succeeded at 9263 (offset -22 lines).
patching file sql/sql_show.cc
patching file sql/structs.h

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #3065 is a reply to message #3059 ]

Mon, 12 May 2008 03:42

debug
Messages: 122
Registered: March 2008

Senior Member

I'll let you know when 5.0.60 microslow patch will be released.

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #3101 is a reply to message #3065 ]

Tue, 20 May 2008 00:56

ilys
Messages: 11
Registered: December 2007

Junior Member

> I'll let you know when 5.0.60 microslow patch will be released.

When? Smile

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #3105 is a reply to message #3101 ]

Tue, 20 May 2008 11:52

debug
Messages: 122
Registered: March 2008

Senior Member

Most probably it will be done by the end of this or next week.

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #3190 is a reply to message #3105 ]

Tue, 17 June 2008 15:24

ilys
Messages: 11
Registered: December 2007

Junior Member

we still wait! Smile

I have yum repo for many users and i can't update mysql upto 5.0.60 without microslow patch.

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #3197 is a reply to message #3190 ]

Wed, 18 June 2008 07:18

debug
Messages: 122
Registered: March 2008

Senior Member

It's here

[Updated on: Wed, 18 June 2008 07:21]

Mikhail Solovyev, MySQL Performance Expert
MySQL Performance Blog
MySQL Consulting

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #3445 is a reply to message #2595 ]

Mon, 18 August 2008 02:21

ilys
Messages: 11
Registered: December 2007

Junior Member

Hi!

What about patch for mysql-5.0.67 (official community release)?

patch -p1 < /usr/src/redhat/SOURCES/patch-mysql-5.0.60-msl+innodb.diff
patching file include/my_time.h
patching file innobase/buf/buf0buf.c
patching file innobase/buf/buf0rea.c
patching file innobase/fil/fil0fil.c
patching file innobase/include/buf0rea.h
patching file innobase/include/fil0fil.h
patching file innobase/include/os0file.h
patching file innobase/include/thr0loc.h
patching file innobase/include/trx0trx.h
patching file innobase/lock/lock0lock.c
patching file innobase/os/os0file.c
patching file innobase/srv/srv0srv.c
patching file innobase/thr/thr0loc.c
patching file innobase/trx/trx0trx.c
patching file scripts/mysqldumpslow.sh
patching file sql/filesort.cc
patching file sql/ha_innodb.cc
patching file sql/log.cc
patching file sql/log_event.cc
patching file sql/mysqld.cc
Hunk #2 succeeded at 408 (offset 3 lines).
Hunk #4 succeeded at 3653 (offset 3 lines).
Hunk #6 succeeded at 4989 with fuzz 2 (offset 3 lines).
Hunk #7 succeeded at 5384 (offset 6 lines).
Hunk #8 succeeded at 6055 (offset 9 lines).
Hunk #9 succeeded at 6845 (offset 11 lines).
Hunk #10 succeeded at 7306 (offset 9 lines).
Hunk #11 succeeded at 7658 (offset 19 lines).
patching file sql/mysql_priv.h
Hunk #1 succeeded at 489 (offset 4 lines).
Hunk #2 succeeded at 1420 (offset 16 lines).
patching file sql/my_time.c
patching file sql/set_var.cc
Hunk #4 succeeded at 697 (offset 6 lines).
Hunk #6 succeeded at 993 (offset 10 lines).
Hunk #8 succeeded at 1081 (offset 15 lines).
Hunk #10 succeeded at 3573 (offset 15 lines).
patching file sql/set_var.h
patching file sql/slave.cc
patching file sql/sql_cache.cc
Hunk #1 succeeded at 1341 (offset 7 lines).
patching file sql/sql_class.cc
Hunk #1 succeeded at 188 (offset 14 lines).
Hunk #2 succeeded at 2200 (offset 3 lines).
Hunk #3 succeeded at 2233 (offset 14 lines).
Hunk #4 succeeded at 2281 (offset 3 lines).
patching file sql/sql_class.h
Hunk #4 succeeded at 550 with fuzz 2 (offset 1 line).
Hunk #6 succeeded at 1185 (offset 1 line).
Hunk #7 succeeded at 1297 (offset 3 lines).
Hunk #8 succeeded at 1704 (offset 5 lines).
patching file sql/sql_parse.cc
Hunk #3 FAILED at 2265.
Hunk #4 succeeded at 6031 (offset 55 lines).
1 out of 4 hunks FAILED -- saving rejects to file sql/sql_parse.cc.rej
patching file sql/sql_select.cc
Hunk #1 succeeded at 6210 (offset 14 lines).
Hunk #3 succeeded at 9277 (offset 14 lines).
patching file sql/sql_show.cc
patching file sql/structs.h
patching file sql-common/my_time.c
-bash-3.2$ echo $?
1

On 5.0.66a (and on 5.0.66, 5.0.64, 5.0.62) patch has applied correctly.

Report message to a moderator

Re: microslow patch for mysql-5.0.54 [message #3502 is a reply to message #2595 ]

Fri, 05 September 2008 04:24

zImage
Messages: 1
Registered: September 2008

Junior Member

It needs just some minor tweaking. Here you are:

http://blog.lifepattern.org/wp-content/uploads/2008/09/micro slow_innodb_and_userstats-5.0.67.patch

We have nothing to fear but fear itself.
http://blog.lifepattern.org/

Report message to a moderator

Previous Topic:	Benchmark tool for MySQL
Next Topic:	xfering data from table to table within a single databse

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 5 11:52:35 EST 2008

Total time taken to generate the page: 0.08408 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.