Re: keeping a fulltext index in memory

Hi Mark, I'm no Linux expert, but I think you would look at the difference between the SIZE and RSS values in top (or the equivs. in other progs...). Also IIRC, from your first message, I don't think you're using a full-text index in your query, are you? I think I saw column LIKE '%word%' and

Re: web hosting/PHP MyAdmin

Hi Matthew, Before I started using phpMyAdmin, I didn't want anything to do with it. :-) But now I find it to be nice for quick things like browsing tables, quick edits, table statistics, etc. For queries that return large amounts of text, it's MUCH more legible than the command line. :-) Keep

Re: [q] can I start MySQL in READONLY mode?

Hi Mark, How about just giving the user(s) only the SELECT privilege temporarily? Matt - Original Message - From: Mark Swanson Sent: Monday, September 01, 2003 7:33 PM Subject: [q] can I start MySQL in READONLY mode? Hello, I have a situation where I'd like to do some debugging

Re: Many Read and Writes...

Hi, If the index file is just 1k (the same size as an EMPTY table!), it sounds like you don't have any indexes. The 8.6MB table is probably at least a few thousand rows, right? Well, if all your queries are scanning the whole table, that would cause a few Table_locks_waited! :-) In order to help

Re: Select from one table where ID not in another table

Hi Marty, Yes, a query like this: SELECT t1.* FROM table1 t1 LEFT JOIN table2 t2 ON (t2.id=t1.id) WHERE t2.id IS NULL This assumes that table2.id is defined as NOT NULL. See also: http://www.mysql.com/doc/en/JOIN.html Hope that helps. Matt - Original Message - From: Martin Moss

Re: Query not returning 0 count records....

Hi Mike, If you use a LEFT JOIN, I think you'll get the results you want. Something like SELECT afs.stat_date, afs.hits, COUNT(v.clientcode) AS signups FROM affiliate_stats AS afs LEFT JOIN vtconlineusers AS v ON (v.creation_date=afs.stat_date AND v.dealercode=afs.affiliate_id) WHERE

Re: spaces in index name

Hi Ben, When using column/index names with odd characters (such as spaces), you need to use backticks (SHIFT + the ~ key) around the name: `index id` This ALTER TABLE query should make all the changes you want: ALTER TABLE v2easy0_users DROP INDEX `login connexion`, DROP INDEX `index id`, --

Re: spaces in index name

Hi, - Original Message - From: Benjamin KRIEF Sent: Sunday, August 31, 2003 8:17 PM Subject: Re: spaces in index name thanks for all your answers ! i'd never imagine that mailing-list to be so active and efficient! It's usually not that active on weekends, volume-wise. And I see

Re: Newbie Table question

Hi, - Original Message - From: Eternal Designs, Inc Sent: Saturday, August 30, 2003 9:46 PM Subject: Re: Newbie Table question To copy table A to table B(non-existent) use this command: CREATE TABLE B SELECT * FROM A; Note. If your two tables are from different databases the syntax

Re: Random Selects

Hi Jay, There seemed to be a problem with the first use of RAND() on new connections (is this in a script?). It was supposed to be fixed in a recent version of MySQL (I think in 3.23.56 and 4.0.10). Anyway, the workaround I discovered to work is to just call RAND() at least once before using it

Re: Explanation of multiple-column indexes

Hi Jesse, - Original Message - From: Jesse Sheidlower Sent: Monday, August 25, 2003 8:26 AM Subject: Explanation of multiple-column indexes After some discussion in a separate thread, I've been trying to get a better understanding of the workings of multiple-column indexes, and think

Re: Upgrading 3.23-4.0 under WinXP ?

- Original Message - From: Thomas Andersson Sent: Saturday, August 23, 2003 8:15 AM Subject: Upgrading 3.23-4.0 under WinXP ? Hi! I'm pretty green at this and I'm a bit clueless here, After reinstalling my system I upgraded from 3.23 to 4.0 of MySQL, then I moved my old dbs in

Re: Lots of FULLTEXT stuff (suggestions)

Hi Steven, Thanks for replying. Your posts that I've found when searching for FULLTEXT information have had great ideas. :-) Searching millions of posts efficiently and effectively isn't easy. :-( Heh. Thinking about ft_min_word_len some more (and how I wish they'd lower the default), I don't

Lots of FULLTEXT stuff (suggestions)

Hi all, I'm planning to use MySQL's full-text search for my forum system (possibly 5+ million posts). I've been playing with it a lot lately to see the performance and functionality and have some suggestions/questions. First, since a few of you may be wanting to know, here is a thread where I

Re: Named pipe vs TCP/IP speed

- Original Message - From: Jakob Dölling Hi: This surprised me! I have been connecting with named pipes (and telling others to do the same) on Win2k since I discovered them, because my queries (and time to connect) are most definitely *faster*. The client/server communication is

Named pipe vs TCP/IP speed

Hi all, I just noticed this in the manual yesterday: http://www.mysql.com/doc/en/Windows_running.html MySQL supports TCP/IP on all Windows platforms. The mysqld-nt and mysql-max-nt servers support named pipes on NT, 2000, and XP. The default is to use TCP/IP regardless of the platform, because

<    1   2   3