| |
| |
| |
|
Page: 1 2 3
Comments:
<0> thank you, this is exactly what i've been looking for :-)
<1> the "Another SQL tut" link on your site gives a "file not found" k_f
<2> thank you, removed
<1> n.p.. "1st key data's SQL section" gives connection failed.. might be temporary
<3> that one works for me
<1> ok =) seems like it was temporary then
<2> wfm
<2> beebum: the maximum connection yesterday was 185 concurrent connections to MySQL
<3> wow
<3> i'm about to get blasted
<3> http://abclocal.go.com/ktrk/story?section=weather&id=3266865
<3> i may not be leaving as soon as i thought
<4> what is that?
<3> a storm
<3> i can hear it
<2> hmm, ok
<3> if you click on that metro pic, i'm right about where that airport is shown towards the bottom
<2> pasadena / pearland?
<2> hmm, closest I've been is Orlando,FL
<3> roughly but it's still houston where i am
<3> cool
<2> 2 weeks in '94
<2> 2 weeks in new jersey..
<3> you need to come to houston, get caught in traffic in one of these storms ;D
<2> hehe
<2> I know that austin is the state capitol of texas
<2> and that is about all I know about TX
<3> that's more than i know about noreway
<2> Oslo is the capitol
<2> :)
<3> ah
<2> but I'm off... later
<3> ok, take care
<2> hmm, one problem with having a nap that last some hours is that it really scew up the daily rythm
<2> got rid of the headache though..
<3> heh
<3> at least it's friday
<2> yeah
<2> get to read some Sigma Protocol
<2> it is a good book
<2> Robert Lodlum
<3> cool
<3> i've got several books lined up to read
<3> just isn't enough time to do everything i want to do :(
<2> nah, I've spent 10 days on 10 pages of sigma protocol
<5> time enough to sit on irc :-)
<2> Eldritch: "research"
<3> heh
<3> some of my tasks are just monotonous
<3> not sure i spelled that right
<3> like closing these work orders for instance
<3> i've already verified them, it's just up arrow, change a character, enter ...
<2> but maybe I should read some sigma
<2> later..
<3> later
<3> Eldritch will keep me company while i finish this ;)
<5> im tired, im hanging out for lunch so can then have a nap
<3> heh
<6> Hello
<6> Anyone here?
<6> oy
<6> NWO|Lecter
<7> hello people
<7> AndSheWas ?
<6> hello
<7> i have a pb
<6> pb?
<7> problem
<6> me too :)
<7> :))
<6> I'm trying to connect from java
<7> nope ... you lost me
<7> :)
<7> i install mysql , it works very well , reboot , doesn't work at all
<7> wtf is happenin ?
<6> what happens?
<6> maybe the service isn't started
<6> mysqld-nt.exe on Windows
<7> i can't start it
<7> mysqld* doesn't work
<7> i have to reinstall each reboot
<6> Hmmm
<6> Still theree NWO|Lecter
<6> there?
<7> yep
<7> found anything?
<6> No
<6> But maybe there is a log file?
<3> hi
<8> hi
<8> how do I make foreign key with mysql
<9> MYSQL mc; printf("ERROR: %s", mysql_error(&mc));
<9> whats wrong!?
<9> it gives me non alphanumeric characters
<10> how can we get the difference (in minutes) between two datetime value? datediff(date1,date2)
<11> Hello
<12> hi
<2> hmm
<2> hi
<12> if my key efficiency is at 99% how can I fix it? by changing the key cache block size?
<12> yes, that is my question.
<12> I am new to tweaking mysql
<12> but reading the doc is not all taht clear
<12> err that
<2> have you read chapter 7 of the manual?
<12> on my way
<2> http://dev.mysql.com/doc/refman/5.0/en/optimization.html
<2> http://dev.mysql.com/doc/refman/5.0/en/myisam-key-cache.html
<12> I am running 4.1
<2> okay, http://dev.mysql.com/doc/refman/4.1/en/myisam-key-cache.html
<2> not changed that much
<12> yeah.. I am looking right now
<12> I have been familiarizing myself with all teh server vars this mornng
<12> but it's been quite some years since I admin'd MySQL db's
<2> what does OPTIMIZE TABLE tablename; do?
<12> Are you asking me?
<2> but long story short you want to increase the key_cache_size
<12> or pointing me to more reading material?
<2> more as in "does that help the situation"
<12> okay, If I have 4gb ram, what should I set my key_cache_size to?
<12> I mean for comparison.. I am reading the docs right now
<2> sorry, but I won't comment on that
<2> depends on too many factors
<12> right now my key chache block size is set to 1024
<12> err cache
<12> my key buffer size is set to 134217728
<12> Is that default?
<2> | key_buffer_size | 67108864 |
<2> is waht I use
<2> what*
<2> but as I said it depends on a lot of factors
<12> such as?
<2> if you need a 128MB cache, by all means use it
<2> 64 MiB is sufficient here for now anyways
<12> Well this server is hammered pretty hard daily.
<2> number of tables for one thing
<12> is 134217728 default?
<12> I am wondering what exactly this past sys admin did
<12> because the server ahs been crashing for weeks
<2> no, 128MiB is not the default
<2> iirc the default is 16MiB
<12> I just started here, and changed interactive timeouts and wait time to 300 (5 min) which stopped the server from spawning to many sleeping process's.
<12> it stopped the crashing ... but I am dong as I read and go.
<2> http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html
<2> or in your case 4.1
<12> yeah, That is where I read that.
<2> http://dev.mysql.com/doc/refman/4.1/en/server-parameters.html
<2> says the same thing..
<12> K_F, the key_cache_size you mention, is the same as key_cache_block_size on 4.1?
<12> Also, can I change it on the fly? Or can I sue my.cnf?
Return to
#mysql
or
Go to some related
logs:
#chatzone
Daeg +bondage
#MissKitten
#AllNiteCafe
sexysamira
#slice
#linuxhelp
#MissKitten
#linux
#AllNiteCafe
|
|