MySQL is not a strictly typed database. Given that and the different character types some tricky situation might arise. Especially when it comes to trailing spaces....
Today we had an interesting situation where the same query was executed significantly slower when it was written with GROUP BY instead of DISTINCT and I...
In MySQL a big portion of the problems you’re facing is different replication delays so there’s no surprise this is one of the most common interview...
(Note: when I’m talking about MySQL I usually assume InnoDB storage engine. Any other case I explicitly tell this is MyISAM or Memory etc.) I’ve heared...
Why is it so important to close connections to databases if there’s no explicit need to keep them open (which usually the case)? Symptoms Icinga reports...
Last week one of my collagues came to me with the following problem. He was not able to create an innodb table. MySQL returned ERROR 1005: Can’t create table (errno:...
@n26 After trying to transfer foreign currency and couldn’t find any information I finally saw this: “If you have an N26 Business or N26 Business Black account, foreign currency transfers are not possible” How is it possible that one of the most important feature is not available?!?!
Before you head over to the community dinner come to my talk “From scheduled downtime to self-healing infrastructure” to learn about large scale automation at 6pm #perconalive
Recent comments