| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> great, I'll have try
<1> well g'luck with it
<2> is it good idea to compile php with +msql -mssql +mysql +mysqli +odbc ( gentoo) ?
<3> I have set mysql to run under the user "mysql". However it seems to start 2 processes, one running under the name I specified and one running under root
<3> is this normal?
<4> skogsmaskin: Actually, you don't want that specific query, ***uming you want a distinct list of ids.
<0> No, not that query direct, but something like it.
<4> skogsmaskin: You might be better off with: SELECT id FROM table1 GROUP BY id HAVING count(*)>1;
<0> The thing is I have a unique `id` for each record. And there are the fields `uid` and `user`.
<4> skogsmaskin: Replace id with whatever field you wish.
<0> I want to select the `id`s where `uid` is the same twice (or more) for each `user`
<5> hey -- i have a tmp table (MEMORY storage engine) -- that I want to flush periodically... is there a witty way to run a query once it hits a particular size?
<6> skogsmaskin: one command
<7> hey all - i have a table w about 2 million records, and have reports that use them, and for each record, joins on serveral tables out from the large table to gett all of the report data. everything that's indexable is index, but performance is still too f*ed up. any ideas?
<6> polvi: you can make temp tables.
<6> polvi: built into mysql, no need to create your own
<8> hmm... I'm writing an application that will be using prep statements and innodb tables. it's a call detail recorder for a phone switch, so it could theoretically be handling hundreds of calls at any given point in time. the record doesn't get handled until the call is hungup, so it wouldn't be all at once for processing. the logging will go into an apr threadsafe queue. you guys think there'd be any problem with running thru the whole queue f
<7> polvi: cron job is my first thought. SimAtWork - he's using tmp tables already.
<9> n00b question... can i select WHERE ID= '0','1',5-9?
<9> and how would i do that?
<8> it is possible that new items may continue filling into the queue before it depletes for the commit.
<7> bashusr: where id in (1, 2, 3)
<10> where do you set mysql memory limit
<9> lorfds: in the my.ini file
<8> bah, where's Therion when you need him?
<10> where is that stored usually?
<8> lorfds: depends. perhaps search for the file?
<11> lorfds do you really want to do that
<5> shift8: yeah, it grows at about 5000 rows a sec... so i need to do it rather frequently
<10> is it a bad idea?
<10> archivist -- things are running slow, so i thought that might help
<6> bashusr: where id=0 or id =1 or (id >5 and <9)
<11> that may slow it more
<10> why?
<11> less cache
<11> query buffer etc
<10> ok -- well i dont know that much about this stuff -- what is best way to speed it up
<12> how would i do this? if a row matching some conditions exists, change one of the fields, if one does not, create one
<11> give it more memory
<10> haha
<10> i see.....
<11> or check your sql statements
<11> use explain
<10> what will that do?
<13> howdy
<13> whats the best way to update mysql5.0 to mysql 5.1?
<11> show you whats not using indexes
<8> Baz_: you like to play with fire?
<9> SimAtWork: that's a lot of or statements.... shift8's solution seems more clean
<9> thanks shift8
<13> u dont recommend it?
<6> bashusr: you're quite correct
<9> Baz_: there's a howto in docs.mysql.com or something like that
<9> there is a guide there Baz_
<6> i've never seen "in" before
<6> shift8: where can i find documentation onit?
<9> SimAtWork: it makes sense...
<11> !man in
<14> (Comparison Functions and Operators) : http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
<13> its not a simple procedure? should i just avoid it? i'm not doing it for any particular reason, just dont want any security issues
<9> put the things in an array
<9> Baz_: there is no security issues
<9> Baz_: mysql 5.0.x will take care of security issues
<9> you don't need to upgrade major versions...
<9> only the minor ones to keep up with security fixes.
<13> they should prolly have an auto update windows style feature dont u think?
<9> HAHA. no Baz_
<13> hehe, oh no, or atleast an easy way to do it
<9> many "new" features may break certain implementations of certain code
<9> that's why some places don't ever upgrade....
<9> has sourceforge upgraded to 4 yet? Last i checked... they were still using 3
<13> ahh, what if there's a vulnerability that needs to be patched - how do they handle that?
<8> that's why sf ****s heh
<15> that's because their sysadmins are cowardly and badly trained
<15> and/or their development is a mess
<8> Baz_: how about finding a vunerability that needs to be fixed before trying to update for no good reason.
<16> or not trained at all
<15> you need to be quite well organized to make upgrades safe
<15> stuff like testing and daily builds helps
<13> just saying lets say something big is discovered tommoro
<8> Baz_: 5.0 -> 5.1 is not the same type of update as 5.0.1 to 5.0.2 is.
<8> Baz_: then you'd go to docs.mysql.com and read WHAT you should upgrade to.
<8> 5.1 is alpha or beta right now no?
<13> sounds fair
<13> i don't know much, but i know i love you
<8> Baz_: bigger numbers does not always mean better.
<13> thats not what my girlfriend says
<8> uhm, unless you're a hot ***y teenage girl, don't love me. heh.
<9> mishehu: read the topic...
<9> mishehu: 5.1.7-Beta
<8> bashusr: yeah, the point remains the same though...
<15> SOL?
<8> he thought 5.1 was automatically better
<8> which it will be once it's got the kinks worked out.
<9> for me...
<9> i'm happy with mysql3 (i think)
<17> how many characters does a longtext allow for in sql 3.23?
<13> i did think that, i am silly
<9> i don't do any crazy left, right,center,middle joins or anything like that!
<8> bashusr: nah, I would never write a program for 3.
<18> My internet died earlier.
<15> eeeeek! I was on 3.22 until quite recently
<8> I didn't do any mysql work until 4.1 came out.
<19> When I was talking about how MySQL doesn't accept a root account with no p***word.
<15> then I managed to upgrade to a 5.0... except our version of Perl DBI is so old it doesn't support transactions :-(
<9> mishehu: what "new" features do you actually use? i don't think i use any of their new features.
<8> bashusr: I heavily use prepared statements.
<13> one more noob question: i tried running this command and it told me to check my syntax: RENAME DATABASE djsamples_dbo TO djsamples;
<19> And I was going to ask if there's any way I can trick MySQL, and give myself no p***word for root, or find out what the p***word is.
<17> bashusr, there have been a few times i want triggers
<13> i'm trying to rename a DB
<8> bashusr: i've not yet updated to 5.0.x, but I do want to work wtih views and triggers.
<8> sooner or later I'll get to it.
<20> Baz_: that is a 5.1.7+ feature
<17> so longtext how many chars?
<13> oh... so there's noway to rename a DB then right?
<20> upgrade to 5.1.7 .. then you can use that statement
<21> can anyone help with a federated storage engine question? Does the remote database have to be MySQL 5.x or can it be 4.1?
<20> otherwise you need to do some file system hackery
<13> can i duplicate a db to a new schema name?
<20> followed by some grant table cleaning
<13> ooof
<13> i dont think i'm comfortable enuf for that
<20> dunno .. maybe mysql administrator has some nice tool for that
<8> barry: I'd imagine that it'd have to be also 5.0.x or better, but it's just an educated guess on my behalf.
<21> mishehu: thanks.. I'm using 4.1 as the remote database server and I get an error saying table testdb.1 doesn't exist.. where testdb is the database on the federated master machine (5.0.x)
<5> wow, tmp tables are fast... im doing ~30,000 inserts/s
<19> Is there a way to find out what my MySQL server's root p***word is? O_o?
<22> ask the dba?
<19> I'm the dba. :( I installed it on my local machine.
<19> But it came with a package of apache, php, mysql, and a few other things
<22> and forgot it, eh? =)
<22> !man reset root p***word
<14> (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<19> No, there's just no manual for it
<19> And they set the p***word to something else
<19> OH GOT fsweetser THANK YOU /caps :D
<22> no prob =)
<23> dreamweaver is refusing to detect my MMHTTPDB.php located at /home/large/devcore/public_html/_mmServerScripts/MMHTTPDB.php, the URL-prefix is set to
<23> http://82.157.27.106/~devcore/ . anything wrong about these settings? any special URL-prefix secrets i donnu about?
<16> ?
<16> can *you* access the file?
<23> yes
<16> then I would ***ume the settings in Dreamweaver are wrong
<23> do you see anything worng?
<16> other than you asking for Dreamweaver help in a database support channel? no
<16> maybe try a more relevant channel
<23> dreamweaver is asking for a myswl related file
<24> hehe
<23> *mysql
Return to
#mysql
or
Go to some related
logs:
netflix previews problem
ubuntu urar
subtitle size mplayer
#kde
downthemall hammer server
+gentoo +lib6464
tomp script 4.0
rug upgrade kernel
#ubuntu
redhat reconfigure X11
|
|