Kannan Muthukkaruppan kmuthukk

Co-Founder/Co-CEO @ YugaByte

kmuthukk / fires_load.sql

Last active June 13, 2022 23:25

Sample load script for "fires" synthetic test data.

	# Dependencies:
	# On CentOS you can install psycopg2 thus:
	#
	# sudo yum install postgresql-libs
	# sudo yum install python-psycopg2

	import psycopg2;
	import datetime;
	from multiprocessing.dummy import Pool as ThreadPool

kmuthukk / ysql_one_to_one_github_10654.sql

Created November 22, 2021 20:50

Test case for https://github.com/yugabyte/yugabyte-db/issues/10654

	# Dependencies:
	# On CentOS you can install psycopg2 thus:
	#
	# sudo yum install postgresql-libs
	# sudo yum install python-psycopg2

	import psycopg2;
	from multiprocessing.dummy import Pool as ThreadPool

	num_tenants=100

kmuthukk / ysql_many_tables.py

Created May 29, 2021 15:07

sample script to load test creations of tables across many schemas

	# Dependencies:
	# On CentOS you can install psycopg2 thus:
	#
	# sudo yum install postgresql-libs
	# sudo yum install python-psycopg2

	import psycopg2;
	from multiprocessing.dummy import Pool as ThreadPool

	connect_string = "host={} dbname=yugabyte user=yugabyte port=5433".format("172.151.44.47");

kmuthukk / sample_loader_for_issue_6509.py

Created November 30, 2020 22:59

	# Dependencies:
	# On CentOS you can install psycopg2 thus:
	#
	# sudo yum install postgresql-libs
	# sudo yum install python-psycopg2

	import psycopg2;
	from multiprocessing.dummy import Pool as ThreadPool

	num_users=1000000

kmuthukk / LargeScan.java

Created November 30, 2020 22:11

	package com.yugabyte.sample.apps;
	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.ResultSet;
	import java.sql.SQLException;
	import java.sql.Statement;
	import java.sql.PreparedStatement;
	import java.sql.Array;
	import java.util.ArrayList;

kmuthukk / ScanAndDelete.java

Created November 25, 2020 01:17

	package com.yugabyte.sample.apps;
	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.ResultSet;
	import java.sql.SQLException;
	import java.sql.Statement;
	import java.sql.PreparedStatement;
	import java.sql.Array;
	import java.util.ArrayList;

kmuthukk / DeferrableScan.java

Last active November 24, 2020 22:23

	package com.yugabyte.sample.apps;
	import java.sql.Connection;
	import java.sql.DriverManager;
	import java.sql.ResultSet;
	import java.sql.SQLException;
	import java.sql.Statement;
	import java.sql.PreparedStatement;

	public class DeferrableScan {

kmuthukk / ysql_select_for_update.py

Last active November 24, 2020 19:26

	# Dependencies:
	# On CentOS you can install psycopg2 thus:
	#
	# sudo yum install postgresql-libs
	# sudo yum install python-psycopg2

	import psycopg2
	from threading import Thread,Semaphore
	import random
	import time

kmuthukk / ysql_load.py

Last active November 10, 2020 19:09

	# Dependencies:
	# On CentOS you can install psycopg2 thus:
	#
	# sudo yum install postgresql-libs
	# sudo yum install python-psycopg2

	import psycopg2
	import time
	from multiprocessing.dummy import Pool as ThreadPool

kmuthukk / ycql_overwrite_range_query.py

Created October 10, 2020 01:55

test program to test range scan in the presence of high overwrites

	pip install yb-cassandra-driver

	from cassandra.cluster import Cluster
	from cassandra import ConsistencyLevel
	import time
	import random
	from multiprocessing.dummy import Pool as ThreadPool


	cluster = Cluster(['127.0.0.1'])