| |
| |
| |
|
Page: 1 2
Comments:
<0> Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using p***word: NO)
<0> Could not connect to the database
<0> that is error
<1> Eldritch: just got back
<2> thanks, but fixed it all by my self
<1> congratulations :)
<2> not mysql, but security (sort of) issue $invoice = 'HP'.dechex(crc32(md5(uniqid(microtime(), true)))); my hopefully always unique invoice
<1> hehenot sure why you crc32 after md5-ing
<2> i needed to bring down the string length
<1> fair enough
<2> i dont whan to have an invoice number take up half the page :-)
<1> from a security perspective you are better off by using two different numbers
<3> Anyone... str_to_date('Fri, 10 Feb 2006 11:21:00 GMT', get_format(date, 'usa')); --- returns NULL ---- what am I doing wrong? Trying to obtain the timestamp
<1> customer number / invoice id
<4> according to top I have 11 mysqld processes running each with 25 megs resident memory. I have no actual content in my database yet. Why would mysql be consumming so much resources?
<4> is mysqld just mallocing 25 megs at start up for no reason?
<1> 7341 mysql 16 0 276m 84m 7912 S 0.0 8.5 1:42.91 mysqld
<4> was that an actual statment?
<1> that is with 87 threads
<1> 84 / 87 = 0.965517241
<1> MB / thread
<4> I don't even have any database content yet. Why is mysql consuming so much resources?
<1> you probably configured it wrongly
<1> what OS? what compile flags?
<4> linux
<1> linux is a kernel, not an OS, the OS would be GNU/Linux. but continue.
<1> which distribution?
<1> was it a binary package?
<4> A little early in the conversation to be getting political don't you think?
<1> ?
<4> I'
<4> I'll call linux a kernel only if and when Herd is released.
<4> at anyrate. How do I trim down resource consumption.
<4> ?
<1> suit yourself, rtfm
<4> suit myself what? I don't recall saying anything.
<4> distribution=gentoo
<4> is there a URL for TFM on mysql?
<5> Hello
<5> is there an easy way to select all fields but 1, sort of a subtractive * ?
<1> no
<5> :/
<1> nor would that be a wise thing to do
<5> why not wise?
<5> ...or you mean "not wise to have such capability"
<1> not wise to have such a capability and not wise to use it even if it existed
<1> and the clue is if you change the schema
<1> suddenly you add a LONGTEXT field that you didn't plan on some years ago
<1> bandwidth between the mysql server and the client increase by some gigabytes a day
<1> slows down the whole thing
<1> instead of just specifying the fields you actually use
<5> ah yes, I understand for a client-side query how that would indeed be a bad thing.
<5> at least now I know. Thanks :)
<1> You're welcome.
<5> have a great weekend.
<6> hello
<6> anyone can help me ?
<6> hello
<7> helo
<7> i am having problems with phpmyadmin
<8> go over to the boss's place to fix their vpn... end up down at bribie island for seafood dinner
<9> mud crabs?
<9> "morton bay bugs"
<10> hy, i have a problem with a simple subquery, is it allowed to paste an URL here ? to show the code ?
<11> my goal: build a select statement that merges a date field and a time field into a single datetime field useful for comparisons
<1> cast,concat,rtfm
<1> http://www.kfwebs.net/links/6 for SQL
<11> you mean i can litterally concat. these things as strings?
<11> jeez i've searched incredibly too far
<11> makes my day happy
<12> K_F, do you know of any program that will show me the number of bytes a certain ip has downloaded from a server?
<1> historically or from now on?
<12> from now one
<12> realtime against the kernel preferably
<12> or stack..
<1> mrtg / ntop
<12> mrtg?
<12> i mean, i wanna see whos downloading most from me
<12> and sort it accordingly to that .. to filter out possible abuse and such
<12> people running wget or scripts to eat my bw etc
<1> http://people.ee.ethz.ch/~oetiker/webtools/mrtg/index.en.html
<1> http://www.ntop.org/
<1> I use the latter
<12> yeah well i use mrtg
<1> and a simple log analyser will help in your case
<12> but i want per client ip .. not total
<12> hmm those figures aint correct
<12> in the logfiles.
<12> ntop seems nice though
<12> thanks
<1> hmm, gf and I broke it off today
<12> aww
<12> sorry to hear that
<1> nah, it was about time for it
<1> still, we were together for two years, living together the last..
<1> that said, she still has the student housing she lived in before
<1> so spent most of the day moving her stuff over there
<1> mostly clothes..
<12> hmm .. ok
<1> guess we've both seen it coming for some time
<1> still **** when it actually happend though
<12> heh, sounds like a civilized break though
<1> matter of definition, pizza and vodka for me tonight
<1> one of the good things when I own everything here in the first place, apartment, furniture, ...
<12> heh
<12> ntop is really cool
<12> thanks for the tip
<1> you're welcome
<1> I usually have an ssh -L 4000:localhost:3000 -N host&
<12> ah
<12> i just opened a port on the box for that ;)
<12> to my ip
<1> bad,bad
<1> :)
<12> ive got static here anyway
<12> why? ;)
<1> well, do you use the SSL-enabled one at least?
<12> no?
<1> plaintext => bad
<12> ehheh
<12> yeah
<12> well i know..
<12> i dont mind, im not going to admin it
<12> just watch the stats
<1> ntop support SSL antively if you use -w
<12> yup, noticied
<1> but I just tunnel it
<12> ofc i could use ssl.. hmm
<12> ok, changed to ssl. happy now? :)
<12> i really need to get ssl for a couple of other sites aswell
<12> i just got so put off with ssl after implementing it with qpopper
<12> and eudora
<1> I prefer courier-imap-ssl and courier-pop3d-ssl
<1> actually don't use SSL for my SMTP
<1> of course it has TLS
<12> mhh
<1> SSL negotiate the encryption before connection
<12> im tempted to just bring up a vpn with all my boxes
<1> TLS negotiate afterwards
<12> heh
<1> hopefully you get TLS for HTTP soon as well
<1> with SSL it isn't possible to use SSL on shared hosting
<12> yeah i know
<12> heh
<12> or well
<12> it's possible
Return to
#mysql
or
Go to some related
logs:
ioctl: LOOP_SET_STATUS: Invalid argument ubuntu
#AllNiteCafe
Moter Baick
#php
#linux
#linux
#MissKitten
#AllNiteCafe
#mirc
#linux
|
|