Re: Xserve G5

[Bryan Harris]

> Has anyone had any experiences running MySQL on a Xserve G5 with Macintosh
> OSX?
> 
> We are thinking of purchasing some new hardware to run our MySQL server.  The
> 64-bit architecture is something we would like to take advantage of.
> 
> Is this good, bad, otherwise? Any comments would be appreciated.


I've had great success running it on my 4-year old Mac laptop (using the
latest OS), and the Xserve is quite a machine (see #3 at
http://www.top500.org/list/2003/11/).  I think you'll have to compile MySQL
on the Xserve to take advantage of the 64-bit architecture.

Then if you are saavy (which I'm not, but I know people who are) Apple has
offered a suite of free profiling tools (Shark is a big one) that shows
which routines use the most processor time, and will even show you the
assembly code and when the processor stalls, why, and what you can do about
it.  Very slick.

See .

- B



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

On database structure -- keys and speed

[Bryan Harris]

Hi, all,

I'm still very much a newbie at MySQL, and thought a good starter project
would be a simple places database of every populated place-name in the world
along with its latitude and longitude.  I already have the data, and
originally planned to have only 4 tables with 2-4 fields each:

Places:  placename, adm2code, lat, lon
ADM2 (e.g. county):  adm2name, adm2code, adm1code
ADM1 (e.g. state):  adm1name, adm1code, countrycode
Country: countryname, countrycode

After importing the data, however, I realized that my key-ing must be wrong.
I didn't key the placename because they're not guaranteed to be unique, but
that means that a search for "Artesia" takes many (~30) seconds to complete,
which is really not very useful.

Does anyone have any suggestions on how this is done?  I'm sure the same
problem comes up when searching for "Tom Jones" in a names database...

Thanks in advance.

- Bryan



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ?? .tcshrc On OS X ??

[Bryan Harris]

> .tcshrc is the config file for your settings on the environment variables
> for your session of tcsh. When your looking for $SHELL your looking for the
> command line interpretor. FreeBSD can use most any of them. bash, csh, ksh,,
> sh, tcsh, etc. Usually the .rc file is found in your home directory i.e.
> /home/bsmythe/.tcshrc the file usually contains things like your $PATH
> variable or $PROMPT. Your best bet is to type "env" (on FreeBSD at least).
> That should give you a list of environment variables if you like the way
> your command line works now then I wouldn't change too many things.

Under OS X the home directories are in /Users.


> So you have a MAC. Look in your McManual to see where you set things like
> the type of command line prompt. Does it let you change the prompt from
> SHELL> to SHELL_8:00AM:\ . The file you use to set this environment variable
> is the file you use to set the PATH.

OS X behaves like most unixii, except for the different location of the home
directories.  OS X 10.2 defaults to tcsh, 10.3 defaults to bash.


> OS X 10 is claimed to be a kissing cousin to FreeBSD so I will make that
> assumption. First you will get stuck. But your system is like a 4wheeldrive
> and these lists are the wench to drag you out of places you ought not be. So
> add a good helping of persistence. You can do this. I'm an ex-truck driver.

I'm pretty sure OS X is a combination of NetBSD and NeXT, but don't quote me
on that.  I use IRIX and OS X daily, and they are almost identical at the
command line level (except that OS X has a bunch of extra tools for
interacting with the GUI/clipboard/applescript/etc, which is awesome).


> Good scrappy computers can be found for less than 50$ for an IBM PC. Load it
> up with FreeBSD. Buy a Good FreeBSD book Like FreeBSD Unleashed by Michael
> Urban and Brian Tiemann. Then just port down the Mysql rdbms. Use your Mac
> to administer the thing. SSH to the FreeBSD box from the Mac and get used to
> working roughly remote. You can do this. It's just going to take persistence
> on the command line.

There's no reason to do this!  Why would anyone want to stick a
headache-in-a-box on their desk.  The Mac will do everything he needs as
soon as he figures out how his shell works.

- B




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ?? .tcshrc On OS X ??

[Bryan Harris]

> I had tips from some people here to install the complete MySQL from Server
> Logistics
> on my Mac OS X 10.2 and so I did (I also installed Apache 2 and PHP from
> them).
> Now I'm on Step one, but got stuck here. (I always get stuck while trying
> this MySQL).
> 
> In the pdf-file that came along with the installation it says:
> 
> shell> echo $SHELL
> This will return the path to the shell you are using. In most cases it will
> return
> either "/bin/tcsh" (tcsh shell) or "/bin/bash" (bash shell). If you are
> using the tcsh
> shell, you will have to modify the file ".tcshrc" located within your home
> directory. If this file does not exist, then you will have to create a new
> one. After
> opening the file in your text editor, add the following line at the bottom
> of the
> file:
> setenv PATH "$PATH":/Library/MySQL/bin
> Save the file.

=)  The file is actually in your home directory.  What are you using for
your text editor?  Pico is probably the easiest, so to do the step above, go
to the terminal and type:

pico ~/.tcshrc

The .tcshrc file is hidden because it starts with a ".", so you don't see it
in the finder, nor with a regular ls of a directory.  You have to do an "ls
-a" to see it.

But if you want to do this step a little easier, type this:

echo 'setenv PATH "$PATH":/Library/MySQL/bin' >> ~/.tcshrc

fyi, the shell replaces the "~" with /Users/yourusername before it does
anything else.


> But when I try to find this .tcshrc file (whisch is the one showing up when
> I write
> that line in my Terminal. I can't find it (not by using Sherlock or when
> looking).
> I guess it should be in MyComputer / Library / MySQL / bin. But it isn't.
> So I wrote the line they explain in the end of the text above and try to
> save it as
> .tcshrc, but my computer tells me I can't use a name with a dot in the
> beginning.
> So I tried to take that away and then drop the file from the desktop to the
> bin folder,
> but then it tells m I'm not allowed to change that folder?!
> 
> What am I supposed to do??? I'm really a newbie here... and it seems I'll
> always be...
> I've tried this sooo many times the last week now. I'm about to give up
> soon.

You're in unix now, which is really cool, but has a learning curve to it.  I
recommend reading the tutorials on www.osxfaq.com, they'll explain a lot.

- B



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: view warnings?

[Bryan Harris]

>> I'm pretty new to MySQL, but I already like it.  Kudos to the developers!
>> 
>> I recently did a mysqlimport on a few data files, and it came back with over
>> 4000 warnings.  How can I actually see what the warnings were?  I'm still
>> not sure what it was upset about...
> 
> You can't.
> From 4.1.1 you can see warning if you use LOAD DATA INFILE statement:
> http://www.mysql.com/doc/en/SHOW_WARNINGS.html

I used mysqlimport because I could import a bunch of files all at once.
Does LOAD DATA have this capability?

TIA.

- B


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

view warnings?

[Bryan Harris]

I'm pretty new to MySQL, but I already like it.  Kudos to the developers!

I recently did a mysqlimport on a few data files, and it came back with over
4000 warnings.  How can I actually see what the warnings were?  I'm still
not sure what it was upset about...

TIA.

- Bryan


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]