Reputation
Next tag badge:
96/100 score
48/20 answers
Badges
12 91 208
Newest
 Good Answer
Impact
~8.2m people reached

Aug
25
comment Mysql create trigger if not exist
You need to schedule downtime of 1 min to do this. That will ensure no data loss.
Aug
25
comment replication filtering replicate-rewrite and do-table Mysql 5.6 (innodb engine )
Please don't use BLACKHOLE storage engine : dba.stackexchange.com/questions/73502/…
Aug
24
comment MySQL drops every connection, even locally
Please run SHOW GLOBAL STATUS LIKE 'uptime'; multiple times. Does the value reset or does it keep increasing ???
Aug
24
comment MySQL drops every connection, even locally
Is mysql crashing ? Run \s. What does it say after each crash ?
Aug
20
comment How does Postgres make its B-tree index?
@ErwinBrandstetter already answered something like this last year : stackoverflow.com/questions/25004505/b-tree-or-b-tree/…
Aug
20
comment Merge multiple columns into one column in different table?
Do you have any sample data with output from this query ???
Aug
18
comment Overwrite event - data from SQL Server to MySQL
You should show use the table structure of the table in SQL Server you are sourcing from and the table structure of the table you are updating with the data from SQL Server.
Aug
13
comment Convert MyISAM to InnoDB
1) How much free space do you have in datadir right now ? 2) Please post the table structure of the 80GB table. 3) What is the output ofSHOW GLOBAL VARIABLES LIKE 'innodb_file_per_table'; 4) How much RAM in the DB Server ? 5) How many CPU/cores ? 6) Is the DB Server bare metal or VM ?
Aug
13
comment Locking because of triggers mysql
Quick Question: Do you have MySQL Replication setup right now ???
Aug
12
comment Split brain scenario - RAC and PXC
@Mat Thank you. I''ll update my answer accordingly.
Aug
12
comment INSERT… ON DUPLICATE KEY UPDATE not working as I expect
Once you create the unique index on (a,b,c) , doing INSERT INTO example (a, b, c) VALUES (1,2,3) ON DUPLICATE KEY UPDATE a = VALUES(a), b = VALUES(b), c = VALUES(c); would update 1 with 1, update 2 with 2, and update 3 with 3. In effect, nothing changed. Doing INSERT IGNORE INTO example (a, b, c) VALUES (1,2,3); would determine ahead of time that nothing needs to change.
Aug
12
comment SQLyog and MariaDB engine
I need a favor. Please login to MariaDB and run SHOW ENGINES. In the row that has InnoDB, look at the comment section. What does it say ???
Aug
11
comment How can I force MySQL to IGNORE ALL indexes?
@yercube I just tried and no index is chosen, not even the Clustered Index (MySQL 5.6.21)
Aug
11
comment How can I force MySQL to IGNORE ALL indexes?
Hey, I upvoted yercube's answer myself. My answer is just another way and explains the Optimizer's loophole.
Aug
11
comment How can I force MySQL to IGNORE ALL indexes?
@ypercube yes, but you have to dummy-down the query enough for that to happen.
Aug
11
comment group_concat and group by together
This query get messier if you want to accommodate servers that are only in one environment.
Aug
11
comment group_concat and group by together
MY BRAIN HURTS !!!
Aug
7
comment How to detect MySQL slave writes?
@akuzminsky Good point. Slave should be read_only=1;. However, someone with SUPER can still run DML on the Slave. It's either this answer or upgrade the Slave to MySQL 5.7 with super_read_only (dev.mysql.com/doc/refman/5.7/en/…)
Aug
6
comment Got an error reading communication packets
Any issues with inconsistent transfer rates using Ethernet protocol ???
Aug
6
comment Got an error reading communication packets
Was the firewall the only networking component you checked ???