Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options answers only user 877

An operating system published by Apple.

2
votes
DISCLAIMER : Not a Menial Base 2 person VACUUM is a sqlite operation for defragmenting tables and tablespaces. It also helps reclaim diskspace. It defragments all sqlite tables by copying data from …
answered Mar 18 '14 by RolandoMySQLDBA
0
votes
MyISAM still uses .MYD and .MYI. The only way you can see .frm files only and no other table file would be this: All tables are using InnoDB innodb_file_per_table disabled (all table data would be …
answered May 1 '15 by RolandoMySQLDBA
1
vote
This may depend on where you generated the CSV file. If the CSV file was generated on a Windows machine, there could be some character set issues See https://code.google.com/p/sequel-pro/issues/detai …
answered Apr 22 '13 by RolandoMySQLDBA
2
votes
DISCLAIMER : Not a MacOS user That is an alternative way. This shutdown method can be done in MacOS, Linux, Windows, any platform MySQL is supported in. I actually prefer your mysqladmin method for …
answered May 8 '12 by RolandoMySQLDBA
1
vote
First shutdown mysql mysqladmin -uroot -p shutdown Then, launch mysqld by hand mysqld --defaults-file=... or if MySQL is running with all defaults and you are just changing datadir, do this mys …
answered May 12 '15 by RolandoMySQLDBA
15
votes
One of the silent killers of MySQL Connections is the MySQL Packet. Even the I/O Thread of MySQL Replication can be victimized by this. According to the MySQL Documentation You can also get these e …
answered Sep 1 '11 by RolandoMySQLDBA
1
vote
I just noticed you have lower_case_table_names defaulted to 2. According to the MySQL Documentation on lower_case_table_names You should not set this variable to 0 if you are running MySQL on a …
answered Apr 7 '13 by RolandoMySQLDBA
0
votes
DISCLAIMER : Very Rookie MongoDBA My guess would be the Document Size According to "MongoDB Limits and Thresholds" BSON Document Size The maximum BSON document size is 16 megabytes. Th …
answered Sep 28 '15 by RolandoMySQLDBA
2
votes
According to the MySQL 5.0 Certification Study Guide Chapter 32 Section 32.3.4, Pages 456,457 describe the Conditions for Binary Portability which bring out the following: Binary portability is …
answered Feb 28 '13 by RolandoMySQLDBA
5
votes
You many need to take a look at the comprehensive list of all Server Variables. Some of them you can change for the duration of your session, some you may change with the SET GLOBAL command, and other …
answered Jun 10 '11 by RolandoMySQLDBA