| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> semget(IPC_PRIVATE, 4096, IPC_CREAT|0x4c3570e0|0240) = -1 ENOSYS (Function not implemented) ?
<1> semget?
<1> are you using BDB or something?
<0> skip-bdb in my.cnf
<0> should I be looking for something else?
<2> which function I use for multiple 2 field's value?
<3> field1 * field2?
<2> shabbs: yep
<3> no, that's what you use
<3> select field1 * field2
<4> I'm trying to start mysql /etc/rc.d/init.d/mysql start and it's giving me an error, however, when i do: 'su mysql' and then do 'mysqld' it's listening for connections
<1> scoates: try ipcs and ipcrm
<2> ohhh ok tnx
<2> :-)
<1> maybe some BDB support is not happy
<0> there are no mysql-owned semaphores, there
<1> anyway, time to upgrade to 4.0
<1> delete all anyway ;-)
<0> would they be owned by my httpd?
<0> heh
<0> yes, I will upgrade to 4.0, but it can't happen right now.
<5> Darien_: will you read http://wiki.roomfullofmirrors.com/wiki/Ticket_schema and see if it helps you understand my problem any better? i'm not so sure a LEFT JOIN is going to get it. or i am just not understanding how to write the query
<0> server load floats between 7 and 30 because of missing MySQL
<6> I have a database I have to interface with which is designed very badly. In it I have user.memberOfGroups which is a blob of a comma seperated list of group ids that the user belongs to. Then I have post.readRight which contains a comma seperated list of groups that can read the post... Without redesigning the database (which can't be done as its from a crappy supplier I have no control over) or jumping out into php and doing loops how can I c
<1> scoates: turn off httpd
<0> I guess
<0> (-:
<1> running with gdb and breakpointing on 'semget' might give you a clue which code fails
<1> if you don't use bdb, you can maybe turn it off
<1> mysql doesn't use semaphores anywhere else
<7> jsumners: you want to find all tickets which have more than one row in the second table? or more than two rows?
<1> or shared memory
<5> Darien_: _only_ two rows
<0> well, skip-bdb is in my my.cnf
<0> so it shouldn't be using it..
<7> jsumners: ok
<5> every ticket will have at least 2
<8> anyone know the name and location of the default log file on windows servers?
<0> I'm going to reboot this server; back in a few mins
<1> scoates: then check how mysqld is ran, and run it under gdb :)
<7> jsumners: SELECT ticket_number COUNT(t2.action) FROM table1 t1 INNER JOIN table2 t2 USING (ticket_number) GROUP BY ticket_number
<8> never mind
<7> jsumners: that should give you a list of all the ticket numbers, and how many entries for each are in the second table
<7> jsumners: does it?
<5> give me a moment
<9> boo on the manual!
<7> boo
<10> boo the search in the manual
<9> it's unclear on the on duplicate key update ..
<9> If you specify ON DUPLICATE KEY UPDATE (added in MySQL 4.1.0),
<11> what's unclear?
<9> that on duplicate_key_update is 4.1.0+ only..
<9> well no it's not unclear
<9> but..
<7> but you didn't read well enough :p
<9> there should be an easy way to say function x works in 4.0,4.1,9.0
<7> there is
<9> it's in the 3.23,4.0,4.1 manual..
<12> LIES
<5> Darien_: yes, that did perform the count
<7> one example way would be to say, in the manual, what version it was added in
<7> jsumners: great, now you just need to filter out which entries !have two rows
<9> so i automatically ***umed if it says it's in there it works on 3.23, 4.0 and 4.1
<8> I'm trying to figure out why our mysql 5.0 installation is taking a long time to do simple backend queries. Anyone know of any way to track what the problems might be >
<9> LIARS!
<7> alphablue: and you know what ***uming does
<7> alphablue: it makes an *** out of u and ming
<7> poor ming :(
<9> ming is a whore
<7> he's a better man than you'll ever be
<9> the only ming's i've ever known were women...
<12> Ming is Merciless
<7> you mean you paid them to be women
<9> no, like i said Ming is a whore.. i don't need to pay em
<7> maybe you're unclear on the whole whore/slut dichotomy, but that's kind of the defining trait of a whore
<9> hmm and we can't use replace into...
<7> you could upgrade
<9> i thought prostitute was the one i paid
<9> no we can't. well.. not by july 1st
<5> Darien_: it would be great if there were a way to do it in SQL in MySQL 4.1.7 (does it support subqueries?) but it might be easisest for me to write a php script. good insight on counting the actions by they way. i wasn't thinking of that at all
<13> anyone have any pointers on how to reduce tmp_tables ?
<14> hello
<9> we don't have the time to do regression tests
<14> can i have more settings like bind-address in /etc/my.cnf
<14> ??
<11> no
<14> i mean bind-address=first-ip
<9> for an upgrade of software, while we're changing functionality and adding functionality
<14> bind-address=secondip
<11> tribunal - from yesterday?
<14> this is not good then
<9> he said no
<11> run explain on the queries
<11> index as needed
<13> sjrussel: I switched from myisam to innodb yesterday. it seems to help a lot
<13> sjrussel: right now I'm trying to figure out ways to lower the amount of tmp_tables made
<11> really? great
<11> it was locking problem then?
<13> sjrussel: ya
<9> that was a lot of fun
<15> how could I form a query where I want to select stuff from one table and use the 2 things I select as where clauses in the main query? like I want to do everything in one query
<9> upgrade to mysql 9.0 that has the everythinginonequery function
<9> Pro edition
<5> oh sweet. 4.1 does support sub-queries. i will look into that after lunch. thanks again Darien_
<7> jsumners: I suppose you could use a subquery, but it might well not be fantastically fast
<11> find the # 1 offender query, add indexes, rinse repeat until either (no temp tables) or (index overhead is too high)
<11> why do people always try to write everything in one query?
<5> it will be something new to learn :)
<13> sjrussel: hehe ok
<15> couldnt I use a subquery to do this?
<7> jsumners: SELECT ticket_number FROM (SELECT ticket_number COUNT(t2.action) as tcount FROM table1 t1 INNER JOIN table2 t2 USING (ticket_number) GROUP BY ticket_number) WHERE tcount=2
<5> sjrussel: i don't have write access to the database so creating a temporary table to do what i need isn't going to work
<7> jsumners: I dunno if that's an optimised solution thouguh
<5> looks good
<11> then store the data in your app layer
<11> app people never let the db do enough, db people never let the app do enough...
<11> subqueries can be good, just make sure you're not executing 10 bajillion queries per 'line' of sql
<11> (in some cases, subqueries are executed many, many times)
<16> rar
<16> (SELECT 1 AS n) UNION (SELECT 2 AS n) ORDER BY n DESC LIMIT 1;
<16> ^^ if I want a tuple n,m returned where n is whatever's determined by that, and m is fixed, what do I add?
<16> I've been slaving helplessly for a while :(
<16> ((on less of a toy example))
<11> bungly - that doesn't work, because constants don't mutate IIRC
<16> really?
<16> I mean fixed like SELECT 'foo' as m and joined with the result from what I spammed
<11> in a Union?
<11> fyi, I don't think the ORDER does what you thing
<11> IIRC, it applies to the last select, not hte result set. but I could be way off base
<16> nm about that, it's a toy
<16> oh
<16> hm
<16> wouldn't a union make 'foo' try to go into my wee 'n' column?
<17> "joined with the result"?
<0> reboot didn't help; but upgrade to 4.0 did
<0> so, I still have no idea what it was, but I have a working MySQLd now
<17> Upgrading to an old release?
<0> hopefully I didn't break many apps
<0> domas: thnks very much
<0> thanks, even
<4> I upgraded to mysql 5. I now get: http://forums.babetemplates.com/ error. Is there a way to fix this?
<18> Juggernaut_: do not mix join styles. use ibf_forums f JOIN ibf_categories c ON f.somethign = c.something LEFT JOIN ibf_moderators m ........
<16> will[werk]/sjrussel: I'd like | n | m | / | 2 | 'foo' |
<4> inviso: So, it's the software itself? It's Invision Power Board..
<18> Juggernaut_: Seems pretty likely :)
<9> babetemplates.com work safe ?
<9> wait.. i work from home..
<18> that link is
Return to
#mysql
or
Go to some related
logs:
#gentoo
#physics
#openzaurus
#fedora
reiserfs md0 warning sh-2006
#gaim
#gimp
mysql left join empty rows
#bash
php exec bash script
|
|