New answers tagged mysql-8.0
0
votes
Optimize MySQL server configuration insertion
Rate Per Second = RPS
Suggestions to consider for your my.cnf [mysqld] section to improve performance,
key_cache_division_limit=50 # from 100 for hot and warm key_buffer mgmt to reduce key_reads
...
- 1,662
2
votes
Not a duplicate, but still getting Integrity constraint violation: 1062 Duplicate entry
For ππ€π‘πππ or π
²π
·π
°ππ
Ύπ
½, you need CHARACTER SET utf8mb4.
The antique _general_ci collation does not take much into consideration. Change to utf8mb4_0900_as_ci.
SELECT 'ππ€π‘πππ' = 'π
²π
·π
°...
- 76.3k
1
vote
Accepted
Sum column and remove lines sum
Basically you are asking to delete the records from your table I hope this is a single process.
This can be done by inserting your "final" data into a temporary table truncate your existing ...
- 3,685
0
votes
Accepted
SHOW TRIGGERS privilege without also being able to DROP TRIGGER?
Is it possible to give a user privilege to view Triggers, i.e. execute
the SHOW TRIGGERS command, without also giving them permission to DROP
TRIGGER?
No. In a few words show triggers and drop ...
- 3,685
0
votes
MySQL NDB Cluster Community - High memory utilization by mysqld only on source/replica nodes
The MySQL Server on the source cluster will consume memory when writing binlog of all changes that happens in NDB.
This is done by a background thread which subscribes to change notifications on all ...
Top 50 recent answers are included