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

17h
reviewed Edit suggested edit on Database design: Which will perform better, auto incremented column or a composite key for appointments
17h
revised Database design: Which will perform better, auto incremented column or a composite key for appointments
grammar
19h
reviewed Reject suggested edit on MySQL,- changing collation causes big problems
2d
comment Accuracy of mysqldbcompare vs other tools like pt-table-checksum
Sorry, no experience with mysqldbcompare
2d
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
Sep
16
comment Unable to open MONyogs
2.8.17. Looks like that's what was packaged for my version of ubuntu. I tried on a centos box that has sqlite3 (3.6.20). It doesn't error right away but get the message after trying .databases in the shell
Sep
16
comment Unable to open MONyogs
Yes. What's your real question or comment?
Sep
15
revised Never ending count(*) on a table after upgrading to Percona 5.6.16
additional details
Sep
15
asked Never ending count(*) on a table after upgrading to Percona 5.6.16