Database Administrators
Rick James's user avatar
Rick James's user avatar
Rick James's user avatar
Rick James
  • Member for 12 years, 6 months
  • Last seen this week
Profile Activity
Stats
77,029
reputation
10.7m
reached
5,485
answers
2
questions
top 0.11% overall
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
5
gold badges
45
silver badges
111
bronze badges
Top tags
View all tags
5,153
Score
5,088
Posts
93
Posts %
852
Score
626
Posts
11
Posts %
815
Score
658
Posts
12
Posts %
694
Score
748
Posts
14
Posts %
418
Score
356
Posts
6
Posts %
413
Score
428
Posts
8
Posts %
Top posts
View all questions and answers
All Questions Answers
Score Newest
answer
27
How large should be mysql innodb_buffer_pool_size?
Feb 7, 2015
answer
24
MySQL: will a transaction lock the row?
Mar 5, 2017
answer
23
How to safely change MySQL innodb variable 'innodb_log_file_size'?
Jul 25, 2011
answer
21
Possible to make MySQL use more than one core?
May 17, 2012
answer
21
How can I optimize a mysqldump of a large database?
May 20, 2011
answer
21
Should I use UUID as well as ID
Oct 25, 2015
answer
21
Performance implications of MySQL VARCHAR sizes
Jul 2, 2016
answer
19
Identity column re-seed: when it is necessary?
Nov 25, 2018
answer
17
In the same query INSERT, can two VALUES being NOW() return a different time?
Mar 22, 2021
answer
16
MySQL DELETE becomes exceptionaly slow with a large number of rows
Aug 18, 2016
Top Meta posts
4
0
8
Please use different color on 'seen' anchor tag
5
Huge number of visits
Top network posts
View all network posts
194
Trouble with UTF-8 characters; what I see is not what I stored
117
MySQL utf8mb4, Errors when saving Emojis
110
Trouble with UTF-8 characters; what I see is not what I stored
78
What's the difference between utf8_unicode_ci and utf8mb4_0900_ai_ci
76
Handling very large data with mysql

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.