Question : I’m trying to select the time field from five tables and return the oldest time. The userid field […]
Category: MySQL
Maintaining a production big table
Question : I have a very large table: Table1 in a production environment which I need to alter a column […]
MySQL Cluster – Got error 1601 ‘Out extents, tablespace full’ from NDB
Question : I am trying to do some tests on MySQL Cluster. I am creating my database using following commands: […]
Constraint to force pair of IDs
Question : I would like a constraint to force a pair of IDs. For example, I have a table with […]
MySQL JOIN statement
Question : I have 2 tables like below: product_name id | productName —-+—————– 1 | item 1 2 | item […]
Connection to a MySQL server fails after server restart
Question : Until this morning I could connect via Sequel Pro to one of our networked machines that has the […]
mysql 8 high availability with drbd, corosync and pacemaker
Question : I would like to implement High Availability for MySQL8, is this version supported by drbd, heartbeat, corosync, pacemaker? […]
MySQL Cast to TINYINT [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
How to set mariadb read_write for some specific tables while starting as read_only=1
Question : I am trying to set a mariadb slave which is exact replica of master db. As per the […]
GRANT ROLE TO USER in MySQL
Question : I created one role QI_RO, granted all privileges on all schemas on the server and I was trying […]