User john.locke - Database Administrators Stack Exchange

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

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

3

8

votes

3

answers

5

kviews

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

mysql import bulk

jul 19 '12 at 18:58 RolandoMySQLDBA 42.9k

2

7

votes

4

answers

475

views

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

mysql mysql-5 authentication

jan 28 at 5:20 RolandoMySQLDBA 42.9k

1

7

votes

3

answers

3

kviews

check constraint does not work?

mysql constraint

aug 5 at 9:03 ypercube 9,403

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

563

views

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

mysql mysql-5

feb 16 '12 at 22:21 RolandoMySQLDBA 42.9k

4

votes

1

answer

115

views

how much overhead an error in RDBMS has?

rdbms error-handling

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

1

3

votes

2

answers

292

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

3

kviews

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

mysql explain

nov 20 at 11:56 dezso 4,234

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 42.9k

1

3

votes

1

answer

107

views

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

mysql-5

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

3

2

votes

4

answers

11

kviews

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

mysql update

mar 22 at 7:16 vineesh 1

2

votes

1

answer

350

views

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

mysql

jun 27 '12 at 11:11 ypercube 9,403

1

2

votes

2

answers

67

views

Are these extra Index fields needed?

mysql index select

may 17 '12 at 15:18 Derek Downey 10k

2

votes

2

answers

130

views

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

query

mar 30 '12 at 10:06 ypercube 9,403

2

votes

1

answer

93

views

Why cp1256 collation is not 1 byte in MySQL?

mysql collation

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

1

vote

3

answers

291

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

154

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 42.9k

2

1

vote

1

answer

307

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 42.9k

1

vote

3

answers

231

views

Replication or Sharding for a huge table?

mysql replication

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

1

vote

2

answers

161

views

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

count mysqli

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

1

vote

2

answers

560

views

Do I need SQL_NO_CACHE for write intensive query?

mysql performance

apr 17 '12 at 10:19 RolandoMySQLDBA 42.9k

1

vote

2

answers

1

kviews

Table compression in InnoDB?

mysql innodb myisam

dec 21 '11 at 19:51 RolandoMySQLDBA 42.9k

1

vote

2

answers

496

views

Where should I look for my.cnf?

mysql innodb

dec 19 '11 at 17:33 RolandoMySQLDBA 42.9k

1

vote

1

answer

169

views

Normalization, field types and relationship

mysql

dec 15 '11 at 21:53 RolandoMySQLDBA 42.9k

0

votes

1

answer

159

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

40

views

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

mysql index order-by

jun 30 '12 at 8:08 ypercube 9,403

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 662

0

votes

0

answers

154

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 662

0

votes

1

answer

332

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.3k

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,547

john.locke

30 Questions