Kaby Lake / Z270 Overclocking Statistics

[Massman]

Kaby Lake Statistics

• 964 overclocking results
  
• 132 overclockers
  

[table=head]{colsp=2}Hardware Statistics

Top-5 Motherboard Brands | ASUS, GIGABYTE, MSI

Top-5 Mainboards (users) | GIGABYTE Z270X-Gaming SOC, ASUS ROG Maximus IX Formula, ASUS ROG Maximus IX Hero, MSI Z270 XPower Gaming Titanium, ASUS ROG Maximus IX Apex

Top-5 Mainboards (submissions) | GIGABYTE Z270X-Gaming SOC, ASUS ROG Maximus IX Apex, ASUS ROG Maximus IX Formula, MSI Z270 XPower Gaming Titanium, ASUS ROG Maximus IX Hero

Top-5 Memory Brand (users) | G.SKILL, Corsair, Samsung, Kingston, GALAX

Top-5 CPU SKU | Core i7 7700K, Core i7 7500U, Core i5 7600K, Core i5 7200U, Core i3 7350K

Top-5 CPU Cooling | Liquid Nitrogen (50.65%), AIO Water (15.45%), Water cooling (10.94%), Air cooling (6.91%), Cascade (3.17%)[/table]

 

Last updated: 15/11/2016

 

[table=head]{colsp=2}Community Statistics

Most Active User | topyoyoguybest, 41 submissions

Most Active Team | PURE, 51 submissions

Most Active Country | United States, 241 submissions

Highest Variety CPUs by User | Overclockers.com, 3 CPUs

Highest Variety CPUs by Country | 4 countries, 40 CPUs

Highest Variety Motherboards by User | [flag]id.png" > Bboyjezz, 3 motherboards

Highest Variety Motherboards by Team | Hardwareluxx.de, 5 motherboards

Highest Variety Motherboards by Country | Germany, 14 motherboards[/table]

 

SELECT COUNT(*), COUNT(DISTINCT user_id), COUNT(DISTINCT result.mb_model_id) FROM result JOIN cpu_model USING (cpu_id) WHERE core_id=1219;
SELECT COUNT(*), COUNT(DISTINCT mb_model.manufacturer_id) FROM mb_model WHERE mb_model.chipset_id=6391;

SELECT manufacturer.name, COUNT(*) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id = 6391) GROUP BY manufacturer_id ORDER BY COUNT(*) DESC;
SELECT mb_model.name, COUNT(DISTINCT user_id) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id = 6391) GROUP BY mb_model.model_id ORDER BY COUNT(DISTINCT user_id) DESC;
SELECT mb_model.name, COUNT(*) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id = 6391) GROUP BY mb_model.model_id ORDER BY COUNT(*) DESC;
SELECT mb_model.name, COUNT(DISTINCT user_id) FROM result JOIN mb_model ON (result.mb_model_id = mb_model.model_id) JOIN manufacturer USING (manufacturer_id) WHERE (mb_model.chipset_id=6391 AND result.cpucooling_id=9) GROUP BY mb_model.model_id ORDER BY COUNT(DISTINCT user_id) DESC;

SELECT result_data.memory_vendor, COUNT(*) FROM result JOIN result_data USING (data_id) JOIN cpu_model USING (cpu_id) WHERE core_id=1219 GROUP BY memory_vendor ORDER BY COUNT(*) DESC;
SELECT cpu_model.model, COUNT(*) FROM result JOIN cpu_model USING (cpu_id) WHERE core_id=1219 GROUP BY cpu_id ORDER BY COUNT(*) DESC;

SELECT cooling.name, COUNT(*)/1321 FROM result JOIN cooling ON (result.cpucooling_id = cooling.cooling_id) JOIN cpu_model USING (cpu_id) WHERE core_id=1219 GROUP BY cooling.cooling_id ORDER BY COUNT(*) DESC;

SELECT user.name, COUNT(*) FROM result JOIN USER USING (user_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY user_id ORDER BY COUNT(*) DESC;
SELECT team.teamname, COUNT(*) FROM result JOIN USER USING (user_id) JOIN team ON (user.team_id = team.team_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY team.team_id ORDER BY COUNT(*) DESC;
SELECT country.name, COUNT(*) FROM result JOIN USER USING (user_id) JOIN country USING (country_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY country_id ORDER BY COUNT(*) DESC;
SELECT user.name, COUNT(DISTINCT cpu_id) FROM result JOIN USER USING (user_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY user_id ORDER BY COUNT(DISTINCT cpu_id) DESC;
SELECT team.teamname, COUNT(DISTINCT cpu_id) FROM result JOIN USER USING (user_id) JOIN team ON (user.team_id = team.team_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY team.team_id ORDER BY COUNT(DISTINCT cpu_id) DESC;
SELECT country.name, COUNT(DISTINCT cpu_id) FROM result JOIN USER USING (user_id) JOIN country USING (country_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY country_id ORDER BY COUNT(DISTINCT cpu_id) DESC;
SELECT user.name, COUNT(DISTINCT result.mb_model_id) FROM result JOIN USER USING (user_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY user_id ORDER BY COUNT(DISTINCT result.mb_model_id) DESC;
SELECT team.teamname, COUNT(DISTINCT result.mb_model_id) FROM result JOIN USER USING (user_id) JOIN team ON (user.team_id = team.team_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY team.team_id ORDER BY COUNT(DISTINCT result.mb_model_id) DESC;
SELECT country.name, COUNT(DISTINCT result.mb_model_id) FROM result JOIN USER USING (user_id) JOIN country USING (country_id) JOIN cpu_model USING (cpu_id) WHERE cpu_model.core_id=1219 GROUP BY country_id ORDER BY COUNT(DISTINCT result.mb_model_id) DESC;