| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
<l008com> yeah i thought i was joining the tables but i don't join these values so this is actually something i need to do in php not mysql
<l008com> nevermind
<l008com> greater than or equal to
<l008com> >=
<l008com> or =>
<archivist_> 1982
<kuku5> I need mad help with my query
<l008com> word dawg?
<kuku5> :)
<kuku5> http://pastebin.com/399546
<kuku5> 70 sec to process this.
<kuku5> 3 tables.
<kuku5> Trying to do a aging report
<lokus> kuku5: no index for the join, so cartesian product
<l008com> i am having a ***** of a time focusing on my code tonight
<kuku5> duh!
<kuku5> which fields index - the ones that I join ?
<kuku5> b/c those a primary indexes
<will_> lokus: It's not a cartesian product. He has join conditions.
<kuku5> wow
<lokus> ok, but will need to almost inspect all rows, wrong term then
<will_> Full table scan
<kuku5> o ****
<will_> Time to sleep!
<will_> !fooP
<lokus> not exactly full table scan too, since the tables have to be scan once for each row from prwevious table
<kuku5> http://pastebin.com/399551
<kuku5> went from 70 sec to 0.8 :)
<strib> babar thinks celeste is bianca -- http://pastebin.com/398959 <-- anyone help diagnose?
<lokus> kuku5: can be even better actually
<kuku5> to 0.05 sec
<kuku5> how better ? :)
<lokus> kuku5 add an index (date_due,person_id)
<kuku5> nah
<kuku5> that didnt do it
<lokus> strib: do an ifconfig in celeste
<lokus> strib: what is the ip? 218 ?
<Ronan> can anyone here script mIRC?
<p_mash> Ronan: this channel is for mysql database.
<Ronan> yeah, I know. But it's worth a shot.
<Ronan> There isn't a scripting channel :/
<p_mash> check the room list .. u might find something !
<Ronan> I did, well. most of it, it's pretty big y'know.
<SpComb> ROOM?
<Ronan> 2766 channels are a little hard to scan through mind you.
<SpComb> #help.scripting on quakenet is pretty official, I think
<Ronan> Whole different server?
<Ronan> If I must, thank you.
<strib> lokus: http://pastebin.com/399566
<strib> i.e. celeste is 129.234.4.250, just like we expect
<lokus> strib: weird, how come the reverse dns map it to bianca
<strib> lokus: How do you mean? Which line of pastebin?
<lokus> the error from mysql -h babar
<strib> Yes, that seems to be the only thing that thinks it celeste is bianca.
<strib> #10 shows that nslookup for celeste's IP returns celeste, on babar.
<lokus> strib: can you try nslookup 129.234.4.250 on babar ?
<strib> lokus: host does that; see line 10. But yes, if you wish
<strib> 250.4.234.129.in-addr.arpa name = celeste.dur.ac.uk.
<lokus> strib: this is weird
<strib> I've tried a reboot of celeste (pointless, since I'm pretty sure the problem is on babar) and a mysql stop/start on babar.
<strib> I've FLUSH HOSTS'd on babar.
<syle2> how do you compare characters
<lokus> strib: problem why mysql treat celeste as bianca
<strib> bianca is in the grant tables.
<lokus> strib: not that
<lokus> strib: are you able to do a telnet to babar from celeste
<strib> Sure.
<lokus> strib: then check from babar, using ps , you should be able to get where the telnet session comes from
<strib> Oct 20 09:14:11 babar sshd[20574]: Accepted p***word for root from 129.234.4.250 port 58541 ssh2
<lokus> it is correct 250
<strib> <nod> :|
<lokus> then must be the reverse dns issue
<lokus> but the it seems to map 250 to celeste correctly too
<strib> If this had happened yesterday, I'd have been able to take down the servers to diagnose it.
<strib> But it happened the moment babar and celeste went into production :((
<strib> lokus: http://bugs.mysql.com/bug.php?id=13659
<lokus> but that is in show processlist, maybe you can try to restart the mysqld server
<lokus> strib: or there is a sql command to flush host or something
<strib> lokus: yes, there's FLUSH HOSTS;
<strib> But it didn't help me.
<strib> lokus: it appears in SHOW PROCESSLIST too: maybe their permissions allowed an arbitrary host to connect for replication.
<strib> ..so they only noticed when they did SHOW PROCESSLIST;
<lokus> strib: then the host in show processlist is correct or not
<strib> not
<lokus> strib: alternative you have now is to add another user for the host bianca
<strib> Yeah, I did that last night. But bianca is one of our web servers so I really don't like that.
<lokus> strib: try IP address
<strib> Apparently the grant by IP is only tried if it couldn't resolve.. at least, that's what someone else on #mysql said.
<lokus> strib: then remove bianca and celeste, it should try to match the IP
<lokus> strib: from the grant table
<strib> I can't; I have to let the web server contact my databases :)
<lokus> i mean the user slave which you have problem connecting
<strib> Oh, I see. I could s/bianca/her-ip/
<lokus> not all user
<strib> I'll try that.
<strib> Oh, and thanks :)
<sidewalk> what does the following mean:
<sidewalk> Fatal error: Call to undefined function mysql_connect() in
<V***co> hi
<p_mash> sidewalk: means that the php_mysql.dll extension is not enables in php.ini
<V***co> PHP error ?
<sidewalk> okey, how do i enable it?
<cosminb> anyone knows how to grant a mysql user the privileges to create views (CREATE VIEW command)?
<V***co> edit php.ini file
<p_mash> uncomment in the php.ini file ie take the ; away
<sidewalk> its a windows-machine
<cosminb> this is what i get when trying to create a view:
<cosminb> CREATE VIEW command denied to user 'logan'@'localhost' for table 'google_idxs_cnt'
<V***co> cosminb : connect to mysql with root and edit mysql.user table
<cosminb> V***co: i connected as root and used grant show view, create view to...
<cosminb> shouldn't this suffice?
<cosminb> also did a flush privileges
<p_mash> sidewalk: uncomment php_mysql.dll in the c;?winnt/php.ini file
<sidewalk> then reboot?
<p_mash> sidewalk: and restart apache
<V***co> cosminb : u should try the same script using root and no p*** to see if it works ... of it does it's a priv problem
<cosminb> ok, let me see...
<sidewalk> what if that file doesnt exist?
<V***co> sidewalk : it has to exist ....
<sidewalk> nokey
<p_mash> sidewalk: is it php5 ?
<V***co> sidewalk : it's the php config file ... php wouldn't run without
<p_mash> sidewalk: is there a bunh of *.dll files in the ext/ directory ?
<sidewalk> i mean php_mysql.dll
<cosminb> hmm, just looked ad the mysql.user table, and it shows me i don't have the create_priv set to 'Y'... nevertheless, i can create tables, why is this?
<lokus> cosminb the priv is on multiple level, user store global level
<V***co> cosminb : r u on phpMyAdmin or something like that or logged root ?
<lokus> cosminb: show grants for current_user();
<cosminb> root, on the mysql console
<lokus> cosminb: will give you the priv of the conencted user
<cosminb> ok
<cosminb> 1sec
<V***co> anyone ever hab problems using users and p*** after installing mysql ?
<cosminb> lokus: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
<cosminb> this is all I have
<lokus> cosminb: on what? *.*
<cosminb> no, on logan.*, user is logan
<lokus> cosminb: it means in the database logan only
<lokus> cosminb: all tables in logan db
<cosminb> yes
<lokus> cosminb: you want to allow logan to create view?
<V***co> cosminb : tables in logan db
<cosminb> so shouldn't this allow me to create a view into logan database?
<V***co> lokus : 2 fast :)
<cosminb> yes
<cosminb> :)
<cosminb> i want to create view
Return to mysql
or
Go to some related
logs:
tangx skullcrusher
"get e17""
|
|