user avatar
user avatar
user avatar
Rick James
  • Member for 11 years, 1 month
  • Last seen this week
23 votes

How to safely change MySQL innodb variable 'innodb_log_file_size'?

23 votes

How large should be mysql innodb_buffer_pool_size?

23 votes
Accepted

MySQL: will a transaction lock the row?

21 votes

How can I optimize a mysqldump of a large database?

21 votes

Possible to make MySQL use more than one core?

19 votes
Accepted

Identity column re-seed: when it is necessary?

17 votes

In the same query INSERT, can two VALUES being NOW() return a different time?

17 votes
Accepted

Should I use UUID as well as ID

16 votes

Performance implications of MySQL VARCHAR sizes

13 votes

How to optimize very slow SELECT with LEFT JOINs over big tables

13 votes
Accepted

Convert MySQL database from latin1 to utf8mb4 - and take care of German umlauts

13 votes

How do you calculate how much hardware resources you need for a database?

13 votes
Accepted

What is the optimal solution for storing real time time-series in MariaDB / MySQL?

13 votes
Accepted

Error Log Location?

12 votes
Accepted

MySQL DELETE becomes exceptionaly slow with a large number of rows

12 votes

DELETE command not completing on 30,000,000 row table

12 votes
Accepted

Automatically purging binary logs

12 votes

How to lower "Created_tmp_disk_tables" - temporary tables count created on DISK?

11 votes

Are junction tables a good practice?

10 votes
Accepted

Does "deprecated" in MySQL means "not guaranteed" or "still guaranteed"?

10 votes

mysqlcheck to optimize innodb tables -- performance/scheduling

10 votes
Accepted

MariaDB - cannot set max_connections and wait_timeout through my.cnf

10 votes
Accepted

Do varchar/text/longtext columns in MySQL occupy full size in filesystem even for partially filled cells?

10 votes
Accepted

Delete Slow Query Log File

9 votes

Error 1366: Incorrect string value: '\xF0\x9F\x98\x8A\x0AC…' for column 'text_body' at row 1

9 votes
Accepted

Can converting MyISAM to InnoDB cause problems?

9 votes
Accepted

Best Practice to Archive Old Data in MySQL

9 votes

Error Code 1117 Too many columns; MySQL column-limit on table

9 votes

Mysql - unknown variable 'table_cache=64'

9 votes

Best General Purpose Character Set and Collation for MySQL

1
2 3 4 5
166