2,797 reputation
1934
bio website
location
age
visits member for 2 years, 10 months
seen Jul 24 at 21:03

Jul
24
comment How can I decrease FULLTEXT initialization time?
Non answer, but consider moving search functions outside of mysql into something like elastic search
Jul
23
reviewed Approve suggested edit on Why is my select statement so slow?
Jul
23
reviewed Approve suggested edit on DB2 (LUW) equivalent for Oracle “drop user cascade”
Jul
21
reviewed Approve suggested edit on same query different servers,different execution plan and time
Jul
21
reviewed Approve suggested edit on Long running simple query SQL Server 2008 R2
Jul
20
awarded  Popular Question
Jul
18
reviewed Approve suggested edit on What permissions are necessary for truncating a table?
Jul
18
asked LDAP authentication with Percona Server
Jul
7
accepted Any way to force “garbage collection” in TokuDB?
Jul
3
comment Any way to force “garbage collection” in TokuDB?
Well yes. When you run an "optimize" for example it may take say 30 seconds during which time it's in the process list. What I'm finding though is after it completes (and is no longer in the processlist), it can take some amount of time (1m+) before the actual file in the data directory shrinks.
Jul
3
comment Any way to force “garbage collection” in TokuDB?
That was my method of "monitoring", I was hoping for something more informative than polling the file system hoping/wondering when if/when my desired outcome had any effect
Jul
3
asked Any way to force “garbage collection” in TokuDB?
Jul
2
awarded  Inquisitive
Jul
2
awarded  Curious
Jul
1
awarded  Notable Question
Jun
30
comment MySQL 5.1: change datadir variable value in my.cnf
You really should look at upgrading. 5.1 is very dated. 5.6 has been out long enough to be production ready.
Jun
30
reviewed Approve suggested edit on how make mysql table name case insensitive in ubuntu
Jun
26
revised mysql database restore takes long time
grammar
Jun
24
answered mysql database restore takes long time
Jun
24
revised Block user access to certain tables
alternate solution