Blog

I have this table: +—-+——————+——————+ | Id | Start | End | +—-+——————+——————+ | 1 | 2018-02-04 11:30 | 2018-02-05 12:00 | | 2 | 2018-02-04 15:40 | 2018-02-05 08:00 | | 3 | 2018-02-05 10:00 | 2018-02-06 09:00 | +—-+——————+——————+ I found this strange situation using MariaDB 10.1.18 InnoDB. I called this query: SELECTRead more

I have two tables Table A and table B. Table B has a foreign key reference on table A. Table A has multi column indexes. When I insert into table B(id references last row of Table A) a shared S lock is taken on supremum pseudo record in table A. Why is this gap lockRead more

How can I restore a InnoDB database from filesystem files (FRM/IBD)? I cannot run db service from that system, so I tought to move its file to another Windows machine but I don’t know if is there any procedure to follow in this case.Read more

I am continuous getting above error in mysqld log. Please tell me what is this error about and how to solve it. I am using mysql 5.7 (not mariadb)Read more

Table structure for config: property (primary key) value description Query: SELECT property, value FROM config If I put a covering index on (property, value) the optimizer still chooses the PRIMARY index, but the extra in EXPLAIN is NULL. If I tell the optimizer to use my covering index, the extra in EXPLAIN is USING INDEX.Read more

After running mysqltuner.pl, I get an Innodb write log efficiency way above 100 %. Why? What does it mean? There is no specific reccomendation from mysqltuner. DB is MariaDB 10.1.26 on Debian 9.x with 1 GB RAM. ——– InnoDB Metrics —————————————————————————- [–] InnoDB is enabled. [–] InnoDB Thread Concurrency: 0 [OK] InnoDB File per tableRead more

I am using Jamf to manage 25K Macs and 13K iOS devices. Every time I try to update iOS apps or configuration profiles for a large number of devices my database gets overwhelmed. I have MySQL 5.6 running on Windows server 2008R2 with 16 cores and 32GB Ram. I have tried adjusting things like query_cacheRead more

I’ve read that table_open_cache variable is only for MyIsam tables and has nothing to do with InnoDB tables. Is this true?Read more

I’m having a problem with Mamp 4.2.1 and Mac OS 10.13.2 When I run Mamp, the open web page is grayed out and I have this message in the logs 2017-12-31 10:07:47 1921 [Warning] InnoDB: Cannot open table mysql/innodb_index_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. SeeRead more

We are setting up a replicated slave from a MySQL database running 5.6.37. The slave is running the exact same version. All tables use InnoDB as engine. Mysqldump is invoked with: mysqldump –master-data –routines –single-transaction –skip-lock-tables –databases db_1 db_2 We have two databases that should be replicated. After reading documentation and following examples found whenRead more