| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<inviso_> 9 million isn't really that large
<OneFix_Work> inviso: why? It seems to take too long to access the data as a large table
<inviso_> Then index it properly.
<xerxes1358> _Pavlik_, what is load data do ? I did SOURCE sqlfile.sql;
<OneFix_Work> inviso: Umh, I have
<archivist> mod_cure The general rule is to never ***ign a value to a user variable in one part of a statement and use the same variable in some other part the same statement. You might get the results you expect, but this is not guaranteed.
<_Pavlik_> xerxes1358: what need you? load many strings to table?
<mod_cure> archivist, one = two, two = one <-- trying to do that
<xerxes1358> _Pavlik_, I have 2 large files (500mb each) with pieces of text from webblogs
<mod_cure> want to switch values
<inviso_> OneFix_Work: Then check your key_buffer_size to make sure you can cache a decent portion of the index
<OneFix_Work> The primary key would be the filename...
<xerxes1358> _Pavlik_, I want to load them as fast as possible in a datab***
<xerxes1358> database
<EnderOL> is it possible to do math with mysql on some things selected within the same statement and with AS put as a certain name?
<_Pavlik_> xerxes1358: read here http://dev.mysql.com/doc/refman/5.0/en/load-data.html
<OneFix_Work> inviso: The MyISAM database would be the best for this, right?
<_Pavlik_> xerxes1358: it's the fastest method. much faster than many INSERTs
<inviso_> OneFix_Work: It's what I tend to use. With that said, InnoDB can outperform MyISAM in some cases especially under very heavy read/write load
<OneFix_Work> inviso: key_buffer_size is set to 8388600...my whole database is ~160MB
<krusaf> hello
<krusaf> i try to execute a mysqldump from an other computer from my server and i got this : mysqldump: Got error: 2003: Can't connect to MySQL server on 'zeus' (111) when trying to connect
<krusaf> i configure the server for a connection from this host and i always have the same error
<inviso_> OneFix_Work: That's 8MB.... Take a look at the MYI file to get an idea how large the index actually is
<EnderOL> in mysql can i do math with the results of other calculations?
<inviso_> EnderOL: my guess would be yes. select 1+2; select some_col*42 from some_table; Those are valid. Not sure what you're after though
<inviso_> krusaf: check for bind-address in /etc/my.cnf
<OneFix_Work> inviso: Sh, I should be able to set it signifigantly higher without causing problems...right?
<EnderOL> i'm after select 1+3 blaat, 7+9 foo, foo+blaat bar
<inviso_> OneFix_Work: You're using default settings it appears. Tuning a number of the server variables may be very helpful if you have the ram
<inviso_> EnderOL: nope
<krusaf> ok inviso
<EnderOL> so i would do the same maths again for that?
<EnderOL> select 1+3 blaat, 7+9 foo, 1+3+7+9 bar?
<OneFix_Work> inviso: Yea, I have 2G on this system
<inviso_> EnderOL: yeah. That's the way the SQL spec works :(
<EnderOL> ****teh
<inviso_> OneFix_Work: go to town then. Bump thread_cache_size to 8. Bump up your buffers and your query_cache/key_buffer. See the following doc for a list of the variables
<inviso_> !m OneFix_Work server system variables
<SQL> OneFix_Work: (Server System Variables) : http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
<inviso_> !m OneFix_Work tunin
<SQL> OneFix_Work: (System Factors and Startup Parameter Tuning) : http://dev.mysql.com/doc/mysql/en/System.html
<inviso_> psh
<inviso_> !m OneFix_Work tuning
<SQL> OneFix_Work: (Tuning Server Parameters) : http://dev.mysql.com/doc/mysql/en/Server_parameters.html
<EnderOL> that's gonne be one ****ing big query
<krusaf> thanks inviso it's alrigth ^^
<inviso_> krusaf: eh? You get it working?
<archivist> !weather egnx
<SQL> Current conditions at East Midlands, United Kingdom: It is 2 C (37 F), windspeed is 33.80 km/h, and visibility is 11.27 km. (Information current as of 2006.02.27 2150 UTC).
<archivist> hmph doesnt mention the rain!
<krusaf> inviso yes i have comment the bind-address in my.cnf and it works fine :)
<inviso_> EnderOL: people pay money to watch that kind of stuff..
<inviso_> krusaf: excellent
<krusaf> :D
<dogmeat> trying an insert ... select, but getting errors. how can i fix it? thanks http://hashmysql.org/paste/viewentry.php?id=1496
<EnderOL> meh it's probably nothing compared with some company databases and stuff, but for my php website stuff it's freaking long :)
<OneFix_Work> inviso: Yea, I already set that :) I just used the 256M one
<mod_cure> archivist, update expects a column name after set
<mod_cure> this will work ->
<mod_cure> UPDATE table SET col_1=(@var:=col_1), col_1=col_2, col_2=@var;
<FenixRF> greetings.
<FenixRF> can I do regex in a query?
<FenixRF> instead of using replace
<FenixRF> basically, I want the query to remove all non alpha-numeric characters from a field
<EricCartman-iBoo> this is weird
<EricCartman-iBoo> I've imported some data intop mysql server, there's probably something wrong with the encodings
<EricCartman-iBoo> whenever I do a select * in the table, mysql query shows different values for the same rows
<EricCartman-iBoo> it some times display null
<EricCartman-iBoo> somtimes some garbage
<inviso_> FenixRF: nope
<FenixRF> bummer
<inviso_> yup
<FenixRF> inviso,
<FenixRF> I've got a question
<Killaz> I'm trying to delete a db, but I cant!!
<Killaz> DROP db_name
<FenixRF> in my php, I'm using preg_replace to replace all non alpha-numeric after I use strlower...
<Killaz> doesnt work
<inviso_> !m Killaz drop database
<SQL> Killaz: (DROP DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/DROP_DATABASE.html
<FenixRF> you think the query would be successful if I used something like SOUNDEX(LOWER(REPLACE(Field, ' ', ''))) = SOUNDEX("<preg_replace result>") ?
<roue> hi folks.
<inviso_> FenixRF: no idea. I haven't used soundex much
<FenixRF> I'll try it
<roue> if I delete a huge chunk of data from a table I know there's a command to use to reclaim that disk space but it escapes me at the moment. anyone know off the top of their head? flush or something ...
<inviso_> !m roue optimize
<SQL> roue: (OPTIMIZE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html
<roue> ahh. thank you. that's exactly what I was looking for.
<inviso_> np, enjoy
<roue> brain not working 100% today.
<FenixRF> inviso, yep... works... even though they're slightly different, they're still similar enough to work
<Killaz> inviso: cant make it work.. I get ERROR 1064
<Killaz> Im such a noob
<inviso_> paste the full error
<Trevelyan> can mysql use a raw block device for a db? or does it need an fs?
<Killaz> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'webcalendar' at line 1
<sjrussel> I think InnodDB can
<inviso_> Killaz: and full query please
<Killaz> inviso: DROP webcalendar
<inviso_> Killaz: that's what you were trying before. Please clicky that link I gave you earlier and look carefully
<inviso_> Killaz: Note that values like {DATABASE | SCHEMA} are required. You need one or the other. So, DROP DATABASE db_name.
<inviso_> [IF EXISTS] is an optional value (denoted by the brackets)
<Killaz> *blush*
<Killaz> om my god
<Killaz> think it's time to go to bed
<Killaz> inviso: thnx... sorry for disturbing you with such a stupid mistake
<inviso_> Killaz: np, it happens
<Leithal> ALL THE TIME
<Leithal> For instance, this guy made a very stupid mistake: http://news.bbc.co.uk/2/hi/africa/4748292.stm
<alphablue> nice
<inviso_> hey archivist
<inviso_> err, arjenAU even :)
<arjenAU> Leithal: perhaps they're very happy... who knows. some human wives bleat also, so he may not even see a diff
<Leithal> hey arjen :)
<arjenAU> beeeeh
<Leithal> lol
<arjenAU> like, someone should start giving Bush bananas every time he behaves like a monkey. I'll happily volunteer a stash of my virtual bananas.
<arjenAU> inviso_: so, will you coming to the UC ?
<inviso_> arjenAU: No way for me to justify it :( I'm about to become an oracle lacky anyway
<alphablue> a real db
<arjenAU> haha
<inviso_> s/real/expensive/
<archivist> real slow
<inviso_> kibab: dude... Not nice.
<kibab> inviso_: I was trying to help you learn... by osmosis ;)
<arjenAU> inviso_: as a MySQL DBA, you could work for Google, Yahoo, CNET... like today. great demand. I'll happily put you in touch with someone.
<arjenAU> there's increased degrees of coolness to being a MySQL DBA ;-)
<arjenAU> inviso_: anyway as you know many companies use oracle and mysql side by side. we'll even have some UC items on that. for developers AND DBAs.
<mhillyer> And an even higher degree of coolness to being MySQL certified!
<arjenAU> Leithal knows...
<Leithal> :D
<inviso_> arjenAU: that sounds really nice. I'm committed to my current job for a while though. We're in the middle of a large implementation and I simply won't jump ship.
<alphablue> netsol uses mysql and oracle. for some reason our DW is Oracle still, but everything I work on is mysql
<inviso_> arjenAU: and no way the uni will fund a trip for me to the UC :(
<lsmith> i think i will try to get part one of the developer exam done in march
<alphablue> most people don't know, but the WHOIS db is mysql
<lsmith> and part two done in april
<arjenAU> alphablue: that's fine. don't even try to migrate the rest. that's not the point.
<arjenAU> alphablue: now I know ;-) of course, ppl try to pretend netsol doesn't exist these days
<alphablue> arjen: we're not migrating, i'm just adding to your comment, that many people co-exist peacefully
<arjenAU> lsmith: ye you can sign up for the betas now
Return to
#mysql
or
Go to some related
logs:
resize compiz slow
vectorlinux kdetv
#sdl
pypy shedskin
OLE Error-0x80020009
thundercity font
sendmail.cf dbmail
#php
install a version of cedega
#asm
|
|
