Searching a large table

yet quick and light on resources, search system? Is a fulltext index the best way to achieve maximum performance with this kind of search? Thanks. -- Steve - Web Applications Developer http://www.sdwebsystems.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql T

Re: Searching a large table

main table, or is that more work than what it's worth in my case? -- Steve - Web Applications Developer http://www.sdwebsystems.com On Fri, May 5, 2006 2:35 pm, sheeri kritzer said: > Sounds like you want LIMIT and OFFSET -- > > everything after my name and before your post is cop

Re: customer id - made the worst possible way

If you really want to change the customer ID, then you can always copy the entire table to another table with a primary key set. Then simply reference that primary key field and forget the prior one. -- Steve - Web Applications Developer http://www.sdwebsystems.com On Tue, May 9, 2006 9:33 am

Re: customer id - made the worst possible way [SOLVED]

major code re-writes, I suggest keeping the old ID field for pre-existing records and relying on the new primary key ID field for new ones -- at least until you decide to change all necessary application functionality to reference the new ID. -- Steve - Web Applications Developer

MySQL, PHP and Yahoo webhosting

MySQL server through socket '/tmp/mysql.sock' (46)" and the tem-folder in my page root is empty, too. But i have PHPMyAdmin and i can log in there. i just have no clue where the files are and how i change it so that i finaly can start learning by doing... Thanks so much for the help..

insert html into database

Hi everyone... how do I enter html code into my database???

than you for your answer but...

thank you for the clue of double quoting the html when inserting into the database but I still get the error. the problem seems to be that I have quotes INSIDE the html code as well (links and pix) so, i still get this error. " Database Selected: candlecatalog Query: insert into Products (Pro

RE: than you for your answer but...

I'm a very beginner and trying to get my way into sql with... One told me to double quote the html. Now, it's said the php has a "mysql_real_escape_string" so... What the hell is this and how do I make that work??? And where is the radio to call MAYDAY???? Or SOS??? Steve wr

making varchar field to act like numeric field

dynamically cast the data to a numeric format so I can use MySQL's numeric sorting? I can't change the field's data type because it also needs to be able to hold textual data. Thank you for your help. -- Steve Musumeche CIO, Internet Retail Connection -- MySQL General Mailing Li

update or insert if necessary?

d I'm wondering if there is anything like and "up-sert" command, or at least a preferred way of doing this operation. TIASteve

Re: BULK DATA HANDLING 0.5TB

/optimize-overview.html Table OPTIMIZE command http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html Using EXPLAIN http://dev.mysql.com/doc/refman/5.0/en/using-explain.html http://dev.mysql.com/doc/refman/5.0/en/explain.html MySQL system variables http://dev.mysql.com/doc/refman/5.0/en/mysqld-op

Database quotas?

Hey guys, is it possible to bind some databases to a userid so u can do disk quotas on them, or limit how big a db can be? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database quotas?

Yeah but when they make a nwe table, it will be owned by root.root wont it? > On Wed, Sep 24, 2003 at 01:38:43PM +1000, [EMAIL PROTECTED] wrote: >> Hey guys, >> >> is it possible to bind some databases to a userid so u can do disk >> quotas on them, or limit how big a db can be? > > chown the file

libc6 binary same as i686?

x27;m trying to pick the best path, but between this older K62 and the warning about gcc 2.96, I'm having trouble :) (I'll be using a K62 with RH7.1) Thanks in advance, Steve - Before posting, please check: http:

RE: Referring Page in PHP/SQL

lose connection mysql_close($connection); } else // login/pass check failed { mysql_free_result ($result); mysql_close($connection); // redirect to error page header("Location: error.ph

Full Text Index and MySQL 4.0.2

at as words, examples are "C++", "AS/400", "TCP/IP", etc.' If this feature is supported, I would appreciate any help in getting this to work. Thanks in advance, Steve - Before posting, pl

Re: MySQL update subquery replacement

e not been printed, with the matching product's current status regards Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archi

Win2k

denied to database error at the bottom. If you hit connect again, and type in the correct password,it errors out. Steve

mysql.sock deletes itself on Solaris

>Description: /tmp/mysql.sock is there and then apparently randomly its removed without warning.. mysql still accepts TCP connections and theres no log comment to indicate an error. >How-To-Repeat: It seems random.. >Fix: Good question - any ideas?! >Submitter-Id: steve

host = %

hank You. Best Regards, Steve - 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]> T

Re: most appropriate data type for currency?

the same but with a few extra decimal points to keep rounding errors small and predictable. For cases where the errors would tend to accumulate (banking etc) I think you need a Double. I can't imagine a case where I would use a Float. Steve > Of course, in the interests of fairness,

i686 Binary on i586 OK?

#x27;t be run on the older ones. I understand the source is available but I'd like to use the binary, if possible. Thanks for any help, Steve - Before posting, please check: http://www.mysql.com/manual.p

mysqld got signal 11;

ar 21 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20266642 Mar 20 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Mar 20 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql critical Thanks and Regards,

RE: getting unique results

SELECT DISTINCT 'Service type' FROM 'service_providers' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 20 April 2006 12:45 To: mysql@lists.mysql.com Subject: getting unique results SELECT `Service type` FROM `service_providers` How do I get only unique resu

Tough query to crack

7;db_context_ID' in field list" I know why it's failing but there's a failure in translation. Can anybody figure out how to translate this into SQL that will work in MySQL? Thanks in advance for any helpsteve--- Steven J Orton Software Engineer Northrop Grumman Mi

RE: Tough query to crack

the IDs are put into the APPLICABLE_TARGET_IDS temporary table. steve--- Steven J Orton Software Engineer Northrop Grumman Mission Systems Middletown, RI 02842 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wed 6/28/2006 4:01 PM To: Orton, Steve Cc: mysql@lists.mysql.com Subject:

RE: Tough query to crack

on Systems Middletown, RI 02842 -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED] Sent: Wed 6/28/2006 4:57 PM To: Orton, Steve; mysql@lists.mysql.com Subject: Re: Tough query to crack />I don't think that will work because Context_ID is not found in 'target

mysql hangs on connection attempt

abase with appropriate results. i work for a school district and the central office people have just built a new LAN that involved changing the addresses of our dns servers. the servers are behind a NAT, and only their external addresses changed. this is a really tough bug, so any help would b

Re: mysql hangs on connection attempt

ent before the first line of code in this function echos to the page, but if the die(); statment is placed after the call to mysql_connect(), there is nothing printed to the page. thanks for the help, steve > On 7/18/06, Steve Strong <[EMAIL PROTECTED]> wrote: > > we are using

Re: mysqlcc / mysql query browser

I use EMS MySQL Manager. You can buy it here: http://www.sqlmanager.net/en/products/mysql/manager/buy No, I am not affiliated with them, but I use the product everyday and I love it. Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Pooly wrote: Hi, MysqlCC not being in

Re: Managing big mysqldump files

eed penalty (that is, do mysqldump | bzip2 > outputfile.bz2). Try 'man gzip' and 'man bzip2' for more info. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavi

Re: Table permissions - before the table is created?

If you are manually editing the grant tables, don't forget to FLUSH PRIVILEDGES after you add the new tables. Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Chris Jones wrote: Thanks for that. Will create the two tables ahead of time which won't affect th

Re: Data dictionary for MySQL

t the information_schema database; it might have everything you need already: http://dev.mysql.com/doc/refman/5.0/en/information-schema.html steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavi

Shell

Greetings, Does anyone know how I can set up my shell so that the mysql command works without navigating to the directory? I am using Mac OS 10.2.8 and 10.4 shell> mysql ­u name ­p ?? Thanks, -- Steve Marquez

Re: Distinct select over 2 fields?

Select DISTINCT(lat_long_field) from table where... Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Brian Dunning wrote: Many different records will be returned though, I just don't want any dupes where both lat/lon is the same. :) On Sep 12, 2006, at 12:20 PM,

Re: Distinct select over 2 fields?

You could try using CONCAT: select distinct(CONCAT(lat, long)) from table where ... Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Brian Dunning wrote: Lat & lon are two different fields. Either can be duplicated, but not both. On Sep 12, 2006, at 12:33 PM, S

Re: query to find duplicate rows

Select COUNT(*) as num_entries, url from table WHERE num_entries>1 GROUP BY url Untested, but the concept should work for you. Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Peter Van Dijck wrote: Hi all, a though query problem for me... I have a table with 2 rows t

Re: Cloning or duplicating a record

s unique. Check mysql manual for more info on syntax of insert command. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Center

Re: making varchar field to act like numeric field

near 'decimal)' at line 1 Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Douglas Sims wrote: You can use CAST or CONVERT to see the data as a numeric type. If the table is very big and you're going to be querying it intensely, you might want to create a

Re: making varchar field to act like numeric field

Dan, Thank you, that works! FYI, you can treat the field like a number, including sorting, numeric functions, etc. For example, select * from table order by (text_field+0.0) Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Dan Nelson wrote: In the last episode (Sep 28

comparing two databases

Is there a program out there that I can use to compare two databases? Just the structure, not the content. Thanks Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: comparing two databases

see that it will do everything that I need for other things too. I like that it can do a type of CVS for a database too. A couple of long term projects that I am on could really use something like that. Thanks Steve At 05:45 AM 9/29/2006, COS wrote: Hi, Look at DBTools Manager Enterprise

Re: create database outside /mysql/data/

Hi Laurie You can put the DB data on any disk or directory as long as it's location is in the .ini file #Path to the database root datadir="C:/MySQL/Data/" HTH Steve l'[EMAIL PROTECTED] wrote: I installed Mysql on windows and found out that the documentation

Re: INSERT record IF NOT EXISTS?

QL will not perform the update if the column value does not change. steve mysqladmin Ver 8.40 Distrib 4.0.24, for pc-linux-gnu on i386 CREATE TABLE `release_test` ( `BID` int(10) unsigned NOT NULL default '0', `ReleaseID`

Memory usage question

re was any mention of this but haven't seen anything. Is this a normal occurrence? Is there some kind of tuning that I can do to free up more memory? Thanks for listening. Steve

UNICODE and BLOBS

The documentation notes that BLOBS must escape certain characters ( NULL, etc ). Since a blob is not of any character set, how do I know how to prepare a blob for insert? ( which character set / character size to use to test for characters that need to be escaped? Thanks, Steve -- MySQL

Re: dump to more than 1 file

rd database < `cat dump.*` but I don't think that's possible. You'd have to reassemble the dump file first, which means you might run into file size issues again. Probably best to do table-by-table, piping to zip/bzip/gzip as well. steve -- +--- my

Re: Visual database design system

yet. If I recall clearly, it is similar in scope to Datanamic's DeZign - http://www.datanamic.com/ - which is (or was) Windows only. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgf

arbitrary ORDER BY

ot; ... However, my arbitrary ORDER BY statements don't seem to be working on MySQL 5.0.16. Am I remembering correctly? I can't seem to find anything in the MySQL manual. Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: arbitrary ORDER BY

Peter Brawley wrote: Steve, Look for 'FIELD(' at http://dev.mysql.com/doc/refman/5.0/en/string-functions.html. PB Thanks, Pete! For posterity, this is how I solved the problem: To create an abitrary for the ORDER BY clause, create a field like this: SELECT FIELD( field,

Upgrade problems 4.1->5.0.18

Hello fellow listers, I recently upgraded via RPMs from 4.1 to 5.0.18 on a RH9.0 (glibc2.3, kernel 2.4.20) machine. Now I have problems starting the mysqld automatically. When it is invoked, the error "Couldn't find MySQLmanager or server" is emitted. Here is a short history of my actions

Re: counting keywords

stemming you need (eg; to take care of plurals). I've done something like that as well, and included an extra field for the metaphone version of the word, to match approximate spellings. If the text fields were all in plain text, you could even include character positions like word ch

RE: counting keywords

At 1:35 PM +1000 4/11/06, Taco Fleur wrote: Thanks Steve, Much appreciated, I was hoping there was something a little simpler, but I will have a go at it. Anyway of doing this with RegEx, would that simplify things? Hi, and you're welcome - Unfortunately, I don't think this can be

RE: counting keywords

At 1:55 PM +1000 4/12/06, Taco Fleur wrote: Hello Steve, Your suggestion works like a charm, I am now trying to get my head around your following statement, I can't seem to get a grip on what you mean. Is there anyway you could elaborate a little on the following? It would be really nice

Re: [NEWBIE] How To Trim Database To N Records

http://dev.mysql.com/doc/refman/4.1/en/user-variables.html http://dev.mysql.com/doc/refman/4.1/en/example-user-variables.html http://dev.mysql.com/doc/refman/4.1/en/delete.html steve -- +--- my people are the people of the dessert, ---+ | Steve Edberg

Re: How to disable some of the mysql query?

uery_log = "| some_program_that_monitors_activity") that might reduce the load sufficiently. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davi

Re: Consolidation suggestions - some LAMP servers

ually 'localhost' (e.g. wordpress). Steve. On Tue, Dec 9, 2008 at 11:58 AM, Götz Reinicke < [EMAIL PROTECTED]> wrote: > Hi, > > over the last couple of years our infrastructure rose as we needed and > now we are thinking about the next steps as the access to the server

Re: Inno Setup script for MySQL and MySQL ODBC?

t;inno setup script". Please be more specific. Steve.

Re: frequent issues restoring mysqldump file

Andy, I just had an interesting experience you might also find interesting. I rarely have to do restores, also (MySQL is very solid), but I just upgraded my (only) MySQL server. At the same time I upgraded the MySQL release from 5.0.45 to 5.0.67. While testing my procedure (which was a piece of ca

Re: questions about merging

that one db as the back end. Steve. On Wed, Jan 28, 2009 at 6:14 PM, Robert D. Crawford wrote: > Hello, Olaf, > > "Stein, Olaf" writes: > > > the import of the dump will not remove your other tables unless there > > is a naming conflict, then the table will b

Re: Possible to get better error handling for invalid enum parameter to stored program?

running v5.0.51a; as you can see, the first invalid value was truncated to '' with a warning, the second caused an error and did not insert. I don't know what version you're running, perhaps this does not apply to you. For more info: http://dev.mysql.com/doc/re

Re: Auto increment?

hich, by default, will be updated every time a record is inserted or updated. Then the other applications can simply select records with timestamp > last_poll_time. steve -- +--- my people are the people of the dessert, ---+ | Steve Edberg

Re: Creation date

ables (information_schema only exists in MySQL >= 5.0, methinks). Manual references: http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html http://dev.mysql.com/doc/refman/5.0/en/information-schema.html - steve -- +--- my people are the peopl

Re: results of the query as a table

,concat(thing3,thing4) as thing5 from bar where thing4 like 'baz%' order by thing1 desc You could create a TEMPORARY table if needed (CREATE TEMPORARY TABLE...). Assuming version 5.0: http://dev.mysql.com/doc/refman/5.0/en/create-table.htm

Re: results of the query as a table

At 3:29 PM + 10/27/09, Olga Lyashevska wrote: On 27.10.2009, at 15:11, Steve Edberg wrote: At 2:59 PM + 10/27/09, Olga Lyashevska wrote: Dear all, I run a query and I try to save results as a table. On the results of this first query I want to run yet another query (perhaps a few

Re: Alphabetical search to and from

7;,'j','k','l','m','n','o','p') I wouldn't recommend the latter, but might be handy if you were dealing with something more complex than a simple range. - steve -- +-

MySQL 5.4 Support for Mac OS X 10.6.x ?

ETA for GA and to get beta versions (the mysql-5.4.3-beta is supported only on osx10.5-x86_64) ? Thanks, Steve http://dev.mysql.com/downloads/mysql/5.4.html#macosx-dmg http://dev.mysql.com/doc/mysql-macosx-excerpt/5.4/en/mac-os-x-installation.html http://bugs.mysql.com/bug.php?id=46999 http

Re: MySQL 5.4 Support for Mac OS X 10.6.x ?

est/suite/ndb/my.cnf To be followed ... and congratulations to the MySQL Team for the quality of this 5.4 beta version which looks yet great :) Regards, Steve 2009/11/29 Steve Pincaud > Hello, > > I have a Mac Book Pro (64 bits x86) running with Snow Leopard aka Mac OS X >

Re: Select Problem

ID = r.Child inner join categoriesProducts as p on r.Parent = p.ID where p.Category = 'prodCat2'; - s -- +----+ | Steve Edberg edb...@edberg-online.com | |

Re: Mysql version of database link?

x27;t used federated tables yet... - steve -- +----+ | Steve Edberg edb...@edberg-online.com | | Programming/Database/SysAdminhttp://www.edberg-

Stored Proc's

Silly question here... But can I have multiple definers for a stored proc, rather than allowing `us...@`%`? basically, I want to only allow 1 user name, but from only 2 or 3 IP's. My Googleing didn't turn up anything of use, so now, I am here asking :) Thanks in advance! Ste

Re: last_insert_id

, may not be what *you* need. I'd recommend spending some time reading the documentation for autoincrement fields and the last_insert_id() function. - sbe - -- +----+ | Steve Edberg

Binary Logging

reate them when we do go to a master/slave setup? Once i finish moving data around, i can remove the old tables that i am moving them out of, so I don't really see a huge issue with dumping them, i just want to make sure. Thanks in advance! Steve Staples. -- MySQL General Mailing List Fo

RE: Binary Logging

Silly me sees that there is an 'expire_log_days' in the my.cnf But again, if i was to purge everything but the last day or 2... running this command i found: PURGE BINARY LOGS BEFORE DATE_SUB(NOW(), INTERVAL 2 DAY); >From the MySQL command line, will this be ok? Steve. -Ori

MyISAM no table lock

Hi there. I was reading last week (and of course, i can't find it now) something about 'nicifying' a query, so taht it doesn't lock the table... How is this done? I've read so much stuff lately, that i can't find it for the life of me, and google is not being my f

RE: MyISAM no table lock

@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De Meersman Sent: February 8, 2010 10:01 AM To: mysql@lists.mysql.com Subject: Re: MyISAM no table lock On Mon, Feb 8, 2010 at 3:37 PM, Steve Staples wrote: > Hi there. > > I was reading last week (and of course, i can't find i

Converting MyISAM to InnoDB

kind of times/loads i get) i get the error... I am in the midst of removing the combined unique primary key, to see if that is the culperate or not, but if anyone has any ideas, i am eager to listen :) Steve. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Stored Procedure/Function Question

t to be able to allow ALL the users of this database access to it, as well, if I were to change this function, i have to go in, and manage every user that would be attached to it, to allow to use it again. I've tried '%'@'%', and I get the error that this user does not exis

Re: hard disk crash: how to discover the db?

ope I missed the joke here, or missed something... Steve. On Thu, 2010-09-09 at 18:02 -0400, George Larson wrote: > We do nightly backups at work just by taring the mysql directory. In > my environment, that is /var/lib/mysql. > > Like this: > > service mysql stop > cd /var/

Crashed Table - How to report/prevent?

a quick routine that goes and 'shows' the tables, and if it fails, then repair it (or report it back to me via email or something). Any ideas on a way to automate something that is efficient and quick? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: Crashed Table - How to report/prevent?

>From what I read, it puts a lock on the tables (read lock). the tables in one of the databases are continuously being written/read/updated, so I dont want to lock them if at all possible. Are there any other ways? Steve On Mon, 2010-09-13 at 15:11 +0100, a.sm...@ukgrid.net wrote: > W

Re: Capitalize Input via Auto Complete?

sues. it has never crashed, or caused errors in anyway. I am on Ubuntu 9.10 (it wants to uninstall wine to upgrade to 10.04, so for now i am not upgrading) Steve > >> -Original Message- > >> From: Carlos Mennens [mailto:carlosw...@gmail.com] > >> Sent: Tue

Re: Swap data in columns

What about: select `id`, `column1` as 'column2', `column2` as 'column1'; Steve On Wed, 2010-09-22 at 13:06 -0500, Johnny Withers wrote: > Couldn't you just rename the columns? > > JW > > > On Wed, Sep 22, 2010 at 11:53 AM, Rolando Edwards > w

Select NICE

Google has not been kind to me on this one, so I figured I would ask here... how can I select with NICE options, so that it doesn't KILL my server, or any other queries... Do you understand what I am asking? Steve -- MySQL General Mailing List For list archives: http://lists.mysql.com/

GRANT issues

EGES; I can get the user and password set up fine, but it does not grant any privileges. It is probably an easy fix that I am just missing, but I would appreciate your help. Thanks, -- Steve Marquez Marquez Design e-mail: smarq...@marquez-design.com web: http://www.marquez-design.com phone: 479-648-0325

mysqlcheck options

able {tablename} quick; ? the quick repair has alsways worked for me, and it takes like 20minutes, to 1hr+ to repair the tables, but should I do somethign different? if i can run the mysqlcheck -AF say daily, and it would pick up any issues that would be great... any ideas/thoughts would be welcomed.

Purposely Corrupting a table

Ok, been googling all morning, and keep getting the same post (on multiple different sites). Is there a way, where i corrupt a table purposely? I've tried playing with the .MYD file, and yeah, it "marks" it deleted under the check routine, but the table is still readable/writable, just doesn't

Re: why mysql choose a bad query

fields in the > > key (i.e. a covering index) does it still choose what you consider to > > be the wrong key? > > -- > > Regards... Todd > > I seek the truth...it is only persistence in self-delusion and > > ignorance that does harm. -- Marcus Aure

Re: help with query

On 1/11/11 9:31 AM, Simon Wilkinson wrote: select users.id from users where users.id in (select newletters.user_id from newletters left join articles on newletters.id = articles.newsletter_id where articles.newsletter_id is null); I think this would do what you require: SELECT u.id AS user_i

I/O read performance

s, or are they sequential? would symlinking the file to another db make any difference (or is that even possible)? any insight would be appreciated, or even any ideas on what I may do to increase the performance, or even how to measure where the issue could be would help as well. Steve -- MySQL

Re: I/O read performance

discount the value of measuring your raw i/o performance, but > first we should determine how your data is being stored. > > - michael > > On Thu, Jan 13, 2011 at 2:44 PM, Steve Staples wrote: > > Hello, > > > > I've been noticing a little lag in my application

Re: I/O read performance

On 1/13/11 1:21 PM, Steve Staples wrote: table type is MyISAM, it is a "customer_account" table, which holds the email address, and the customer_id field, the queries that are constantly being queried is "select customer_id from customer_account where customer_email = '

Re: I/O read performance

On Thu, 2011-01-13 at 13:51 -0700, Steve Meyers wrote: > On 1/13/11 1:21 PM, Steve Staples wrote: > > table type is MyISAM, it is a "customer_account" table, which holds the > > email address, and the customer_id field, the queries that are > > constantly being

Re: I/O read performance

On 1/13/11 2:13 PM, Steve Staples wrote: On Thu, 2011-01-13 at 13:51 -0700, Steve Meyers wrote: On 1/13/11 1:21 PM, Steve Staples wrote: table type is MyISAM, it is a "customer_account" table, which holds the email address, and the customer_id field, the queries that are consta

Re: I/O read performance

On 1/13/11 3:51 PM, Reindl Harald wrote: Are you sure that the lags are really the query and not the connection? I have seen on a windows server with ipv7 large lags because mysql treid by every connect to make a dns-reverse-lookup first on ipv6 and after fail ipv4 "skip-name-resolve" in the my

Re: Rewrite SQL to stop table scan

tamp. What you want is this: SELECT COUNT(*) AS num FROM alerts WHERE stamp > DATE_SUB(NOW(), interval 300 second) AND devid=244; With this query, MySQL will run DATE_SUB() once, and then use the index on stamp (which I assume you have) to narrow down the result set. Steve -- MySQL General

Re: Group by question

n is not deterministic. If there are multiple rows per album_id, any one of those rows could provide the updated_at column that you're then using to order by. What you probably want is to select (and order by) the max(updated_at). Steve -- MySQL General Mailing List For list a

Re: Rewrite SQL to stop table scan

On 1/17/11 9:52 AM, Jerry Schwartz wrote: [JS] I don't understand how an index on a timestamp would help. Theoretically, each record could have a unique value for the timestamp; so the index would have an entry for each record. Would MySQL really use that in preference to, or in combination with,

Re: optimizing query

rticles table. Another aside -- I noticed you have index_articles_on_newsletter_id as well as index_articles_on_newsletter_id_and_created_at. The first index is redundant, the second index will take care of it. This will slow down your INSERT/UPDATE/DELETE queries to some degree. Steve --

Re: InnoDB and rsync

On 1/25/2011 8:00 AM, Robinson, Eric wrote: your whole solution is crippled because why in the world are you killing your salves and reinit them without any reason daily? There is a very good reason: it is the phenomenon of row drift. The master and slave can appear to be in good sync, but often

  1   2   3   4   5   6   7   8   9   10   >