EP_198--Swimming with Threads

This week, we discuss server thread pooling in MySQL and MariaDB. Ear Candy is a workaround for max key length in InnoDB, and At the Movies is Continuous Integration For Your Database Migrations. News In the news, the OurSQL podcast will change to a monthly format after episode 200. We will still bring the quality episodes you know and love, they will just be spaced further apart. Events DB Hangops - every other Thursday at 11 am Pacific time. Upcoming SkySQL events Upcoming MySQL events MySQL Central will happen during Oracle's OpenWorld conference, Monday September 29th through Thursday October 2nd, 2014. The conference has been expanded in the past few years, when it was known as MySQL Connect. Training SkySQL Trainings Tungsten University trainings Oracle's MySQL Trainings Percona Trainings Server Thread Pooling Server Thread Pool plugin for MySQL manual page MariaDB thread pool knowledgebase plugin_dir where you can find thread_pool.so or thread_pool.dll (Windows) for MySQL Enterprise thread pooling. Installing the thread pool plugin on MySQL thread_pool_size thread_pool_max_threads thread_pool_stall_limit in MariaDB thread_pool_high_priority_connection (MySQL) thread_pool_priority_kickup_timer (MySQL) thread_pool_idle_timeout (MariaDB) thread_pool_oversubscribe thread_pool_min_threads extra-port (MariaDB) MySQL Manual on server thread pool tuning MariaDB Knowledgebase on tuning the threadpool and differences between MariaDB and MySQL Enterprise server thread pool Ear Candy This week in ear candy, we discuss a workaround for max key length in InnoDB. innodb_large_prefix server variable At the movies This week in At the Movies, we present Continuous Integration For Your Database Migrations by Michael Still of Rackspace. This presentation was given at the 2014 Linux Conference Australia. Feedback Facebook group Google+ page e-mail: podcast at technocation.org voicemail using phone/Skype: +1-617-674-2369 twitter: @oursqlcast or Tweet about @oursqlcast