User rubo77

25 votes

2 answers

56k views

How do I shrink the innodb file ibdata1 without dumping all databases?

asked Sep 26, 2012 at 11:12

6 votes

2 answers

5k views

How do uninitialized variables differ from NULL in Mysql?

asked Feb 21, 2013 at 20:50

5 votes

1 answer

4k views

What are the disadvantages if indexes are added on all columns?

asked Apr 14, 2013 at 21:04

4 votes

1 answer

4k views

Is a query with UNIX_TIMESTAMP using indexes in mysql?

asked Nov 7, 2012 at 6:49

3 votes

1 answer

94 views

How identify tables with millions of entries

asked Aug 2, 2013 at 17:02

2 votes

2 answers

5k views

Select the latest changed row in a table

asked Sep 17, 2013 at 16:30

2 votes

2 answers

93 views

Import MySQL table from a textfile to a remote host with compression

asked Nov 8, 2015 at 4:17

1 vote

1 answer

381 views

move postgresql 9.4 cluster to new server

asked Jun 16, 2019 at 6:15

1 vote

2 answers

883 views

Is there slowdown inserting into an InnoDB table that has no index set?

asked Apr 23, 2013 at 18:55

1 vote

1 answer

11k views

What is the difference between int(8) and int(5) in mysql? [duplicate]

asked Nov 29, 2012 at 21:48

1 vote

1 answer

4k views

Why does MATCH() give Score 0, if there are less rows in the database?

asked Feb 14, 2013 at 12:54

0 votes

1 answer

272 views

PHP SQLite Admin is running on PHP 5.4

asked Jun 17, 2014 at 8:26

0 votes

1 answer

55 views

Import lots of mysqldumps with missing CREATE DATABASE

asked Apr 19, 2015 at 9:50

0 votes

1 answer

378 views

default /etc/mysql/my.cnf on wheezy

asked Nov 5, 2015 at 10:53

0 votes

2 answers

773 views

Show full detail error message on the console

asked May 5, 2020 at 7:22

0 votes

1 answer

660 views

fix InnoDB: corrupted TRX_NO after upgrading to 10.3.31

asked Nov 23, 2021 at 21:57

Stack Exchange Network

16 Questions

How do I shrink the innodb file ibdata1 without dumping all databases?

How do uninitialized variables differ from NULL in Mysql?

What are the disadvantages if indexes are added on all columns?

Is a query with UNIX_TIMESTAMP using indexes in mysql?

How identify tables with millions of entries

Select the latest changed row in a table

Import MySQL table from a textfile to a remote host with compression

move postgresql 9.4 cluster to new server

Is there slowdown inserting into an InnoDB table that has no index set?

What is the difference between int(8) and int(5) in mysql? [duplicate]

Why does MATCH() give Score 0, if there are less rows in the database?

PHP SQLite Admin is running on PHP 5.4

Import lots of mysqldumps with missing CREATE DATABASE

default /etc/mysql/my.cnf on wheezy

Show full detail error message on the console

fix InnoDB: corrupted TRX_NO after upgrading to 10.3.31