#mysql
13 October 2007
Total 15 pages. You are browsing page 5/15.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
04:06 <****> now if I go to usr/local
04:06 <****> hmm it has been a while since I used bsd
04:06 <****> there seem to be about five files that have the word mysql in it
04:06 <****> and when I type mysql at the command line it gives me back
04:06 <****> "Error 2002 (HY000): Can't connect to local MySAL server through socket '/tmp/mysql.sock
04:07 <****> er.. that was mySQL.. mistype
04:07 <****> have you googled around a bit?
04:07 <****> yeah.. a bit.. but there's so much
04:07 <****> I looked at the mysql documentation.. and it has a step by step process
04:07 <****> however.. the first step doesn't work
04:07 <****> which is to create a usr mysql
04:08 <****> well take a look at this tutorial for example: http://www.freebsdmadeeasy.com/tutorials/web-server/install-mysql-server-on-freebsd.php
04:08 <****> that's quite helpful.. I think
04:10 <****> except.. that the very first instruction doesn't work
04:14 <****> wow.. it won't even let me edit the rc.conf file
04:15 <****> are you using the devils editor?
04:15 <****> pico?
04:16 <****> what is the devils editor?
04:16 <****> vi
04:17 <****> no.. I just typed pico rc.conf
04:18 <****> whew
04:19 <****> any clue why it wouldn't let me edit?
04:19 <****> maybe you dont have permission
04:19 <****> do you know what sudo is?
04:20 <****> sorta
04:20 <****> should I type sudo pico ....
04:20 <****> yes
04:21 <****> I type sudo and it says "sudo: Command not found"
04:21 <****> try this
04:21 <****> su -
04:21 <****> that'll get you root
04:22 <****> then you can edit the file
04:22 <****> thanks a lot mates
04:22 <****> time to go bed
04:22 <****> thanks
06:53 <****> i was doing stuff and then i stopped mysql to stop what i'm doing, now it don't want to start .. is there a command i can use to fix it?
06:57 * alnokta suffers because he deleted /var/log/*
07:07 <****> Aletheuo: you did a rm on that dir?
07:08 <****> Aletheuo: forget that just a bad tab completion to another a person
07:08 <****> %LOGONSEVER%
07:09 <****> my bad.
07:09 <****> your bad to the bone
07:09 <****> "your" too, man!
07:19 <****> ToeBee: they thought my spelling was funny in ##windows
07:19 <****> %LOGONSEVER% <- that spelling
07:20 <****> you're in ##windows? I may have to ignore you now! :p
07:21 <****> I was asking what variable would tell me what active directory gc i auth'd against
07:21 <****> anyway. They thought it was funny until i told them i copied/pasted from microsoft kb
07:22 <****> heh
07:22 <****> you can't ignore me
07:22 <****> : (
07:22 <****> groupadd user -G mysql
07:23 <****> this right for adding the user "user" to mysql group
07:23 <****> ?
07:23 <****> err
07:23 <****> groupadd creates a group
07:23 <****> so no
07:23 <****> oh shnap , how do i go about this than ?
07:23 <****> useradd ?
07:24 <****> usermod I believe
07:24 <****> check the man page...
07:24 <****> yeah am now thanks
07:24 <****> been a while since I used it
07:24 <****> weird place to ask
07:25 <****> if i have a 20 web servers running 100 processes each, how is my database server going to handle being hit by 2000 connections?
07:25 <****> chadmaynard, ive seen worse asked in weirder places
07:25 <****> ;-)
07:26 <****> majikman: 2000 connections per second? per hour?
07:26 <****> slack_baphomet: oh so you've done this before?
07:26 <****> no this is a first , but dont really see why it matters though , was an easily awnsered question
07:26 <****> :)
07:27 <****> ToeBee, well, each time an apache process gets a new request, doesn't it open and close a new connection? with 20 webservers, i would imagine something like 2000 requests per second, easily
07:28 <****> majikman: 100 hits/sec seems like a LOT to me
07:28 <****> 100 hits/sec on a web server?
07:29 <****> yes. for each of the 20 sites to be doing that constantly seems somewhat unreasonable unless you are running some major websites...
07:30 <****> ToeBee, i'm assuming major websites
07:30 <****> and its not 20 separate sites, its 1 site on 20 web servers
07:30 <****> oh
07:31 <****> can mysql handle that many requests?
07:31 <****> well, it can handle a lot of requests over a persistent connection
07:31 <****> but can it handle that many requests over non-persistent connections?
07:32 <****> not sure. setting up a connection can be expensive... if you really have that big of a website you might need to look in to connection pooling
07:32 <****> i'm wondering if there are any alternatives to connection pooling
07:33 <****> mysql clustering? I don't deal with anywhere near that much traffic so I'm probably not the best person to be answering these questions :)
07:33 <****> heh... well... neither do i
07:33 <****> otherwise i'd be freaking out intsead of asking
07:33 <****> but... i need to prepare a proposal
07:34 <****> so... hmm.... i was hoping someone might know theory or anything
07:34 <****> probably hard to say... will probably depend greatly on hardware and how complex the queries are
07:35 <****> I mean it would be easy to set up a 10 line script to benchmark how many connections/sec you can establish to mysql
07:36 <****> hmm... true
07:36 <****> i have a bit of research to do then
07:37 <****> channel is pretty dead now too. Others might know more but have had too much beer on a Friday night to be of any use
07:37 <****> Why does MySQL uses Latin1 by default instead of Unicode?
07:37 <****> heh, ok, thanks ToeBee
07:41 <****> because multibyte charsets are ftl
07:42 <****> hornet99: probably because it takes less space and is good enough for most of the people who use mysql?
07:43 <****> 8-bit isn't multi-byte...
07:44 <****> because multibyte charsets are ftl
07:44 <****> http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
Total 15 pages. You are browsing page 5/15.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last