Bookmark and Share
Last Updates
Display: 51 - 60 of 150, Total Pages: 15
<< < 1 ... 2 3 4 5 6 7 8 9 ... 15 > >>
[Blog] MySQL replication got problems on now() [Original] 2010-2-27 4:20pm

The values of the column 'lastModified' are different on the master and the slave.

Read Full Article...

Section:MySQL DBA | Read:567 | Comment:0 | Rating:0%

[Blog] ERROR 1005 (HY000): Can't create table [Original] 2010-2-23 12:19am

Got the following error when adding a FK to a table:
ERROR 1005 (HY000): Can't create table 'db1.#sql-133b_d8714' (errno: 150)

Read Full Article...

Section:MySQL DBA | Read:2082 | Comment:0 | Rating:0%

[Blog] InnoDB: Error number 37 means 'No locks available'. [Original] 2010-2-18 2:23pm

I used "innodb_file_per_table" in my.cnf and failed to load a database which has about 280 innodb tables. I can load the data if I disable "innodb_file_per_table". With this parameter, I got the following errors in mysqld.log.

Read Full Article...

Section:MySQL DBA | Read:3781 | Comment:0 | Rating:0%

[Blog] An example of user_defined variables [Original] 2010-1-4 11:50am

select max(trans_id)+2000 into @v1 from transactions_overflow_insert;

Read Full Article...

Section:MySQL DBA | Read:503 | Comment:0 | Rating:0%

[Study Notes] The query optimizer and Last_query_cost [Original] 2009-11-18 12:15pm
MySQL uses a cost-based optimizer, which means it tries to predict the cost of variousexecution plans and choose the least expensive. The unit of cost is a single randomfour-kilobyte data page read. Y..

Read Full Article...

Section:MySQL DBA | Read:908 | Comment:0 | Rating:0%

[Work Notes] an example of loop insert in a MySQL procedure [Original] 2009-11-13 4:13pm
delimiter //CREATE PROCEDURE insert_temp()    BEGIN    DECLARE v1 INT;    SET v1 = 2707242;    WHILE v1 < 2721615 DO    in..

Read Full Article...

Section:MySQL DBA | Read:11022 | Comment:0 | Rating:0%

[Blog] Linux maximum number of open files or file descriptors [Original] 2009-11-11 10:18pm

There are two levels of control on Linux maximum number of open files (or file descriptors), system limit and per-user/group/process limit. /etc/sysctl.conf is to set system-wide amount for kernel, /etc/security/limits.conf is to assign specific limits on per-user/group or process.

Read Full Article...

Section:Linux tips | Read:36403 | Comment:0 | Rating:0%

[Study Notes] Speeding up [Original] 2009-11-10 12:54pm
Not all ALTER TABLE operations cause table rebuilds. For example, you can change or drop a column’s default value in two ways (one fast, and one slow). Say you want to change a film’s defa..

Read Full Article...

Section:MySQL DBA | Read:897 | Comment:0 | Rating:0%

<< < 1 ... 2 3 4 5 6 7 8 9 ... 15 > >>
Latest Comments
eozzrixrlo

on line..
- By admin, 2008-4-24 2:34am
rvaqlckrdu

free nud..
- By admin, 2008-4-24 2:33am
xndfjmwcpj

- By admin, 2008-4-5 1:02pm
vsjblsgatm

somali p..
- By admin, 2008-4-5 1:01pm
jknsdsmvyi

- By admin, 2008-3-12 1:48am
fkgyuchizk

tramadol..
- By admin, 2008-3-12 1:48am
wnniqpohsg

- By admin, 2008-4-24 2:32am
unxnmahoya

in phent..
- By admin, 2008-4-24 2:29am
bkgulrjbtt

- By admin, 2008-3-12 1:47am