| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> Darien:
<1> gnube: and the query itself, of course
<2> Darien, will do
<0> check this out
<3> archivist: every used an if and a group by
<0> ./bin/mysqladmin -u root -h localhost -p -S /tmp/mysql5.sock
<0> works
<0> BUT
<0> ./bin/mysqladmin -u root -h localhost -p -P 3307
<0> doesnt
<4> try 3306
<0> NO
<1> woo~
<0> mysql4 is on 3306
<0> thats what im trying to figure out
<0> 2 servers parallel
<1> ok well
<0> wich 2 phpmyadmin install
<0> :( sigh
<1> if one is giving you the problem and the other isn't, then you're connecting to two different servers
<0> Darien: hows that
<3> darien every used an if and a group by
<0> im very careful what i specify in connection string
<2> http://pastebin.ca/41078
<2> is where it is
<1> albo: ?
<2> SELECT manufacturer_pn FROM product_tags, cnet WHERE product_tags.product_id = cnet.manufacturer_pn;
<2> is the query
<1> ok
<1> a primary key will not help that query
<1> you need an index on product_id
<3> Darien: SELECT sum(if(eventtype='click',1,0)) as uh,sum(if(eventtype='view',1,0)) as uh,
<1> albo: ?
<3> Darien: SELECT sum(if(eventtype='click',1,0)) as clicks,sum(if(eventtype='view',1,0)) as views,
<2> Darien, I see, so I should create and Index on product_id, I ***ume there is some documentation on the MySQL site about that?
<5> NSERT INTO pub_poll_options (description) VALUES ('slogan 3');
<5> *INSERT
<3> Darien: SELECT sum(if(eventtype='click',1,0)) as clicks,sum(if(eventtype='view',1,0)) as views group by whatever.
<1> albo: quit pasting me **** for ****'s sakes
<1> I don't even know what the hell you're talking about
<4> !m gnube alter table
<6> gnube: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<2> thanks so much Darien and archivist
<5> nm that works fine
<2> gonna hang around a bit if I might in case I need some help, bit of a SQL noob.
<2> heh
<3> Darien: isnt there a statement like "analize" that i use to see how many rows were searched
<4> lurk and learn
<2> my motto :)
<2> (or it is now)
<1> gnube: SELECT c.manufacturer_pn FROM cnet c INNER JOIN product_tags p ON (p.product_id = c.manufacturer_pn)
<1> !m albo explain
<6> albo: (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<3> Darien: will explain pick up on subqueries
<1> !m albo explain
<6> albo: (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<3> Darien: apologize for your obscenties
<1> no
<7> how can i reduce how much ram mysql uses? like... it isnt used much, but it takes a lot of ram
<3> Darien: you asked me a question and i gave you an answer and you cursed instead of had a conversation
<1> albo: I didn't ask you to flood me with junk
<1> albo: you started saying stuff to me out of nowhere, I had no idea what you were talking about, and then you started pasting queries to me
<7> because ram usage was 56M without it, and 344M before
<1> albo: if you're going to harp on me for MY manners, you should learn some of your own first
<8> in a many-to-many join table, I have a_id and b_id, how do I draw out only a_ids where b_id = 'value1' AND 'value2' ?
<1> SkramX: you can reduce the size of the buffer pool, the myisam key cache, etc
<1> !man buffer pool
<3> Darien: i did not curse. i was looking for information in a gloriously peaceful manner.
<6> Nothing found.
<1> hmm
<7> Darien: where is this? my.cnd?
<7> *cnf
<1> albo: you were har***ing me in a rude manner
<1> SkramX: should be, yep
<7> key_buffer = 16M
<7> that?
<7> myisam_sort_buffer_size = 8M
<7> is that normal?
<1> it's not abnormal
<4> yes, making them smaller may/will slow mysql down
<7> well.
<3> Darien: im telling you now that i wasnt
<7> like there are a lot of ones that are 20M
<1> albo: you can either give up or I can ignore you
<7> what does it mean?
<1> albo: but you're not getting an apology
<7> like, everytime it queries, or does it have to do for each process
<1> oh
<3> Darien: my silence is not me giving up
<1> you mean in 'ps aux' or 'top' ?
<7> Darien: eh?
<1> albo: give up
<1> SkramX: 'a lot of ones' what? where?
<1> please be specific :)
<9> Which command can I use to show currently running queries on the command line?
<1> SHOW PROCESSLIST;
<7> the different buffer fields in my.cnf, SQL
<7> * Darien
<1> ok
<9> Beautiful; thanks
<3> Darien: that means nothing to me. my silence on the matter which i will accept does not mean ive given up. it seem you want to make an absolute out of the situation
<1> there, peace and quiet
<4> albo your talking nonsense
<1> SkramX: there are lot of entries in your my.cnf that are set to 20M?
<7> yes.
<9> !m processlist
<6> Incorrect usage. See 'help m'
<9> !m Julian|Work processlist
<6> Julian|Work: (SHOW Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW.html
<1> !man processlist
<6> (SHOW Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW.html
<1> como eso
<7> key_buffer, sort_buffer_size, etc.
<7> Darien: ^^
<1> ^^
<7> ?
<1> SkramX: so how much ram is MySQL taking?
<7> about 250!
<1> how do you know?
<7> ill set them to 10 and then restart mysql
<7> i stopped it, did a ram reading, and restarted
<1> SkramX: ps aux | grep mysql
<7> mysql 7088 0.0 1.2 80036 25604 ? S 23:58 0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
<7> root 7426 0.0 0.0 1476 488 pts/12 S+ 23:58 0:00 grep mysql
<7> root 7024 0.0 0.0 2336 1040 ? Ss 23:58 0:00 /bin/sh /usr/bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf
<7> multiple ones like 7088 though.. i ***ume they are just forks.
<1> no, they're threads
<7> thats what I meant sorry.
<1> but you have an old kernel
<7> uhmm..
<1> anyway, your MySQL is only using 25 megs of memory
<7> 2.6.X
<1> yeh, an old 2.6.x
<7> hrmm
<7> well
<7> one sec
<1> newer ones show it as one process
<1> not that it matters
<1> also, please pastebin for anything more than two lines
<7> 10002 58 1.1G 337.6M 12m15s66 0m16s58 23h10m27 smiller01-vs2-01
<7> 10002 41 342.1M 56.6M 12m22s67 0m16s57 23h10m38 smiller01-vs2-01
<7> before...after
<1> ?
<7> 337.6M => 56.6M
<1> what's that from?
<7> they are virtual servers
<4> Skramx is it a single user system or a multiuser server
<7> two
<7> dual xeon's
Return to
#mysql
or
Go to some related
logs:
gentoo default console font
tcfmgr: config file `tcfmgr.map' (usually in $TEXMFMAIN/texconfig) not found
#php
firefox yast
what is libwx
#javascript
how to use wildcards in php
#python
where is snddevices
debian unresolved symbol crc32_le_Ra34f1ef5
|
|