Search code examples
VARCHAR vs TEXT performance when data fits on row...


mysqldatabaseperformanceinnodbmysql-5.7

Read More
Row size doesn't exceed for VarChar...


mysqldatabaseinnodbmysql-5.7

Read More
Limit the row of the table to be used by one script at a time...


phpmysqllockinginnodb

Read More
LOCK TABLES can cause deadlocks in InnoDB?...


phpmysqlinnodbdatabase-deadlocks

Read More
MySQL returns "Can't create table because of lock error (errno: 147)"...


mysqllockinginnodb

Read More
mariadb sluggish after drop table...


mariadbinnodbgalera

Read More
Are full count queries really so slow on a large MySQL InnoDB tables?...


mysqlperformanceinnodbmysql-slow-query-log

Read More
mysql query : get the last row of related table on multi table selection...


phpmysqllaravelinnodb

Read More
How to know if an uncommitted transaction tries to insert a specific unique key into SQL...


sqltransactionsmariadbinnodbunique-key

Read More
MySQL Update query - Will the 'where' condition respected on race condition and row locking?...


phpmysqlpdoinnodb

Read More
How to configure MySQL 5.6 LONGBLOB for large binary data...


mysqlsqlrowinnodb

Read More
Insert into on duplicate key - auto increment id skipped...


mysqlsqldatabaseinnodb

Read More
MySQL: What is a page?...


mysqldatabaseinnodb

Read More
How can I delete and get the row data in an atomic way?...


mysqlinnodbmysql-5.5

Read More
Optimising Storage Space: Many rows & columns with the same values...


mysqlindexingstorageinnodb

Read More
How do I match up USER table and USERINFO table records one for one?...


phpmysqlinsertinnodbphp-7.2

Read More
Order rows by column whilst keeping rows with a common column together...


phpmysqlmariadbinnodb

Read More
Inserting last created auto_increment value into the table using LAST_INSERT_ID()...


pythonmysqlforeign-keysinnodb

Read More
What is InnoDB and MyISAM in MySQL?...


mysqlinnodbmyisam

Read More
ERROR MY-011542 Repl Plugin group_replication reported: 'Table repl_test does not have any PRIMA...


innodbmysql-group-replicationmysql-innodb-cluster

Read More
A node in MySQL 5.7 innoDB cluster is crashed and unable to re-join the crashed node to the cluster...


mysqlinnodbmysql-group-replicationmysql-innodb-cluster

Read More
How to optimize an "optimize" MYSQL query that takes a lot of time...


mysqldatabaseinnodbdatabase-optimization

Read More
Query performance on primary index vs index...


mysqlperformanceinnodb

Read More
Warning: A long semaphore wait...


mysqlsqlinnodbalter-tablefull-text-indexing

Read More
Database not importing...


mysqldatabaseinnodb

Read More
AWS MySQL 5.6.40 - once overwhelmed, always overwhelmed...


mysqlamazon-web-servicesinnodb

Read More
Seek paginated query gets progressively slower on a big table...


mysqlinnodb

Read More
How to regex in a MySQL query...


mysqlsqlregexinnodb

Read More
Transferring MySQL Workbench to Server...


mysqlsqlinnodbmysql-workbench

Read More
InnoDB field type size vs file size descrepency?...


mysqlinnodb

Read More
BackNext