Tag Info

New answers tagged

0

By default, an index key for a single-column index can be up to 767 bytes –MySQL Reference Manual The size of your index is: 191 (characters) * 4 (utf8mb4 max size per character) + 4 (length) + 1 (NULL) = 769 The calculation may not be 100% exact, I am not fully sure about the length requirements, but I will assume it is not a bug. The reason ...


0

((100G is not the same as 100M. typo was fixed)) The line you gave is what you do -- in my.cnf. (Double check the syntax.) That configuration was very important 15 years ago -- when some operating systems could not create a file bigger than 2GB (or 4GB). Now is is just an artifact. Most people simply have autoextend on the last entry and forget about ...


2

Some general considerations, first: MySQL, and I am talking about InnoDB specifically, is optimized for OLTP loads, specially for good performance for point SELECTS and writes. That doesn't mean that you cannot do bulk inserts (I get 600 000 row insertions/second on my desktop-grade SSD), but that has an impact on the performance of other operations, ...



Top 50 recent answers are included