| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> can someone shed some light on this
<1> Question: how can i enable access to mysql server from my lan? I noticed the bind-address option in the my.cfg but i can't replace localhost with a subnet nor multiple ips!
<0> that query is fine.. if I copy it and try to run it.. it executes fine..
<2> Tadipar: what is ?
<0> exactly
<3> archivist: you were right, the app is having problems
<3> thanks
<0> I get these errors.. sometimes its that character
<0> and sometimes its that "reserved" symbol.. the R in a circle
<2> le_mackeux: comment it out or use the machine's ip
<2> Tadipar: client side character sets perhaps?
<1> iviso: if i comment it out, that means there is no acl to access it?
<2> le_mackeux: eh?
<0> the query is ascii as far as I know
<0> but that character doesn't even exist in the query
<1> invio: if i comment it out, that mesns the is no restriction to access the sql server?
<4> so I've got a slow mysql server chewing cpu, I'm a sysadmin not a DBA or a programmer, I've just got load through the roof. I turned on slow-query logging and I'm seeing things like: SELECT * FROM my_order WHERE cart_uid = NULL; # Query_time: 120 Lock_time: 59 Rows_sent: 1 Rows_examined: 639068 -- are those times in seconds?
<2> le_mackeux: not at the socket level. MySQL still has the internal permissions that are evaluated
<2> !m le_mackeux adding users
<5> le_mackeux: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<2> le_mackeux: note the part about user@host
<1> tks
<0> inviso.. here is the other error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near seeders, t.times_completed, p.ip, p.port from torrents t, peers p where t.iD = at line 1
<2> hacim: heh, that's not good. cart_uid = NULL isn't valid anyway
<2> hacim: and yes, in seconds
<4> inviso: is this an indication that this thing isn't indexed maybe?
<2> hacim: find your programmers and hit them with a bat. It may not be indexed and it should be WHERE cart_uid IS NOT NULL
<4> inviso: how can i tell if things are indexed?
<2> !m hacim show indexes
<5> hacim: Nothing found
<4> inviso: well, there are entries where cart_uid ='asioejsofjso;fjeofjseof' and the query time is about that high
<2> bah
<2> !man show index
<5> (SHOW INDEX Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW_INDEX.html
<2> there it is
<2> !m hacim explain
<5> hacim: (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<2> hacim: you'll need that as well
<0> inviso .. let me know when you have a moment
<2> Tadipar: that really doesn't make much sense. Where are you running these queries from?
<0> they are running from a windows box to a linux box
<2> from php? mysql command line? python? C#? etc
<6> when you've got master/slave setup on a database.. There must be a way to have triggers on the master/stored procs on the master, that don't trickle down to the slave
<4> inviso: hrm, looks like it has a btree index already
<0> the fact that, mysql is able to print out the query without errors means it gets the query fine
<0> c#
<2> hacim: well, use explain to figure out why it's so slow
<0> if there was a network error or something, it wouldn't get the complete query.. but in this case, it gets the complete correct query.
<2> Tadipar: I really don't know what to tell you. It sounds like a charset problem, but I don't know how or why. Do you have a mysqlab support contract?
<0> but if there was a charset problem, wouldn't it show up when it prints the query out with the error ?
<2> perhaps
<2> I'm guessing :)
<4> inviso: ok, I do EXPLAIN SELECT * FROM my_order WHERE cart_uid = NULL; and it shows me the table, the type possible_keys (NULL), key (NULL), key_len (NULL), ref (NULL), rows (639321), extra (Using where)
<7> hacim: WHERE blah=NULL; ??
<0> where is errmsg.sys used ?
<4> Xgc: thats whats in my slow-query.log
<7> hacim: Do you realize that will never return anything?
<4> Xgc: no, because I'm only the sysadmin having to deal with the machine under the weight of this horrible code
<2> hacim: like I said, WHERE cart_uid IS NULL
<7> hacim: Ok. THe query is essentially useless for anything other than creating load/traffic and no results.
<8> Leithal line 104 is using the answer before the dir has has found it
<4> inviso: oh you mean it should be IS not =?
<4> inviso: because before you said it should be IS NOT NULL
<7> hacim: Yes. IS NULL -or- IS NOT NULL
<9> archivist: elucidate ;)
<4> Xgc: but not = NULL
<7> hacim: Correct.
<4> awesome...
<4> thanks everyone
<8> you are using token 4 in dir section for the file name
<8> except that token 4 is read FROM the result
<8> if i am reading it correctly
<10> anyone ever have problems connecting to mysql with a PHP script and getting an error that mysql.sock doesn't exist when it actually does and in the right place, with the right permissions?
<11> how could you design an sql query that it takes a timestamp from a field and convert it to a dateformat
<11> ?
<3> hi again
<3> seems that mysql is inserting an \n to the fields
<2> !m vhuren alter table
<5> vhuren: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<3> in my table i have id, from, date but the from field that is $from = trim($_GET['from'); is inserting an \r or \n before the field
<12> anyone know an online site where you can connect to remote mysql db?
<6> federated
<6> or are you talking a free account where you can try it?
<12> ?
<13> how you mean taht akumanz?
<12> i just mean a website where i put in server address, login p*** and login to a basic online mysql admin
<13> why not using phpMyAdmin ?
<12> sigh
<12> this is what i mean - http://forums.invisionpower.com/lofiversion/index.php/t198534.html
<14> hi everybody
<12> bye
<15> hello my bunnies
<16> hi.
<15> :D
<16> werd
<16> i'm walking out on the 28th
<16> going back to Phoenix, and back to school.
<15> please don't remind me.
<15> got 2 exams at uni tomorrow
<16> hah
<15> Quine McCluskey, Karnaugh, Hazards, error diagnosis, Adders (Parallel, Serial, Neumann), FlipFlops,...
<15> all crap like that >;/
<7> Digital Circuits. One of my favorite cl***es.
<16> Which cl*** is this for
<15> Xgc indeed >;/
<15> Directed Acyclic Graphs... Ordered Binary Decision Diagrams... burn !
<15> Registers... gahh
<7> Being an E.E. I liked those kinds of cl***es.
<15> i like them too
<15> but not when you got a lot of stuff to do besides them :D
<7> I'd stay up all night on those projects and love it.
<8> elecronic engineers tend to have electronics as a hobby too
<15> i wish i had a breadboard
<15> and more time
<15> i'd try to construct some adders :D
<8> who needs breadboard, a real rats nest is fun
<7> I remember breadboarding a multi-phased clock CPU out of SSI components. Lots of fun debugging that one. 1st time it was successfully completed. :)
<15> yeah wish i had more time
<15> now with this contract signed today, i'll be busy for at least 6 months
<15> time for bed
<14> hi everybody i am learning mysql and i was wondering if there are resources with scripts wich i could use to create a simple music database for testing
<8> search sourceforge
<14> sourceforge
<7> flixor-: CREATE DATABASE music;
<7> flixor-: There ya go.
<7> Pretty simple.
<17> i have a very dumb question... i want to select all the values in the email column of a table
<17> SELECT EMAIL from tablename ORDER BY EMAIL
<17> is that right?
<17> its only giving me the first row
<7> shale: Then you have only one row in the table.
<17> no
<7> shale: When you say "its", what do you mean exactly?
<7> shale: Did you try that query via MySQL command line client or MySQL Query Browser?
<7> shale: SELECT count(*) FROM EMAIL; Tell me what that returns.
<7> shale: or whatever the tablename is.
<7> shale: The answer to your first question is Yes. The query is fine. You don't need the ORDER BY clause, but that will not impact the number of rows in the result set.
<7> shale: If you think there are rows that were not returned, that can only be due to facts that you have not provided.
<17> when i say "its" i'm referring to a php script i'm working with.
<17> i do:
<17> $q="SELECT EMAIL FROM " . $table . " ORDER BY EMAIL";
<17> $tbl_members=mysql_query($q) or die (mysql_error());
<17> print count($tbl_members) . "<br>";
<17> and it prints "1"
<7> shale: Look at the query log to see what the final query looked like... or echo $q to the display and past the query here.
<7> s/past/paste
<7> shale: When you find the actual query, try it via MySQL Query Browser or command line client.
<17> when i echo $q it shows: SELECT EMAIL FROM members ORDER BY EMAIL
Return to
#mysql
or
Go to some related
logs:
#oe
#gentoo
threatcat
libsdl nvidia-glx
proxylist.php
etherape Gtk-WARNING **: cannot open display
ikey2000 linux
#php
cannot stat defconfig openembedded
wgr614v5 Connection reset by peer
|
|