Tag: mysql

355 How do you mysqldump specific table(s)? 2011-12-16T20:39:37.727

267 Can MySQL reasonably perform queries on billions of rows? 2012-07-02T19:36:13.747

216 What are the main differences between InnoDB and MyISAM? 2011-01-03T20:46:02.927

174 How can I monitor the progress of an import of a large .sql file? 2012-05-02T16:54:41.177

160 How can I optimize a mysqldump of a large database? 2011-01-03T21:13:48.603

145 How large should be mysql innodb_buffer_pool_size? 2012-10-21T15:03:45.757

118 How can I move a database from one server to another? 2011-01-04T15:38:47.870

104 Possible to make MySQL use more than one core? 2011-09-12T14:59:54.003

102 Create a MySQL database with charset UTF-8 2014-09-17T03:13:43.087

97 How to safely change MySQL innodb variable 'innodb_log_file_size'? 2011-02-16T15:01:01.553

95 Advantages and Disadvantages to using ENUM vs Integer types? 2011-10-19T15:50:08.357

90 ALTER TABLE - Rename a column 2014-03-29T09:53:24.090

87 Storing vs calculating aggregate values 2011-01-05T01:32:11.040

81 Good explanation of cascade (ON DELETE/UPDATE) behavior 2013-06-20T14:18:32.647

76 Is it safe to delete mysql-bin files? 2013-04-26T20:56:52.687

73 mysql: Show GRANTs for all users 2012-08-28T10:28:32.173

66 How can a group track database schema changes? 2011-01-03T20:46:32.393

66 Safest way to perform mysqldump on a live system with active reads and writes? 2012-06-20T00:50:25.460

59 How do I completely disable MySQL replication 2008-09-18T11:44:23.400

58 What is the best way to reduce the size of ibdata in mysql? 2011-12-09T06:15:25.167

55 Find highest level of a hierarchical field: with vs without CTEs 2011-10-24T14:48:52.640

53 What is the performance impact of using CHAR vs VARCHAR on a fixed-size field? 2011-05-10T20:49:33.127

53 MySQL any way to import a huge (32 GB) sql dump faster? 2014-11-19T20:36:46.370

52 MySQL: Create index If not exists 2012-09-19T13:40:32.710

52 What is faster, one big query or many small queries? 2014-09-18T12:17:16.410

51 What is the default order of records for a SELECT statement in MySQL? 2011-09-22T04:22:59.460

50 Why does InnoDB store all databases in one file? 2012-03-25T13:49:16.630

50 When to use views in MySQL? 2012-04-11T18:30:18.507

50 Which is faster, InnoDB or MyISAM? 2012-05-03T20:51:54.867

48 How to easily convert utf8 tables to utf8mb4 in MySQL 5.5 2011-11-22T12:18:30.003

48 Is it safe to use innodb_flush_log_at_trx_commit = 2 2012-02-10T05:36:22.313

43 What problems will I get creating a database per customer? 2011-02-03T10:54:10.757

43 Why aren't primary key / foreign key matches used for joins? 2012-03-16T00:16:57.660

43 How do I swap tables in MySQL? 2012-08-07T12:39:28.540

42 Is it possible to have passwords configured per database or per host in .my.cnf 2011-07-15T19:13:36.473

42 Why should I create an ID column when I can use others as key fields? 2011-11-22T19:56:28.047

41 Is there a tool like Microsoft's "SQL Server Profiler" for MySQL? 2008-09-24T01:40:48.050

41 Why is DROP DATABASE taking so long? (MySQL) 2012-01-27T12:50:19.567

41 Scalability limitations of PostgreSQL and MySQL 2012-09-10T14:14:49.883

40 NULL or NOT NULL by default? 2011-01-03T23:20:37.913

39 Performance implications of MySQL VARCHAR sizes 2011-01-08T20:39:18.110

38 How do you tune MySQL for a heavy InnoDB workload? 2011-01-04T18:17:50.210

38 Trying to use MySQL Workbench with TCP/IP over SSH - failed to connect 2011-06-26T14:02:57.187

38 intermittent MySQL crashes with error "Fatal error: cannot allocate memory for the buffer pool" 2012-09-30T16:40:13.430

38 InnoDB: Error: Table "mysql"."innodb_table_stats" not found after upgrade to mysql 5.6 2013-12-06T20:31:05.747

37 When is the right time to use MariaDB instead of MySQL, and Why? 2011-01-03T21:02:58.160

37 Multi cores and MySQL Performance 2011-09-18T14:38:17.790

37 MySQL DB import/export command line in Windows 2010-04-25T10:56:26.400

36 How do you calculate mysql max_connections variable? 2011-02-15T12:09:36.393

36 MySQL 5.1.66 SSL connection error ERROR 2026 (HY000) 2013-01-04T09:06:08.800

36 SSD vs HDD for databases 2014-02-27T18:07:20.410

35 In MySQL, does the order of the columns in a WHERE clause affect query performance? 2011-03-17T20:56:41.640

35 Restore mysql database with different name 2011-12-07T07:33:46.737

35 Is MySql's LAST_INSERT_ID() function guaranteed to be correct? 2012-07-19T17:34:50.663

35 How to make MySQL table name case insensitive in Ubuntu? 2014-02-22T06:33:27.097

34 How to update one table based on another table's values on the fly? 2012-07-19T13:14:23.423

34 How to grant super privilege to the user? 2014-04-17T10:41:12.227

33 Difference between On Delete Cascade & On Update Cascade in mysql 2014-08-22T06:22:50.720

33 Why are simple SELECTs on InnoDB 100x slower than on MyISAM? 2014-08-27T12:29:18.650

32 MySQL : Why are there "test" entries in mysql.db? 2012-02-17T20:33:57.767

32 Is the CPU performance relevant for a database server? 2012-04-26T13:26:59.750

32 How to import a .sql file in MySQL? 2012-09-14T11:43:19.737

31 Why does MySQL not have hash indices on MyISAM or InnoDB? 2011-05-17T05:58:14.387

31 Error Code 1117 Too many columns; MySQL column-limit on table 2011-07-20T07:24:46.673

31 Possible INDEX on a VARCHAR field in MySql 2013-03-02T22:18:30.213

31 MySQL: How to check foreign keys related to a table 2015-05-24T15:48:54.027

30 How long is "too long" for MySQL Connections to sleep? 2011-03-03T20:37:00.837

30 How to SELECT from SHOW TABLE STATUS results 2011-06-07T21:23:27.967

30 Is it possible to mysqldump a subset of a database required to reproduce a query? 2011-08-15T21:24:04.683

30 How do I change the DEFINER of a VIEW in Mysql? 2011-12-16T02:56:03.837

30 MySQL and window functions 2013-04-16T15:08:27.170

29 Order by column should have index or not? 2012-01-20T07:22:00.443

29 For absolute performance, is SUM faster or COUNT? 2012-10-24T20:56:44.690

29 EXISTS (SELECT 1 ...) vs EXISTS (SELECT * ...) One or the other? 2016-12-29T08:02:32.663

28 Character vs Integer primary keys 2011-01-05T01:06:31.337

28 How Does Table Partitioning Help? 2011-10-07T18:49:29.063

28 How should I design a relationship table for friendship? 2012-01-05T13:52:21.917

28 Get the rank of a user in a score table 2012-02-22T20:48:07.487

28 restore table from .frm and .ibd file? 2012-04-22T03:59:53.467

28 MySQL Set UTC time as default timestamp 2012-07-01T11:33:29.480

28 MySQL InnoDB crash post-mortem 2012-09-28T02:54:13.330

28 Access denied for user 'root'@'%' 2012-12-19T09:15:33.017

28 How to properly kill MySQL? 2013-03-06T05:28:02.670

28 CREATE INDEX vs ALTER TABLE ADD INDEX - MySQLism, or SQL Standard? 2013-07-18T18:58:13.230

27 How can I change the default storage engine in phpmyadmin? 2011-01-04T03:50:52.477

27 What is the recommended way to backup a MySQL/Amazon RDS database to S3? 2012-01-23T16:16:21.800

27 How can I move a MySQL database to another drive? 2012-03-01T19:00:12.450

27 Why would SELECT * be magnitudes faster than SELECT foo? 2014-07-27T11:11:26.803

26 INT(5) vs SMALLINT(5): numbers in parenthesis after the numeric type 2011-01-07T04:05:23.057

26 How do I properly perform a MySQL bake-off? 2011-06-19T17:52:27.543

26 selecting where two columns are in a set 2013-02-06T19:10:22.253

26 Is there a graceful or safe restart for mysql like for apache httpd? 2013-02-25T19:33:07.190

26 How do I enforce a write-once then read only database table in SQL? 2017-11-21T20:16:02.020

25 Tool to generate large datasets of test data 2011-01-09T21:21:25.970

25 Dump only the Stored Procedures in MySQL 2011-07-25T14:55:41.833

25 MySQL Error Reading Communication Packets 2012-06-12T17:40:25.673

25 Amazon RDS for MySQL vs installing MySQL on an Amazon EC2 instance 2013-02-11T13:24:50.343

25 How to speed up queries on a large 220 million rows table (9 gig data)? 2013-04-10T20:46:52.620

25 Changing mysql table comment 2014-02-25T08:32:59.250