| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> I was going to mention that... I don't use transactions...
<1> well, as a MyISAM app, you can't anyway
<0> And I LOVE table locking! Screw row-level.
<2> anyone know how to solve this? Query Failed: Lost connection to MySQL server during query
<0> !m _Raven_ gone away
<1> is your db server overloaded?
<3> _Raven_: (MySQL server has gone away) : http://dev.mysql.com/doc/mysql/en/Gone_away.html
<0> :(
<1> table-level locking is, IMO, the biggest drawback of MyISAM
<1> :(
<0> I bet.
<0> BUT IT'S SO FAST!
<1> it kills performance
<0> ...
<2> thnx, think that is it
<4> sjrussel: i have a similar issue ... thinking of switching to postgres for that reason..
<4> what's the fastest way to add/insert over 6.5M URLs based in a text file into a url table?
<1> or, just don't use locks (my personal solution)
<0> jade, LOAD DATA INFILE
<0> !m jade load data infile
<3> jade: (Problems with NULL Values) : http://dev.mysql.com/doc/mysql/en/Problems_with_NULL.html
<0> !m jade load data
<3> jade: (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<4> will, thanks trying it..
<0> jade, If you did want row-level locking, InnoDB is your pick.
<0> So is BLACKHOLE.
<1> BLACKHOLE is super-fast for inserts
<0> :)
<5> does MyISAM lock the whole table for each insert?
<0> I believe so.
<1> yes, unless you have never deleted from a table
<6> MORBO AGREES WITH THE PUNY HUMAN!
<7> thanks will
<0> Delete? Who needs that?
<8> Hi! If i have a column fulled with not unique numbers, how can i select the 5 most frequent number from it?
<0> SELECT numbers, COUNT(numbers) AS cnt FROM table GROUP BY numbers ORDER BY cnt DESC LIMIT 5; ?
<9> Annoying mysql problem: I can log into mysql on the command line, but not through phpMyAdmin. Any obvious things I should check?
<0> C_Dreamer, Error message?
<9> #1045 - Access denied
<0> Means you specified the wrong p***word.
<9> Er, quite so, but I know I'm typing it in right.
<9> So I'm betting I screwed up the config somehow.
<9> The same p***word works fine in a bash shell
<0> You could be trying to log in via TCP and you entered in the localhost/socket p***word.
<0> Login to mysql as root. Anyway you can. Look at your user table to see if you have two roots.
<9> I do have two roots
<9> Both are set to the same p***word, though
<9> One is User:root and Host:localhost
<9> The other is User:root and Host:foo.co.uk (for some value of foo)
<9> The full error message text says: Access denied for user 'root'@'localhost' (using p***word: YES)
<9> Curiously, it says this even if I try to use some other account name. (i.e. it still says 'root'@'localhost'). Maybe that's a clue.
<0> Check config.inc.php ...
<9> where? /etc/init.d ?
<0> phpMA directory.
<9> Okay, found it. Didn't know it existed. What am I checking for?
<0> The root p***word...
<0> It's probably blank.
<9> lol - found two candidates so far, both had no effect
<9> still searching
<9> Changed all three, still not working
<9> Presumably I don't need to restart mysql or PHP when changing config.inc.php ?
<9> Or do I?
<10> you need to restart php
<9> I thought Apache re-started that every time it needed to shell out to PHP
<0> No you don't.
<0> It's an application setting. Not PHP/Apache setting.
<10> if its a cgi yes module no
<0> This is a phpMyAdmin setting.
<0> :)
<9> Then I don't need to restart anything. And I'm still stuck. :-(
<0> Because you didn't change the right one. You're better off reading the docs for phpMyAdmin.
<9> C is a piece of cake compared to this.
<10> hehe
<11> is there a command in the mysql client to pull in and process a local sql script? i know i can pipe the script to the client, but i believe
<0> It has nothing to do with the language.
<11> i believe i saw a command for it, also *
<0> jeef, SOURCE
<11> cool, thanks will. :)
<9> Oh, one more thing - does phpMyAdmin 2.6.3-pl1 have an upper limit (of, like, 8 or fewer characters) for p***words?
<9> I'm using a 9-character p***word.
<9> Oh, n/m - I'm asking in the wrong channel. Sorry.
<12> anyone using jdbc with mysql?
<13> when I try to create a procedure I get the following error, Table 'mysql.proc' doesn't exist
<0> I should learn about procedures... that would be fun.
<14> will: thanks, i don' t understand it, but it works fine.
<0> zzz, What did I tell you?
<0> GhettoJava, The guy you want to talk to is mm-mysql. But he left
<14> will: how to select the fifth most frequent number from a column;
<12> ok
<15> Hi. Im installing mysql on fc3. I've followed the instructions on the dev.mysql site. When I try to start mysql, it fails to start.
<0> zzz, The top 5 or the fifth one?
<15> The error log is pasted at:
<15> http://rafb.net/paste/results/X6Oufg89.html
<0> Oh you said it worked...
<14> will: top 5
<14> will: sorry, i mispelled it.
<15> I understand it is a permissions prob, but the error message doesn't say where which directory requires the corrected permissions.
<16> hi!
<6> Well hey howdy hey!
<16> hey, how can I reset my primary key ordered by 'name'
<16> ?
<6> Reset it?
<0> Drop it and recreate it.
<16> yeah, so I drop and how do I recreate?
<0> sjrussel, Aww man, that Shariff guy left..
<6> Why reset it?
<0> sjrussel, Want to show him why we don't like FKs with questions like above :)
<16> mhillyer: Well, I have an app list for a php thing I'm making, and want to have id ranges for new apps... like, admins are from 50 to 100, etc
<6> That is not a good way to do it.
<16> any suggestion, mhillyer ?
<6> Why not just have an identifier column?
<16> yeah, I have, but wanna use a numbered id to make faster selects, that's all
<16> so admins get from 50-100, etc
<6> Faster selects?
<16> yep
<6> Ok, what happens when you get admin #51?
<9> will - I'm in. Thanks. (You were right about config.inc.php but I missed an obvious thingie)
<0> C_Dreamer, :)
<0> mhillyer, The world implodes...
<16> mhillyer: well, if you're admin, you get 50 to 100
<6> And when you get a 51st admin?
<6> Your design does not scale?
<16> no, it's an app list
<0> That can never happen.
<6> Never ever ever
<0> What is an "app list"?
<16> like, "modify user", "delete everybody", etc
<6> Renich: Just get an identifier column.
<16> I have one... hehe... in fact, I have 2...
<10> index it and order by it
<16> ok, I will, archivist
<6> Renich: You never depend on a surrogate PK to be a certain value.
<0> mhillyer, If I went to the UC, can you sneak me into your keynote?
<6> I'll have to get a keynote first.
<0> Don't you have one?
<0> I thought your name was on the list.
<6> MORBO DOES NOT DEMEAN HIMSELF TO KEYNOTES!
<0> WHO IS MORBO?
<6> I have three sessions, but none of them are keynotes.
<0> oh
<6> http://www.gotfuturama.com/Information/CharacterBios/morbo.dhtml
<0> mhillyer, If I went to the UC, can you sneak me into one or more of your sessions?
<16> thanks for the advice, c ya all
Return to
#mysql
or
Go to some related
logs:
mod perl internal_redirect_handler
ml570 ubuntu
xorg ctrl+alt++ problem
festival + british female + Ubuntu
#perl
IPTABLES -A FORWARD -i gre
starchat nameserver
krfb 5800
#web
smartmontools vt6421
|
|