Hot answers tagged

2

The dump does not include the INDEXes other than the PRIMARY KEY. The dump does not include "free space" in the disk files. The dump is text, not binary. For example a BIGINT takes 8 bytes in the file, but if, say, the value is "1" it takes 2 bytes in the dump: "...,1,..." (the number plus one of the commas). On the other hand,...


2

I was always told that "%" means every host except localhost. This is plain wrong. % is a wildcard. It matches 0 or more of any character: SQL pattern matching enables you to use _ to match any single character and % to match an arbitrary number of characters (including zero characters) Thus % in the hostname field matches any host, including ...


1

Performance is not relevant, use one user per website for both traceability and security, that way if you ever get any performance issues you can more easily track which site it relates to.


1

Intro This is actually an upstream change. Some distributions might change the setting back, but it is likely that most will just follow upstream. The codebase is hosted on https://github.com/mysql/mysql-server The actual file where binary logging is made default ON, is sql/sys_vars.cc Digging through the blames, eventually I nailed down the commit that ...


1

Concurrent users is usually around 10, doesn't really go over 20 ...but your screenshot shows 23 active mysql sessions, and you configured your webserver to allow 256. Swap on cheap hosting is an anti-pattern - once your machine starts getting into swap it will spend all its time reading and writing the swap file while the requests start backing up on ...


Only top voted, non community-wiki answers of a minimum length are eligible