Reputation
1,547
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 14
Newest
 Enlightened
Impact
~94k people reached

Mar
8
awarded  Enlightened
Mar
8
awarded  Nice Answer
Dec
20
awarded  Yearling
Dec
4
awarded  Tenacious
Nov
26
revised how to reset value of auto incremented id to a specific value in mysql?
added 8 characters in body
Nov
24
answered how to reset value of auto incremented id to a specific value in mysql?
Oct
27
comment MySql - How to monitor the amount of reads/writes to the DB
performance_schema adds a little overhead on your db instance, this is why it was not my first thought but you are right you can study this solution to.
Oct
20
answered MySql - How to monitor the amount of reads/writes to the DB
Oct
4
answered Securing MySQL backup process
Sep
16
answered What indexes should one use for this two-table setup?
Sep
16
revised Autocommit disabled on mysql restart
added 1 character in body
Sep
16
answered Autocommit disabled on mysql restart
Aug
28
comment How to know which user update/insert or delete in MYSQL database?
You have the source IP/host in each entry. But yes if the MySQL are behind a load balancer, depends of its conf but yes they can all got the same IP/host.
Aug
25
answered How to know which user update/insert or delete in MYSQL database?
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 :)