Reputation
1,187
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
4 13
Newest
 Yearling
Impact
~39k people reached

May
15
comment Mysql - Examine last query run by thread in sleep state
@gwgeller nope general logging in table is worse than file. You can find some technical benches on the web (fromdual.com/general_query_log_vs_mysql_performance).
May
9
comment Create Table not working
Yes but why move from MySQL ? :) Just kiding, in my opinion MySQL would not accept the ASC, DESC keywords because some DBAs can think that create an descendant index is possible.
May
9
comment Create Table not working
From MySQL documentation "An index_col_name specification can end with ASC or DESC. These keywords are permitted for future extensions for specifying ascending or descending index value storage. Currently, they are parsed but ignored; index values are always stored in ascending order."
May
9
comment Create Table not working
@ypercube can you explain?
May
9
answered Create Table not working
May
8
comment Mysql - Examine last query run by thread in sleep state
Yes but even temporary, you can overload your production. Depends on how your load and your configuration (mostly disks conf), if you are doing 20K ops and your /var/log/mysql uses the same disks than /var/lib/mysql it will be a mess in a second. In contrast, for a dev/qal environment I recommend to enable general_log by default, just say that, we must be precise on our answer to not be responsible for issues on stackexchange user databases :)
May
8
revised MySQL database freezing after 'use'
added 25 characters in body
May
8
comment MySQL database freezing after 'use'
disable_auto_rehash is not a server variable but a client variable so it does not need a server reboot. Just add disable_auto_rehash in the [mysql] section in your my.cnf.
May
8
comment Mysql - Examine last query run by thread in sleep state
Your answer is not suitable for a production workload. Enabling the general_log does not need a server reboot it's a dynamic variable. Be careful with enabling general log on a heavy loaded instance, it can generates lot of I/Os and slow down your platform.
Dec
20
awarded  Yearling
Sep
30
awarded  Explainer
Sep
24
revised Binlog not consistent between slave and master
Add "edit" on Binary Log managment
Sep
23
revised Binlog not consistent between slave and master
added 18 characters in body
Sep
23
revised Binlog not consistent between slave and master
deleted 3 characters in body
Sep
23
revised Binlog not consistent between slave and master
added 217 characters in body
Sep
23
revised Binlog not consistent between slave and master
deleted 156 characters in body
Sep
23
revised Binlog not consistent between slave and master
deleted 156 characters in body
Sep
23
answered Binlog not consistent between slave and master
Jul
7
comment Whats row size in mysql?
Haha, thanks for feedback
Jul
6
answered Whats row size in mysql?