heathdutton

Fake GitHub Stars: January 2025 Analysis

This analysis uses StarScout, an open-source tool from ICSE '26 research paper "Six Million (Suspected) Fake Stars on GitHub."

Detection Methodology

Two complementary heuristics identify suspected fake stars:

Heuristic	What It Catches	Signal Strength

heathdutton

heathdutton

heathdutton

heathdutton

-- List the disk size of all tables and partitions in MySQL/InnoDB.
SELECT 
    isp.Schema,
    isp.Table,
    isp.Partition,
    ROUND(isit.size / 1e+6) AS 'MB',
    ROUND(isit.size / 1e+9) AS 'GB',
    ROUND(isit.size / 1.1e+12, 2) AS 'TiB',
    isit.File
FROM (

heathdutton

D&D 5e Unearthed Arcana Index

Because finding anything in this page is harder than it should be

Date	Article	Contents
2015-02-02	Unearthed Arcana: Eberron [PDF]	Changelings, shifters, warforged, Wizard (Artificer), rules for action points, dragonmarks

heathdutton

-- Show all tables and their corresponding innodb_table_per_file files (if present)
SELECT *
FROM (
  SELECT 
    TABLE_SCHEMA as 'Schema',
    TABLE_NAME as 'Table',
    ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024) as 'Info MB',
    ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024, 6) as 'Info GB',
    (DATA_LENGTH + INDEX_LENGTH) / 1099511627776 as 'Info TiB'
  FROM INFORMATION_SCHEMA.TABLES

heathdutton

-- Give a quick MySQL/AuroraDB database a simple health check.
-- See comments below to customize to your needs.
-- (this is all one query)

-- Step 1: Find very large tables
SELECT 'Table is very large' AS `Issue`,
       NULL                  AS `User`,
       NULL                  AS `Host`,
       TABLE_SCHEMA          AS 'DB',
       TABLE_NAME            AS `Table`,

heathdutton

DELIMITER ;;
DROP PROCEDURE IF EXISTS `assasinate`;;
CREATE PROCEDURE `assasinate`(queryportion VARCHAR(255))
BEGIN
  DECLARE sql_string MEDIUMTEXT;
  DECLARE count MEDIUMINT;
  SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
  SET FOREIGN_KEY_CHECKS = 0;
  SET @count = 0;
  SET @sql_string := 'tmp';

heathdutton