Alexander Tretyak GonzoTheJudge

GonzoTheJudge / gist:6b42bff1fc9bbe4b61652cb902ca2765

Created April 5, 2019 11:34 — forked from jphalip/gist:c13c1c5fba7f9a6a16ce

Locust debugging

	from locust import HttpLocust, TaskSet, task
	from locust import events


	class UserBehavior(TaskSet):

	@task
	def google(self):
	self.client.get("/")

GonzoTheJudge / mysql.show.database.or.table.size

Created January 10, 2019 10:04

MySQL show database/table size in MB

	SELECT table_schema AS "Database",
	ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"
	FROM information_schema.TABLES
	GROUP BY table_schema;

	SELECT table_name AS "Table",
	ROUND(((data_length + index_length) / 1024 / 1024), 2) AS "Size (MB)"
	FROM information_schema.TABLES
	WHERE table_schema = "database_name"
	ORDER BY (data_length + index_length) DESC;