Mysql 8 0 30 0 64 bit

OpponentEloDiffResultsScoreLOSPerf– Stockfish 15 64-bit 4CPU3622+13−13(+164)6.5 − 13.5(+0−7=13)32.5%6.5 / 200.0%+53– Stockfish 14 64-bit 4CPU3621+13−13(+163)5.5 − 14.5(+0−9=11)27.5%5.5 / 200.0%+14– Dragon by Komodo 3.1 64-bit 4CPU3616+14−14(+158)5 − 15(+0−10=10)25.0%5.0 / 200.0%−8– Fat Fritz 2 64-bit 4CPU3601+10−10(+143)6.5 − 13.5(+0−7=13)32.5%6.5 / 200.0%+32– Berserk 10 64-bit 4CPU3567+13−13(+109)6 − 14(+0−8=12)30.0%6.0 / 200.0%−18– Revenge 3.0 64-bit 4CPU3558+9−9(+100)6.5 − 13.5(+1−8=11)32.5%6.5 / 200.0%−15– Ethereal 13.75 64-bit 4CPU3554+12−12(+96)6.5 − 13.5(+0−7=13)32.5%6.5 / 200.0%−14– Koivisto 8.0 64-bit 4CPU3551+11−11(+93)7 − 13(+0−6=14)35.0%7.0 / 200.0%−2– SlowChess Blitz 2.9 64-bit 4CPU3545+9−9(+87)8.5 − 11.5(+0−3=17)42.5%8.5 / 200.0%+41– Clover 5.0 64-bit 4CPU3544+17−17(+86)12 − 20(+0−8=24)37.5%12.0 / 320.0%+9– Deep Sjeng 3.6 a16 64-bit 4CPU3544+16−16(+86)12 − 20(+0−8=24)37.5%12.0 / 320.0%+9– RubiChess 20220813 64-bit 4CPU3530+15−15(+72)7 − 13(+0−6=14)35.0%7.0 / 200.0%−20– rofChade 3.0 64-bit 4CPU3526+10−10(+68)7 − 13(+0−6=14)35.0%7.0 / 200.0%−24– Clover 4.0 64-bit 4CPU3525+16−16(+67)11 − 19(+0−8=22)36.7%11.0 / 300.0%−16– Minic 3.32 64-bit 4CPU3520+14−14(+62)8.5 − 15.5(+0−7=17)35.4%8.5 / 240.0%−28– Minic 3.30 64-bit 4CPU3515+14−14(+57)6.5 − 13.5(+0−7=13)32.5%6.5 / 200.0%−52– Caissa 1.8 64-bit 4CPU3513+17−17(+55)11 − 15(+0−4=22)42.3%11.0 / 260.0%+8– Seer 2.5.0 64-bit 4CPU3510+13−13(+52)9.5 − 10.5(+1−2=17)47.5%9.5 / 200.0%+38– Carp 3.0.0 64-bit 4CPU3501+16−16(+43)10.5 − 11.5(+0−1=21)47.7%10.5 / 220.0%+29– Arasan 23.4 64-bit 4CPU3499+13−13(+41)8.5 − 11.5(+0−3=17)42.5%8.5 / 200.0%−4– Uralochka 3.38c 64-bit 4CPU3493+15−15(+35)10 − 10(+2−2=16)50.0%10.0 / 200.0%+35– Rebel 15.1a 64-bit 4CPU3490+16−16(+32)9 − 11(+0−2=18)45.0%9.0 / 200.1%+4– Arasan 23.5 64-bit 4CPU3488+15−15(+30)10.5 − 11.5(+1−2=19)47.7%10.5 / 220.2%+17– Igel 3.1.0 64-bit 4CPU3484+12−12(+26)9.5 − 10.5(+0−1=19)47.5%9.5 / 200.3%+13– Black Marlin 7.0 64-bit 4CPU3466+14−14(+8)8.5 − 11.5(+1−4=15)42.5%8.5 / 2018.7%−41– Houdini 6 64-bit 4CPU3456+7−7(−2)9 − 11(+1−3=16)45.0%9.0 / 2060.1%−31– Velvet 5.1.0 64-bit 4CPU3454+17−17(−4)16.5 − 13.5(+7−4=19)55.0%16.5 / 3063.2%+29– Marvin 6.1.0 64-bit 4CPU3448+15−15(−10)11.5 − 12.5(+0−1=23)47.9%11.5 / 2482.7%−20– Wasp 6.00 64-bit 4CPU3440+15−15(−18)12.5 − 7.5(+5−0=15)62.5%12.5 / 2096.4%+55– Nemorino 6.05 64-bit 4CPU3432+16−16(−26)10 − 10(+3−3=14)50.0%10.0 / 2099.2%−26– Booot 7.0 64-bit 4CPU3428+16−16(−30)10 − 10(+2−2=16)50.0%10.0 / 2099.7%−33– Velvet 4.1.0 64-bit 4CPU3423+15−15(−35)11 − 9(+4−2=14)55.0%11.0 / 20100.0%−4– Mantissa 3.7.2 64-bit 4CPU3381+15−15(−77)12 − 8(+4−0=16)60.0%12.0 / 20100.0%−17– Marvin 6.0.0 64-bit 4CPU3377+16−16(−81)11 − 9(+2−0=18)55.0%11.0 / 20100.0%−53– Expositor 2BR17 64-bit 4CPU3376+16−16(−82)12.5 − 7.5(+6−1=13)62.5%12.5 / 20100.0%0– Counter 5.0 64-bit 4CPU3373+18−18(−85)14.5 − 9.5(+7−2=15)60.4%14.5 / 24100.0%−17– Smallbrain 6.0 64-bit 4CPU3370+16−16(−88)13.5 − 10.5(+3−0=21)56.3%13.5 / 24100.0%−52– Stash 34.0 64-bit 4CPU3364+18−18(−94)16.5 − 7.5(+10−1=13)68.8%16.5 / 24100.0%+28– Drofa 4.0.0 64-bit 4CPU3318+20−20(−140)15 − 3(+12−0=6)83.3%15.0 / 18100.0%+102– Winter 1.0 64-bit 4CPU3306+18−18(−152)12.5 − 3.5(+9−0=7)78.1%12.5 / 16100.0%+40– Drofa 3.3.22 64-bit 4CPU3300+21−21(−158)13.5 − 6.5(+7−0=13)67.5%13.5 / 20100.0%−47

".$myvar{'version'}."\n"; } else { goodprint "Currently running supported MySQL version ".$myvar{'version'}."\n"; } } # Checks if MySQL version is greater than equal to (major, minor) sub mysql_version_ge { my ($maj, $min) = @_; return $mysqlvermajor > $maj || ($mysqlvermajor == $maj && $mysqlverminor >= ($min || 0)); } # Checks for 32-bit boxes with more than 2GB of RAM my ($arch); sub check_architecture { if ($doremote eq 1) { return; } if (`uname` =~ /SunOS/ && `isainfo -b` =~ /64/) { $arch = 64; goodprint "Operating on 64-bit architecture\n"; } elsif (`uname` !~ /SunOS/ && `uname -m` =~ /64/) { $arch = 64; goodprint "Operating on 64-bit architecture\n"; } elsif (`uname` =~ /AIX/ && `bootinfo -K` =~ /64/) { $arch = 64; goodprint "Operating on 64-bit architecture\n"; } else { $arch = 32; if ($physical_memory > 2147483648) { badprint "Switch to 64-bit OS - MySQL cannot currently use all of your RAM\n"; } else { goodprint "Operating on 32-bit architecture with less than 2GB RAM\n"; } } } # Start up a ton of storage engine counts/statistics my (%enginestats,%enginecount,$fragtables); sub check_storage_engines { if ($opt{skipsize} eq 1) { print "\n-------- Storage Engine Statistics -------------------------------------------\n"; infoprint "Skipped due to --skipsize option\n"; return; } print "\n-------- Storage Engine Statistics -------------------------------------------\n"; infoprint "Status: "; my $engines; $engines .= (defined $myvar{'have_archive'} && $myvar{'have_archive'} eq "YES")? greenwrap "+Archive " : redwrap "-Archive " ; $engines .= (defined $myvar{'have_bdb'} && $myvar{'have_bdb'} eq "YES")? greenwrap "+BDB " : redwrap "-BDB " ; $engines .= (defined $myvar{'have_federated_engine'} && $myvar{'have_federated_engine'} eq "YES")? greenwrap "+Federated " : redwrap "-Federated " ; $engines .= (defined $myvar{'have_innodb'} && $myvar{'have_innodb'} eq "YES")? greenwrap "+InnoDB " : redwrap "-InnoDB " ; $engines .= (defined $myvar{'have_isam'} && $myvar{'have_isam'} eq "YES")? greenwrap "+ISAM " : redwrap "-ISAM " ; $engines .= (defined $myvar{'have_ndbcluster'} && $myvar{'have_ndbcluster'} eq "YES")? greenwrap "+NDBCluster " : redwrap "-NDBCluster " ; print "$engines\n"; if (mysql_version_ge(5)) { # MySQL 5 servers can have table sizes calculated quickly from information schema my @templist = `mysql $mysqllogin -Bse "SELECT ENGINE,SUM(DATA_LENGTH),COUNT(ENGINE) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND ENGINE IS NOT NULL GROUP BY ENGINE ORDER BY ENGINE ASC;"`; foreach my $line (@templist) { my ($engine,$size,$count); ($engine,$size,$count) = $line =~ /([a-zA-Z_]*)\s+(\d+)\s+(\d+)/; if (!defined($size)) { next; } $enginestats{$engine} = $size; $enginecount{$engine} = $count; } $fragtables = `mysql $mysqllogin -Bse "SELECT COUNT(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND Data_free > 0 AND NOT ENGINE='MEMORY';"`; chomp($fragtables); } else { # MySQL my @tblist; # Now we build a database list, and loop through it to get storage engine stats for tables my @dblist = `mysql $mysqllogin -Bse "SHOW DATABASES"`; foreach my $db (@dblist) { chomp($db); if ($db eq "information_schema") { next; } my @ixs = (1, 6,

NULL, [latitude] float NOT NULL, [longitude] float NOT NULL, [zip_code] nvarchar(30) NOT NULL, [time_zone] nvarchar(8) NOT NULL) ON [PRIMARY]GOCREATE CLUSTERED INDEX [ip_to] ON [ip2location].[dbo].[ip2location_db11]([ip_to]) ON [PRIMARY]GO Import Database BULK INSERT [ip2location].[dbo].[ip2location_db11]FROM '{PATH TO IP2LOCATION-LITE-DB11.CSV}'WITH( FORMATFILE = '{PATH TO DB11.FMT}')GO NOTE: You will need to copy the FMT code below and save it as a file named DB11.FMT on your computer. SQL Server 2016 12.0111 SQLCHAR 0 1 """ 0 first_double_quote Latin1_General_CI_AI2 SQLCHAR 0 20 "","" 1 ip_from "",3 SQLCHAR 0 20 "","" 2 ip_to "",4 SQLCHAR 0 2 "","" 3 country_code Latin1_General_CI_AI,5 SQLCHAR 0 64 "","" 4 country_name Latin1_General_CI_AI,6 SQLCHAR 0 128 "","" 5 region_name Latin1_General_CI_AI,7 SQLCHAR 0 128 "","" 6 city_name Latin1_General_CI_AI,8 SQLCHAR 0 20 "","" 7 latitude "",9 SQLCHAR 0 20 "","" 8 longitude "",10 SQLCHAR 0 30 "","" 9 zip_code Latin1_General_CI_AI,11 SQLCHAR 0 8 ""\r\n" 10 time_zone Latin1_General_CI_AI Create Database CREATE DATABASE ip2location WITH ENCODING 'UTF8';\c ip2locationCREATE TABLE ip2location_db11( ip_from bigint NOT NULL, ip_to bigint NOT NULL, country_code character(2) NOT NULL, country_name character varying(64) NOT NULL, region_name character varying(128) NOT NULL, city_name character varying(128) NOT NULL, latitude real NOT NULL, longitude real NOT NULL, zip_code character varying(30) NOT NULL, time_zone character varying(8) NOT NULL, CONSTRAINT ip2location_db1_pkey PRIMARY KEY (ip_from, ip_to)); Import Database COPY ip2location_db11 FROM 'IP2LOCATION-LITE-DB11.CSV' WITH CSV QUOTE AS '"'; Import Database mongoimport -u USERNAME -p PASSWORD --authenticationDatabase admin --drop --db ip2location --collection ip2location_db11 --type csv --file "IP2LOCATION-LITE-DB11.CSV" --fields ip_from,ip_to,country_code,country_name,region_name,city_name,latitude,longitude,zip_code,time_zone MySQL MS-SQL PostgreSQL MongoDB Create Database CREATE DATABASE ip2location;USE ip2location;CREATE TABLE `ip2location_db11_ipv6`( `ip_from` DECIMAL(39,0) UNSIGNED, `ip_to` DECIMAL(39,0) UNSIGNED, `country_code` CHAR(2), `country_name` VARCHAR(64), `region_name` VARCHAR(128), `city_name` VARCHAR(128), `latitude` DOUBLE, `longitude` DOUBLE, `zip_code` VARCHAR(30), `time_zone` VARCHAR(8), PRIMARY KEY (`ip_to`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; Import Database LOAD DATA LOCAL INFILE 'IP2LOCATION-LITE-DB11.IPV6.CSV'INTO TABLE `ip2location_db11_ipv6`FIELDS TERMINATED BY ','ENCLOSED BY '"'LINES TERMINATED BY '\r\n'IGNORE 0 LINES; Create Database CREATE DATABASE ip2locationGOUSE ip2locationGOCREATE TABLE [ip2location].[dbo].[ip2location_db11_ipv6]( [ip_from] char(39) NOT NULL, [ip_to] char(39) NOT NULL, [country_code] nvarchar(2) NOT NULL, [country_name] nvarchar(64) NOT NULL, [region_name] nvarchar(128) NOT NULL, [city_name] nvarchar(128) NOT NULL, [latitude] float NOT NULL, [longitude] float NOT NULL, [zip_code] nvarchar(30) NOT NULL, [time_zone] nvarchar(8) NOT NULL) ON [PRIMARY]GOCREATE CLUSTERED INDEX [ip_to] ON [ip2location].[dbo].[ip2location_db11_ipv6]([ip_to]) ON [PRIMARY]GO Import Database BULK INSERT [ip2location].[dbo].[ip2location_db11_ipv6]FROM '{PATH TO IP2LOCATION-LITE-DB11.IPV6.CSV}'WITH( FORMATFILE = '{PATH TO DB11.FMT}')GO NOTE: You will need to copy the FMT code below and save it as a file named DB11.FMT on your computer. The first line of the FMT code indicates the version of bcp. Please change the version as according to your MS-SQL installed. SQL Server 2016 12.0111 SQLCHAR 0 1 """ 0 first_double_quote Latin1_General_CI_AI2 SQLCHAR 0 39 "","" 1 ip_from "",3 SQLCHAR 0 39 "","" 2 ip_to "",4 SQLCHAR 0 2 "","" 3 country_code Latin1_General_CI_AI,5 SQLCHAR 0 64 "","" 4 country_name Latin1_General_CI_AI,6 SQLCHAR 0 128 "",""

Data size / buffer pool: ".hr_bytes($enginestats{'InnoDB'})."/".hr_bytes($myvar{'innodb_buffer_pool_size'})."\n"; push(@adjvars,"innodb_buffer_pool_size (>= ".hr_bytes_rnd($enginestats{'InnoDB'}).")"); } } } # Take the two recommendation arrays and display them at the end of the output sub make_recommendations { print "\n-------- Recommendations -----------------------------------------------------\n"; if (@generalrec > 0) { print "General recommendations:\n"; foreach (@generalrec) { print " ".$_."\n"; } } if (@adjvars > 0) { print "Variables to adjust:\n"; if ($mycalc{'pct_physical_memory'} > 90) { print " *** MySQL's maximum memory usage is dangerously high ***\n". " *** Add RAM before increasing MySQL buffer variables ***\n"; } foreach (@adjvars) { print " ".$_."\n"; } } if (@generalrec == 0 && @adjvars ==0) { print "No additional performance recommendations are available.\n" } print "\n"; } # --------------------------------------------------------------------------- # BEGIN 'MAIN' # --------------------------------------------------------------------------- print "\n >> MySQLTuner $tunerversion - Major Hayden \@mhtx.net>\n". " >> Bug reports, feature requests, and downloads at " >> Run with '--help' for additional options and output filtering\n"; mysql_setup; # Gotta login first os_setup; # Set up some OS variables get_all_vars; # Toss variables/status into hashes validate_tuner_version; # Check current MySQLTuner version validate_mysql_version; # Check current MySQL version check_architecture; # Suggest 64-bit upgrade check_storage_engines; # Show enabled storage engines security_recommendations; # Display some security recommendations calculations; # Calculate everything we need mysql_stats; # Print the server stats make_recommendations; # Make recommendations based on stats # --------------------------------------------------------------------------- # END 'MAIN' # --------------------------------------------------------------------------- # Local variables: # indent-tabs-mode: t # cperl-indent-level: 8 # perl-indent-level: 8 # End: