2,884 reputation
11135
bio website
location
age
visits member for 3 years, 1 month
seen 18 hours ago

18h
reviewed Approve suggested edit on Does `Seconds_Behind_Master` show exact Slave Lag from Master?
1d
answered SELECT in federated table is to slow
2d
revised Mongo DB Backup & restore
many grammar corrections
Oct
27
reviewed Approve suggested edit on Hyperthreading & MySQL InnoDB Thread Concurrency Performance
Oct
24
reviewed Edit suggested edit on Database design: Which will perform better, auto incremented column or a composite key for appointments
Oct
24
revised Database design: Which will perform better, auto incremented column or a composite key for appointments
grammar
Oct
24
reviewed Reject suggested edit on MySQL,- changing collation causes big problems
Oct
23
comment Accuracy of mysqldbcompare vs other tools like pt-table-checksum
Sorry, no experience with mysqldbcompare
Oct
22
answered Accuracy of mysqldbcompare vs other tools like pt-table-checksum
Oct
21
reviewed Approve suggested edit on Importing a SQL Dump File through XAMPP's Command Line
Oct
20
answered increasing disk space for mysql data volume
Oct
20
comment Mysql datatype for username of maximum 15 characters
To that extent I'd recommend ensuring running the mysqld w/ SQL_MODE strict. This will ensure attempts to insert something longer fails hard with an error. Otherwise it will succeed with just a warning and truncating the value
Oct
17
comment Mysql datatype for username of maximum 15 characters
What does this have to do with security?
Oct
15
comment MySQL: Prevent DROP TABLE and TRUNCATE TABLE on Slaves
Out of curiosity, could you elaborate why you wish to do this? Generally you want your slave to be 1:1 with your master.
Oct
15
comment MySQL error: Access denied for user 'a'@'localhost' (using password: YES)
You don't. If you don't specify a -h hostname it assumes "localhost" meaning it's looking for a socket, not a TCP port w/o the protocol flag. You could setup a shell aliase if you're tired of typing out all the arguments.
Oct
14
answered Super slow (day long) count(*) after upgrade to 5.6
Oct
13
revised Super slow (day long) count(*) after upgrade to 5.6
Adding relevant pt-config-diff output
Oct
13
revised Super slow (day long) count(*) after upgrade to 5.6
adding table schema details
Oct
13
asked Super slow (day long) count(*) after upgrade to 5.6
Sep
17
awarded  Notable Question