ElaKiri Community
Downloads
Go Back   ElaKiri Community > Computers & Internet > Web Development
Reload this Page -MariaDB-Vs-MySQL~Performance
Reply
 
Thread Tools
(#1)
Old
KingCM's Avatar
KingCM KingCM is offline
Senior Member
KingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to all
 
Posts: 6,442
Join Date: Jul 2013
Location: ☵404 Page Not Found
smile -MariaDB-Vs-MySQL~Performance - 10-06-2015, 02:54 PM




ඔයාල හැමෝම දන්නවා ඇතිනේ Sun Microsystems විසින් MySQL 2008 දී ඩොලර් බිලියනයකට මිලදී ගන්නවා කියල.


ඊට පස්සේ Oracle විසින් Sun Microsystems මිලදී ගන්නවා 2009 දී.


මේක Sun Microsystems මිලදී ගන්න කොට MySQL වල වැඩ කරපු original developers (founders ලා )සෙට් එක ඉවත් වෙනවා.............


David Axmark, Allan Larsson and Michael "Monty" Widenius. - founders


මේ අය අයෙත් 22 January 2009 දී ආරම්භ කරනවා MariaDB කියල එයාලගෙම company ක් .

MySQL engine එක අරගෙනම තමයි මෙයාල මේක හදන්න ගන්නේ ..............හැබැයි ගොඩක් improvments කරනවා ....... ඩොලර් බිලියනයක් ගත්ත නිසා දැන් සල්ලි බාගෙත් එහෙම හොදට තියෙනවනේ.........


කරපු improvments ලිස්ට් එකක්ම මෙතන තියෙනවා........ Click Here

දැනට MariaDB විසින් නිකුත් කර ඇති version -



source-wikipedia


එත් හැමෝම MariaDB හොදයි ෆාස්ට් අනන් මනම් කිව්වට අපි දන්නේ නැනේ .........

එක නිසා මට පොඩ්ඩක් හිතුන මේක පොඩ්ඩක් ටෙස්ට් කරලා බලන්න.......


මේ තියෙන්නේ මිලියන ගානක් data enter කරනකොට MySQL සහ MariaDB වල performance එක.


මේක මිට වඩා වෙනස් වෙන්න පුළුවන් hardware requirenments අනුව.මම මේක test කලේ core i 3 4GB normal ලැප්ටොප් එකක.SSD එකක් භාවිතා කලොත් මිට වැඩ ගොඩක් fast වෙයි.



මේ තියෙන්නේ data row මිලියන 2ක් insert කරනකොට database එකට ඒ සදහා ගත වූ කාලය.


MySQL





MariaDB





වෙනස- 34.3 - 18.3 = 16 seconds

( MariaDB වලට වඩා MySQL තත්පර 16 ගිහින් තියෙනවා.)



මේ තියෙන්නේ data row මිලියන 4ක් insert කරනකොට database එකට ඒ සදහා ගත වූ කාලය.


MySQL



MariaDB






වෙනස- 70.5 - 44.5 = 26s

(MariaDB වලට වඩා MySQL තත්පර 26 ගිහින් තියෙනවා.)



මේ තියෙන්නේ data row මිලියන 10ක් insert කරනකොට database එකට ඒ සදහා ගත වූ කාලය.


MySQL




MariaDB




වෙනස- 177.9 - 117.9 = 60s


(MariaDB වලට වඩා MySQL තත්පර 60(one minute) ගිහින් තියෙනවා.)


ඒ වගේම මම මේ වෙනස් වීම graph එකකත් නිරුපනය කල.





(MySQL ,MariaDB performance test Graph - insert කරන data ප්‍රමාණය million වලින්ද ,කාලය තත්පර වලින්ද දක්වා ඇත.)


දැක්ක නේද කොපමණ වෙනසක්ද කියල.......


අනිත් එක වාසියක් තමයි file size එක..... MySQL = 200MB වෙනවා MariaDB = 54 MB (64bit version) download කරන්නත් ලේසි.


MySQL සමග එන්නේ GUI editor එක MySQL workbench එකනේ.......ඒ workbench එකනම් හෙනම අච්චාරුවක් .


එත් MariaDB සමග එන GUI එක HeidiSQL මේක Object Pascal වලින් ලියල තියෙන්නේ ... ඒ කියන්නේ Embarcadero Delphi ..... එක නිසා මේක ගොඩක් ෆාස්ට් .මමත් දැන් අවුරුදු 2ක ඉදන් භාවිතා කරන්නේ HeidiSQL.








source - heidiSQL



HeidiSQL විතරක් නෙමෙයි SQLyog , Navicat වගේ GUI editor සමගත් භාවිතා කරන්න පුළුවන්.


හොදම දේ තමයි MySQL වලින් කරපු කිසිම දෙයක් වෙනස් නොකර MySQL ,MariaDB වලින් replace කරන්න පුළුවන් වීම .


MariaDB install වෙන්නෙත් MySQL කියලමයි.එත් backend එක වෙනස්.


වැරදි අඩු පාඩු තිබුනානම් සමාවෙන්න....... මම වරද්දපු තැනක් තියෙනවනම් මට වඩා දන්නා බුද්දිමත් අය ඒවා පෙන්නවා දෙන ලෙසත් ඉල්ලා සිටිනවා.


--------------------------------------------------------------------
Reply With Quote
(#2)
Old
dildude's Avatar
dildude dildude is offline
Senior Member
dildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of lightdildude is a glorious beacon of light
 
Posts: 10,534
Join Date: May 2015
Location: 🅷🅴🅰V🅴🅽
10-06-2015, 02:56 PM

ela ela api nam sql server
Reply With Quote
(#3)
Old
KingCM's Avatar
KingCM KingCM is offline
Senior Member
KingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to all
 
Posts: 6,442
Join Date: Jul 2013
Location: ☵404 Page Not Found
10-06-2015, 03:00 PM

Quote:
Originally Posted by dildude View Post
ela ela api nam sql server
thawath dawasaka SQL server test ekakuth karala balanna one..... rep +5
Reply With Quote
(#4)
Old
GTRZ's Avatar
GTRZ GTRZ is offline
Administrator
GTRZ is a name known to allGTRZ is a name known to allGTRZ is a name known to allGTRZ is a name known to allGTRZ is a name known to allGTRZ is a name known to allGTRZ is a name known to allGTRZ is a name known to allGTRZ is a name known to allGTRZ is a name known to allGTRZ is a name known to all
 
Posts: 16,372
Join Date: Apr 2006
Send a message via MSN to GTRZ Send a message via Yahoo to GTRZ
10-06-2015, 03:05 PM

Monada mysql and mariadb versions machan? ochchra loku wenasak nam naha.
samahara than wala mysql perform karanawa hondata.

percona mariadb walata wadaa fast innodb walaa. mama hithanne dan percona xtradb engine eka thiyenne mariadb walath.



Send your suggestions, complains, media etc.. for ElaKiri.com from PM or as email to [email protected]


MSN/Yahoo IM [email protected]

||||||||||| Face Fears. Live Dreams! |||||||||||

Join the ElaKiri friendship campaign!
Reply With Quote
(#5)
Old
Sadeepa Arosha's Avatar
Sadeepa Arosha Sadeepa Arosha is offline
Senior Member
Sadeepa Arosha is a glorious beacon of lightSadeepa Arosha is a glorious beacon of lightSadeepa Arosha is a glorious beacon of lightSadeepa Arosha is a glorious beacon of lightSadeepa Arosha is a glorious beacon of lightSadeepa Arosha is a glorious beacon of lightSadeepa Arosha is a glorious beacon of lightSadeepa Arosha is a glorious beacon of lightSadeepa Arosha is a glorious beacon of lightSadeepa Arosha is a glorious beacon of lightSadeepa Arosha is a glorious beacon of light
 
Posts: 8,806
Join Date: Aug 2009
Location: ඇයි එන්නද ?
10-06-2015, 03:11 PM

ela +9


mysql (5.5.44-MariaDB-cll-lve)

Last edited by Sadeepa Arosha; 10-06-2015 at 03:14 PM.
Reply With Quote
(#6)
Old
ilanganthilaka's Avatar
ilanganthilaka ilanganthilaka is offline
Senior Member
ilanganthilaka is a name known to allilanganthilaka is a name known to allilanganthilaka is a name known to allilanganthilaka is a name known to allilanganthilaka is a name known to allilanganthilaka is a name known to allilanganthilaka is a name known to allilanganthilaka is a name known to allilanganthilaka is a name known to allilanganthilaka is a name known to allilanganthilaka is a name known to all
 
Posts: 13,813
Join Date: Jun 2008
10-06-2015, 03:12 PM

ela

rep 13+
Reply With Quote
(#7)
Old
KingCM's Avatar
KingCM KingCM is offline
Senior Member
KingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to all
 
Posts: 6,442
Join Date: Jul 2013
Location: ☵404 Page Not Found
10-06-2015, 03:15 PM

Quote:
Originally Posted by GTRZ View Post
Monada mysql and mariadb versions machan? ochchra loku wenasak nam naha.
samahara than wala mysql perform karanawa hondata.

percona mariadb walata wadaa fast innodb walaa. mama hithanne dan percona xtradb engine eka thiyenne mariadb walath.

thank you GT ayye reply ekata............ ow ow samahara awastha waladi mysql hodata perform karanawa................ mama eka piligannawa.......

mamath dakka percona hoda fast kiyala.......... ekath gana poddak hoyala balanna one.....


mariaDB version eka - mariadb-5.5.35-winx64.msi

mysql version eka - mysql-installer-community-5.6.14.0.msi

waradi thiyenna puluwan mama meka test kale mage thiyena knowledge eke hatiyatane....
Reply With Quote
(#8)
Old
Ayeshlive's Avatar
Ayeshlive Ayeshlive is offline
Senior Member
Ayeshlive is a name known to allAyeshlive is a name known to allAyeshlive is a name known to allAyeshlive is a name known to allAyeshlive is a name known to allAyeshlive is a name known to allAyeshlive is a name known to allAyeshlive is a name known to allAyeshlive is a name known to allAyeshlive is a name known to allAyeshlive is a name known to all
 
Posts: 10,711
Join Date: Jul 2011
Location: *̶͑̾̾​̅ͫ͏̙̤g͛͆̾ͫ̑͆&
10-06-2015, 03:15 PM

Quote:
Originally Posted by GTRZ View Post
Monada mysql and mariadb versions machan? ochchra loku wenasak nam naha.
samahara than wala mysql perform karanawa hondata.

percona mariadb walata wadaa fast innodb walaa. mama hithanne dan percona xtradb engine eka thiyenne mariadb walath.
MySQL walath engine eka anuwa, operation eka wenas wenawa Writes adu reads wadi table walata MyISAM thamath hodai.

Anith eka developers he skills. MariaDB perf gain walin wadak na queries inefficient nam.
Reply With Quote
(#9)
Old
KingCM's Avatar
KingCM KingCM is offline
Senior Member
KingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to allKingCM is a name known to all
 
Posts: 6,442
Join Date: Jul 2013
Location: ☵404 Page Not Found
10-06-2015, 03:17 PM

engine eka = Innodb
Reply With Quote
(#10)
Old
EVALUTION's Avatar
EVALUTION EVALUTION is offline
Senior Member
EVALUTION has a spectacular aura aboutEVALUTION has a spectacular aura aboutEVALUTION has a spectacular aura about
 
Posts: 218
Join Date: Oct 2014
Location: Colombo, Sri Lanka
10-06-2015, 03:17 PM

bump
Reply With Quote
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



Copyright 2006 - 2011 ElaKiri Beta2.Evo vBulletin, vBa iBproArcade Subdreamer I-Magic MKv

Page generated in 0.02300 seconds with 9 queries