Re: Date Problems

within double quotes: $query_Recordset1 = "SELECT .. .FROM Results"; You need to escape the quotes in your statement. Regards Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql.sock deleted

to be in /tmp whilst others expect it to be in the mysql directory. I find best solution to this problem is to start mysql, then create a symbolic link in the /tmp directory to the socket: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock This works on my systems, you may have to adjust to you

RE: Check out this Free software I found to document your IT infrastruct

then spam the list with an advert for McAfee! Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

High Performance MySQL on Amazon

October 31, 2004 £29.26 Does anyone know the difference between these two books? Has Derek Balling somehow absorbed Jeremy D. Zawodny to become Derek J. Balling? ;) Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

--replicate-rewrite-db fails when attempting to drop a table

ings replicate-do-db=livedb_backup replicate-rewrite-db=livedb->livedb_backup --->8- Thanks Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Trying to index a table - cant figure out best way

LEFT JOIN article_views ON article_views.article_id = articles.id WHERE ( date <= '2009-10-07' AND date >= '2009-10-01') GROUP BY article_id Any help would be greatly appreciated. Thanks Ian

Re: Trying to index a table - cant figure out best way

articles eq_ref PRIMARY PRIMARY 8 database.article_views.article_id 1 Using where No difference :/ And I used the query below so its only 1 week and not the 2-3 weeks in the table. Thanks anyway :) Ian 2009/10/9 Daevid Vincent > ALTER TABLE articles ADD INDEX date_idx (date); > > > -

Simple Query Question

post_id ORDER BY views DESC LIMIT 10 Any ideas as to whats wrong. I know its something simple, I just cant put my finger on it. Thanks in advance, Ian

Re: Simple Query Question

Hi, Thanks, I just checked and it was a memcache that was caching the output. See I knew it was a simple solution ;) Thanks for the effort everyone and sorry for wasting time. Regards Ian 2009/12/17 Aleksandar Bradaric > Hi Ian, > > Why do you think something's wrong? Here i

Re: HA & Scalability w MySQL + SAN + VMWare: Architecture Suggestion Wanted

s, If you can't alter the application to split reads and writes, why not let MySQL Proxy to do it for you? http://forge.mysql.com/wiki/MySQL_Proxy Combine this with haproxy and you could build a multi-master environment with each master having any number of slaves. Set MySQL Proxy to send

Re: How to encrypt Text and still be able to use full text search? 3rd Attempt ++

and that you don't want to give too much away. I can say one thing though, in order for the data to be indexed by MySQL , it has to be in an unencrypted form somewhere in the database. There is no way I know to get around this, but I hope someone can correct me :) Regards Ian -- --

Re: Storing Apache logs in MySQL.

d? Hi, An easier method may be to install mod_log_mysql on each of the Apache servers and log directly to the central MySQL installation. Regards Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

/tmp/mysql.sock dissapears

ey_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout The machine in question is a dual xeon with 4gig of ram. Any ideas? Thanks in advance, Ian

Re: /tmp/mysql.sock dissapears

basedir=/usr/local --datadir=/var/db/mysql --user=mysql --pid-file=/var/db/mysql/hostname.pid --port=3306 --socket=/tmp/mysql.sock --myisam-recover=BACKUP,FORCE We could try that, but why would it behave differently to the current sh script? Thanks Ian On Thu, Feb 28, 2008 at 7:43 PM, Vidal Garza

Re: /tmp/mysql.sock dissapears

Hi, Okay, I have added that and will wait and see when it happens again if there is anything in that log. Just out of interest, does that log show anything different to the /var/db/mysql/hostnameofunit.err file ? Cheers Ian On Thu, Feb 28, 2008 at 8:44 PM, Vidal Garza <[EMAIL PROTECTED]>

Re: /tmp/mysql.sock dissapears

Hi, No, there is nothing in there cleaning /tmp. Mind you, further investigating there are still some temp files in there from last year - so the directory isnt getting wiped clean. Thanks :) On Fri, Feb 29, 2008 at 3:36 AM, Steve Bernacki <[EMAIL PROTECTED]> wrote: > Does the system in questio

Re: /tmp/mysql.sock dissapears

. Cheers Ian On Fri, Feb 29, 2008 at 12:43 PM, Sebastian Mendel <[EMAIL PROTECTED]> wrote: > Ian schrieb: > > Hi, > > > > I am running mysql 5.0.45 on freebsd 4.11 and for some strange reason > > /tmp/mysql.sock keeps on disappearing and we are forced to kill -9 mysq

Re: /tmp/mysql.sock dissapears

Hi, I dont know about network, but I know using php we cant access anything in MySQL once the file is gone. When it happens again, ill be sure to check network. Cheers Ian On Fri, Feb 29, 2008 at 12:54 PM, Sebastian Mendel <[EMAIL PROTECTED]> wrote: > Ian schrieb: > > Hi, &g

Re: /tmp/mysql.sock dissapears

and mysql stops working. Thanks Ian On Fri, Feb 29, 2008 at 5:46 PM, Vidal Garza <[EMAIL PROTECTED]> wrote: > Ian escribió: > > Hi, > > > > Okay, I have added that and will wait and see when it happens again if > there > > is anything in that log. Just

Re: system : Install Mysql 5.x binaries with php4 on Debian

sock I consider the latter the best option as it wont break anything else that depends on the socket. Regards Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Type Mismatch

instead of 'Long'. If this is the case you may have to specifically CAST it into a number type in your SQL statement or use one of the VBScript functions CInt(), CLng(), CDbl(), CSng() etc. Hope this helps Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

max_user_connections -- help

the connection was refused. Is this a known problem? Is there a solution? - ian -- | Ian SalesUnmetered & ADSL solutions | database administrator for Home & Business | PlusNet Technologies Ltd. @ http://www.plus.net + - My Referrals - It

table full error

M table it works fine. Thanks, -- Ian - 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

64bit mysql and gcc

will have done this before. Thanks in advance, IW. Ian Waters [EMAIL PROTECTED]/interesting.net/geekninja.net/geekcoop.com PGP Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xFF7EE368 - Befor

Re: 64bit mysql and gcc

rnaca, Cyprus ><___/ www.mysql.com > Ian Waters [EMAIL PROTECTED]/interesting.net/geekninja.net/geekcoop.com PGP Public Key: http://pgp.mit.edu:11371/pks/lookup?op=get&search=0xFF7EE368 - Before

Re: 64bit mysql and gcc

Here is the 2.8 package I just downloaded from one of your mirror sites. [reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin> ls mysqld mysqld* [reckon]/vol0/homes/ian/tmp/mysql-3.23.46-sun-solaris2.8-sparc/bin> file mysqld mysqld: ELF 32-bit MSB executable SPARC Ver

RE: 64bit mysql and gcc

(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 > IW. Ian Wa

Group-wise maximum

have to handle grouping 600,000 rows! Is that correct? Is there a better solution? I tried using sub queries but that didn't seem to be much faster. If I had 1,000 items to search for 60 attributes the sub queries would be called 60,000 times. Any ideas? Thanks! Ian --

MySQL crashes

te, I altered some my.cnf parameters, and then the site stayed up for 14 days before doing the same. This site is identical to others I have seen - that are running with no issues. Could this be hardware (memory related)? Regards, Ian Collins.

Re: How To Pronounce MySQL

k with the ANSI pronunciation, although you still hear "sequel" being used today... and not just by old-timers :-) - ian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Importing 3Gb File

-timeout Does anyone have any advice as to what I could change to make it import, and not break half way through. The command im running to import is: mysql -n -f -p < alldb.sql Thanks in advance, Ian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscr

FW: Importing 3Gb File

Sorry, forgot to send to the list aswell. My reply is at the bottom. > -Original Message- > From: Ian Barnes [mailto:[EMAIL PROTECTED] > Sent: 08 June 2006 09:58 PM > To: 'Kishore Jalleda' > Subject: RE: Importing 3Gb File > > > > > -Origina

Repairing table problem

the memory that MySQL is allowed to use? I am running MySQL 5.0.18 Thanks, Ian

RE: Importing 3Gb File

sslist | ++--+---+-+-+--+---+ --+ 2 rows in set (0.00 sec) I have put more RAM in (I now have 768Mb's, as well as 3Gig of SWAP). Thanks for the suggestions! Cheers Ian > -Original Message- > From: mos [mailto:[EMAIL PROTECTED] > Sent: 09 June 2006 07:15 PM > To

RE: Importing 3Gb File

3 sbsize infinity bytes vmemoryuse infinity kb [EMAIL PROTECTED] /home # I have upped my RAM in the unit with 512Mb to 768Mb, so I think I should have enough RAM now. Any other ideas? Thanks, Ian > -Original Message- > From: Jeremy Cole [mailto:[EMAIL PROTECTED] >

Re-importing a mysqldump file

, I need id to auto-increment and serverid to be set by something that I specify depending on what file im importing. Is this possible? Or would the best way be to import the dumped file into a temp table and then select out of the temp table into my correct table ? Thanks for any help! Ian

RE: Re-importing a mysqldump file

Hi, No unfortunately not... Cheers Ian > -Original Message- > From: John Meyer [mailto:[EMAIL PROTECTED] > Sent: 25 June 2006 05:41 PM > To: mysql@lists.mysql.com > Subject: Re: Re-importing a mysqldump file > > Ian Barnes wrote: > > Is this possible? Or woul

Doing sum's if certain conditions are true

in. Is there any way of achieving this via the sql query because the above is a hugely tedious way of doing it. I know mysql has an if() statement, but I have no idea how to implement it using what i want to achieve above. Thanks in advance. Ian

mysqldump quotes in MySQL 5.0.26

e on!!) What am I missing here? Has anyone else seen this? Regards, Ian Collins. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqldump quotes in MySQL 5.0.26

it. I've also tried the mysql -u root -p < file.sql as well with no difference. I actually got the database in by doing a "split -b 1000 dumpfile" as I can edit a 10Mb file, but not a 10Gb one - and then joining them back together - bit of a hack but it worked. Strange

mysql5 onHPUX - no entry for terminal type

) Any ideas? (It may sound trivial but we have automated test suites that break because of this). Regards, Ian Collins. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Full Table Scan when using Fulltext Match Clause and OR clause together

ings start to work well again, but alas my SQL is auto generated, and it's hard to tune things like that. Anyone have any feelings about this.. is it behaving correctly and my expectations or wrong or might it indicate a minor feature? Kindest Regards and Many thanks for your time! Ian.

mysql_real_query failed: Can't find file: ... .frm (errno: 24)

query failed: Can't find file: './sqllive/XHEAD.frm' (errno: 24) The query for this particular error was: select max(id) from XHEAD Regards, Ian. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Log file full of Got an error reading communication packets

r reading communication packets) 051004 22:08:34 Aborted connection 314 to db: 'sqllive' user: 'sqllive' host: `localhost' (Got an error reading communication packets) My /etc/my.cnf is: cat /etc/my.cnf [client] port=3306 socket=/tmp/mysql.sock [mysqld] port=3306 socket

mysql_real_query failed: Can't find file: ... .frm (errno: 24)

query failed: Can't find file: './sqllive/XHEAD.frm' (errno: 24) The query for this particular error was: select max(id) from XHEAD Regards, Ian. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql_real_query failed: Can't find file: ... .frm (errno: 24)

query failed: Can't find file: './sqllive/XHEAD.frm' (errno: 24) The query for this particular error was: select max(id) from XHEAD Regards, Ian. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Database design help

solutions but I would end up with hundreds of tables which I would like to avoid. Any help on the direction that I should go would be greatly appreciated. Ian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Database design help

s the way I would do it. What you think? mpneves On Wednesday 18 January 2006 18:09, Ian Klassen wrote: > Hi all, > > I'm trying to figure out a solution to the following problem. > > Let's say I have a store with various products. I take inventory of these > pr

Re: Database design help

2006-02-01 | 1 | 98 2006-04-01 | 1 | 50 date | product_id | rep 2006-01-01 | 1 | rep 1 2006-03-01 | 1 | rep 2 This seems to be the cleanest solution, other than requiring a table for every field that I want to track. Ian At 02:36 PM 1/18/2006 -0800, Ed Reed wrote: I built my inventory sy

Re: Database design help

f each field that changes into it's own table. Any recommendations? Thanks again. Ian At 12:35 AM 1/19/2006 +, Marco Neves wrote: Ian, I'ld like to help you, but a more specific db design would depend on more specific description on your application needs.

Re: Database design help

Rhino, I appreciate your comments. This wasn't meant to be a real world example. My actual application keeps track of changing data in a gas network. I wanted to simplify the problem to help in finding an answer to my dilemmas. Ian At 04:45 PM 1/20/2006 -0500, Rhino wrote: Ian, I

Re: Database design help

Hi Dan, It would be a pretty large table of changes, but this solution would work, if as you say, I don't mind making those sacrifices. Something to think about. Thanks. Ian At 03:59 PM 1/20/2006 -0600, Dan Buettner wrote: Perhaps you could use database triggers to keep track of

Query Help

d=cc.id AND cc.section=s.id AND s.scope='content' AND c.sectionid='1' ORDER BY cc.ordering, cc.title, c.ordering LIMIT 0,10; The error I get for both ones is: Unknown column 'c.access' in 'on clause' Thanks and sorry for the stupid question. Cheers Ian -

RE: Query Help

1' ORDER BY cc.ordering, cc.title, c.ordering LIMIT 0,10; Thanks, Ian -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: 24 January 2006 09:50 PM To: Ian Barnes Cc: mysql@lists.mysql.com Subject: Re: Query Help Ian Barnes wrote: >Hi, > >This is my curr

Replication for historical data

Hi, I have a customer who wants to be able to replicate their live MySQL database to a second server, but not to have any data deleted. i.e., they want to accumulate the data. I don't believe you can do this with replication. Does anyone know a way of doing this? Cheers, Ian. --

Replication for historical data

Hi, I have a customer who wants to be able to replicate their live MySQL database to a second server, but not to have any data deleted. i.e., they want to accumulate the data. I don't believe you can do this with replication. Does anyone know a way of doing this? Cheers, Ian. --

Re: How to Use Cascade Delete Properly

at http://www.lolajl.net/blog/ > "No greater injury can be done to any youth than to let him feel that > because he belongs to this or that race he will be advanced in life > regardless of his own merits or efforts." - Booker T. Washington > > -- Ian Simpson Award Winning System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to Use Cascade Delete Properly

ame foreign key three times. You should be ok as you are specifying a name for the constraint, and it checks for unique names. On Fri, 2009-01-02 at 06:03 -0500, Lola J. Lee Beno wrote: > Ian Simpson wrote: > > If you want deletes to be blocked, then you shouldn't be using ON DE

Re: [MySQL] Re: REPOST: ON DUPLICATE failure

on 5.1.30, it did the same thing, 2 rows. But at least it DID update on > 5.1.30, but not on 5.0.37. > -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MYSQLDUMP ERROR

state.sql > -- Connecting to 152.20.1.115... > mysqldump: Got error: 1044: Access denied for user 'dip'@'152.20.1.%' to > database 'dip' when doing LOCK TABLES > > Thanks, > Krishna Chandra Prajapati -- Ian Simpson System Administrator MyJobGroup --

Re: grant user create privilege

gt; > > > > > > mysql> create database testdb; > > ERROR 1044 (42000): Access denied for user 'user'@'localhost' to > > database 'testdb' > > > > Can someone point out the error of my ways? > > > > Many thanks,

Prevent execution of queries without a WHERE clause

me unwilling to experiment with them without advice, in case one of them disables networking or something similar. Hoping someone can help with this. Thanks -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

RE: Prevent execution of queries without a WHERE clause

gt; Regards > > John Daisley > Mobile +44(0)7812 451238 > Email j...@butterflysystems.co.uk > > Certified MySQL 5 Database Administrator (CMDBA) > Certified MySQL 5 Developer > Cognos BI Developer > > ------- > Sent from HP IPAQ mobile device. >

Re: Prevent execution of queries without a WHERE clause

ws unless the statment include a LIMIT clause > 3. Multiple-table SELECT statments are allowed only if MySQL will > examine no more than 1,000,000 rows to process the query. > > The --i-am-a-dummy option is a synonym for --safe-updates. :) > > Gluck > > Darren > &g

Re: Simply join that confuses me.

n I do something like this: > > SELECT > * from Projects where Project_ID = 5, > Name from People where Projects.Boss_ID = People.ID as Boss_Name, > Name from People where Projects.Admin_ID = People.ID as Admin_Name, > Name from People where Projects.Assistant_ID = People.ID as

Re: Remove 'debian-sys-maint' Account?

ost'. Has anyone ever removed this account? Do I need it or can > I safely remove this account? I don't understand why it's there. I > don't want to break MySQL even though there is no data or databases on > this machine but I would like to keep this as clean as possib

Re: Replication - LINUX to WIN

he INTERNET now has a personality. YOURS! See your Yahoo! Homepage. > http://in.yahoo.com/ -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: MySQL Storage Engine

purely from the webpage ? > > Cheers > Neil -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Replication - LINUX to WIN

Hi Vikram, As far as I know it's just table names: I think it's related to the fact that the Windows file system is case-insensitive, while Linux filesystems generally are not. On Thu, 2010-03-18 at 15:18 +0530, Vikram A wrote: > Hello Ian Simpson, > > Thank you for repl

RE: Question about DELETE

; > My question is: if I delete many records in a single delete statement > > (i.e., DELETE FROM table WHERE id = 1 AND id = 5 ... AND ID = 100) how many > > times are the foreign keys/indexes updated? > > > > Once for the entire DELETE operation or one time for each r

Re: Starting a 2nd MySQL instance on UNIX

Mark, When you try to log-in to the new instance, are you specifying the new port number to the client? If you don't give it the new port number, then it will connect to the default port, which is presumably your 4.0.20 instance. Mark-E wrote: I have a Solaris box where MySQL 4.0.20 instanc

Very slow inserts into InnoDB tables

entical table. The MySQL configuration of the two databases is identical, except for the tablespace file size (the new server has a larger tablespace defined), and the InnoDB logs (again, new server has larger logs). Can anybody suggest an area of investigation as to the cause? Thanks, -- Ian Simpso

Re: Very slow inserts into InnoDB tables

trx_commit Value: 1 Variable_name: sync_binlog Value: 0 Variable_name: innodb_locks_unsafe_for_binlog Value: OFF Thanks -- Ian Simpson On Fri, 2008-06-13 at 17:43 +0530, Alex Arul Lurthu wrote: > Please check if the my.cnf configurations to be the same. >

Re: Very slow inserts into InnoDB tables

Blk_read Blk_wrtn sda 88.47 782.20 998.77 9046888130 11551757459 The new server, which is just trying to handle replication Device:tps Blk_read/s Blk_wrtn/s Blk_read Blk_wrtn sda 77.83 1367.55 2914.72 358474084 764029986 Thanks

RE: Very slow inserts into InnoDB tables

this... Thanks for all your help  -- Ian Simpson On Fri, 2008-06-13 at 10:40 -0400, Jerry Schwartz wrote: > >Disk usage: the older server (the one that's running fine) is running > >more transactions per second, but has lower blocks written and read per > >second t

RE: Very slow inserts into InnoDB tables

go) suggest that the older server is handling roughly the same data quantities, but just using a much lower percentage of the drive's bandwidth. I can't seem to find a tool which reports on exactly how much write bandwidth a drive has; everything seems to focus on reading speed. Thanks, 

RE: Very slow inserts into InnoDB tables

rcentage of the bandwidth it's using, and then doing a calculation with those numbers to get the 100% value, but I don't know if that's valid, since there are generally a number of other operations going on at the same time. Thanks  -- Ian Simpson On Fri, 2008-06-13 at 08:48 -0700, Wm Mus

Re: Do I need to use GROUP BY to do this?

es_activity` ( >   `sales_id` int(11) NOT NULL auto_increment, >   `sales_date` datetime NOT NULL default '-00-00 00:00:00', >   `sales_type` tinyint(4) NOT NULL default '0', >   PRIMARY KEY  (`sales_id`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=

Re: Reset of Status Parameters

e current rate? > > Is there any way to reset that parameter so that the data can reflect > current without restarting the MySQL > > Thanks in advance > ..venu -- Ian Simpson System Administrator MyJobGroup This email may contain confidential information and is inten

Re: Do I need to use GROUP BY to do this?

ike: Datetypenumber 2008-06-15 1 4 2008-06-15 2 2 2008-06-16 1 2 2008-06-17 1 2 which is the data that you want in a different output format. Thanks On Mon, 2008-06-23 at 18:16 -0700, Grant Giddens wrote: > Ian, > > Thanks for the help

Re: delete query question

the deleted > rows..) > > Can't this be done in one query? Or two? > > Thanks, > > Jeff > > > > -- Ian Simpson System Administrator MyJobGroup This email may contain confidential information and is intended for the recipient(s) only. If an addressing o

RE: delete query question

http://dev.mysql.com/doc/refman/5.0/en/delete.html just search in the page for 'join' and you'll find the relevant section On Tue, 2008-07-08 at 11:35 -0400, Jeff Mckeon wrote: > > > -Original Message- > > From: Ian Simpson [mailto:[EMAIL PROTECTED] >

Re: Access denied for user 'debian-sys-maint'@'localhost'

bian-sys-maint'@'localhost' IDENTIFIED BY > PASSWORD 'LongPasswordHere' WITH GRANT OPTION > > To test it out, I try a mysql -u debian-sys-maint -p, type in the password > and get the "Access denied" error again. What's going on? Why can

RE: How do I (can I) use aggregate functions inside a select

Safe Data, Inc. > > (910) 285-7200 [EMAIL PROTECTED] > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > >

threading in mysql-embedded

ed so I ask. What are the rules for MyISAM and threads? Any general thoughts on what backend to use for mysql embedded also appreciated. We noticed that InnoDB seems to enjoy exit()ing on error conditions (like disk full) which isn't very nice. Ian -- MySQL General Mailing List For lis

Re: Relational Databasing on busy webserver

gt; I've said, we are dealing with at least 200,000 user records, probably > 300,000-400,000 in the next year. The User table contains at least 50 > attributes, 15 of which are Foreign Keys that link to tables that will > likely never change (the users choices for countryID, stateID

Odd crash with MySQL Embedded 5.1.28

So we're using MySQL Embedded in Amarok, it works fine for most of us that use 5.1, including myself. However the following backtrace is from the second person to have this issue. Its repeatable, happens at startup. Is there something about how their MySQL is setup on their system that could cause

Re: Odd crash with MySQL Embedded 5.1.28

On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote: > So we're using MySQL Embedded in Amarok, it works fine for most of us > that use 5.1, including myself. However the following backtrace is > from the second person to have this issue. Its repeatable,

Re: Odd crash with MySQL Embedded 5.1.28

your server groups are (usually just server, client) are incorrect How could they be incorrect? I only vaguely get what they are for, something about the config groups in my.cnf file. Ian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

how to figure out what options are supported, was Re: Odd crash with MySQL Embedded 5.1.28

On Fri, Sep 26, 2008 at 1:55 PM, Ian Monroe <[EMAIL PROTECTED]> wrote: > On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote: >> So we're using MySQL Embedded in Amarok, it works fine for most of us >> that use 5.1, including myself. However the fo

Re: Odd crash with MySQL Embedded 5.1.28

On Fri, Sep 26, 2008 at 1:55 PM, Ian Monroe <[EMAIL PROTECTED]> wrote: > On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]> wrote: >> So we're using MySQL Embedded in Amarok, it works fine for most of us >> that use 5.1, including myself. However the fo

Re: how to figure out what options are supported, was Re: Odd crash with MySQL Embedded 5.1.28

On Fri, Sep 26, 2008 at 4:15 PM, Dan Nelson <[EMAIL PROTECTED]> wrote: > In the last episode (Sep 26), Ian Monroe said: >> On Fri, Sep 26, 2008 at 1:55 PM, Ian Monroe <[EMAIL PROTECTED]> wrote: >> > On Fri, Sep 26, 2008 at 9:37 AM, Ian Monroe <[EMAIL PROTECTED]&g

Re: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'ODBC'@'localhost' (using password: YES)'

all is disabled.If this is caused by a firewall barrier please tell me > how to open the port in Nortan Internet Security. > > > Varuna -- Ian Simpson System Administrator MyJobGroup -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Confusion over query stratergy

it's doing a full table scan over all 29 million records. Whilst this query appears to run fast still, surly it's not right that a full table scan is needed? Thanks, Ian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL select basics

2008/10/17 dave aptiva <[EMAIL PROTECTED]>: > > I tried SELECT ID_number, max( count( CU_number ) ) but this causes an error > "# - Invalid use of group function " # sqlite3 SQLite version 3.5.9 Enter ".help" for instructions sqlite> create table moo (id_number, cu_number); sqlite> insert int

Re: REPLICATION

2008/10/16 Krishna Chandra Prajapati <[EMAIL PROTECTED]>: > I believe that yahoo, google and other companies must be generating reports. > How they are doing. Any Idea. This is how google do it: http://en.wikipedia.org/wiki/MapReduce Have you seen federated tables? Be aware of the performance on

Re: Confusion over query stratergy

2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>: > *How long does the second query actually take to run compared to first? Actually, really quickly - so quickly that I also suspected that a full table scan was not taking place. I'd like to understand how the output of EXPLAIN can differ from the act

Re: Confusion over query stratergy

2008/10/17 Brent Baisley <[EMAIL PROTECTED]>: > Why are you creating a subquery/derived table? > > Just change your limit to 1,2 > ORDER BY updates.AcctSessionTime DESC LIMIT 1,2 Because then the maths in the select part isn't executed, and I don't get the figures I need. -- MySQL General Maili

Re: FLOOR(DATE_ADD(CURDATE(), INTERVAL 4 MONTH)) -- ?

2008/10/17 Rob Wultsch <[EMAIL PROTECTED]>: > On Fri, Oct 17, 2008 at 1:33 PM, Rene Fournier <[EMAIL PROTECTED]> wrote: > >> Okay, I realize that query won't work, but that's essentially want I want >> to do: >> >> Add four months to the current date, then return the first day of that >> month, e.g

Re: DELETE - error_count

2008/10/17 Reyna.Sabina <[EMAIL PROTECTED]>: > Hi, > > Running Environment: > MySQL Server version: 5.0.45 > OS is Red-Hat 64-bit > > The table 'junk' doesn't have a row with id=4. Two tests to trap 'errors' > using DELETE follows: > Perhaps I'm missing something - but a delete matching no

  1   2   3   4   >