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

Tag: my.cnf

The best MySQL configuration for my server

By adminPosted on January 15, 2023

Question : I’m little newbie in configuring mysql and I need some advices. Few days ago I made little home […]

What is wrong with table_cache hit rate?

By adminPosted on January 8, 2023

Question : In my.cnf I have: table_cache = 524288 open_files_limit = 65535 Both are at max allowed value for mysql […]

What is the difference between setting the directive default-character-set under [client] as opposed to [mysqld]?

By adminPosted on November 24, 2022

Question : Reference: https://stackoverflow.com/a/8690422/784637 Correct me if I’m wrong, but the best answer suggests a way to force everything being […]

How to optimize the my.cnf of a MySQL server that mixes InnoDB and MyISAM tablespaces?

By adminPosted on November 17, 2022

Question : I have a database that, because of some issues, I needed to convert some tables from MyISAM to […]

What is the recommended my.cnf settings for 32 GB Server

By adminPosted on November 17, 2022

Question : I am just moving my website to a new server and ı want to know what is the […]

Why “.my.cnf” file is empty?

By adminPosted on October 10, 2022

Question : I want to edit some of InnoDB variables ,I go to the .my.cnf which is located in home/.my.cnf […]

Galera: any drawback of enabling wsrep_log_conflicts and cert.log_conflicts?

By adminPosted on October 7, 2022

Question : We have a HAProxy which balances reads and writes to only one (of three) Galera nodes. If this […]

MATCH AGAINST one character words returns empty rows with ft_min_word_len = 1

By adminPosted on September 30, 2022

Question : I’ve set ft_min_word_len = 1 to my.cnf file, also SHOW VARIABLES LIKE ‘ft_min_word%’ displays ft_min_word_len as 1. Then […]

How do I make binlog-format=ROW the start up default in the /etc/my.cnf file?

By adminPosted on September 24, 2022

Question : I can run the query SET GLOBAL binlog_format = ‘ROW’ and it works for that session. How do […]

What is wrong with table_cache hit rate?

By adminPosted on September 21, 2022

Question : In my.cnf I have: table_cache = 524288 open_files_limit = 65535 Both are at max allowed value for mysql […]

  • 1
  • 2
  • 3
  • …
  • 10

Recent Posts

  • 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
  • Postgresql create index concurrently
  • SQL insert into … values (…, select(…))
  • Block user access to certain tables

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