| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> my desktop is a plain old 2ghz something that's 3 years old, only a fraction of the power of the server
<0> ahhh
<1> theBenke: that's very vague. try asking some specific questions. how are you running mysqld?
<2> Guess ata are **** drives because the desktop machine with ide is much faster.
<0> so when i do the iostat i might be getting not physical block reads, but rather cache hits?
<1> Lion-O: SCSI-1 is teh bestest!!11
<2> LinuxUser: read up on this, THEN draw conclusions and such.
<2> and be precise.
<0> ok, i've googled around quite a bit to figure out where i need to start looking, and i'm not really sure
<2> the manuals might help
<3> Cynic: /usr/local/mysql
<3> oops
<0> so (in my little brain) it seemed that one logical place would be to figure out "how much disk access is occuring, and how much is the server capable of?"
<4> Awwww, Lion-O's helping the "special" one, that's so nice! *gives Lion-O a medal*
<3> Cynic: /usr/local/mysql/bin/mysql
<2> duh
<0> if it's capable of X, and it's doing 90% of X, then obviously, IO is a problem
<2> LinuxUser: so in order to determine this you don't read up on the specs. No. you goto #linux and ask "Whats a normal capability for my server?"
<1> theBenke: did you follow all the instructions in mysqls INSTALL and README files? there are some procedures you have to follow first, and I think it recommends running safe_mysqld rather than the plain mysqld bin first time.
<0> well i can find out specs on sata drives to see what kind of disk bandwidth they are capable of
<0> but i'm not sure how to compare iostat's results with specs
<2> LinuxUser: considered reading iostats manual ?
<0> i know that iostat reports blocks/sec, and a block is 512 bytes
<0> yes i have read it
<0> but when i did that test just now on my desktop it looks like iostat is reporting cache activity, not physical disk access
<2> "it seems" ?
<2> omg
<3> Cynic: hmm yeah, I've try to run mysqld_safe and I get A mysqld process already exists
<1> theBenke: then it's already running. but you may have missed out the step of setting up the superuser account, etc...
<3> Cynic: yeah I set it
<1> theBenke: stop the mysqld processes, and start again, this time reading the INSTALL and README files.
<3> ok
<3> hmm
<3> Installing all prepared tables
<3> /usr/local/mysql/libexec/mysqld: Can't read dir of '/root/tmp/' (Errcode: 13)
<5> unsa run
<4> Is mysqld running as root?
<3> the install is running as root
<2> depends how you set it up
<3> :/
<3> geez...
<3> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
<6> theBenke: or, if I scroll up higher, find out why the server is trying to use /root/tmp/. Maybe you should actually read the configuration files
<3> okay
<6> (better yet, why are you running this from /usr/local? why did you not install your distribution's mysql package that already had a sane configuration
<1> RelDrgn: as long as he makes nice start/stop scripts for it, installing from source isn't too bad..
<3> well, I install MySQL from rpmdrake, and I didn't see any files of MySQL, after that I downloaded MySQL tar.gz
<7> anyone know offhand the vim settings that makes matching braces highlight when you complete them?
<7> i used to have it but lost my old vimrc
<6> theBenke: of course you didn't "see any files" you didn't look where they were installed :P
<2> twofish: 'syntax on' iirc
<7> Lion-O: no not that one
<7> when you type the closing brace the cursor flashes to the opening one and back
<6> showmatch
<3> RelDrgn: default installation is /usr/local/mysql ... right?
<6> theBenke: no
<6> theBenke: /usr/local is never used by distributions.
<7> showmatch
<1> theBenke: so, you've probably got two instances of mySQL installed. uninstall the package first, or get rid of the from-source installation
<7> YES
<7> thank you
<6> theBenke: the distribution will have setup startup scripts in /etc/init.d/ or the like, and will automatically start the server for you
<7> thanks!
<6> theBenke: read your distribution's documentation, it will explain how the distribution manages the servers and other software you install.
<3> ok
<8> so what distro does people here abuse?
<9> windows
<3> ;)
<10> hi
<10> everybody
<11> hello
<12> Kind of dead in here tonight
<11> reality_ you want to discuss irq balancing?
<12> Seeing as I disable it...
<12> I don't no what help I'd be
<11> reality_ thats one option. i heard alan cox recomends it. it just lets cpu0 handle the irqs. im thionking of doing that and then setting them manually through /proc
<11> well setting the one or two i care about.. my video card.
<12> What are you hoping to gain out of it?
<11> reality_ less flaky driver performance. i use the proprietary nvideo video card and ive had lockups. not in the last few weeks. and when it locks up i see the disk still working normally. as if only my display froze
<11> nvidia
<12> I doubt that has much to do with irq balancing
<11> reality_ yes you are right. but its just one more thing to check
<12> What kernel are you running?
<11> reality_ right now 2.6.15.3 but i and other have had the same problem since like 2.6.12 or so. it have been fixed, as i said it hasnt happenned in a while.
<11> i mean it might be fixed and i just dont know it
<12> Well, if I'm not mistaken 2.6 has irq balancing disabled by default
<11> reality_ hmm, interesting. i noticed it didnt work. right now im useing the user level irqbalance program. before i was useing both which i know now was wrong.
<12> The More You Know (TM)
<11> i'll try to turn the kernel one back on now that i know it is disabled by default
<11> thanks
<11> oh, one flakey thing about my video drivers is PCI: Failed to allocate mem resource #6:20000@f0000000 for 0000:01:00.0 but of course thats very unlikely to have anything to do with proccessor affinity.
<11> except as memory allocation
<13> hmm, wonder if I should upgrade samba
<4> Mother****ER ARGH!
<4> *finds Mozilla's HQ and kills them ALL*
<13> eh?
<14> you too are angered that mozilla isn't modular and reusable like a good unix app should be?
<4> Spent like 30+ minutes putting in a support ticket at sunsolve.sun.com, put in all the info, was *just* adding my boss as an alternative contact... and boom, Mozilla simply vanished.
<11> thats what i first hated about netscape. the whole idea of a web browser as a one size fits all application used to bother me. now ive learned to expect less from the web
<13> oh, I use firefox
<4> Right, Firefox, that's what I use
<13> I don't have any problems with it.
<4> I rarely have problems with it, except on my Linux box.
<13> just upgraded to 1.5.0.1 today.
<13> ahh, I run it on Solaris
<14> maybe mozilla detected a potentially disrespectful image on the site and protested your use of it to spread that hate
<4> Speaking of upgrading: is anyone here using SuSE 10 and YaST2 and did the kernel upgrade?
<4> The last time I did a kernel upgrade on this system, the new kernel was FUBAR and would reboot the system during bootup, so I had to fallback to the previous kernel version... I'm a little leary about that happening again.
<14> just use firefox and thunderbird.. Yes, they could have made things a lot easier by developing in a modular fashion like the last 30 years of unix development has done but hey.. what's a duplication of a couple dozen MB of ram to people with hundreds ?
<15> CeruleanD, I usually have no problems with SuSE, YasT and kernel upgrades; but I use 9.3
<4> hmm
<4> Well, I did it, now I just need to re-run lilo and reboot and see what happens.
<4> Ugh, but first go find out why one of servers just decided to stop responding. brb
<11> the web could be so much more, you could have one app for ftp, another app for viewing picturesm and another one for viewing databases and one for files that you download. but the whole idea of combineing them together, is either right or wrong:)
<11> either you accepth the bloat or you dont
<11> I mean accept
<14> debian unstable actually has 1.5.0.1
<14> crazy
<4> Ah, well, this explains it... DNS seems to think the server is in the DMZ, but it's not... that would make things ... difficult...
<11> my answer is live with the bloat just kill it when im not useing it
<16> well i have figured out quite a bit more about linux io issues
<16> but am still not sure if i am interpretting stuff correctly
<1> oh god
<16> so... it looks like (if i am reading iostat correctly) transfers of 250kb/sec are totally trivial, as i thought
<16> which implies that my performance problem is some kind of software config (mysql + apache + php) problem
<16> which doesn't really surprise me
<16> although cpu use is also quite low. so i need to look at other things: maybe there aren't enough threads handling some process, etc
<13> oh my god. he's talking about threads now.
<13> have you even looked into tuning mysql? granted I don't know what your problem is.
<16> well, i'm trying to use some kind of rational approach to figuring out where the problem is
<13> well I know what one of your problems are. but anyway.
<1> schitzo: yeah, awesome huh.
<16> i haven't looked into mysql at all. my approach (which may be totally butt-headed, i know) is to first try to figure out which component of the system needs to be tuned
<17> I just built a dual core system, any heads up on installing fedora core5 test2 64bit?
<16> for example if cpu is pegged at 90% all the time, that tells me something
<13> digital712: insert CD, boot, install. see what blows up.
<18> digital712: yeah. burn the cd or dvd. boot it. click.
<14> yea, give me your dual core system so i can make real use of it
<16> or if disk io is pegged at some number which is too high, then maybe i'm just trying to serve too much traffic and i need to install ram and do caching in a good way
<17> fu
<1> LinuxQuest: are you talking to anyone in particular? or are you just babbling to the world?
<14> i didn't know everyone was all into martial arts
<17> funny
<17> wanna b's
<16> well i got flamed last time i was here for trying to figure out where to even begin on a performance problem
<16> which we know it can be non-trivial to isolate the right place to fix such things
Return to
#linux
or
Go to some related
logs:
sam undernet almighty
12frenzy
english prison 1805
DOWNLOAD DJ Alligator vs Gigi DAgostino - Blow My Bla Bla
oblivion SYNAPSiS
#AllNiteCafe
std tolower
parazi7u
#javascript
#windows
|
|