| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> /etc
<1> Then you restart the server and it is enabled.
<1> /etc/my.cnf
<2> ah
<2> that doesnt have a skip-innodb at all
<2> http://pastebin.com/652151
<1> Interesting, how is the server started?
<2> no idea
<2> probably service mysql start
<3> it could have been compiled w/out any innodb support
<1> sjrussel: But that usually results in a NO for have_innodb.
<4> hoppeznemide
<4> in explain, the type "ALL" is bad?
<3> yes
<4> i has 2 all and 1 eq_ref
<3> unless you exect it
<1> inono: It could be that the script starting mysql is p***ing a --skip-innodb to the call to the mysql server.
<3> you probably need to index on the join condition
<4> i has it
<4> i think...
<4> i check again
<5> hey guys
<4> hey blanky
<5> I just want to make sure, an address (domain name, whatever, i.e. mysql.blah.com ) can't start with a number right?
<5> so you can't have 3sd.3hing.com
<5> just wondering so I could eliminate that type of checking in my program
<4> is it better-> worst list in this site:http://dev.mysql.com/doc/refman/5.0/en/explain.html
<4> the type
<4> so
<4> system
<4> const
<4> eq_ref
<4> ref
<6> Stop it
<4> ok :)
<4> so is it the better -> worst list?
<5> so...anyone?
<7> might anyone know of any patches for mysql to use something like PostgreSQL's cidr type?
<3> yes
<4> blanky_: what field type you use?
<4> i guess use varchar (255)
<5> MetaMorfoziS, I mean like, not having to do with sql, can a domain name start with a number
<5> becuase I have a variable (in C)
<8> Hiya I have a table with 3 columns, (name char, date date, hours integer). Now i wanna get the hours from each date... is it possible?
<5> a string, that one can p*** as "mysql.site.com" or "127.0.0.1", so either an ip address or a name
<3> http://1and1.com
<5> oh, duh, okay thanks sir
<7> I would like to do something like: select count(ip) from db where ip = '1.2.3.4/16'
<4> oh
<9> Could someone give me an example of command to connect to a distant mysql server's database (I can access it by the web, using phpmyadmin, but i'd like to access it using bash command line, if it's possible)... and without using ssh
<4> i miss translated
<4> yes
<4> ^^
<10> gilianima, -h host
<11> Godsey: if you store the IP as a 32 bit int, not as a string, that would be possible using bitfield operators.
<7> Duesentrieb: and what of ipv6? :)
<12> gilianima: mysql --host=serveraddress
<12> gilianima: What Julian and I suggested are synonymous. :P
<7> I understand what you mean, but it seems like a bit too much work. I'm pretty much lazy.
<11> Godsey: 64 bit
<11> or was it 128?
<11> whatever
<7> 128 I believe.
<11> ip-adresses can bit bit-masked
<7> you mean doing something like count(ip) where ip && 255?
<7> or 16384? something like that?
<11> you need a "= x" at the end
<11> but yes
<11> for strings, you can use like
<11> but only in 8 bit steps
<11> if that'S good enough for you...
<4> where i can know what fields i need to be index?
<9> Julian|Work, Elazar: thanks...
<4> or what field with what field together i need to index?
<7> I'll check, I think the application end is "dumb"
<11> Godsey: WHERE ip LIKE "1.2.3.%" would work for /24
<11> but it's slow
<7> Duesentrieb: I should have given a better example:
<11> (the bitfield thing would probably be slow, too)
<11> (but not that slow)
<7> select ( ... /24) as cnt24, ( ... /18) as cnt18, ( ... /16 ) as cnt16
<7> Duesentrieb: I have about 32 million rows right now.
<11> you'll need separate queries for that
<11> if you want it fast, make a separate column for each byte
<13> why do you have that may ip's logged
<11> index by (ip1, ip2, ip3, ip4)
<11> that can be queried and counted efficiently
<7> Duesentrieb: do you know if doing that and then making a view will still utilize the indexes?
<11> it should
<11> there are issues with indexes in views
<11> but generally, it should.
<7> I3ooI3oo__werk: I didn't say select distinct count(ip) :)
<11> i suggeste *one* composite index above, btw, not four
<13> OIC
<13> lol
<7> Duesentrieb: I'll see if I can use a stored proc to split the ip up.
<10> I've seen the IP split into four columns in a few apps.
<7> or maybe a trigger, that would let me emulate the cidr type
<10> That seems to be the accepted way if you're querying against parts of it.
<7> I could check /16 and /24 easily that way
<14> hey people, got a problem running mysql 4.0 on ubuntu, if I try to connect from this machine I get a error saying to run mysqladmin flush-hosts, do that and everything runs fine, after a little bit of time it will do it again. Nothing should be connecting from this machine besides the mysql administrator
<7> not sure how I'd do /18.. maybe leave it out :)
<14> Godsey: missed what you are talking about, looks like netmasks , whats the problem?
<7> if(input3 >= 128, where db3 >=128, where db3 < 128)
<15> evening ;)
<4> what does it mean
<4> in explain
<7> Jenocin: just brainstorming how to match ips in a db efficiently.
<4> the table column
<4> derived2
<4> derved4
<4> derved3
<4> derived4-
<14> Godsey: what are you trying to do?
<4> hm?
<7> I'm doing it with cidr in pgsql, but I would like to move over to mysql cluster.
<14> Godsey: ah ok
<16> Godsey: I've got a couple of database that track IPs, and just using 32bit ints and bitmasks works quite well
<7> Jenocin: the big picture is a smtp reputation db.
<14> Godsey: what about removing parsing the ip into 4 fields
<17> hey :) what can I use to graph mysql usage? I was planning to do a script to run a "show processlist" each minute and fill that data in rrdtool, but I want to see if I can get some averages, etc
<11> fsweetser: filtering by bitmask does not use an index, though, right? I suggested to split it up into separate columns and use a composite index.
<14> Godsey: meant parsing into 4 fields
<7> Jenocin: yes, Duesentrieb provided me with that idea
<11> hehe, ok
<14> Godsey: ok sorry , just jumping in
<16> if the ip field is index, I *think* the index should be used
<16> let me double check, actually...
<7> fsweetser: do you convert to int in application or use mysql to do it?
<11> fsweetser: how would the index be used on WHERE ip && 0xFFFFFF00 = 1234567?
<16> mostly mysql, with the inet_ntoa/inet_aton functions
<14> what am I looking for to find out why I keep having to mysqladmin flush-hosts?
<18> mysql doesn't have function based indexes yet. As such, neither inet_aton and ip && 0xFFFFFF00 would use an index
<7> fsweetser: thanks for those functions, I wasn't even aware of them.
<16> just double checked, and (at least on 4.1) it looks like it doesn't use bitmasks
<16> even so, I have a table with 26 million records, and it's quite fast
<16> let me check on 5.0...
<7> darn inet_aton isn't cidr aware :P
<7> was really hoping for where ip between INET_ATON('204.17.223.145/32') and INET_ATON('204.17.223.145/16') :)
<7> it will use indexes if I do it that way..
<16> if you already know the masks, can't you juse leave the host parts at 0?
<16> between INET_ATON('204.17.223.145') and INET_ATON('204.17.0.0')
<7> no, I have 3 boundries I like to check /16 /18 /24
<7> /18 is a bit tricker
<7> trickiet
<16> gotcha
<16> even so, I would personally generate the int on the application side and leave the IP as a simple int
<7> I'm reading about using bitmasks.
Return to
#mysql
or
Go to some related
logs:
ubuntu apt backup folder
#web
#physics
install slackware lvm2
linux from scratch sshd re-exec requires
gentoo ivman sata disk
#lisp
#perl
stumbleuppon
+mysql 5 +fc3 +yum
|
|