| |
| |
| |
|
Comments:
<0> Any way I can watch the sequence queries occur? They queries initiate from a web app.
<1> query log cyphor
<1> and grep the connection id / process id
<2> holy ****! compiling mysql with debug, no crash.. without debug, crashes... god damnit
<2> dammit rather
<3> heisenberg uncertainty principle
<4> mhillyer: when i run MYSQL, it hangs this way. The command does not seem to complete. i hit CTRL C to interrupt
<2> Version: '5.0.21-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port: mysql-server-5.0.21
<2> mysqld got signal 8;
<4> and i get this
<4> [1]+ Done /usr/mysql/mysql/bin/mysqld_safe user=mysql
<5> hi all, it appears that my DB only allows table keys lengths to be 500... is there a way to change this to something higher?
<5> 500 bytes, that is
<6> booga: that's not hanging, that's mysql ending right after it starts
<0> ty Jax
<6> booga: what does your error log say?
<3> spiderworm you can't index all of a text/blob column
<5> gleam-: :) I dont want to do that lol
<5> i only want to increase it by 50
<5> 550 bytes
<7> Innodb question, I have a table with cogs, and a table with colors, each cog can have 0 or 1 color, so I have a colorid field in cogs, when I set it to a foriegn key to the color pri key, it does not allow me to leave the field null. Is there an option in creating the foreign key that I'm missing to allow null, or do I need to create a color that represents 'no color'?
<6> LedZeplin: is the field set NULL?
<4> i will take a look at the logs. this is how it goes
<4> http://rafb.net/paste/results/pnwxP274.html
<6> or is it defined as NOT NULL?
<7> null is allowed in the field
<6> booga: that's the same paste as before
<8> LedZeplin: put show create table your_table; in a pastebin please
<2> i'm getting : mysqld got signal 8; ... on freebsd 6.0 with mysql 5.0.21 ... I was thinking of installing the latest gcc in ports and retrying, think that would resolve the issue?
<2> gcc version 3.4.4 [FreeBSD] 20050518
<5> no-one knows if the max table key length can be changed in the mysql confic file?
<8> spiderworm_work: you want an index wider than 500 bytes?
<5> inviso: yes
<8> why?
<5> inviso: because mediawiki 1.6.5 wants it
<8> typcially, wider than 10 or 15 bytes is a waste of space
<5> hey im not looking to argue with you or the mediawiki people
<8> gah :(
<5> i just want some sort of resolution :)
<8> then change the script
<9> somebody knows best!!!
<8> cut the silly indexes down to 25 bytes if you want to, but 500 is just crazy
<8> 10 is probably sufficient
Return to
#mysql
or
Go to some related
logs:
#php
You need to manually update libzypp, rug
LVM alternate install Ubuntu
so_buf linux
debian install chkconfig
perl base64_encode
#linux
suse mysql-query-browser Segmentation fault $PRG-bin
#math
rc_splash: command not found
|
|