MariaDBServerbenefitsfroma78percentincreaseinthroughputandan18percentcutinresponsetimewhenrunningontheIntelXeonPlatinum8180processor1IntelXeonPlatinumProcessorAcceleratesMariaDBServer*andMyRocks*SolutionBriefIntelXeonPlatinum8180processorServerPerformance"MyRocks*isastorageenginethataddstheRocksDBflash-storage-optimizeddatabasetoMariaDBServer.
Evenwhileunderdevelopment,itshowsgoodperformanceandscalability,closetomaturestorageengineslikeInnoDB.
Weranourpre-releaseMariaDBServer10.
2.
9withthebuilt-inMyRocksengineundertheSysbenchread-onlymulti-tabletestonthenewestIntelXeonPlatinum8180processors.
Theydeliveredupto1.
78xmorethroughputwith1.
18xreductionoftheaverageresponsetimecomparedtothepreviousgenerationIntelXeonprocessorsE5-2699v4"—MichaelWideniusCTO,MariaDBCorporationMariaDBServerisoneofthemostpopulardatabaseserversintheworld.
It'smadebytheoriginalfoundersofMySQLandnotableusersincludeWikipedia,WordPress.
comandGoogle.
Asbusinessesbecomemoreandmoredataintensive,thecostpertransactionbecomesanimportantmetric.
Therearetwowaystolowercostpertransaction.
Thefirstistolowerthecostofdatainfrastructure;andthesecondistoincreasehardwareefficiency.
WithMariaDBandIntel,organizationscandobothbyusinganenterprisesubscriptiontoreducedatabasecostsandmulti-coreprocessorstoincreaseperformancewithexistingservers.
IntroducingMariaDBServerMariaDBServerisanopensourcedatabase,andthefoundationofMariaDBTX,anenterpriseopensourcesolutionfortransactionalworkloads.
MariaDBServerisengineeredforflexibility,efficiency,andreliability.
Byimplementinganextensiblearchitectureandsupportingcontributionsfromleadinginternetandtechnologycompanies,includingAlibaba,Facebook,GoogleandTencent,MariaDBServermeetsmodernenterpriserequirementswithcommunityinnovation.
MariaDBServer,engineeredtoscaleonstandardmodernhardware,canbedeployedonbaremetalservers,virtualmachines,cloudinstances,and/orcontainers.
MariaDBServerisnowthedefaultdatabaseonleadingLinuxdistributions,includingRedHatEnterpriseLinux*andSUSEEnterpriseLinux*,aswellasleadinginfrastructureplatforms,includingOpenStack.
Inaddition,MariaDBServerusesIntelAdvancedEncryptionStandardNewInstructions(IntelAES-NI)toimproveencryptionperformance,bothinmotionandatrest.
ThemodernandextensiblearchitectureofMariaDBServerprovidesthefoundationforbusinessestocontinuouslyinnovatewithnewapplicationsandmodernizelegacysystems.
OneofthestrengthsofMariaDBServeristhatitallowsuserstochoosetheirownstorageengine.
InnoDBisthedefault.
Itwasdesignedprimarilytoworkwithharddisks,butnewstoragemediahavesinceemergedincludingnon-volatilememory(NVM)andsolidstatedrives(SSDs).
MyRocks*,developedbyFacebook,isastorageenginethatisoptimizedfornewermedia,andaimstooffergreatercompressionandfasterperformance.
Whilecurrentlyavailableasapreview,MyRockswillbefullysupportedinthenextmajorreleaseofMariaDBServer.
SolutionBrief|IntelXeonPlatinumProcessorAcceleratesMariaDBServer*andMyRocks*2LearnmoreMariaDB:mariadb.
comIntelXeonPlatinumprocessors:https://www.
intel.
com/content/www/us/en/products/processors/xeon/scalable/platinum-processors.
htmlTestingthenewprocessorInadvanceoftheofficialsupportforMyRocks,MariaDBandIntelworkedtogethertoassessthepossibleperformancegainsusingthelatestgenerationIntelprocessor.
IntelengineerscomparedtheperformanceofMariaDBServer10.
2.
9runningontwoIntelXeonprocessorsE5-2699v4againstMariaDBServer10.
2.
9runningontwoIntelXeonPlatinum8180processors.
Inbothcases,MyRockswaschosenasthestorageengine.
TheteamusedtheSysbenchOLTPbenchmark,1amulti-threadedbenchmarktoolforevaluatingdatabaseperformanceunderintensiveload.
Toconfirmtherewerenobottlenecksintheperformance,IntelVTuneAmplifier2017andamodifiedversionoftheopensourceProcessorCounterMonitorwereused.
Theresultsshoweda78percentincreaseinread-onlythroughputwiththeIntelXeonPlatinumprocessorswhencomparedtothepreviousgenerationv4processors.
1Inaddition,averageresponsetimesatpeakthroughputwerecutby18percent.
1OptimizingthesoftwareAcollaborationwithIntel,usingIntelVTuneAmplifier2017,partoftheIntelParallelStudioXE2017suite,ledMariaDBtoidentifyperformanceoptimizationsforIntelprocessors.
TheresultisMariaDBServertakingadvantageoftheadditionalcoresinIntelXeonPlatinumprocessors,scalingtotwosocketsand112hardwarethreadsinthisperformancecomparison.
1Findthesolutionthatisrightforyourorganization.
ContactyourIntelrepresentativeorvisitwww.
intel.
com.
SolutionBrief|IntelXeonPlatinumProcessorAcceleratesMariaDBServer*andMyRocks*3SolutionProvidedBy:Allinformationprovidedhereissubjecttochangewithoutnotice.
ContactyourIntelrepresentativetoobtainthelatestIntelproductspecificationsandroadmaps.
Inteltechnologies'featuresandbenefitsdependonsystemconfigurationandmayrequireenabledhardware,software,orserviceactivation.
Performancevariesdependingonsystemconfiguration.
Nocomputersystemcanbeabsolutelysecure.
Checkwithyoursystemmanufacturerorretailer,orlearnmoreathttps://www.
intel.
com/content/www/us/en/products/processors/xeon.
html.
SoftwareandworkloadsusedinperformancetestsmayhavebeenoptimizedforperformanceonlyonIntelmicroprocessors.
Performancetests,suchasSYSmarkandMobileMark,aremeasuredusingspecificcomputersystems,components,software,operationsandfunctions.
Anychangetoanyofthosefactorsmaycausetheresultstovary.
Youshouldconsultotherinformationandperformanceteststoassistyouinfullyevaluatingyourcontemplatedpurchases,includingtheperformanceofthatproductwhencombinedwithotherproducts.
Formoreinformationgotowww.
intel.
com/performanceInteldoesnotcontrolorauditthedesignorimplementationofthirdpartybenchmarkdataorWebsitesreferencedinthisdocument.
IntelencouragesallofitscustomerstovisitthereferencedWebsitesorotherswheresimilarperformancebenchmarkdataarereportedandconfirmwhetherthereferencedbenchmarkdataareaccurateandreflectperformanceofsystemsavailableforpurchase.
Inteltechnologies'featuresandbenefitsdependonsystemconfigurationandmayrequireenabledhardware,softwareorserviceactivation.
Performancevariesdependingonsystemconfiguration.
Checkwithyoursystemmanufacturerorretailerorlearnmoreathttp://www.
intel.
comTestingbyIntel,September2017.
Softwareconfiguration:MariaDB*:SysbenchOLTPworkload.
OS:Ubuntu*Server17.
04x64.
Sysbench0.
4.
12,MariaDB10.
2.
9GITsnapshot2017-09-12.
TheworkloadisnotI/Oboundandisnotmemorysizebound.
Baseline:2SIntelXeonE5-2699v4,2.
2GHz,22cores,IntelTurboBoostTechnologyandIntelHyper-ThreadingTechnologyenabled,BIOS63.
R00,64GBtotalmemory,1600MT/s/DDR4LRDIMM,1TBSATAHDD,IntelSSDDCP3700Series2TB.
New:2SIntelXeonPlatinumprocessor8180,2.
5GHz,28cores,IntelTurboBoostTechnologyandIntelHyper-ThreadingTechnologyenabled,BIOS1.
00.
0412,192GBtotalmemory,12slots/16GB/2666MT/s/DDR4LRDIMM,1TBSATAHDD,IntelSSDDCP3700Series2TB.
PerformanceresultsarebasedontestingasofSeptember2017andmaynotreflectallpubliclyavailablesecurityupdates.
Seeconfigurationdisclosurefordetails.
Noproductcanbeabsolutelysecure.
IntelAES-NIrequiresacomputersystemwithanAES-NI-enabledprocessor,aswellasnon-Intelsoftwaretoexecutetheinstructionsinthecorrectsequence.
AES-NIisavailableonIntelprocessors.
Foravailability,consultyourresellerorsystemmanufacturer.
Formoreinformation,seehttp://software.
intel.
com/en-us/articles/intel-advanced-encryption-standard-instructions-aes-ni/.
paypal贝宝可撸$10的代金券!这两天paypal出了活动,本次并没有其他的限制,只要注册国区的paypal,使用国内的手机号和62开头的银联卡,就可以获得10美元的代金券,这个代金券购买产品需要大于10.1美元,站长给大家推荐几个方式,可以白嫖一年的VPS,有需要的朋友可以看看比较简单。PayPal送10美元活动:点击直达活动sfz与绑定卡的号码可以重复用 注册的邮箱,手机号与绑的银联卡必须...
CloudCone是一家成立于2017年的国外VPS主机商,提供独立服务器租用和VPS主机,其中VPS基于KVM架构,多个不同系列,譬如常规VPS、大硬盘VPS等等,数据中心在洛杉矶MC机房。商家2021年Flash Sale活动继续,最低每月1.99美元,支持7天退款到账户,支持使用PayPal或者支付宝付款,先充值后下单的方式。下面列出几款VPS主机配置信息。CPU:1core内存:768MB...
前几天有关注到Megalayer云服务器提供商有打算在月底的时候新增新加坡机房,这个是继美国、中国香港、菲律宾之外的第四个机房。也有工单询问到官方,新加坡机房有包括CN2国内优化线路和国际带宽,CN2优化线路应该是和菲律宾差不多的。如果我们追求速度和稳定性的中文业务,建议还是选择CN2优化带宽的香港服务器。这里有要到Megalayer新加坡服务器国际带宽的测试服务器,E3-1230配置20M国际带...