Questions tagged [mariadb-10.1]

Question 1

Question: Does anyone have advice on what I can do to successfully get this new replica set up and replicating from our production server just like the old replica? Details: I am trying to set up a ...

Question 2

Slow query is enabled but only logs few queries when you retrieve the slow log. It’s been working ok all last week, suddenly this week, it only logs just 2 or 3 queries. Long query time = 0.01 and I ...

Question 3

I am facing an issue with MariaDB 10.1 on a log table with the following (simplified) structure: CREATE TABLE logs ( log_id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, log_date TIMESTAMP DEFAULT ...

Question 4

I have been reading too many information about InnoDB parameters, but I still have a doubt. Should "innodb_log_buffer_size" be larger than "innodb_buffer_pool_size"?

Question 5

Given the following tables.. CREATE TABLE `event` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(50) COLLATE utf8_general_ci NOT NULL, `data` longblob NOT NULL, `...

Question 6

I have 2 tables with below structures. question table id, audio, s_id 1, ad1, 500 2, ad2, 500 3, ad3, 500 answers table where q_id is FK of question table. id, s_id, q_id, number, answer 1, 500, 1, ...

Question 7

MariaDB server experiences some sort of freezes happening sporadically with no visible reason or connection to outside factors (load, etc). After a thorough investigation the common picture for those ...

Question 8

There is a table with compound key: t_count + pageType VARCHAR(32) ascii_bin + pageId VARCHAR(255) utf8_bin + count INT PRIMARY(pageType, pageId) Its purpose is to track how many times each page ...

Question 9

Currently I have several sql queries that look like this: INSERT INTO `test` (col1, col2) SELECT * FROM (SELECT '1','2') AS tmp WHERE NOT EXISTS ( SELECT * FROM `test` WHERE col1='1' AND col2='...

Question 10

I had tried to change MariaDB root password using following Ansible script. - name: Dump MySQL root Password debug: msg: "MySQL new Password : {{ mysql_pass }}" ...

Question 11

I have two tables namely table_a and table_b. Table_a has several columns including student_id and course_start_date Table_b has several columns including student_id and fee_pay_date student_id is INT ...

Question 12

I have read many different questions about slow MariaDB/MySQL shutdown, but I have not found an answer which solves my problem yet. On one of our servers with the highest load, when I issue a stop ...

Question 13

When I run following command mysqld_safe --skip-grant-tables & I get message myuser@myvm:~$ 200523 08:24:41 mysqld_safe Logging to syslog. 200523 08:24:41 mysqld_safe Starting mysqld daemon ...

Question 14

I have this query: SELECT COUNT(*) AS "Other" FROM events JOIN triggers ON events.objectid = triggers.triggerid WHERE events.name REGEXP "No data from SAM0056(.FTG|.REC|.LEFT|.RIGHT|.BACK), .* ...

Question 15

When I create a new user in MariaDB, I cannot login as that user. First I login to the database as root doing mariadb in a bash terminal. I then run the following commands to create a database and ...

Stack Exchange Network

Questions tagged [mariadb-10.1]

Troubleshooting foreign key dependency error when setting up new MariaDB replica

Slow Query Log Only Logs Few Queries

Very slow MariaDB query when adding ORDER BY/LIMIT but there are no rows

InnoDB Buffer Pool and Buffer Log

How are SELECT queries isolated from each other with MariaDB 10.1?

GROUP CONCAT and GROUP BY using LEFT JOIN If no record exist Must return something

MariaDB freezes with no visible reason

Updating log table in an effective manner

MariaDB: Insert records (list of tuples) into table if not exists

MariaDB root password change using Ansible

SQL Error(1054): Unknown column in 'where clause' when trying to update. Column is actually available

MariaDB 10.1 shutdown stuck at "Event Scheduler: Purging the queue"

Unable to run mariadb in safe mode

Optimize SELECT statement for mysql database

Cannot login as new user on MariaDB

Hot Network Questions