mysql_kill(3)

💅 mysql_kill — bestie, we're ending this connection's whole career

okay so this is mysql_kill(3), straight out of the MariaDB Connector/C manual. yeah, manual section 3, the C library girlies. let's get into it 🎀

✨ NAME ✨

mysql_kill — kills a connection. that's it. that's the whole vibe. it's giving executioner but make it a function call 💀

🌸 SYNOPSIS 🌸

#include <mysql.h>

int mysql_kill(MYSQL * mysql,
               unsigned long);

yes bestie, that second param is literally just unsigned long with no name. the manual said what it said, and we're keeping it exactly. no notes 🫶

🦋 DESCRIPTION 🦋

so basically you use this function to ask the server to kill a MariaDB thread, and you pick which thread with the processid parameter. key word: ask. the server does the actual yeeting 🔥

and where do you get that processid from, you ask? you gotta retrieve it with SHOW PROCESSLIST. that's the plug. no cap.

but wait — if the thread you're trying to kill is your own connection? then you use mysql_thread_id(3) instead. don't be out here trying to kill yourself with the wrong function, that's embarrassing 😭

💖 PARAMETER 💖

• mysql — a connection identifier, which was previously allocated by mysql_init(3) and connected by mysql_real_connect(3). returns 0 on success, otherwise nonzero.
• long — process id. that's the one. the target. the chosen one ✨

👑 NOTES 👑

• if you just wanna stop a running command without killing the whole connection, use KILL QUERY instead. like, calm down, you don't have to end everything 💅
• lowkey important: mysql_kill() only kills a connection. it does not free any memory. none. zero. nada. you have to free that yourself, explicitly, by calling mysql_close(3). don't forget or the memory just sits there haunting you 🙈

🌈 RETURN VALUE 🌈

returns zero on success, non zero on error. simple as that, fr fr.

🎀 SEE ALSO 🎀

• mysql_thread_id(3)
• mysql_close(3)
• mariadb_cancel(3)

ok that's the whole page bestie, go forth and kill connections responsibly 🫶✨

Version 3.4 of the MariaDB Connector/C manual, babes — that's the source and the version, and honestly? iconic. slay 💜👑