Reputation
Next tag badge:
99/100 score
43/20 answers
Badges
13 121 250
Newest
 percona
Impact
~11.1m people reached

2d
comment Run multiple MySQL instances in Windows
Thank you. Sound like you want to do a MySQL BakeOff : dba.stackexchange.com/questions/3375/…. You should post your results as an answer there.
Apr
25
comment MySQL Performance Tuning for MyISAM
@RickJames FIXED increase read performance by 20-25% as published. I have client in the past that enjoyed it when I implemented for them (Of course, they had gobs of money and diskspace, so it's not for everyone or every workload)
Apr
22
comment Is it possible to quickly create/restore database snapshots with PostgreSQL?
This is of no use for large databases. Plus, why torture git with binary files of varying size ?
Apr
22
comment Migrate from innodb_file_per_table to off in MySQL ALTER TABLE removing ibd files
Thank you for the credit !!!
Apr
21
comment In [Percona] MySQL, is the Adaptive Hash Index included in the Total memory allocated count?
Perhaps it was not being populated to start with due to your workload : percona.com/blog/2016/04/12/…
Apr
20
comment Is there anyway that I can manually create a PID for the MySQL instance?
If you ran mysqld_safe, it already created a PID. If you run service mysql start, that runs mysqld_safe again. That will whack the socket file and the PID will be different. I wrote about why you should not do that : dba.stackexchange.com/questions/132697/my-mysql-server-died/…
Apr
18
comment Insert the same time, it is possible to happen?
Although this is good, please expound more on why this would or give an example
Apr
15
comment When is Seconds_Behind_Master too big?
@WAF oops you are right
Apr
15
comment How to skip the current 'Relay_Master_Log_File' in AWS MYSQL RDS?
Is replication still running ? In other words, is Slave_IO_Running = Yes and Slave_SQL_Running = Yes ?
Apr
14
comment Server warnings on MongoDB startup
@Ghopper21 Powercycling / Rebooting the DB Server can only help if you chkconfig the mongod service. Otherwise, it has to be manual.
Apr
11
comment Oracle Min - ORA-00937 not a single-group group function
This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review
Apr
11
comment How to select mutiple values with like clause
Is the column indexed ???
Apr
1
comment Server warnings on MongoDB startup
Did you run the service before the restart of mongod ? service disable-transparent-hugepages start ; service mongod restart
Apr
1
comment Server warnings on MongoDB startup
Did you restart mongod ?
Mar
31
comment “Cannot resolve table name” error when applying MySQL dump to RDS
+1 for both question and answer. You found your own answer and you will eventually get back the 200 points. Moral of the Story for everybody else ? Read the Release Notes for MySQL (or any other RDBMS) before just installing.
Mar
30
comment MySQL Event scheduler not generating CSV
Please run SELECT * FROM information_schema.events WHERE event_schema='x' AND event_name='tbl_event'\G and post the output
Mar
29
comment “Cannot resolve table name” error when applying MySQL dump to RDS
Please present the following: SHOW CREATE TABLE Prospect\G, SHOW CREATE TABLE Restaurant\G, and SHOW CREATE TABLE Zone\G
Mar
25
comment What's the risk of keeping a table with row size > 8126 in MySQL 5.7?
@RickJames Yes. I updated my answer to clarify
Mar
11
comment MySQL Backup Strategy
QUESTIONS : 1) How many databases ? 2) How many tables per database ? 3) Is this a multitenant database ? 4) Are you gzipping the mysqldumps ?
Mar
3
comment Problem with mysql group_concat, complex query, not getting required result
You are Welcome !!!