Re: Macintosh: Trouble with grant tables?
On 8 Feb 2004, at 1:33, Marty Ray wrote: I am new to mysql and I am having trouble getting started. I am using a Macintosh G5 running OS 10.3.2. I got mysql installed and it would run, however when I tried to create a database, I got an error saying permission denied. I tried running the scripts/install_mysql_db, and I had to change permissions on ./data. Once I solved that one I now have a problem that has me stumped. When I run the script it now says: ERROR: 1 Can't create/write to file './mysql/db.frm' (errcode: 13) That's still permisison denied: % grep 13 /usr/include/sys/errno.h #define EACCES 13 /* Permission denied */ I have fixed the permissions on the ./data directory, but I can't figure out what else to do. Any suggestions? (take it easy on me, I'm fairly new to Unix) Assuming you have stuff install in /usr/local/mysql... chown -R mysql /usr/local/mysql/data chmod -R u+rw /usr/local/mysql/data That's assuming your mysql is running as the user mysql. -- Dave Hodgkinson CTO, Rockit Factory Ltd. http://www.rockitfactory.com/ Web sites for rock bands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: myisamchk vs OPTIMIZE TABLE
On 8 Feb 2004, at 19:37, Mark Hazen wrote: *snip* Here's my problem: I've got a bunch of tables with hundreds of millions of rows in them. Every night, I delete about couple million rows and then run millions of searches on these tables. What should I worry about more? A sorted index or a data file with no deleted rows in it? I don't mind running either OPTIMIZE TABLE (which apparently rebuilds everything and sorts it) or just the myisamchk to sort the index. Does anyone know which one might get me more mileage? What's the nature of your query? If it's using an integer index and that's what your searching on, then having it physically sorted is a Good Thing. If you're table-scanning your main table, you're toast anyway. Finding ways of making that faster is the way to go, maybe partitioning your data into small, fixed width, fields I care about and other stuff is the way to go? -- Dave Hodgkinson CTO, Rockit Factory Ltd. http://www.rockitfactory.com/ Web sites for rock bands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: myisamchk vs OPTIMIZE TABLE
On 8 Feb 2004, at 20:28, Mark Hazen wrote: My tables are just 2 INT columns. I have unique indexes on them going both ways. Sounds like you're sorted. You know, this might sound strange, but does the performance drop off at all if you lose the indices? A table scan of rows 8 bytes wide is going to be pretty damn quick. Plus there's a lot less maintenance to do without indices and no risk of them getting corrupted. -- Dave Hodgkinson CTO, Rockit Factory Ltd. http://www.rockitfactory.com/ Web sites for rock bands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Help with query
On 6 Feb 2004, at 14:38, Erich Beyrent wrote: This seems really efficient, since the only large number of rows to search against is the main listings table, if I read this right. Is there any further optimization that I can do, or this as good as it gets? Believe me, I am NOT complaining!!! Yes, it has to to a table scan on the criteria because of the leading %: it can't use an index for that. And 2500-odd rows is nothing. -- Dave Hodgkinson CTO, Rockit Factory Ltd. http://www.rockitfactory.com/ Web sites for rock bands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is there any documentation of Best Practices/Troubleshooting Guides for Administering MySQL
On 4 Feb 2004, at 20:32, Dan Muey wrote: We are implementing three or four MySql servers (as a start) and I'm writing the Troubleshooting Guide for our operational staff. None of these folks have any MySQL experience (and I'm a newbie myself). I need a pretty basic 'Cheat Sheet' for troubleshooting common production type problems. The staff is all very technical - Senior level Oracle DBAs - I'm going to have to drag them kicking and screaming into the MySQL world :-) Thanks in advance. I'm having fun with this tool, I'm looking forward to see how it does in production. It will do awesome, it always has for me anyway! I'd say the best general guide is the mysql.com website, very informtive and intuitive. No, Evelyn's request is a good one. I use MySQL day to day for some very different applications and have little trouble with it. Others coming to it from so-called real database backgrounds try to make it behave like Oracle and it rebels. There are design and code considerations that just make life easier for the programmer and the DBA. As with any database (ask a Sybase DBA!) The mod_perl support mailing list, led by Stas Bekman, produced the mod_perl guide with community support that recently led to an 800+ page O'Reilly book. I'd like to see something like this for MySQL: for those beyond basic web applications and trying to make their lives easier. Um, does this make sense? -- Dave Hodgkinson CTO, Rockit Factory Ltd. http://www.rockitfactory.com/ Web sites for rock bands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Performance...
"Patrick FICHE" [EMAIL PROTECTED] writes: I just wanted to know if my assertions are rigth and what are the common way to solve this type of problems ? Store your results into a temporary table? -- Dave Hodgkinson, http://www.hodgkinson.org Editor-in-chief, The Highway Star http://www.deep-purple.com Apache, mod_perl, MySQL, Sybase hired gun for, well, hire - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php