Linked Questions

1
vote
0answers
20 views

Innodb file format - Percona Server [duplicate]

I had my innodb file format changed from antelope to barracuda recently. Is it safe to have both antelope and barracuda at the same time? I have my setup running properly now. What issues I would ...
3
votes
2answers
14k views

MySQL 5.5 High CPU Usage

I have been working with a client with high traffic website(500k visitors and 600-800 active users at any given time). This uses wordpress and the DB is using MyISAM engine. The problem we had was ...
2
votes
2answers
9k views

How to optimize MySQL for large BLOB updates

I have a table that holds large BLOBs (up to 10M), and is updated frequently. The problem is that UPDATE statements can take up to 1 second to execute, and due to app design this blocks UI. I need to ...
5
votes
2answers
1k views

What's the risk of keeping a table with row size > 8126 in MySQL 5.7?

I just upgraded from MySQL 5.6 to 5.7, and had the bad surprise to discover that a WordPress plugin table contains a ridiculous 438 fields, and exceeds the row size limit of 8126 bytes. Here is the ...
3
votes
2answers
693 views

AWS RDS Really Odd Error… #1041 OUT OF MEMORY, Buffers OK and Memory OK

I have an AWS RDS (MySQL 5.6.35) db.m3.medium that has given me a random error when attempting to modify a table's structure in the past two weeks: #1041 - Out of memory; check if mysqld or some ...
1
vote
1answer
1k views

innodb_thread_concurrency seems evil as it enlarge table size by big factor

Environment: OS: MS Windows 2012 R2, CPU: Xeon 12 logical processors, HDD Block Size: 8 KB, DB engine (MariaDB 10.1.23 Or MariaDB 10.2.6 Or MySQL 5.7.18) with Default Settings. Schema: CREATE ...
1
vote
1answer
764 views

Acceptable to use Antelope and Barracuda simultaneously?

I've been doing some reading about the Antelope and Barracuda file formats for InnoDB. I recall at least one source mentioning that the two should not be used simultaneously. I can't think of a good ...
1
vote
1answer
806 views

MySQL/Percona Server is taking long and I'd prefer to skip all this waiting even if it means data loss

Originally posted to https://www.facebook.com/groups/GNUAndLinux/permalink/10155020539805019/ but no replies received. I run Percona Server 5.6.21-70.0-688 x64 on Ubuntu Server 12.04 LTS x64, 64GB ...
0
votes
2answers
582 views

Minimizing database size (Many small tables)

Our database is interesting in that we have a large amount of tables that take up a correspondingly large amount of space, but when we do a MySQL dump of said database, it is surprisingly small. ...
1
vote
1answer
365 views

InnoDB compression: memory usage

InnoDB offers table compression for Barracuda-type tables and the recommendation seems to be to "adjust" buffer_pool_size. The documentation is rather vague about the definite impact of compression on ...
1
vote
2answers
367 views

MySQL TEXT Disk Space

I have a plain text file with 3 million articles divided with \n. The file is 58G When I'm adding the articles to an InnoDB table one per row INT id TEXT article_content the .ibd file of this ...