ON SUN, DEC 30, 2007 AT 02:18:31PM +0100, KRIS KENNAWAY
WROTE:
> GERGELY CZUCZY WROTE:
> >ON SAT, DEC 01, 2007 AT 12:22:34PM -1000, JEFF
ROBERSON WROTE:
> >>ON SAT, 1 DEC 2007, GERGELY CZUCZY WROTE:
> >>
> >>>ON SAT, DEC 01, 2007 AT 04:06:55PM -0500,
MIKE TANCSA WROTE:
> >>>>AT 03:56 PM 12/1/2007, GERGELY CZUCZY
WROTE:
> >>>>>I DON'T QUITE UNDERSTAND THE
QUESTION. IT'S THE VERY SAME BOX, WITH
> >>>>>A DUALBOOT CONFIGURATION.
> >>>>FIRE UP THE 3WARE CONTROLLER'S RAID
MANAGEMENT SOFTWARE AND MAKE SURE THE SAME WRITE CACHING
STRATEGY IS SET FOR FREEBSD AND LINUX.
> >>>>THE
> >>>>DRIVER MY DEFAULT TO DIFFERENT VALUES.
> >>>>
> >>>>I.E. UNDER "CONTROLLER
SETTINGS" MAKE SURE "WRITE CACHE" AND
"QUEUING" ARE THE SAME VALUES FOR LINUX AND
FREEBSD.
> >>>LET'S GET BACK TO THIS ON MONDAY. I'M AT
HOME NOW, AND THE
> >>>BOX IS AT ME WORKPLACE, STILL RUNNING A
TEST (I CAN'T REBOOT IT).
> >>ALSO, CAN YOU VERIFY WITH A READ-ONLY TEST TO
SEE WHERE IT'S AT? I HAVE NOT TESTED WRITES WITH THAT MANY
THREADS. I NOTICE MYSQL
> >>GOES MUCH FASTER WITH A FRESH TABLE TOO. SO
CAN YOU BLOW AWAY AND RECREATE THE SYSBENCH TABLES AND THEN
DO READ-ONLY? IF THAT IS
> >>MUCH SLOWER WE'LL KNOW THERE IS SOME
CONFIGURATION PROBLEM OR SIMILAR.
> >IT WILL ALL BE AVAILABLE HERE:
> >HTTP://PHOEMIX.HARMLESS.HU/MYSQL/
>
> HI,
>
> SORRY FOR THE LATE REPLY, I WAS ON VACATION. I HAVE A
COUPLE OF COMMENTS ABOUT THIS:
>
> * YOU ARE USING SOME VERY OLD MYSQL VERSIONS AND TRYING
TO COMPARE BETWEEN DIFERENT VERSIONS. NEW MINOR RELEASES IN
THE 5.0 SERIES HAD
> VERY DIFFERENT PERFORMANCE, AND YOU REALLY NEED TO BE
USING AT LEAST 5.0.45 (I DIDN'T NOTICE A PERFORMANCE CHANGE
BETWEEN 5.0.45 AND
> 5.0.51 BUT THERE WAS A BIG IMPROVEMENT IN EVERY RELEASE
UP TO .45. IN ADDITION, VERSIONS OLDER THAN (I THINK) .37
HAVE SERIOUS
> PERFORMANCE BUGS).
>
> I APPRECIATE THAT YOU MIGHT BE CONSTRAINED BY LOCAL
REQUIREMENTS, BUT IT'S REALLY NOT MEANINGFUL TO COMPARE
DIFFERENT MYSQL VERSIONS IF
> YOUR GOAL IS TO STUDY OS PERFORMANCE.
IT'D BE A PITA TO INSTALL THE BOTH VERSIONS. MAYBE NOW, THAT
THE PORTS FREEZE IS OVER, I CAN
DO SOMETHING. BUT HONESTLY, EVERY MYSQL VERSION WAS FASTER
ON LINUX, THAN ENY ON FREEBSD,
EVEN THE .22 ONE WAS FASTER. WE START WORK ON JAN02, I WILL
SEE WHAT CAN I DO.
>
> * WHAT DATABASE ENGINE ARE YOU USING? I HAVE ONLY
TESTED WITH INNODB BUT MAYBE YOU ARE USING MYISAM? PLEASE
PROVIDE YOUR EXACT
> SYSBENCH COMMAND LINES.
MYISAM, OF COURSE. INNODB IS NOT ANY GOOD WITH REPLICATION,
AND WE NEED BACKUP.
> * COMPARE TO MY CONFIG FILE HERE:
>
> HTTP://PEOPLE.FREEBSD.ORG/~KRIS/SCALING/MY.CNF
>
> THE DEFAULT MYSQL CONFIG HAS VERY POOR PERFORMANCE FOR
INNODB (YOU NEED AT LEAST INNODB_THREAD_CONCURRENCY = 0 TO
DISABLE SOME MYSQL
> BRAIN-DEATH). MAYBE TUNING IS REQUIRED FOR MYISAM
ALSO.
>
> * ALSO MAKE SURE YOU ARE USING IDENTICAL CONFIG
SETTINGS ON THE TWO SYSTEMS.
HTTP://PHOEMIX.HARMLESS.HU/MYSQL/ VERIFY YOURSELF. ONLY THE
PATHS ARE
UPDATED, BUT THE MAIN PARAMETERS ARE JUST THE SAME.
> * WITH THE ABOVE, PLEASE COMPARE READ-ONLY MODE ALSO (I
THINK JEFF ALREADY ASKED YOU ABOUT THIS BUT I DIDNT SEE A
REPLY). THAT WILL
> ALLOW US TO CALIBRATE WHAT IS GOING ON.
HTTP://PHOEMIX.HARMLESS.HU/MYSQL/RO-ALL.PNG
THE GRAPH IS MISTITLED AS READ-WRITE, BUT IT'S A READONLY
TEST.
SINCERELY,
GERGELY CZUCZY
MAILTO: GERGELY.CZUCZY HARMLESS.HU
--
WEENIES TEST. GENIUSES SOLVE PROBLEMS THAT ARISE.
|
