Reputation
Next tag badge:
93/100 score
33/20 answers
Badges
12 109 238
Newest
 Nice Answer
Impact
~10.1m people reached

Jan
25
comment check storage engine from shell
@chaitanya.varanasi Please look at the other answer. It has what you want. For the sake of clarity, I will say this: If you are running MongoDB 3.x, just run db.serverStatus().storageEngine.name. It will either say mmapv1 or wiredTiger.
Jan
24
comment Add ranking to query output
Questions :Q1) Suppose Oliver and Michael have 4. Would the ranking be : 1 Oliver 4, 1 Michael 4, 3 Steven 1 or 1 Oliver 4, 2 Michael 4, 3 Steven 1 ? Q2) Suppose Michael and Steven had 2. Would the ranking be : 1 Oliver 4, 2 Michael 2, 3 Steven 2 or 1 Oliver 4, 2 Michael 2, 2 Steven 1 ?
Jan
9
comment Postgres Can't Add Foreign Key Constraint
This does not provide an answer to the question. To critique or request clarification from an author, leave a comment below their post. - From Review
Jan
5
comment How come MongoDB WiredTiger snappy & zlip compression consumes same memory
Please display your /etc/mongod.conf
Dec
15
comment Same record shows up multiple times in ordered paginated query
@Phil Thanks for finishing my answers ;-)
Dec
14
comment With MySQL 5.6, Is there any way to keep a replication slave X seconds behind_the_master?
What version of MySQL are you using ?
Dec
11
comment Replication has failed; how to get going on again?
Please expand on why this process works
Dec
10
comment Release MySQL Memory and Performance Tunning
Sweet answer. I wish I had more time to play with MySQL 5.7. +1
Dec
8
comment Visual studio 2010 missing BI 2010 (SSDT 2010)
Please don't add "thank you" as an answer. Instead, vote up the answers that you find helpful. - From Review
Dec
4
comment Optimizing a MySQL “IN” query
Based on the comment on the values, anyone of those TTY values will trigger a table scan. Please try out other values besides those nine TTYs.
Dec
2
comment Cannot open table mysql/innodb_index_stats
@Tertium you are right. I wrote a better way four(4) months later : dba.stackexchange.com/questions/54608/…
Nov
30
comment Unknown column 'actions_in_group' in 'field list'
@ypercube but perfectly acceptable in the MySQL parallel universe :-) (BTW it worked in the sqlfiddle (which is a subuniverse))
Nov
28
comment Possible INDEX on a VARCHAR field in MySql
Hey MrD. I actually like your answer. Why ? In my old answer, I said in SUGGESTION #1 : If you index like this, you can either look for the whole string or do left-oriented LIKE searches. I also said in SUGGESTION #3 : If you are looking for one specific value and those values could be lengths well beyond 32 characters, you could store the hash value:. Your answer adequately demonstrates why one should not use huge keys and should index on leftmost characters, which can make a difference in performance. Your answer belongs here. +1 for your answer and Welcome to the DBA StackExchange.
Nov
24
comment Discover missing foreign keys and/or indexes
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review
Nov
23
comment Mongo HDD disk grows to fast when insert / deleting data
While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. - From Review
Nov
17
comment Install MySQL for Windows from .zip and reset root password
@MikeLischke I just realized the password column was renamed authentication_string.
Nov
17
comment Install MySQL for Windows from .zip and reset root password
@MikeLischke Thank you. I need to delete this answer
Nov
13
comment #1041 - Out of memory issue in mysql
Updated my answer ...
Nov
6
comment MySQL Trigger Error
That will generated the error again because END;// should be END //.
Oct
30
comment Can I combine the results from multiple columns into a single column without UNION?
@MichaelRichardson glad I could help !!!