?

Log in

No account? Create an account
March 26th, 2001 - LiveJournal Development — LiveJournal [entries|archive|friends|userinfo]
LiveJournal Development

[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

March 26th, 2001

Max keyfile length [Mar. 26th, 2001|12:00 am]
LiveJournal Development

lj_dev

[bradfitz]
Anybody know what's up with MySQL and its "Max keyfile length"? We were having table handler 136 errors from the log table earlier because there wasn't enough space free in the index file. Not on the filesystem.

Look at this and go search for "./log.MYI". See how full it is? Hell, I'll paste the relevant table:

./log.MYI MyISAM file: ./log.MYI Record format: Fixed length Character set: latin1 (8) File-version: 1 Creation time: 2000-11-09 16:49:15 Recover time: 2001-03-25 22:27:09 Status: open,changed Auto increment key: 1 Last value: 2529102 Data records: 2377474 Deleted blocks: 0 Datafile parts: 2377474 Deleted data: 0 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 2 Datafile length: 97476434 Keyfile length: 57940992 Max datafile length: 176093659134 Max keyfile length: 67107839 Recordlength: 41 table description: Key Start Len Index Type Rec/key Root Blocksize 1 26 4 unique unsigned long 1 19351552 1024 2 38 2 multip. short prefix 44834 24294400 1024 40 1 int8 8367 41 1 int8 950 3 2 4 multip. unsigned long prefix 39 35307520 1024 38 2 short 31 40 1 int8 16 41 1 int8 2 4 10 8 multip. ulonglong prefix NULL 5 43405312 1024 5 18 8 multip. ulonglong prefix NULL 1 57480192 1024

I think when I did a repair table on it (even though it reported no errors), it changed something (because it works now), and updated the "Recover time"

link8 comments|post comment

Innobase [Mar. 26th, 2001|04:25 pm]
LiveJournal Development

lj_dev

[bradfitz]
Note to self: play with Innobase on local machine. Looks promising.

Anybody have experience with it, good or bad?
link9 comments|post comment

(no subject) [Mar. 26th, 2001|04:43 pm]
LiveJournal Development
lj_dev
[ahze]
I've tried this couple times.

All seems to work grand except the following

# mysql -u lj -p livejournal < /home/lj/livejournal.sql
Enter password:
ERROR 1064 at line 1020: You have an error in your SQL syntax near 'user(user),
KEY (email),
KEY (status),
KEY (statusvis)
) TYPE=MyISAM PACK' at line 45


# mysql --version
mysql Ver 11.13 Distrib 3.23.35, for -freebsd4.3 (i386)
link3 comments|post comment

OBOE [Mar. 26th, 2001|11:21 pm]
LiveJournal Development

lj_dev

[herbie]
Hmm... Of-by-one error. I'd track it down myself tonight, but need to actually do homework., and since it's simple, I figured I'd let somebody else have the fun on this one.

On the "Recent Entries" page (and possibly the friend's page - I dunno) it puts up a link for "Previous 20" when there are only 20 entries, and therefore the link links to an empty page... Anybody who cares, feel free to find the bug.
link1 comment|post comment

navigation
[ viewing | March 26th, 2001 ]
[ go | Previous Day|Next Day ]