| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> Hi
<0> Hi, what is the best way for calcul the Centreal time Or EST if I have the time in gmt?
<1> what format is your time in?
<1> JFDionne: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
<2> I'm doing a full text search match() against()... how do I make sure to only return rows where the rank is > 0?
<1> where are you putting the MATCH AGAINST in the first place? the SELECT or the WHERE?
<2> the select
<1> so put it in the where?
<2> oh ok
<2> if I do that - how do I sort by the rank?
<0> Jivedue Hi, right now I'm having a timestamp in est time, but I'm trying to convert it to something else... but I'm having some problem, because in est time sometime is -4 and soemtime is -5...
<3> ORDER BY
<2> yeah but you can't do that unless it's in the select
<1> dampjam: so put it in both places
<4> www.mysql.com: deadhead, isn't a db!
<2> if I put it in both, will it be trying to run it twice
<2> or is it smart enough not to
<4> dbms != db
<1> JFDionne: so subtract one hour?
<5> recomendation of good reference manual of mysql online??
<4> that's enough?
<1> madadamas: http://dev.mysql.com/doc/ ?
<0> Jivedue yes, I know about Est time.. but I'm trying to "convert" time for each people coming to my site, and they can be from europe or anything like that.. and i'm not sure about if they are using the Daylight Savings time
<5> Jivedue, thanks buddy.
<1> JFDionne: So don't. I'm not a good person to talk to about time, because I tried to think about how to deal with DST etc. and I decided it's not worth it
<6> JFDionne: that wouldn't be the job of the database, normally
<1> JFDionne: There are states in the US that don't do DST while the rest do, the whole time thing is a mess
<0> Jivedue thank :)
<0> Duesentrieb I know, but I tried with php and with no luck :) so I try with mysql :)
<6> Jivedue, JFDionne: one very good lib for dealing with this is OlsonDB. Works excellent.
<6> But its perl only (or C too?)
<0> thank I';; try
<1> JFDionne: what I do is just store all times as the unix_timestamp in GMT, whatever the computer gives me... that's about it. and if someone wants it in a different timezone, just subtract/add the appropriate number of hours
<6> Jivedue, JFDionne: play around with http://area23.brightbyte.de/mercury/mercury.php?mode=world_time
<1> Duesentrieb: omg, haha. The whole thing imho is just a nightmare
<6> Jivedue: it is. and OlsonDB deals with it.
<6> it's really a db for what timezone applies where when
<6> even knows about changes to dst policy, etc... very nice.
<1> wow
<1> http://search.cpan.org/~drolsky/DateTime-TimeZone-0.42/lib/DateTime/TimeZone/OlsonDB.pm ?
<1> unfortunately no docs? haha
<6> hehe - it's been a while since I wrote that...
<6> like, more than three years
<6> i figured it out somehow back then :)
<1> Deusentrieb: maybe now would be a good time to follow up w/ it, so I don't have to just figure it out? ;)
<6> err.... no.
<1> Deusentrieb: "..This stuff is a mess."
<6> well, there's a link to my source code at the bottom
<6> but... that stuff is a MESS :)
<0> :) thank
<1> okay, so that's just a module to pull info from an 'OlsonDB'
<1> so all I need is to get the db (and make sure it's current) from somewhere, then I can interpret it myself?
<6> you proabaly want to use their code. no telling how that "DB" looks internally
<6> it's not SQL or anything. Bunch of minary files, iirc
<6> binary
<7> you can't run a full text search on two tables am i correct?
<1> you could union the results, haha
<8> anyone know what information I should look at in SHOW INNODB STATUS to determine if innodb_logfile_size is sufficent or overkill?
<8> Maybe log i/o's per second but I think that telling of weither or not innodb_log_buffer_size is ok.
<9> Is anyone familiar with the unixODBC error: "[unixODBC][Driver Manager]Invalid string or buffer length" ?
<9> It seems to be an unresolved problem....
<10> Hello, what is wrong in this syntax: SELECT * FROM customers WHERE customerID IN (1,2,3); ?
<8> candyProgrammer: nothing.
<11> hi how can i manage mysql via network ?
<10> hmm
<11> i mean to add authorized ip
<11> on the server
<8> !m HeliosTech GRANT
<12> HeliosTech: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<10> But i get an error on this : SELECT * WHERE QuizId IN (1,2)
<10> doh
<10> sorry
<10> i know
<8> I've got a customer with ib_logfiles that sum up to 3GB of space. I want to trim these down so that they're not dead in the water for 20min when a crash happens.
<8> I don't want to trim them so far I loose performance.
<11> TodoInTX i don't really see how can i do that ?
<11> adding a users that in hosts field contains the ip adress of my client ?
<11> my root also is in localhost
<11> how i can authorize both acces via localhost and 1 ip adress ?
<13> !man grant
<12> (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<8> create a 2nd user with GRANT .... on ... to user@'other ip'
<11> ok thx
<14> dang
<14> someone mentioned a good query browser to me the other day (other than the mysql one)
<14> but I can't remember what is is now --- some sourceforge project with one of those 3 or 4 letter acronyms
<15> Hello, I have a query which works under MySQL 5, but does not work under mysql 4. I get an error saying "invalid use of group function". Could someone look at the query and tell me what should I fix? http://pastebin.bafserv.com/3380
<15> ?
<16> hello channel
<17> #1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
<17> any ideas (thats from phpmyadmin
<18> Andy298: http://dev.mysql.com/doc/refman/5.0/en/old-client.html
<17> so i need to update PHP?
<15> Andy: no, you need to set your p***word to be old style
<17> dont that and same error :S
<17> ah sorted it
<19> What happens when a MySQL INT (auto-incrementing primary key) reaches its end?
<19> Will it flip over?
<19> I know for a fact that there won't be any old entries.
<19> Why can't SELECT DISTINCT foobar, * just work?
<17> The mbstring PHP extension was not found and you seem to be using a multibyte charset. Without the mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
<17> any idea on a resolve?
<20> compile in ext/mbstring
<17> im on doze
<20> and do not forget to enable it in php.ini
<19> Fine... just ignore my questions and answer his script-specific one.
<17> its enabled in php.ini
<20> Andy298: check phpinfo();
<19> What happens when a MySQL INT (auto-incrementing primary key) reaches its end? Will it flip over? I know for a fact that there won't be any old entries.
<20> it will not flip over
<21> you get an error and the table stops accepting rows
<20> and it will not reuse deleted id
<19> Damn.
<20> so you will get a duplicate key error
<21> yup
<19> How do you solve this, then?
<21> alter the table
<22> KimmoA: make your int column a bigint column
<20> make your INT a BIGINT
<22> and make it unsigned if you haven't yet done so
<19> What if the BIGINT reaches its end?
<21> KimmoA: it won't
<21> I dare you to fill up a bigint
<19> Must do sometime...
<21> try it
<19> Just in theory...
<19> It feels bad to have a system which CAN break in the distant future.
<21> it won't break in your lifetime
<21> or even a thousand lifetimes
<20> KimmoA: myisam also handles multi column autoincrement columns
<19> Hrm...
<20> but a bigint is big
<19> Will there be performance issues when the primary key reaches very high numbers?
<20> 8 bytes stores alot
<23> Ive got a problem, i have a php script that was dumped on me that generates a 30 line mysql query, and it doesnt work on 3.23
<24> If you fill the bigint you use a two part key with two bigints and set the first for the epoch of the second, by hand.
<23> The line that it has problems with is UNION ALL
<22> Menthol: 3.23 doesn't support UNION, stop using 3.23. now.
<21> KimmoA: no
<19> I see.
<20> "UNION is available from MySQL 4.0.0 on."
<22> there could be performance issues with a bigint primary key compared to a regular int since bigint is twice as big, but if you plan to have more than *4 billion* rows, then it's worthwhile
<21> 18446744073709551615 even at a million rows per second is 18446744073 seconds which is 584 years
<13> I plan living that long
<19> Well... I just constantly add **** to this table, and then a timed program deletes old entries regularly.
<23> i cant change my version of sql, my host is closed and this projects deadline is tonight
<19> That's why it will be large.
<21> KimmoA: a million rows per second?
<19> Hehe...
<19> Nah.
Return to
#mysql
or
Go to some related
logs:
ubuntu uncompress sit files
pkg_cutleaves gentoo
#perl
No route to host vmware server console
#linuxhelp
yukiyu portage
#debian
#oe
#linux
+beagle +cpu time +fedora
|
|