| |
| |
| |
|
<FMJaguar> 1 row found: m0sphere's mom
<bipolar> hey guys... I'm looking for the command to see the current threads in mysql. Searching around but just finding ways using GUI tools so far. Could anyone tell me?
<nickg> bipolar show processlist
<bipolar> ok, I see it now... SHOW [FULL] PROCESSLIST ...thanks a lot, nickg
<phpnuborn> how do i find out the collation of a database is?
<phpnuborn> nobody knows?
<flupps|UK> phpnuborn: \s
<gleam> yawn
<phpnuborn> ok.. how do i set the default collation for DBs and tables?
<nickg> show variables; ?
<gleam> yawn
<gleam> wait i said that already
<gleam> damn.
<duality> is there any reason, when using varchar(x), to set x to something other than 255?
<arjenAU> yes. efficiency and sanity
<duality> can you explain please?
<arjenAU> for some sorting operations, the server uses the max width for efficiency. so you're then wasting time/space if you allocate more than you need.
<arjenAU> that's where there's a choice of x. otherwise it wouldn't matter, eh.
<arjenAU> and the above is just one example of where it matters. just don't be wasteful.
<duality> well... I don't get it. Cause as far as I understand, 50 characters saved in a varchar(50) column will take just as much space as varchar(255). Am I right?
<nickg> if you have a value that you only want it to be 50 characters long, allowing more than 50 would waste space
<nickg> like a username, why does it ever need to be more than say 25 characters long? so set the restriction to 25
<duality> how does mysql store enum values? e.g.: is it different to use enum('first value', 'second value') as oposed to enum('1st', '2nd') ? the manual says nothing about this
<nickg> it stores a bit value
<nickg> each option is ***igned a number, 1, 2, 4, 8, 16, 32, 64.. so on
<nickg> so when the values, such as first value, second value, are only put in the .frm file
<nickg> it stores the bit value in the data
<duality> oh, cool, thanks
<duality> and what if you change a column type from (say) enum('little', 'much') to enum('toolittle', 'toomuch')? Does the data in table rows, that "used" 'little' now "use" 'toolittle'?
<nickg> i believe so.
<Mille> I need to check if an ID exists in table A, if not, add it, return the ID to the script. Insert data to another table containing the ID from table A. Wich will be the fastest way to to this?
<Mille> insert ignore and then select?
<Mille> insert ignore wont return an id back to me, will it?
<nickg> Mille without a function or something along those lines in 5.0, I dont see a way to do it in one query.
<nickg> You can see if it exists by doing a LEFT JOIN
<Mille> that helps. thanks. :-)
<Mille> hm. after rethinking it I'm not sure how you mean I should do it...
<Mille> need to sleep. later.
<madbomber> anyone setup mysql replication where one of the slaves uses different indexes than the master? (can you even do that?)
<lokus> possible
<nickg> it's the ndb guy!
<flupps|UK> madbomber: it's doable
<phpnuborn> what is the difference between collations utf8-general-ci and latin1-swedish-ci ?
<phpnuborn> my webhost is telling me that it makes no difference, even when sorting?
<phpnuborn> he right?
<KilledDot> phpnuborn, I guess... #php ?
<arjenAU> phpnuborn: don't crosspost
<arjenAU> KilledDot: it was a mysql question he asked
<KilledDot> am sorry.
<madbomber> coolio, thanks :)
<Damm> i hate it when people crosspost
<Damm> but there's a difference between latin1 and utf
<Damm> but it depends what it's encoded with to begin with really
<Navin[rus> is there a way to get forgotten root's p***word from a mysql5 database (on FreeBSD)
<Navin[rus> or add another user somehow.. possible?
<lokus> Navin[rus: the manual has instruction how to reset the mysql root p***word
<Navin[rus> can't find it there..
<lokus> search for reset p***word
<lokus> http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
<Navin[rus> mysqladmin -u root -h localhost p***word "root" ?
<Navin[rus> Access denied for user 'root'@'localhost' (using p***word: NO)
<lokus> no, read the url
<nickg> he cant find it!
<lokus> exact url provided already
<Trinitonn> hey guys.. I was wondering if it is possible (with a clause or something), to pick out and count only odd words from a field in a mysql-database..Cause I have almost the same word in every posts, but I dont want to print them ALL out..(but only print once for each different word).. uff..complicated? :P "me leik milk"-english hehe
<Navin> kill `cat /var/db/mysql/w1.domain.com.pid`..... this doesn't work ;-( cat: /var/db/mysql/w1.domain.com.pid: No such file or directory .... but this file is exists! help?
<Navin> is there another way to kill mysqld?
<Mojo-jojo> Navin have you looked into mysqladmin -uroot -p shutdown?
<arjenAU> Navin: chances are it does work, but i't sgetting restarted. you need to kill mysqld_safe first if you do it that way. however, there are nicer methods.
<phpnuborn> what command shows the collation of a Database?
Return to mysql
or
Go to some related
logs:
wow
politics
osdev
|
|