Linked Questions
26 questions linked to/from What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?
4
votes
2
answers
2k
views
Using MyISAM for reading and InnoDB for writing data
I read many articles about comparisons of MyISAM and InnoDB from performance point of view and I decided to use MyISAM for reading data and InnoDB for writing data.
I want to use two structure like ...
- 297
4
votes
1
answer
3k
views
Can I partially invalidate the MySQL table cache?
I want to set a fairly large table to MyISAM mode to keep it cached proactively. The table file is approximately 3GB.
After several hours, MySQL invalidates the entire table from cache, while < ...
- 41
0
votes
1
answer
2k
views
Queries are taking long time to execute
I have large DB around 25 GBs and the most busy table is around 9.5 GBs, database is increasing @ 10% per month, I am using mysql with MyISAM engine.
Problem started 3 days back, there is long list ...
6
votes
2
answers
813
views
Optimal engine for small lookup tables in MySQL
I have following question: I am designing web application with several dozens of small lookup tables: These tables usualy contain three columns (ID, Name, Description) and a couple of rows (mostly ...
- 334
0
votes
1
answer
2k
views
MySQL Read Speed and Partitioning on Separate Drives
Introduction
Simple project but for an heavy read load -90% reads- over a table(~20Milion Rows ever-growing where I have to boost performance and ensure response low time for read queries) that was ...
- 1,012
4
votes
1
answer
617
views
What's the optimal server configuration for fastest inserting in a MySql database in this scenario?
I have a MyISAM table partitioned by range with 90 partitions representing the last 90 days. I expect this table to receive somewhere between 500 million to 1 billion records before i start rotating ...
- 141
1
vote
1
answer
1k
views
What is a storage need for MySQL index on Varchar(100) in InnoDB?
I have a InnoDB table, which has EMail column (VARCHAR(100)), now I will run script which will hash some of that email addresses. I am wondering, if there is a difference in data storage (for example ...
- 113
1
vote
1
answer
1k
views
MySQL CHAR(500)?
I have a table in which one of the fields is always going to be exactly 500 ASCII characters.
I'd like it to be saved inline in the database and be as efficient as possible, as it will be a big table,...
- 157
0
votes
2
answers
788
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.
...
- 447
1
vote
2
answers
250
views
PROCEDURE ANALYSE suggests to turn timestamp into CHAR(19)
Using Procedure Analyse() under MySQL 5.6.30 on a table with about 4 million rows makes the following recommendations:
change timestamp to char(19)
tinyint to ENUM (I noticed it's overzealous with ...
- 473
1
vote
1
answer
293
views
MySQL Multi-Valued Indexes
In the following SQL, Multi-Valued Indexes are generated for the json array.
ALTER TABLE table_name ADD INDEX index_name((CAST(json->'$.field' AS json_type ARRAY))).
ALTER TABLE table_name ADD ...
- 31