User john.locke - Database Administrators Stack Exchange

bio	website
	location
	age
visits	member for	1 year, 5 months
	seen	Nov 24 '12 at 5:23
stats	profile views	76

	652 reputation	bio	website		visits	member for	1 year, 5 months
315 badges		location			seen	Nov 24 '12 at 5:23

2

7

votes

4

answers

463

views

Is splitting a 'users' table for authentication purposes a good idea?

jan 28 at 5:20 RolandoMySQLDBA 41.2k

1

7

votes

3

answers

2

kviews

check constraint does not work?

mysql constraint

aug 5 at 9:03 ypercube 8,644

2

7

votes

3

answers

5

kviews

Why is 'LOAD DATA INFILE' faster than normal INSERT statements?

mysql import bulk

jul 19 at 18:58 RolandoMySQLDBA 41.2k

1

6

votes

2

answers

1

kviews

Do I have to buy MySQL license?

mysql license

feb 5 '12 at 18:32 Peter Mortensen 119

4

votes

1

answer

535

views

Is there a way to find my.cnf in shared hosting?

mysql mysql-5

feb 16 '12 at 22:21 RolandoMySQLDBA 41.2k

4

votes

1

answer

110

views

how much overhead an error in RDBMS has?

rdbms error-handling

dec 17 '11 at 18:32 BryceAtNetwork23 1,291

1

3

votes

2

answers

281

views

Should I use select count(*) for counting records or having a field like comments_no for tables like post, comments?

innodb select count update mysqli

mar 1 at 7:29 Community♦ 1

3

votes

2

answers

2

kviews

Why am I getting `Impossible WHERE noticed after reading const tables` in explain query?

mysql explain

nov 20 at 11:56 dezso 3,892

1

3

votes

2

answers

51

views

Should I put followers_no & following_no & product_no & last_login and etc in the user table? Won't updates cause fragmentation on the table?

mysql database-design innodb fragmentation

aug 1 at 17:30 RolandoMySQLDBA 41.2k

1

3

votes

1

answer

105

views

count(id) on Char(0) column does not work! [duplicate]

mysql-5

dec 16 '11 at 11:21 Jack Douglas♦ 12.8k

2

votes

1

answer

323

views

Should I use WHERE NOT EXISTS or LEFT JOIN for getting the ids of relationship table?

mysql

jun 27 at 11:11 ypercube 8,644

1

2

votes

2

answers

66

views

Are these extra Index fields needed?

mysql index select

may 17 '12 at 15:18 Derek Downey 9,867

2

votes

2

answers

124

views

how to GROUP BY on specific column and COUNT() the other columns?

query

mar 30 '12 at 10:06 ypercube 8,644

2

votes

1

answer

90

views

Why cp1256 collation is not 1 byte in MySQL?

mysql collation

dec 29 '11 at 7:42 a_horse_with_no_name 8,125

1

vote

4

answers

9

kviews

How to update one table based on another table's values on the fly?

mysql update

mar 22 at 7:16 vineesh 1

1

vote

3

answers

274

views

shoud we normalize user profile table with fields like interests,musics,videos,sports, etc?

schema normalization

jul 25 at 16:06 Zachariha Robichaud 1

1

vote

1

answer

152

views

some InnoDB settings in My.cnf are messing up everything, why?

mysql innodb mysql-5 my.cnf

may 24 '12 at 4:57 RolandoMySQLDBA 41.2k

2

1

vote

1

answer

295

views

For 768M RAM server is 617M allocation in my.cnf good or bad?

mysql mysql-5 my.cnf

may 18 '12 at 14:04 RolandoMySQLDBA 41.2k

1

vote

3

answers

226

views

Replication or Sharding for a huge table?

mysql replication

may 5 '12 at 0:54 randy melder 1,802

1

vote

2

answers

159

views

how to get count(*) from table which either has column or not?

count mysqli

apr 27 '12 at 13:01 Leigh Riffel 13.7k

1

vote

2

answers

519

views

Do I need SQL_NO_CACHE for write intensive query?

mysql performance

apr 17 '12 at 10:19 RolandoMySQLDBA 41.2k

1

vote

2

answers

1

kviews

Table compression in InnoDB?

mysql innodb myisam

dec 21 '11 at 19:51 RolandoMySQLDBA 41.2k

1

vote

2

answers

441

views

Where should I look for my.cnf?

mysql innodb

dec 19 '11 at 17:33 RolandoMySQLDBA 41.2k

1

vote

1

answer

169

views

Normalization, field types and relationship

mysql

dec 15 '11 at 21:53 RolandoMySQLDBA 41.2k

0

votes

1

answer

154

views

Why we use low numbers for concurrent in MySQL benchmarks or HTTP_LOAD? [closed]

mysql concurrency benchmark

aug 9 at 8:00 Community♦ 1

0

votes

1

answer

39

views

Is index like key(timetime) usable when we query: SELECT * … ORDER BY timetime DESC

mysql index order-by

jun 30 at 8:08 ypercube 8,644

0

votes

1

answer

36

views

All manual settings get wiped out when saved in My.cnf, why? [closed]

mysql my.cnf

may 22 '12 at 6:02 john.locke 652

0

votes

0

answers

153

views

Are there any caveats to install mysql 5.5 in CentOS 5?

mysql-5.5 installation

may 21 '12 at 16:03 john.locke 652

0

votes

1

answer

292

views

Is there a way to skip errors in procedures and resuming procedure

stored-procedures mysql-5 foreign-key

may 18 '12 at 8:29 Phil 10.2k

0

votes

1

answer

103

views

database normalization and optimization for postOffice DB

database-design

dec 4 '11 at 1:35 Mike Sherrill 'Catcall' 4,422

john.locke

30 Questions