| |
| |
| |
|
Page: 1 2 3 4 5 6 7
Comments:
<0> krummie if you are on Debina read the config file it has it commented out in there
<1> okay
<2> NOw, I'm using the default cookies authtype. Gotta study auth_types ;-)
<0> cornell_ you can add it to your my.cnf otherwise the software being used some could have been compiled against current libraries while others are using older libraries this woudl cause the differences
<0> !m cornell_ authentication Types
<3> cornell_: Nothing found
<4> Ungy: thanks
<0> !m cornell_ old client
<3> cornell_: (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<2> Question... my box is accessable from the net. There is no "sensitive" information in the database. The p***word (which I understand is transmitted in clear text) is used only for the mysql database. Am I alright to leave tightening up security for awhile?
<4> Ungy: didnt realise i could do multiple things in 1 ALTER query
<0> ico2 you can completely rewrite a table in one alter statement to the point the table looks nothign like it did before
<1> Ungy I have turned on "log slow query's" now. I also stopped and started mysqld. Is it true that the log file is missing untill there really is a slow query to log?
<0> cornell_ that is a personal opinion you can do what you want however you want to do it but I would secure it as soon as possible you never know who might be snooping around
<2> And why did I have to use old p***word for root, but not for additional users?
<0> krummie it creates it on need
<0> cornell_ did you read that page?
<2> Ungy: so the cookie auth_type is the least secure?
<2> Ungy: reading it now
<0> cornell_ lots of opinions regarding that I do not think it is very secure personally but you shoudl read and form your own opinion
<2> m! cornell auth_type
<1> Ungy suddenly the file contains data. Now what can I do with the data? I know who's hosting account is doing the slow query's. So according to the data: I should be able to find out what is generating this load and what to do about it?
<2> oops
<0> krummie well you have to see what is causing the problems and then attempt to fix it
<2> !m cornell_ auth_type
<3> cornell_: Nothing found
<0> cornell_ http://dev.mysql.com/doc/internals/en/client-authentication-packet.html
<1> Ungy: this is what I see in the log file: http://pastebin.com/540020 I don't know what to do with this info now.
<1> well I do know that I can figure out what it all means
<1> but just not how ...
<0> krummie why not explain that query and see if you can index somethign to help speed the query up or attempt to rewrite it to be faster and scan less rows
<1> okay Ungy I'll go after it. But is this what might be causing the high loads and stuff?
<2> I've read it, Ungy, and it points out the use of the old_p***word, it also says that to use new, I need the versions which I have ( I think... the packages are MySQL41-client-4.1.5 ( and common and Max) and the document says I need 4.1.1 or above... I'm above (also libmysql14.4.1.5)
<0> krummie it si possible it coudl also be innodb doing things in the background
<0> cornell_ all programs accessing mysql must be compiled against the newer libraries
<5> 4.1.5 is seriously old
<1> Ungy what if it's innodb doing the stuff in background. How can I find that out?
<2> mmm... so, the php-mysql installed from the package needs to be recompiled on my machine with my current mysql?
<2> Well, Leithal, that's what I got from urpmi... I tried urpmi again...
<5> just download it from mysql.com
<2> I did urpmi mysql, and I note the result list includes php5-mysql, not php-mysql. So perhaps the presence/use of php-mysql is the problem, and I need to go to php5-mysql
<5> !perror 143
<3> MySQL error: 143 = Conflicting table definitions in sub-tables of MERGE table
<2> Leithal: I've been looking at that site, and um... an embarrasment of riches, I don't know quite which to pick ;-)
<5> well that depends on your OS ;)
<5> if you are using 4.1 you at least want 4.1.18
<5> or if you want to try 5.0 - 5.0.18
<5> tar.gz is good enough for linux, imo
<2> Leithal: I'm looking at "Linux x86 generic RPM (dynamically linked) downloads" for 5
<2> Well, I'd prefer to stay with rpm
<2> s
<2> Well, I'd prefer to stay with rpm's
<5> get the generic one then
<5> unless there is a targeted one for your system
<2> Nothing for mandrake
<5> get the generic ones for that
<2> the version is 5.0.18-0, and I'd need server, client programs, libraries and header files, and dynamic client libraries, right?
<2> Now... my hardware has problems with newer linuxes (nic's fail) So I'm on Mandrake 10.1, can't go to Mandriva. Also knoppix and Livecd don't work with my hardware...
<2> Any idea if mysql 5 will be a problem, with a slightly old OS?
<2> Or should I stick with 4.1.18?
<5> should be fine
<2> As I've just started this and haven't done anything yet, I'm thinking of using the package manager to remove mySQL4.1 and php-mysql, and downloading the above mentioned rpm's and installing them. Sound like a good plan?
<2> And php5-mysql
<6> Ungy, hello
<2> Gotta step away for a bit, when I get back I'll scroll back
<7> If you aren't here then, thanks much Ungy and Leithal
<8> hi all
<8> i have a problem: error : Can't open file: 'procs_priv.MYI'. (errno: 138)
<8> i tried to fix with mysqlcheck -r --use-frm and with myisamchk -r but no way
<8> still get same problem
<8> any ideas ?
<9> !perror 138
<3> MySQL error: 138 = Unsupported extension used for table
<9> oww
<1> hi: 3616 mysql 15 0 118m 34m 4624 S 73.5 1.7 4:15.38 mysqld
<5> only an index file though
<1> ohw uhm how can I find out what is causing this high load?
<5> and it's on the system tables - so you can mysqldump/mysql_install_db/load mysql database again
<5> or something along those lines
<5> krummie: Queries? ;)
<1> Leithal that can be but how can I find out what query's are doing this?
<5> show full processlist
<5> !man show processlist
<3> (SHOW PROCESSLIST Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html
<10> Is there a standard way to optimize a simple join? I'm joining table foo to bar on foo.id = bar.id, where the id columns are both indexed bigints. It's going unbearably slowly though
<8> Unsupported extensions ?
<8> how could i fix this issues ?
<8> issue :P
<1> Leithal: http://pastebin.com/540081
<5> well they're not doing a lot
<5> using InnoDB?
<5> could be doing a background flush or something
<1> dunno
<1> how can I find out if innodb is being used?
<5> check the output of SHOW TABLE STATUS
<1> Leithal this is all I see
<1> mysql> SHOW TABLE STATUS
<1> ->
<5> ;
<5> all statements end with ;
<5> or \G
<5> "SHOW TABLE STATUS;"
<1> it says no db selected
<1> :/
<5> "USE" your database then
<5> do you know your database name?
<1> there are several db's on the server
<9> pick one
<1> are you talking about the mysqld db? or a random db?
<1> ok
<8> Darien, have you any ideas about to fix " Unsupported extension used for table" ?
<9> nope
<10> I'm currently using the MyISAM engine. Would switching to Innodb possibly speed up basic joins?
<0> bazman more then likely no
<0> bazman did you write a web page about Software testing a long time ago or azre you a different one?
<10> Ungy: have any recommendations? I set the key_buffer_size larger than the index that I'm joining on...
<0> bazman Explain on it and see what you can see
<0> OK I am going to get a game of war3 in before I start working on all this crap I have to do take care
<10> Ungy: have fun
<10> Ungy: (explain doesn't seem to say anything remarkable. It's using the index on the larger table)
<11> is there a mysql frontend for debian, that isn't phpmyadmin?
<5> !tell us about gui
<3> Leithal asked me to tell you this: MySQL Query Browser and MySQL Administrator from mysql.com; phpMyAdmin from phpmyadmin.net; Rekall from rekallrevealed.org; DBDesigner from fabforce.net; Windows users may prefer MySQL-Front and SqlYog at mysqlfront.de and webyog.com
<12> i'm having troubles in making mysql-5.0.18 and php-5.1.2 to communicate through the mysqli extension
<12> i'm trying to connect through the unix socket /var/run/mysql/mysql.sock
<12> The mysqld and httpd daemons are running, but when i try to open a connection, all i get is "can't connect to local mysql server through socket '/var/run/mysql/mysql.sock'".... but the /var/run/mysql/mysql.sock file is there!!!!
<11> thanks Leithal
<12> is there some kind of problem with getting mysql-5.0.18, apache-2.0.55 and php-5.1.2 to work together, as far as you know?
<13> its not mysql problem, man
<12> is it a php related problem?
<10> I'm realizing that if mysql does exactly one seek per row then it will still take 60 hours to execute this join. I bet there's no way to get less than that without using multiple disks
<13> yes
<13> maybe your httpd is chrooted
<12> mdc: what do you mean with that?
<13> man chroot ))
<13> A chroot(2)ed application is locked into a particular directory and unable to wander around the rest of the directory tree
<10> Is it true that if you're selecting a random 25% of the rows from a table that mysql would have to make a disk seek for every row?
<12> I installed apache setting the prefix to /usr... by looking to the /usr/sbin/apachectl script, i don't think httpd is chrooted
<14> Can anyone tell me how to alter the name of a database. I'm having trouble doing it. Thanks.
<10> gary: not sure on this, but you could try simply try stopping the db server, renaming the folder in /var/lib/mysql/ (or wherever your mysql data folder is) and restarting
<10> s/try //
<12> I put the mysql databases in /var/lib/mysql... to what should i rename that folder?
<14> thanks :D
<12> no, sorry
<12> i thought it was addressed to me :-)
<15> how do i escape a comma in an sql query? i wanna do something like "select name from table where id like ',$id,'"...but that doesn't work because of the commas...what can i do?
<15> (i'm using php, btw)
<16> jcurry: thats a php question
<15> lsmith, ok, i got an answer in ##php, but thanks!
<0> jcurry you can do a select CONCAT(',',id.',') if you wnat it done via mysql
<16> Ungy: he already left
Return to
#mysql
or
Go to some related
logs:
#math
drm.ko needs unknown symbol
servage rsync
Latex gaim2
#suse
tao or dao + iso + images
#linuxhelp
#ai
#css
artec t1 ubuntu
|
|