| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
<SpComb> hauum
<Veratien> Can someone please help me?
<tradergt> there are no therapists here
<Veratien> tradergt: I hope you die in a plane crash.
<Juzzy> anyone know if the MYSQL C api object's "reconnect" attribute is reliable enough on its own to use as just a global variabl in a daemon?
<Juzzy> or do I need to wrap it in a while
<tradergt> I would be with your mama
<qru> Is there a way to do a USE INDEX (foo) in an UPDATE (sry for the repeat, thought there might be different eyes here now)?
<arjenAU> Veratien: the errorlog *will* tell. and being rude at people certainly won't.
<tradergt> !m qru update
<SQL> qru: (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<Veratien> arjenAU: I'm ***uming you mean mysqld.log, no? Because there aren't any other mysql logs that I can find. And I have looked. Oooooooh have I looked... *sits in the corner snarling at terminal* So no, the logs don't tell.
<solemnwarning> if i compile mysql server with ./configure --prefix=/
<solemnwarning> where is my.cnf stored?
<tradergt> /etc
<solemnwarning> k
<tradergt> should be anyway
<tradergt> however, i dont think mysql comes with a default my.cnf
<solemnwarning> also, this is my first time building mysql, whats the best place to put it out of /, /usr and /usr/local?
<qru> tradergt: I've read that 1000 times. I must be thick today, but I can't find the answer.
<solemnwarning> anyone?
<tradergt> solemnwarning: its all preference
<keyhack> How can I perform a query in MySQL Query Browser that will allow me to create a temporary table, and then select some data by joining multiple tables with that temporary table? The Script Editor doesn't display any results from the SELECT
<qru> According to the dock, you can use any type of JOIN statements with update. USE is suppose to be a type of JOIN. But I get a syntax error no matter what I do.
<solemnwarning> also, when i install mysql does it also put an init script in /etc/init.d?
<keyhack> Anyone?
<inviso> keyhack: iirc, query browser connects for each query so your temp table won't persist.
<tradergt> solemnwarning: no
<keyhack> inviso: It only handles one query at a time
<keyhack> inviso: The query tab won't let you insert two queries, thats why I went to the Script tab, which doesnt do output. This is redic, lol
<inviso> right. And it closes and reconnects for each query.. Temp tables only last per connection.. I think you're out of luck
<tradergt> keyhack: why are you using query browser?
<keyhack> because thats the application I have at the time, I'll have to look for something else
<inviso> use the command line client.
<tradergt> just do select * from (select whatever)
<inviso> or what tradergt said :) Might be able to do your two queries as a single query
<tradergt> that how you get by without temp tables
<keyhack> I
<keyhack> I'll just look for a better program
<tradergt> my god
<keyhack> look, its not my query
<keyhack> I need a program to look at the results
<inviso> use the cli then
<tradergt> no, of course now, your to smart for us
<keyhack> i don't care if there is another method to achieve the results
<tradergt> now
<solemnwarning> where can i get an init script for mysql5.0 or do i need to write one myself?
<tradergt> solemnwarning: google is your friend
<flupps|UK> solemnwarning: share/mysql.server
<qru> I'd _really_ appreciate it if someone could just tell me if the USE INDEX syntax (or similar) is possible with an UPDATE. I am getting really tired of banging my head against the wall on this.
<rikkus> hi
<flupps|UK> qru: got a pastebin or something?
<qru> flupps|UK: Sure, hold on.
<rikkus> I have mysql running on a headless box which I ssh into, and I'd like to allow access directly to it for a GUI utility on my desktop machine. I think this requires adding a row to the user table on the mysql database. Is there an easy way to do this, e.g. with one of the command line utils, or do I need to construct some SQL?
<flupps|UK> rikkus: www.mysql.com/grant
<rikkus> thanks
<qru> http://pastebin.com/409096
<flupps|UK> qru: that looks weird
<rikkus> flupps|UK: ah, 'grant', thanks a lot!
<rikkus> works now
<flupps|UK> rikkus: =)
<flupps|UK> qru: which version is this?
<rikkus> out of interest, does anyone have a recommendation for a GUI client for MySQL on Windows? I've found SQLyog so far, but there seem to be many.
<flupps|UK> rikkus: really depends what you're used to, many tools, some behave like you "think", those'll be the best... there's no best one, really
<scoates> hello.
<rikkus> ok, thanks, was just wondering if there was one which everyone used
<qru> flupps|UK: 3.23 (don't ask)
<scoates> is this syntax correct? http://phpfi.com/84458
<scoates> and can someone please test it on a non-production server? It crashes 5.0.15 on Windows.
<flupps|UK> qru: hmm
<qru> flupps|UK: The problem is my mysql DB is the backend to IDS data. On the front end the analyst needs to be able to update the status of events.
<flupps|UK> qru: how far off is the 10 row estimate?
<qru> Sometimes the update will affect a single row. Some times it can be thousands of rows.
<qru> 10 row esitimate?
<flupps|UK> scoates: sure
<qru> Oh, sid and cid is the primary key. SO there are two true matches.
<flupps|UK> scoates: that gives me a syntax error
<qru> in reality I am running something like: UPDATE eventSET status=1, last_modified='2005-10-28 16:49:23', last_uid='2' WHERE sid=5 AND cid IN (4093073,4093074);
<scoates> flupps|UK: hmm.. linux?
<scoates> I'm trying from the CLI, now..
<qru> But that takes 30 secs to run.
<scoates> but using SQLYog crashes the MySQL service
<scoates> (using this from SQLYog)
<qru> I am not sure why it's trying to use the sid_time INDEX. It should use the primary key.
<flupps|UK> scoates: either linux/bsd
<flupps|UK> or win
<flupps|UK> qru: the optimizer did have a few bugs on composite indexes in 3.23
<scoates> hmm.. works from the CLI (with an appropriate DELIMITER)
<scoates> ... client shouldn't be able to crash server, though......
<qru> If I change the select to use event_p_key, then the SELECT goes from 30 secs to less then 1 sec.
<flupps|UK> scoates: can you enable the general log and see if you can catch what SQLYog sends to the server?
<qru> flupps|UK: I ran the explain on a test 4.1 DB and got the same results.
<flupps|UK> qru: in 4.1 you could rewrite it to a subquery I guess
<flupps|UK> and force the index in the select part of it
<qru> flupps|UK: Hrm. Sounds like I may need to hack something else together or lose the sid_time index.
<scoates> flupps|UK: sure.. maybe not right now, but I'll try to do it over the weekend..
<flupps|UK> scoates: I don't have SQLYog installed, so can't test
<scoates> would the mdmp and appcompat.txt files help anyone?
<scoates> (I guess these are like core dumps?)
<arjenAU> Veratien: depends on what os/distro you're on, often it's a .err file but sometimes indeed mysqld.log. I think SuSE Linux uses mysqld.log
<scoates> arjenAU: hi. (-:
<arjenAU> hi scoates . I'm not really here, weekend. normally, yes ;-) I prefer freenode.
<scoates> arjenAU: I haven't forgotten about you... I will email. (-:
<scoates> flupps|UK: which directive do you want me to add (to enable the log)?
<Veratien> arjenAU: I cheated in the end. I couldn't find out where /tmp/mysql.sock was being set, so I sym-linked it to the real socket...
<flupps|UK> scoates: just "log" (without the double quotes) in the my.ini file should do it
<flupps|UK> under the [mysqld] section
<Veratien> arjenAU: I hate it when things like this happen with no reason.
<flupps|UK> have to restart the server for it to take effect (****s, I know)
<scoates> yeah.. I figured as much..
<scoates> flupps|UK: here's the entire log: http://phpfi.com/84459
<flupps|UK> scoates: did it work in the command line client?
<scoates> yep.
<flupps|UK> hmm, weird
<scoates> http://phpfi.com/84461
<scoates> the only difference is the user..
<scoates> nope.. firestarter@ from the CLI works fine.
<scoates> very odd.
<scoates> server crashing client is bad, but acceptable.. client crashing server -- not so much.
<flupps|UK> for sure
<flupps|UK> guess could run SQLyog over tcp ip and tcpdump
<flupps|UK> if the part that actually crashes the server doesn't make it over
<arjenAU> Veratien: yea configuring the server or the apps to use the same socket location would be harder ;-)
<arjenAU> Veratien: it, btw, also means that it never did work to begin with. it didn't work first and fail then, since mysql server doesn't magically move its sockets to annoy you ;-)
<inviso> but it's almost halloween? I had a whole server get up and walk off earlier today
<Veratien> arjenAU: Well, it did work though, which is why I'm really... really confused...
<_Terr1> How Do I include a TEXT datatype into a unique key? I get the following error #1170 - BLOB/TEXT column 'DESCRIPTION' used in key specification without a key length TEXT(XXXX) dosent do the trick?
<Veratien> arjenAU: I haven't reconfigured it, and there aren't any other people with shell access to the level that they would be able to around at the moment...
<Jax> ERROR 1145 (42000) at line 1: The host or user argument to GRANT is too long
<Jax> BURNNNN
<Jax> wtf is that ?!
<Veratien> hehehe
<Veratien> MySQL says NO
<inviso> _Terr1: I don't think you can.
<Veratien> jax: I think it's limited to 32 characters? (don't quote me on that, though)
<Jax> yeah i will shred somebody's brains
<Jax> Therion ?!
<Jax> *wrath*
<Veratien> jax: So you can't have 'mark'@'llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch.co.uk' :p
<ZiNoX> is there any possible way to get around FK in MYSQL using MYISAM?
<inviso> ZiNoX: enforce it in your application
<ZiNoX> is it scheduled by MySQL?
<inviso> eh?
<ZiNoX> is it on the schedule of MySQL to support FK in MyISAM?
<_Terr1> inviso, ok 8(
<inviso> Different engines for different purposes... use InnoDB
<Therion> Jax: Yes?
<ZiNoX> then what's the use of MyISAM, when can i consider MyISAM a good substitute to InnoDB
<inviso> _Terr1: that's an awful lot of data to not be unique.. Perhaps you can pick part of it out into a varchar and unique index that? Sounds like you need to normalize a little bit more.
Return to mysql
or
Go to some related
logs:
windows2003
alarmyst
|
|