Question : I was wondering why do we deploy data files under /var/lib/mysql/. Is there a logical reason for that, […]
Category: MySQL
How to solve the error “Error ‘Got error 0 ‘No error’ from NDBCLUSTER’ on query”?
Question : I’m currently working with a large network of MySQL 5.1 DBs (using MyISAM tables) and I’m evaluating a […]
Table metadata lock MariaDB
Question : I’m having serious problems in a DB, where a “Waiting for table level lock” box is loitering and […]
Database Directory storage is full need to change link it to new Partition
Question : My mysql Database Directory size is full. So I want to change it to another partition where there […]
Mariadb always writes tmp disk to a file
Question : I’m trying to understand why Mariadb (v10.4.12) is writing most of the temp tables to disk. Created_tmp_disk_tables 196,8k […]
SELECT WHERE CASE
Question : I have the following table (MySQL): ——————————————————– | id |product_id| store_id | stock_id | priority | ——————————————————– | […]
Open Source tools to visualise MySQL/MariaDB performance metrics (show global status with interval)
Question : I’m searching for an Open Source tool to visualise MySQL/MariaDB performance metrics (output of show global status in […]
What MySQL data types REQUIRE a max length (size) declaration in a create table statement?
Question : I am converting a SQL Server table structure to a MySQL table structure, and I need to know […]
Create user for alternate port
Question : I am running a private MySQL instance on WebFaction WebFaction is a shared host who provides both for […]
Mysql ibdata1 size is too big
Question : My database size (with indexs): 70GB My ibdata1 size: 211GB How can it possible with inno_db_per_file=1 setting? SELECT […]