Reputation
3,279
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
2 15 39
Impact
~484k people reached

Jan
25
awarded  Notable Question
Jan
14
accepted innodb_file_format Barracuda
Dec
23
accepted How do MySQL 5.7 virtual columns differ from views?
Dec
22
comment How do MySQL 5.7 virtual columns differ from views?
I don't get how in my test (using a json_extract virtual column, which was then indexed) didn't add any index_length on a 250M row test table though. If it's ETL on the fly for columns fine but I can't buy magic indexes that perform w/o any noticeable footprint.
Dec
22
reviewed Approve SQL Server 2008 - SIMPLE database log file is HUGE relative to the actual DB?
Dec
22
reviewed Approve Can't remote access MySQL server running on Mac OS X
Dec
22
asked How do MySQL 5.7 virtual columns differ from views?
Dec
16
comment calling multiple procedures from my application Vs calling procedures inside another procedure
I'm pretty sure you can't call SP w/in SP in 5.1
Dec
14
answered With MySQL 5.6, Is there any way to keep a replication slave X seconds behind_the_master?
Dec
7
accepted Tokudb HotBackup
Dec
4
comment Optimizing a MySQL “IN” query
In your example you added an index on COL3; instead of Col2 being referenced in the where clause
Nov
21
awarded  Famous Question
Nov
19
comment Tokudb HotBackup
No, this is not an executable permission thing, it is world readable. All others in the plugin directory have the same 644 permissions. You get a very different error specifying a complete plugin that doesn't exist. In fact you can tell it's starting to do something w/ it b/c it's giving you a symbol name extracted that it can't resolve
Nov
18
revised Tokudb HotBackup
confirming the plugin so does exist in the place it expects
Nov
18
asked Tokudb HotBackup
Nov
17
comment Mysql (Ver 14.14/Redhat): is a new column with default values efficient on column creation?
Either would be O(n) with respect to number of rows. Add a coefficient if you have lots of large texts/blobs that need to be copied in the process. Mysql is rarely "that smart", especially with 5.1
Nov
17
comment Mysql (Ver 14.14/Redhat): is a new column with default values efficient on column creation?
I was trying to say the exact opposite. Note the Ver 14.14 isn't what you're really wanting to consider here, it's the distribution 5.1.73
Nov
17
answered Mysql (Ver 14.14/Redhat): is a new column with default values efficient on column creation?
Oct
6
comment Can MySQL partially save a record?
What are the datatype's of the fields you feel are getting cut off? If you're not running in strict mode and attempt to insert more than 65k characters into a text field it will silently truncate at the max length, only generating a warning, not an error.
Oct
5
awarded  Popular Question