Query 2<\/strong> below will do mass killing MySQL connections \/ processes quickly .<\/p>\nQuery 1\r\n\r\nmysql> SHOW FULL PROCESSLIST\\G;\r\n\r\n*************************** 1. row ***************************\r\n\r\n\u00a0\u00a0 \u00a0 Id: 3\r\n\r\n\u00a0\u00a0 User: root\r\n\r\n\u00a0\u00a0 Host: localhost\r\n\r\n\u00a0\u00a0 \u00a0 db: NULL\r\n\r\nCommand: Query\r\n\r\n\u00a0\u00a0 Time: 0\r\n\r\n\u00a0 State: NULL\r\n\r\n\u00a0\u00a0 Info: SHOW FULL PROCESSLIST\r\n\r\n*************************** 2. row ***************************\r\n\r\n\u00a0\u00a0 \u00a0 Id: 15008\r\n\r\n\u00a0\u00a0 User: root\r\n\r\n\u00a0\u00a0 Host: localhost\r\n\r\n\u00a0\u00a0 \u00a0 db: mysqlslap\r\n\r\nCommand: Sleep\r\n\r\n\u00a0\u00a0 Time: 0\r\n\r\n\u00a0 State:\u00a0\r\n\r\n\u00a0\u00a0 Info: NULL\r\n\r\n*************************** 3. row ***************************\r\n\r\n\u00a0\u00a0 \u00a0 Id: 19759\r\n\r\n\u00a0\u00a0 User: root\r\n\r\n\u00a0\u00a0 Host: localhost\r\n\r\n\u00a0\u00a0 \u00a0 db: mysqlslap\r\n\r\nCommand: Query\r\n\r\n\u00a0\u00a0 Time: 0\r\n\r\n\u00a0 State: query end\r\n\r\n\u00a0\u00a0 Info: INSERT INTO t1 VALUES (95275444,'bNIrBDBl81tjzdvuOpQRCXgX37xGtzLKEXBIcE3k7xK7aFtqxC99jqYnpTviK83bf6lGDgsKd4R3KLmHPnI8TqnIKj1gjw7N2sXFZNS2Svyg8cpZN7atxL39w4igsp')\r\n\r\n*************************** 4. row ***************************\r\n\r\n\u00a0\u00a0 \u00a0 Id: 19760\r\n\r\n\u00a0\u00a0 User: root\r\n\r\n\u00a0\u00a0 Host: localhost\r\n\r\n\u00a0\u00a0 \u00a0 db: mysqlslap\r\n\r\nCommand: Sleep\r\n\r\n\u00a0\u00a0 Time: 0\r\n\r\n\u00a0 State:\u00a0\r\n\r\n\u00a0\u00a0 Info: NULL\r\n\r\n*************************** 5. row ***************************\r\n\r\n\u00a0\u00a0 \u00a0 Id: 19761\r\n\r\n\u00a0\u00a0 User: root\r\n\r\n\u00a0\u00a0 Host: localhost\r\n\r\n\u00a0\u00a0 \u00a0 db: mysqlslap\r\n\r\nCommand: Query\r\n\r\n\u00a0\u00a0 Time: 0\r\n\r\n\u00a0 State: query end\r\n\r\n\u00a0\u00a0 Info: INSERT INTO t1 VALUES (95275444,'bNIrBDBl81tjzdvuOpQRCXgX37xGtzLKEXBIcE3k7xK7aFtqxC99jqYnpTviK83bf6lGDgsKd4R3KLmHPnI8TqnIKj1gjw7N2sXFZNS2Svyg8cpZN7atxL39w4igsp')\r\n\r\n*************************** 6. row ***************************\r\n\r\n\u00a0\u00a0 \u00a0 Id: 19762\r\n\r\n\u00a0\u00a0 User: root\r\n\r\n\u00a0\u00a0 Host: localhost\r\n\r\n\u00a0\u00a0 \u00a0 db: mysqlslap\r\n\r\nCommand: Query\r\n\r\n\u00a0\u00a0 Time: 0\r\n\r\n\u00a0 State: query end\r\n\r\n\u00a0\u00a0 Info: INSERT INTO t1 VALUES (95275444,'bNIrBDBl81tjzdvuOpQRCXgX37xGtzLKEXBIcE3k7xK7aFtqxC99jqYnpTviK83bf6lGDgsKd4R3KLmHPnI8TqnIKj1gjw7N2sXFZNS2Svyg8cpZN7atxL39w4igsp')\r\n\r\n*************************** 7. row ***************************\r\n\r\n\u00a0\u00a0 \u00a0 Id: 19763\r\n\r\n\u00a0\u00a0 User: root\r\n\r\n\u00a0\u00a0 Host: localhost\r\n\r\n\u00a0\u00a0 \u00a0 db: mysqlslap\r\n\r\nCommand: Query\r\n\r\n\u00a0\u00a0 Time: 0\r\n\r\n\u00a0 State: query end\r\n\r\n\u00a0\u00a0 Info: INSERT INTO t1 VALUES (95275444,'bNIrBDBl81tjzdvuOpQRCXgX37xGtzLKEXBIcE3k7xK7aFtqxC99jqYnpTviK83bf6lGDgsKd4R3KLmHPnI8TqnIKj1gjw7N2sXFZNS2Svyg8cpZN7atxL39w4igsp')\r\n<\/pre>\nThe query below get you the script for mass killing of \u00a0MySQL in one key stroke , I usually use this when I am suspecting something unacceptable is happening in MySQL.<\/p>\n
Query 2\r\nmysql> select concat('KILL ',id,';') from information_schema.processlist where user='root';\r\n\r\n+------------------------+\r\n\r\n| concat('KILL ',id,';') |\r\n\r\n+------------------------+\r\n\r\n| KILL 21159;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21158;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21157;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21156;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21155;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21154;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21153;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21152;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21151;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21150;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21149;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21148;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21147;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21146;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21145;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21144;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21143;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21142;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21141;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n\r\n| KILL 21140;\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |\r\n<\/pre>\n <\/p>\n
mysql> select concat('KILL ',id,';') from information_schema.processlist where user='root' into outfile '\/var\/lib\/mysql-files\/kill-mysql-conn.txt';\r\n\r\nQuery OK, 1 row affected (0.00 sec)\r\n\r\nmysql> source \/var\/lib\/mysql-files\/kill-mysql-conn.txt<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes we may have to kill several MySQL connections \/ processes, How can we do that effortlessly ? We have to first list down the connections you want to kill with ” SHOW FULL PROCESSLIST […]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,2,3,37,42],"tags":[6,43,44],"yoast_head":"\nEnterprise-class Consulting, 24*7 Support and Remote DBA Services for MySQL, MariaDB, PostgreSQL and ClickHouse<\/title>\n<meta name=\"description\" content=\"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mass killing of MySQL connections \/ processes\" \/>\n<meta property=\"og:description\" content=\"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering\" \/>\n<meta property=\"og:url\" content=\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/\" \/>\n<meta property=\"og:site_name\" content=\"The WebScale Database Infrastructure Operations Experts\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/WebScaleDBA\/\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/TheWebScaleDBA\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-06T10:01:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-03-11T18:31:45+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Shiv Iyer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@http:\/\/twitter.com\/thewebscaledba\" \/>\n<meta name=\"twitter:site\" content=\"@webscaledba\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Shiv Iyer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/\"},\"author\":{\"name\":\"Shiv Iyer\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618\"},\"headline\":\"Mass killing of MySQL connections \/ processes\",\"datePublished\":\"2018-01-06T10:01:27+00:00\",\"dateModified\":\"2018-03-11T18:31:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/\"},\"wordCount\":82,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"keywords\":[\"MySQL DBA\",\"MySQL Kill\",\"MySQL Troubleshooting\"],\"articleSection\":[\"Kill MySQL Connections\",\"MySQL\",\"MySQL DBA\",\"MySQL Troubleshooting\",\"Show processlist\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/\",\"url\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/\",\"name\":\"Enterprise-class Consulting, 24*7 Support and Remote DBA Services for MySQL, MariaDB, PostgreSQL and ClickHouse\",\"isPartOf\":{\"@id\":\"https:\/\/minervadb.com\/#website\"},\"datePublished\":\"2018-01-06T10:01:27+00:00\",\"dateModified\":\"2018-03-11T18:31:45+00:00\",\"description\":\"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering\",\"breadcrumb\":{\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/minervadb.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mass killing of MySQL connections \/ processes\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/minervadb.com\/#website\",\"url\":\"https:\/\/minervadb.com\/\",\"name\":\"The WebScale Database Infrastructure Operations Experts\",\"description\":\"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations\",\"publisher\":{\"@id\":\"https:\/\/minervadb.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/minervadb.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/minervadb.com\/#organization\",\"name\":\"MinervaDB\",\"url\":\"https:\/\/minervadb.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"contentUrl\":\"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg\",\"width\":200,\"height\":200,\"caption\":\"MinervaDB\"},\"image\":{\"@id\":\"https:\/\/minervadb.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/WebScaleDBA\/\",\"https:\/\/x.com\/webscaledba\",\"https:\/\/www.linkedin.com\/company\/minervadb\/\",\"https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618\",\"name\":\"Shiv Iyer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/minervadb.com\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g\",\"caption\":\"Shiv Iyer\"},\"description\":\"WebScale Database Infrastructure Operations Expert in MySQL, MariaDB, PostgreSQL and ClickHouse with core interests in performance, scalability, high availability and database reliability engineering. Shiv currently is the Founder and Principal of MinervaDB, an independent and vendor neutral Consulting, 24*7 Support and Remote DBA Services provider for MySQL, MariaDB, PostgreSQL and ClickHouse serving approximately 300 customers globally.\",\"sameAs\":[\"http:\/\/minervadb.com\",\"https:\/\/www.facebook.com\/TheWebScaleDBA\",\"https:\/\/x.com\/http:\/\/twitter.com\/thewebscaledba\"],\"url\":\"http:\/\/minervadb.com\/index.php\/author\/shiv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Enterprise-class Consulting, 24*7 Support and Remote DBA Services for MySQL, MariaDB, PostgreSQL and ClickHouse","description":"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/","og_locale":"en_US","og_type":"article","og_title":"Mass killing of MySQL connections \/ processes","og_description":"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering","og_url":"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/","og_site_name":"The WebScale Database Infrastructure Operations Experts","article_publisher":"https:\/\/www.facebook.com\/WebScaleDBA\/","article_author":"https:\/\/www.facebook.com\/TheWebScaleDBA","article_published_time":"2018-01-06T10:01:27+00:00","article_modified_time":"2018-03-11T18:31:45+00:00","og_image":[{"width":200,"height":200,"url":"http:\/\/minervadb.com\/wp-content\/uploads\/2019\/07\/LogoColorTextRight.jpeg","type":"image\/jpeg"}],"author":"Shiv Iyer","twitter_card":"summary_large_image","twitter_creator":"@http:\/\/twitter.com\/thewebscaledba","twitter_site":"@webscaledba","twitter_misc":{"Written by":"Shiv Iyer","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/#article","isPartOf":{"@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/"},"author":{"name":"Shiv Iyer","@id":"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618"},"headline":"Mass killing of MySQL connections \/ processes","datePublished":"2018-01-06T10:01:27+00:00","dateModified":"2018-03-11T18:31:45+00:00","mainEntityOfPage":{"@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/"},"wordCount":82,"commentCount":0,"publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"keywords":["MySQL DBA","MySQL Kill","MySQL Troubleshooting"],"articleSection":["Kill MySQL Connections","MySQL","MySQL DBA","MySQL Troubleshooting","Show processlist"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/","url":"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/","name":"Enterprise-class Consulting, 24*7 Support and Remote DBA Services for MySQL, MariaDB, PostgreSQL and ClickHouse","isPartOf":{"@id":"https:\/\/minervadb.com\/#website"},"datePublished":"2018-01-06T10:01:27+00:00","dateModified":"2018-03-11T18:31:45+00:00","description":"Independent and vendor neutral consulting, support and remote DBA services for MySQL, MariaDB, PostgreSQL and ClickHouse with core expertize in Performance, Scalability, High Availability and Database Reliability Engineering","breadcrumb":{"@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/minervadb.com\/index.php\/2018\/01\/06\/mass-killing-of-mysql-connections-processes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/minervadb.com\/"},{"@type":"ListItem","position":2,"name":"Mass killing of MySQL connections \/ processes"}]},{"@type":"WebSite","@id":"https:\/\/minervadb.com\/#website","url":"https:\/\/minervadb.com\/","name":"The WebScale Database Infrastructure Operations Experts","description":"Committed to Building Optimal, Scalable, Highly Available, Fault-Tolerant, Reliable and Secured WebScale Database Infrastructure Operations","publisher":{"@id":"https:\/\/minervadb.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/minervadb.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/minervadb.com\/#organization","name":"MinervaDB","url":"https:\/\/minervadb.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/","url":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","contentUrl":"https:\/\/minervadb.com\/wp-content\/uploads\/2018\/03\/LogoColorTextRight.jpeg","width":200,"height":200,"caption":"MinervaDB"},"image":{"@id":"https:\/\/minervadb.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/WebScaleDBA\/","https:\/\/x.com\/webscaledba","https:\/\/www.linkedin.com\/company\/minervadb\/","https:\/\/www.youtube.com\/channel\/UClLrz7wS8gVyAR8Lf5x7r1g?view_as=subscriber"]},{"@type":"Person","@id":"https:\/\/minervadb.com\/#\/schema\/person\/b32f096648ad17f01728c12a58285618","name":"Shiv Iyer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/minervadb.com\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/491f7719e102a566a11d41313372a8cf?s=96&d=blank&r=g","caption":"Shiv Iyer"},"description":"WebScale Database Infrastructure Operations Expert in MySQL, MariaDB, PostgreSQL and ClickHouse with core interests in performance, scalability, high availability and database reliability engineering. Shiv currently is the Founder and Principal of MinervaDB, an independent and vendor neutral Consulting, 24*7 Support and Remote DBA Services provider for MySQL, MariaDB, PostgreSQL and ClickHouse serving approximately 300 customers globally.","sameAs":["http:\/\/minervadb.com","https:\/\/www.facebook.com\/TheWebScaleDBA","https:\/\/x.com\/http:\/\/twitter.com\/thewebscaledba"],"url":"http:\/\/minervadb.com\/index.php\/author\/shiv\/"}]}},"_links":{"self":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/581"}],"collection":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/comments?post=581"}],"version-history":[{"count":6,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/581\/revisions"}],"predecessor-version":[{"id":1053,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/posts\/581\/revisions\/1053"}],"wp:attachment":[{"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/media?parent=581"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/categories?post=581"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/minervadb.com\/index.php\/wp-json\/wp\/v2\/tags?post=581"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}