Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: mysql-5.1

MySQL: How to create Column if not exists?

By adminPosted on January 13, 2023

Question : I am trying to create a Column for my table only if it does not exist. I have […]

TCP sockets bottleneck with InnoDB/Debian?

By adminPosted on January 12, 2023

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

By adminPosted on January 11, 2023

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

By adminPosted on December 27, 2022

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

By adminPosted on December 18, 2022

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?

By adminPosted on December 17, 2022

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]

By adminPosted on December 6, 2022

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

By adminPosted on December 2, 2022

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

By adminPosted on November 28, 2022

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

By adminPosted on November 19, 2022

Question : I’d like to do some calculations in a MySQL query. I’ve created some temporary columns which I’d like […]

  • 1
  • 2
  • 3
  • …
  • 19

Recent Posts

  • Postgres to Postgres DBLink with AWS/RDS
  • What are the pros and cons of having more data-bearing members in a MongoDB replica set? [closed]
  • Transaction log backup after full backup is too big
  • Strange behavior with Quotename and substring [closed]
  • MySQL slow select from a view
  • CREATE INDEX vs ALTER TABLE ADD INDEX – MySQLism, or SQL Standard?
  • How to run my query on a one-to-many relation to run efficiently
  • Can I get SSMS to show me the Actual query costs in the Execution plan pane?
  • What are the best Database Analytics Companies for analyzing several 1000s or Mio. of products,sum them together and analyze them for statistics?
  • How to list the permissions on User-Defined Table Types?
  • Do I need an auto-generated ID in addition to a unique field?
  • Why should foreign keys be implemented in my relational database? [duplicate]
  • Difference between changed compatibility level database and new database
  • Does a query with a primary key and foreign keys run faster than a query with just primary keys?
  • What is the limit on the number of INSERT statements you can paste into SSMS and run?
  • String or separate Table
  • Database layout to keep track of the “freshness” of a column value in a specific row
  • MySQL Computed Column counting other rows with attributes relative to this one
  • How to design tables for airbnb style booking system [closed]
  • mysql restart won’t kill child processes on CentOS

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding