| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> if there a #phpmyadmin?
<1> Then go to #phpmyadmin and/or read the docs
<0> oh cool
<2> firewire, yes but none inside
<1> s2bu
<1> Then you shouldn't use it.
<2> oooh very kind of you
<0> who would hang in #phpmyadmin?
<2> thank you very much for your help
<1> NO PROBLEMO
<0> will_ homo
<1> Dude, you scared him off.
<0> good
<0> **** him
<1> Do I have to?
<1> Oh haha
<0> you should get out more
<1> NO SUKKA
<3> 213876.5 inserts/s
<3> <3 MyISAM
<1> Does it include data generation??????
<3> it's a apache log import, so doesn't generate
<3> but it does transform
<3> seem to only get ~60k/s on 5.1, though, hmm
<0> what kind of hardware?
<1> Pentium II
<3> my desktop :)
<0> I should benchmark a new netapp before it gets put into production
<0> flupps: load data infile?
<3> Dual Opteron, 4G memory, 15krpm SCSI Raid1
<3> yea
<0> nice
<3> on 32-bit windows OS, though
<0> I have a pair of dual core opterons on netapps waiting to be put into production
<0> I've never really benchmarked on though
<0> *one
<3> I'm playing with the idea of getting 2x Dual core CPUs for that motherboard
<3> since it does support it
<3> but it's a bit expensive
<1> You make all the money though.
<1> You can afford it.
<0> I'm looking at a single dual core
<3> yes, we're all about the money here.
<0> marten spends a fortune on his tan
<3> I met a girl named Tan on the last flight to US
<0> nice
<1> lepine: I got 1824
<0> the last girl I met on a flight gave me a very wild eyed crazy look as we were picking up our bags so I never called her
<1> inserts per second
<3> one of those weird situations
<1> lepine: P4 3Ghz HT/ 1GB / Linux
<1> RH FC4 :)
<1> Pretty sure 30 is too low.
<1> But who ever said it was MySQL that is the bottlenecK?????
<3> I think will_ is the bottleneck
<1> Most likely.
<1> Should I buy a 150GB 10k SATA drive and 1GB of RAM, or another 20.1" Widescreen LCD?
<3> get the apple 23"
<1> Na. I want another Dell
<1> They have to match!
<3> metero***uality in the computer department, huh
<1> It looks really cool if they do!
<4> where might i beable to find a little telnet daemon that will interface with mysql server?
<1> You don't need a telnet daemon.
<0> 29041/sec
<1> liar!
<1> LDI?
<1> jrthegoob: What do you need/want?
<0> into my own badly optimized storage engine
<1> I'm going to sleep
<1> NITEY
<0> 2381375 rows
<4> will then i need odbc?
<0> what are you talking about
<0> a telnet daemon to interface with mysql how?
<3> firewire: what kind of engine/
<0> flupps: I'm messing around with disk based chained hash tables
<0> for tables that don't do range scans like bridging tables
<3> nice
<4> firewire: well heh more like this...
<4> i have a little 8bit micocontroller connected to an ethernet chip... i want to be able to simple sql queries but putting an odbc library on the 8bit would be impossible
<4> if i could connect using an ansi terminal and do text commands over tcp/ip to communicate with the db it would be awesome...
<4> i presume i could telnet into a unix pc and use the mysql client but it would be nicer if there was just a direct interface
<0> jrthegoob if you can't put the mysql client library on it then you could write a little daemon that would listen for queries and reutrn results
<0> you could even use http
<4> firewire: http is kind of messy..
<4> all that text that it dumps is intense for the 8 bit
<0> what text?
<0> it's just a few lines of headers
<4> when you connect to a http server
<4> i would need a bunch of php wouldnt i
<0> not really
<0> if your 8bit sent a post with a query the http server could return the result as csv or xml
<0> it could be butt simple to parse
<4> hmm.. ya maybe a very simple xml. but SIMPLE is key
<0> you could even use csv
<4> is csv a simple protocol?
<0> comma separated values
<4> oh absolutely.
<4> you mean have the http server return csv?
<0> have the http server return cvs as the 'body'
<4> firewire: is this something i could do with apache or would i need to hack up my own client
<4> my unix sockets is hurting.. so im trying to stay away from any unix programming
<4> i mean hack up my own server
<0> you can't use tcp from the 8bit?
<0> how do you exepect to communicate?
<4> no ican
<4> of course i can
<0> 8bit -> tcp -> apache -> some quick php to execute the query and format the results in csv -> tcp -> 8bit
<4> oh ok nice..
<5> or you could use perl instead of apache + php and avoid having to run an entire web server
<5> or C++ for that matter :P
<4> that beats 8bit -> tcp/telnet -> login -> sqlclient login -> query -> parse ..
<4> andrewbryson: how would i use perl without a webserver to communicate with the 8bit
<4> the only c that is going here is on the 8bit
<5> perl has many well developed libraries for dealing with tcp etc
<5> as does c++
<0> jrthegoob: he's saying have perl listen for connections and run the sql intead of apache
<5> yup
<4> ya but we got going here is insanely simple
<5> lol so is just using perl or c++
<0> apache would be less coding because it's probably already installed on his system
<4> andrewbryson: no then im writing another parser
<5> ah okie
<0> all he has to do it write a little php to execute the queries
<0> but yeah that's also a good idea
<5> fair enough
<4> exactly.. much better
<4> parsing on this 8bit is going to be interesting
<0> jrthegoob: it should be little more than setting pointers to the beginning of strings and replacing commas with '\0'
<4> thats ***uming that a single response fits into memory nicely
<5> well you can set the mtu on the packets to something that fits in memory
<4> it needs to ignore the <body> and then interpret the data coming in
<0> jrthegoob: there will be no <body> unless you have php output one
<0> <body> is not part of http :)
<4> oh nice.. thats where html picks up
<4> so i can have it just dump a csv
<0> http is \n delimited headers with \n\n denoting the end of the headers and the start of the 'body'
<4> firewire: where can i get a copy of the http protocol
<4> the specs.. just google it
<4> ?
<0> yahoo it :)
<0> basic http is.. well.. really basic
<4> the project is pretty cool
<0> if you decide to respect headers it gets more complicated
<4> weve got an 8bit connected to an ethernet chip with a tcp stack on it.
<4> ive got a webserver running that allows users to login in and set some preferences
<6> hey
Return to
#mysql
or
Go to some related
logs:
#linux
ubunto repair totem
realvnc aterm
fedora similar dotdeb.org
#php
#gaim
#math
emerge wlassistant
#php
#php
|
|