mysql_refresh(3)

📦
version 13.0.2 · 4 versions
, in alpine 3.22, alpine 3.23, alpine 3.24, arch rolling, centos-stream 10, debian trixie, fedora 43, fedora 44, nixpkgs unstable, opensuse-leap 16.0, ubuntu questing, ubuntu resolute, ubuntu stonking

✨ mysql_refresh — the glow-up your server info needed ✨

okay bestie, gather round 💖 this is a page from the MariaDB Connector/C manual, and today's main character is mysql_refresh(3) — the function that flushes information on the server. it's giving "spring cleaning but for caches". no cap. 🧹✨

🌸 SYNOPSIS 🌸

#include <mysql.h>

int mysql_refresh(MYSQL * mysql, unsigned int options);

like, that's the whole vibe. one include, one call. iconic. 💅

🦋 DESCRIPTION 🦋

so what does it do?? it flushes different types of information stored on the server. that's it, that's the girl. 💫

the parameter options is a bit-masked integer, and it tells the server which kind of information is gonna get flushed. you pick the flavours, she does the work. periodt. 👑

🎀 PARAMETERS 🎀

  • mysql — a mysql handle, which was previously allocated by mysql_init(3) and connected by mysql_real_connect(3). so like, she has to already exist and already be connected, ok?? don't come at her with a fresh uninitialized pointer, that's not the move. 🙈
  • options — a bit masked composed integer. see below, bestie 👇

options can be any combination of the following flags:

  • REFRESH_GRANT — Refresh grant tables. 🔐
  • REFRESH_LOG — Flush logs. 🪵
  • REFRESH_TABLES — Flush table cache. 🗂️
  • REFRESH_HOSTS — Flush host cache. 🏠
  • REFRESH_STATUS — Reset status variables. 📊
  • REFRESH_THREADS — Flush thread cache. 🧵
  • REFRESH_SLAVE — Reset master server information and restart slaves. 🫶
  • REFRESH_MASTER — Remove binary log files. 🗑️

💜 NOTES 💜

  • To combine different values in the options parameter, use the OR operator |. literally just stack them with pipes, she eats. 🍓
  • mysql_reload() is an alias for mysql_refresh(). same girl, different name. iykyk. ✨

🌈 RETURN VALUE 🌈

Returns zero on success, otherwise non zero. so 0 = slay, anything else = something's up, go check yourself before you wreck yourself. 💀

okay and that's the whole page!! every single flag, every single alias, every single return value — nothing left out, nothing made up. she's thorough AND cute. no cap. 👑💖

this has been Version 3.4 of the mysql_refresh(3) page from the MariaDB Connector/C crew — mwah, love u, go flush responsibly 🎀🦋💅

📦 where this page comes from