Question : I am trying to create a Column for my table only if it does not exist. I have […]
Tag: mysql-5.1
TCP sockets bottleneck with InnoDB/Debian?
Question : We have a big mysql performance issue on a production environment with 18 “front” servers sending mysql queries […]
MySQL: why assign NULL as default value
Question : When we define a table, multiple times we assign default value of a column as NULL. I have […]
How to eradicate Mysql Slave Replication delays when huge updates from master
Question : At my environment we had slave replication with mysql server version 5.1.47 enterprise version.When ever there is huge […]
innodb_flush_method=O_DIRECT vs O_DSYNC performance impact on ext3 with LVM disk partition
Question : In one of my production environments, we have two instances running on a RedHat cluster, with one production […]
Unable to show binary logs how to remove logs from mysql?
Question : Server version: 5.1.50-log MySQL Community Server (GPL) Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the […]
where can I get mysql-5.1.7.tar.gz or mysql-5.1.9.tar.gz? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
Fourth inner join to the same table increases query duration significantly
Question : As soon as I add a fourth inner join to a specific table, the query duration increases significantly: […]
Client to use the slave when the master is down in MySQL replication
Question : Is it possible for the client to use the slave when the master is down in mysql replication? […]
MySQL temporary column in SELECT statement
Question : I’d like to do some calculations in a MySQL query. I’ve created some temporary columns which I’d like […]