Riedsio

Riedsio has asked 3 questions and find answers to 27 problems.

Stats

About

DBA!

Riedsio questions

How to disable or circumvent phpmyadmin's SQL_CALC_FOUND_ROWS
The purpose of SQL's EXISTS and NOT EXISTS

Riedsio answers

MySQL: Optimizing UPDATE of many rows in a large table
Best MySQL setup for rapidly changing big text fields?
Mysql stop slave at log position
Is there any point in creating a second column optimized for FULLTEXT searches?
Mysql ENABLE KEYS commands takes a long time
mysql multi column index not working (as expected)?
MySQL: Constraint two columns so one of them always are NULL
How do you clear overhead (Data_free) in a MEMORY table in MySQL?
SELECT and DELETE
Can't connect to mysql because there are no users