Skip to main content
Rick James's user avatar
Rick James's user avatar
Rick James's user avatar
Rick James
  • Member for 11 years, 9 months
  • Last seen this week
Profile Activity
Stats
140,273
reputation
15.8m
reached
10,327
answers
5
questions
Collectives
PHP
2023 • Member
Communities
View all
About

  • Using MySQL for over a decade, starting before version 4.0.

  • Enjoy designing 'huge' databases.

  • Hang out in forums.mysql.com (a lot more traffic there than here).

  • Been programming since before the invention of Unix or SQL.

My documents and tips: http://mysql.rjweb.org/

Badges
View all badges
14
gold badges
132
silver badges
231
bronze badges
Top tags
View all tags
7,856
Score
9,401
Posts
91
Posts %
1,462
Score
2,013
Posts
19
Posts %
1,429
Score
1,825
Posts
18
Posts %
1,052
Score
1,357
Posts
13
Posts %
1,050
Score
1,153
Posts
11
Posts %
1,016
Score
1,106
Posts
11
Posts %
Top posts
View all questions, answers, and articles
194
Trouble with UTF-8 characters; what I see is not what I stored
Jul 14, 2016
119
MySQL utf8mb4, Errors when saving Emojis
Feb 3, 2016
114
Trouble with UTF-8 characters; what I see is not what I stored
Jul 14, 2016
89
What's the difference between utf8_unicode_ci and utf8mb4_0900_ai_ci
Mar 6, 2019
77
Handling very large data with mysql
Sep 27, 2016
62
How to rename a column name in maria DB
Dec 16, 2018
55
How can I rebuild indexes and update stats in MySQL innoDB?
May 6, 2015
49
Why is table CHARSET set to utf8mb4 and COLLATION to utf8mb4_unicode_520_ci
Apr 29, 2017
47
UTF-8: General? Bin? Unicode?
Jul 29, 2016
44
MySQL: Large VARCHAR vs. TEXT?
Jun 25, 2018
Top Meta posts
5
6
32
Logout and Login
11
Please revert the anchor coloring change
7
Recent fix broke AND-OR queries; cf "nn questions with new activity"
3
Is a question asking for good ways to do something really opinion-based?
Top network posts
View all network posts
27
How large should be mysql innodb_buffer_pool_size?
25
MySQL: will a transaction lock the row?
23
How to safely change MySQL innodb variable 'innodb_log_file_size'?
21
How can I optimize a mysqldump of a large database?
21
Performance implications of MySQL VARCHAR sizes