Something strange here...

2017-06-13 Thread Chris Knipe
Hi all, Can someone explain to me why this is happening please: mysql> SELECT * FROM CustomerDetails WHERE Username=’blah’\G *** 1. row *** EntryID: F83D4109-DCA8-426F-98B1-00B4AF117ACB Username: blah AccountVolume: 0 1 row

Re: need help from the list admin

2016-03-19 Thread Chris Knipe
On Fri, Mar 18, 2016 at 3:43 PM, Lentes, Bernd < bernd.len...@helmholtz-muenchen.de> wrote: > i need your help. I'm trying to write an e-Mail to the list for already > one week. I always get it back because it's classified as spam. > Ditto. I've pretty much given up on this list...

Re: need help from the list admin

2016-03-19 Thread Chris Knipe
yet, both of those messages made it through :-p >>> >>> Stick your domain in http://mxtoolbox.com to see if there's any >>> problems that >>> might be worth solving. If the mailserver classifies you as spam, that's >>> usually caused by something on your sid

Re: need help from the list admin

2016-03-18 Thread Chris Knipe
essages made it through :-p > > Stick your domain in http://mxtoolbox.com to see if there's any problems > that might be worth solving. If the mailserver classifies you as spam, > that's usually caused by something on your side :-) > > - Original Message - > > From:

Indexes strangeness

2016-02-24 Thread Chris Knipe
nx. -- Regards, Chris Knipe

Query Statistics...

2016-02-04 Thread Chris Knipe
already exist), how is this query logged in the statistics? When the ON DUPLICATE KEY UPDATE runs (i.e. it's updating a record), is it still logged as a INSERT query, or is it logged as a UPDATE query? Thnx. -- Regards, Chris Knipe

ORDER BY not using index?

2015-07-18 Thread Chris Knipe
| | | +--++--+--+--+---+-+--++--++-+---+ 2 rows in set (0.00 sec) -- Regards, Chris Knipe

Re: mysql strangeness...

2014-12-08 Thread Chris Knipe
On Mon, Dec 8, 2014 at 3:02 PM, Wagner Bianchi wagnerbianch...@gmail.com wrote: Hello Chris, Can pls you share the below command output... SHOW STATUS LIKE 'Threads%'; SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet; mysql SHOW STATUS LIKE 'Threads%';

RE: mysql strangeness...

2014-12-07 Thread Chris Knipe
the mysql client running on the same host as the mysql server, connected to localhost via TCP. Current connections to the DB was at about 200 out of 500 -- Chris. -Original Message- From: Chris Knipe [mailto:sav...@savage.za.org] Sent: Sunday, December 07, 2014 11:34 PM To: 'mysql

Avoiding table scans...

2014-07-24 Thread Chris Knipe
Hi All, I have a couple of *huge* tables, they're still busy populating, but once done I suspect it will hold well over 3 billion records (and that's more than likely the start of the problem). The mysql server is a highly optimized, powerful server with some 128GB ram, data + binlogs on RAID10

Re: Avoiding table scans...

2014-07-24 Thread Chris Knipe
On Thu, Jul 24, 2014 at 11:47 AM, Johan De Meersman vegiv...@tuxera.be wrote: - Original Message - From: Chris Knipe sav...@savage.za.org To: mysql@lists.mysql.com Sent: Thursday, 24 July, 2014 11:17:50 AM Subject: Avoiding table scans... mysql SELECT MIN(ArtNumber) AS ArtNumber

Re: Avoiding table scans...

2014-07-24 Thread Chris Knipe
Try this SELECT ArtNumber, MessageID FROM 78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNumber=(SELECT MIN(ArtNumber) FROM 78168ea0a9b3b513a1f2d39b559b406e WHERE ArtNumber2118806) +---+---+ | ArtNumber | MessageID |

Re: hypothetical question about data storage

2013-07-26 Thread Chris Knipe
is good with enormous amounts of huge files (media farm here), not sure how it'd fare with smaller files. Hope that helps, Johan - Original Message - From: Chris Knipe sav...@savage.za.org To: mysql@lists.mysql.com Sent: Thursday, 25 July, 2013 11:53:53 PM Subject: hypothetical

Re: hypothetical question about data storage

2013-07-26 Thread Chris Knipe
- From: ckn...@savage.za.org [mailto:ckn...@savage.za.org] On Behalf Of Chris Knipe Sent: Friday, July 26, 2013 12:30 AM To: Johan De Meersman Cc: mysql Subject: Re: hypothetical question about data storage Hi All, Thanks for the responces, and I do concur. I was taking a stab in the dark

hypothetical question about data storage

2013-07-25 Thread Chris Knipe
Hi all, We run an VERY io intensive file application service. Currently, our problem is that our disk spindles are being completely killed due to insufficient SEEK time on the hard drives (NOT physical read/write speeds). We have an directory structure where the files are stored based on the

Re: Possible causes of table crashing

2010-11-30 Thread Chris Knipe
://mark.goodge.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=sav...@savage.za.org -- Regards, Chris Knipe

Where to index - over 15m records and growing

2010-05-07 Thread Chris Knipe
SELECT COUNT(EntryID) FROM IVAOData; ## Grows by a few thousand records per day. ++ | COUNT(EntryID) | ++ | 13130747 | ++ 1 row in set (0.00 sec) -- Regards, Chris Knipe

Re: Where to index - over 15m records and growing

2010-05-07 Thread Chris Knipe
optimizing your query if required... Thanks. Anirudh Sundar On Fri, May 7, 2010 at 12:14 PM, Chris Knipe sav...@savage.za.org wrote: Hi All, I have a huge issue with a query - it copies the entire table to a tmp table when executing the query - and it's a big ass table Any help

Re: Where to index - over 15m records and growing

2010-05-07 Thread Chris Knipe
running... 3948 Seconds the last time I checked... -- Regards, Chris Knipe

Small issue with FULLTEXT searches

2010-04-29 Thread Chris Knipe
been created. Thanks for the assistance. -- Regards, Chris Knipe

Re: Update Doesn't Update!

2009-12-11 Thread Chris Knipe
Quoting cars...@bitbybit.dk: Of course you can have ID=0. Definately agree mysql DESCRIBE test; +-+-+--+-+-++ | Field | Type| Null | Key | Default | Extra |

Re: Server-Crash - What to do?

2006-08-27 Thread Chris Knipe
PS: I already tried with myisamchk -r -o *.MY*, but then all datasets are gone and the table is empty. :-( man myisamchk I tried myisamchk already. But after running the above rescue attempt, the tables are empty. Then I hope you made backups You, do keep backups right? -- Chris --

Re: Server-Crash - What to do?

2006-08-27 Thread Chris Knipe
On filesystem level I made all rescue trials. My problem is, that only the MYD file is still available. I tried reconstructing it with myisamchk -r -o table_name.MYD, but as I said without the wanted result. MYD is your data, MYI is your indexes (Indexes are easy to rebuild, you should not

IP Address Function?

2006-08-26 Thread Chris Knipe
Hi, I need to make *allot* of queries from a application dealing with IP Addresses. At the moment, I'm storing IP addresses as a VARCHAR(16). I would *like* to store them as Integers by converting the IP to it's numerical equivalent. I believe this would also save a enormous amount of

Re: IP Address Function?

2006-08-26 Thread Chris Knipe
RTFM! Let that be a good lesson for me now :) INET_ATON() and INET_NTOA() Brilliant!!! Regards, Chris. - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, August 26, 2006 9:03 PM Subject: IP Address Function? Hi, I need to make

Re: MySQL NOW() function producing 0000-00-00 00:00:00

2006-08-25 Thread Chris Knipe
We are using an NOW() function in our database and occasionally it produces odd results. There are entries where it states: -00-00 00:00:00 instead of the current time. Is this a bug, or are we using the function incorrectly? After patiently injecting at about 400 queries per seconds, a

Re: Testing Email

2006-08-25 Thread Chris Knipe
INSERT INTO a VALUES (NOW()) ? Regards, Chris. - Original Message - From: Renato Golin [EMAIL PROTECTED] To: Nicholas Vettese [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, August 25, 2006 4:31 PM Subject: Re: Testing Email Nicholas Vettese wrote: I have been having

Re: MySQL NOW() function producing 0000-00-00 00:00:00

2006-08-25 Thread Chris Knipe
Doh.. Wrong email ;) INSERT INTO a VALUES (NOW()) ? Regards, Chris. - Original Message - From: Renato Golin [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, August 25, 2006 4:30 PM Subject: Re: MySQL NOW() function

What to index?

2006-08-22 Thread Chris Knipe
Hi, I got 4 relatively big (for me at least) queries. At the moment, the data in the tables are merely test data, but once the system goes into production, I'm expecting millions of records in most of the tables. I'm trying very hard thus to optimise my queries and tables to ensure I get a

Re: MySQL 4.0.27-client and MySQL-4.1.21 server

2006-08-22 Thread Chris Knipe
http://dev.mysql.com/doc/mysql/en/old-client.html Regards, Chris. - Original Message - From: Odhiambo Washington [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, August 22, 2006 7:38 PM Subject: MySQL 4.0.27-client and MySQL-4.1.21 server hi Why is it that I cannot

Re: Audit trail

2006-08-21 Thread Chris Knipe
Well MySQL will see all the changes coming from a single user (the user who the web site connects to the database as). You'll have to add your own routines to log that info to a table or something... Unless ofcourse, I'm missing something, which I doubt :) Regards, Chris. - Original

PURGE MASTER LOGS

2005-08-17 Thread Chris Knipe
Lo everyone, Small issue.. MySQL 4.1.12... PURGE MASTER LOGS BEFORE DATE_SUB(NOW(), INTERVAL 10 DAY); Absolutely nothing happens PURGE MASTER LOGS TO 'blah-bin.00030'; Logs are cleared immediately. Any reason why LOGS BEFORE is not working??? Thanks, Chris. -- MySQL General

database problems.

2005-07-20 Thread Chris Knipe
Hi all, The moral of the story, is don't run out of disk space, but it's a bit to late for that now. A quick scenario One master server, two backups replicating from the master. Our data and bin logs are on two different partitions, and the partition holding the bin logs, ran out of disk

Re: random rows selection

2005-07-20 Thread Chris Knipe
Put a index on col3 and it will be faster. That's the only way as far as I know. -- Chris. - Original Message - From: Michael Monashev [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, July 20, 2005 3:04 PM Subject: random rows selection Hello, How to select 5 random

urgent 4.1.11 / 4.1.12 upgrade

2005-06-09 Thread Chris Knipe
Hi, We've just upgraded (via FreeBSD Ports) our one database from 4.1.11 to 4.1.12, and we are being hit by http://bugs.mysql.com/bug.php?id=10674 - only on certain queries, using rather large temp tables. Now, from what I understand, there is a 4.1.12-1 available? Where is the source? It

memory errors / crashes

2005-05-09 Thread Chris Knipe
We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=536870912 read_buffer_size=2093056 max_used_connections=418 max_connections=2048 threads_connected=404

Re: Migrating Database

2005-05-08 Thread Chris Knipe
Temporary replication comes to mind fs hot copy as well (maybe) -- Chris. I love deadlines. I especially love the whooshing sound they make as they fly by... - Douglas Adams, 'Hitchhiker's Guide to the Galaxy' - Original Message - From: Brian Erickson [EMAIL PROTECTED] To:

where and dates

2005-05-05 Thread Chris Knipe
Hi, I dont think it's needed to go into to much details here but the query: SELECT CONCAT(Airports.IATA, ' - ', Airports.Name) AS ArrivingFrom, ADDTIME(FlightData.TimeStamp, SUBTIME(FlightData.Enroute,DATE_FORMAT(SUBTIME(FlightData.TimeStamp,FlightData.ActDepTime),'%H:%i:%s'))) AS

Re: where and dates

2005-05-05 Thread Chris Knipe
Found my problem... Thanks anyways :) -- Chris. I love deadlines. I especially love the whooshing sound they make as they fly by... - Douglas Adams, 'Hitchhiker's Guide to the Galaxy' - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, May

High Load testing

2005-05-04 Thread Chris Knipe
Hi, I used sql-bench, but that is testing things we already know. We want to establish how many concurrent connections / queries our database server can handle before it starts getting into trouble (no, a different one from the email of last night). This system is a dual proc with 4GB ram and

mysql mem usage

2005-05-03 Thread Chris Knipe
Hi, I have a P4 system with 1GB Ram and 512MB Swap (a little low I know). I'm running a multi threaded MySQL installation on it. With a bit of shock, I realised today that I ran completely out of swap space!!! Each MySQL thread is consuming about 160MB of ram, and I had close to 40 threads

Re: mysql mem usage

2005-05-03 Thread Chris Knipe
the whooshing sound they make as they fly by... - Douglas Adams, 'Hitchhiker's Guide to the Galaxy' - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, May 03, 2005 7:34 PM Subject: Re: mysql mem usage

Re: mysql mem usage

2005-05-03 Thread Chris Knipe
PID USERNAME PRI NICE SIZERES STATETIME WCPUCPU COMMAND 55651 mysql 8 12 138M 33524K nanslp 0:21 0.00% 0.00% mysqld 55649 mysql 20 14 138M 33524K pause0:21 0.00% 0.00% mysqld 55866 mysql 4 14 138M 33524K sbwait 0:12 0.00% 0.00% mysqld Ya,

Re: LEFT JOINS same data twice?

2005-04-15 Thread Chris Knipe
SELECT tlb1.DepartureLocation AS Departure, tbl1.DepartureLocation AS Destination LEFT JOIN DepartureLocation ON tlb2.DepartureID=tlb1.LocationID LEFT JOIN DepartureLocation ON tbl2.ArrivalID=tbl1.LocationID ORDER BY tbl2.Time etc etc etc I get ERROR 1066 (42000): Not unique table/alias:

Re: LEFT JOINS same data twice?

2005-04-15 Thread Chris Knipe
I eliminated your GROUP BY clause because you weren't actually GROUPing anything. You weren't looking for a MIN(), a MAX(), an AVG(), or anything else that GROUP BY was intended to be used for. That method of de-duplicating results will return potentially misleading information as it will randomly

very complicated queries (for me at least).

2005-04-14 Thread Chris Knipe
It's official. I need help ;) Let's do the table structures quickly. mysql DESCRIBE FlightData; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra |

Re: update ... where col is null problem.

2005-04-14 Thread Chris Knipe
I use = 0. It works for me. -- Chris. I love deadlines. I especially love the whooshing sound they make as they fly by... - Douglas Adams, 'Hitchhiker's Guide to the Galaxy' - Original Message - From: Emil Wilmanski [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, April 14,

LEFT JOINS same data twice?

2005-04-12 Thread Chris Knipe
Hi, Is it possible to left join the same data twice? TBL ONE: LocationID Location, varchar(100) TBL TWO: DepartureID, ArrivalID, Time SELECT tlb1.DepartureLocation AS Departure, tbl1.DepartureLocation AS Destination LEFT JOIN DepartureLocation ON tlb2.DepartureID=tlb1.LocationID LEFT JOIN

Re: Ms Sql unique identifier field

2005-03-18 Thread Chris Knipe
AUTO_INCREMENT is not the same as newid(). Frankly, something like newid() would be very useful in MySQL. -- Chris. - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, March 17, 2005 5:53 PM Subject: Re: Ms Sql unique identifier field

replication errors

2005-03-10 Thread Chris Knipe
Lo again, Master and Slave server, both running 5.0.2-LOG (Exactly the same versions). On the master, everything is working fine. Data that gets inserted / updated / deleted etc goes into the bin log, and gets replicated to the slave. HOWEVER On the slave, I am getting syntax errors from the

Re: replication errors

2005-03-10 Thread Chris Knipe
Chris Knipe wrote: [..] Sure, there is a syntax error in the query - yes. But why does the master not put the complete query in the bin log? This is the second time in 3 days that it has happened now. Whilst we are on this, how do I tell the slave to skip the query and proceed

Re: replication errors

2005-03-10 Thread Chris Knipe
Chris Knipe wrote: [..] Sure, there is a syntax error in the query - yes. But why does the master not put the complete query in the bin log? This is the second time in 3 days that it has happened now. Whilst we are on this, how do I tell the slave to skip the query and proceed

Re: replication errors

2005-03-10 Thread Chris Knipe
- Original Message - From: Richard Lynch [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, March 11, 2005 12:08 AM Subject: Re: replication errors mysql SELECT COUNT(RadAcctId) FROM RadiusAccounting; +--+ | COUNT(RadAcctId

Re: replication errors

2005-03-10 Thread Chris Knipe
So there's already data missing on the slave *shrugs* Yep, you told it to SKIP ERRORS. That means that if any query generates an error, for any reason, it's just going to skip over it and move on. So data was missing on your slave the moment you restarted replication -- it skipped the

safe way of replication?

2005-03-09 Thread Chris Knipe
Lo all, Just wondering... Would the below be considered a safe way to do replication... MasterBD: One Database (most Critical) SlaveDB: Replicating all databases from MasterBD as well as hosting allot of other 3rd party, or customer DBs. Basically, the MasterBD holds a single critical

Re: safe way of replication?

2005-03-09 Thread Chris Knipe
. I'll stop replicating mysql tables then... Thanks ;) -- Chris. - Original Message - From: Gary Richardson [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, March 09, 2005 6:23 PM Subject: Re: safe way of replication? I would probably

two-way replication

2005-02-28 Thread Chris Knipe
Hi, Is two-way replication possible with MySQL 5.x? Any good sites / docs describing this type of setup? -- Chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: two-way replication

2005-02-28 Thread Chris Knipe
- Original Message - From: [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Monday, February 28, 2005 7:11 PM Subject: Re: two-way replication Chris Knipe [EMAIL PROTECTED] wrote on 02/28/2005 11:53:14 AM: Hi, Is two-way replication possible with MySQL

first day of week/month

2004-10-18 Thread Chris Knipe
Hi, I know this might be a little silly, but can anyone give me a example on how to get the date of the first day of a week and month? -- Chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

*very* strange...

2004-03-19 Thread Chris Knipe
Lo everyone, I'm *baffled* completely I've never seen something like this before. : I tried this exact query from PHP, Perl, as well as the MySQL thingy... They ALL give the same result - it must therefore be my table mysql SELECT VERSION(); ++ | VERSION() |

Re: *very* strange...

2004-03-19 Thread Chris Knipe
insert into table (username, password) values ('username', 'password') Skip out the username= and password= part. What you are ending up doing here is that the values portion of the insert statement, these two You may kick my ass... Royally. Sorry, I feel like a phrick to say the least...

sub query format...

2003-12-03 Thread Chris Knipe
Lo all, What's the format for a sub query in MySQL?? I've tried the below with a few variants but I can't seem to get it sorted... SELECT songlist.ID AS ID, songlist.duration AS Duration, songlist.artist AS Artist, songlist.title AS Title, songlist.filename AS

Re: How to pass syslog data to a MySql Database?

2003-12-03 Thread Chris Knipe
Have a look on sourceforge. I think it's called mylogd or something similar. It's syslogd with sql support in it. Alternatively, a simple perl script will be able to parse the data and insert it manually into a db. -- me - Original Message - From: [EMAIL PROTECTED] To: [EMAIL

Re: What is a good benchmark?

2003-07-23 Thread Chris Knipe
+--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.91 sec) PIII 850, with 1GB Ram. -

Re: MySQL 4.0.12 proftpd 1.2.8

2003-06-02 Thread Chris Knipe
Jun 02 08:07:17 mod_sql/4.10[1108]: message: 'Unknown column 'password' in 'field list'' mysql SELECT * FROM users WHERE userid = test - ; ++-+--+--+-+--+---+-

unique select between two tables...

2003-01-12 Thread Chris Knipe
lo everyone, I have two tables Both have a DebtCode VARCHAR(6) in them, and both has UNIQUE Indexes on them. How can I select DebtCode as being unique in both tables? DebtCode in both tables, will be three alphabetical characters, followed by three numbers, like ABC001 ... ABC999, etc etc

Re: unique select between two tables...

2003-01-12 Thread Chris Knipe
| +++ | 3 | 79 | +++ 1 row in set (0.02 sec) mysql SELECT COUNT(DISTINCT DebtCode) AS table2 FROM table2 WHERE DebtCode LIKE 'CHR%'; +--+ | table2 | +--+ |0 | +--+ 1 row in set (0.00 sec) -- me - Original Message - From: Chris Knipe [EMAIL PROTECTED

Re: request

2002-12-21 Thread Chris Knipe
LOOL! This *IS* a joke right? ;) - Original Message - From: lateef ayinla [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 22, 2002 2:13 AM Subject: request Dear sir, i come across yourmanual [mySQL Reference] when browsing through the

table upgrades

2002-12-06 Thread Chris Knipe
Lo all, If I have a database with various tables, and I want to upgrade the tables and the data in the tables, will it screw up the permissions assigned to users if I use DROP TABLE / CREATE TABLE (to recreate the changed tables), and then just populate them with the data again? I'm doing it

Re: this is WEAK!

2002-11-27 Thread Chris Knipe
where member='me ' is not the same as where member='me' ('me ' != 'me') I've noticed this as well with just about any mysql version, on any platform. The tables / columns really isn't important here IMHO... From what I can see, trailing spaces are always droped, which shouldn't be. -

Re: Is it possible to export data from access to MySQL?

2002-11-26 Thread Chris Knipe
MySQL-Front is quite good for this... - Original Message - From: Steve Jackson [EMAIL PROTECTED] To: MySQL General Mailing list [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 4:37 PM Subject: Is it possible to export data from access to MySQL? Is it possible to export data from MS

Two queries, can I make it one?

2002-10-16 Thread Chris Knipe
Lo everyone, I have a bit of a dilemma. I use MySQL for all my authentication (user accounts etc, via ftp / mail / radius / http / etc), and currently am using PureFTPD as my FTPD to allow my clients to upload web sites. I use the following to authenticate users for their personal web space...

Re: Lost connections on Freebsd

2002-08-18 Thread Chris Knipe
Lo Michael, I digged a bit more, and while running under debug mode, MySQL doesnt crash, it does complain about a bad file descriptor on /etc/hosts.allow. If this is the cause of the failure, there might be a possibly bug in the code, because I really think it's arb that the entire MySQL needs

Re: Lost connections on Freebsd

2002-08-18 Thread Chris Knipe
...or you have too many open files in the system.You reach the max. number of files which can be opened by the OS.Try to increase file-max from /proc/sys/fs. Highly doubtful. It's a brand new server installation, exactly the same as all my others, and it's not doing half as much as the

Re: Lost connections on Freebsd

2002-08-18 Thread Chris Knipe
/ and reinstall. - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, August 18, 2002 8:01 PM Subject: Re: Lost connections on Freebsd For sure Bad file descriptor error occur because your kernel it's not able

Re: Another one on lost connections( using web interface)

2002-08-18 Thread Chris Knipe
PHP's more than likely just loosing persistent connections to the DB. It's a coding thing I think... You need to call mysql_connect() on every page where you need to use the database, even if you use mysql_pconnect(). If there's a mysql specific error, I think MySQL would most definitely write

Re: Lost connections on Freebsd

2002-08-18 Thread Chris Knipe
the errors now on every single query. Running under gdb also doesn't return anything (or I'm debugging it wrong?) MySQL's error log is empty - nothing logged -- me - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Victoria

Re: Urgent: lost connections,

2002-08-17 Thread Chris Knipe
Lo Victoria FreeBSD 4.6-STABLE (Master), MySQL 3.23.51 Windows 2000 Professional (Slave):, MySQL 3.23.49-nt I've recompiled the master about three times now, and it still crashed. Eventually, it came to such a extend that the moment I open port 3306 MySQL would crash. I can just use telnet ip

Re: I want to add up in a select Statement

2002-08-17 Thread Chris Knipe
sqlst = update sfproducts set projectdonations = projectdonations + testvalue WHERE prodID = ' sProdID ' ^^ $sqlst = update sfproducts set projectdonations = projectdomains + . $testvalue . WHERE prodID = ' . $sProdID . '; $sqlstr then looks like this: update sfproducts set

where clause structures

2002-08-17 Thread Chris Knipe
Lo everyone, I seem to be having a problem with the structuring of my query - more specifically, with the WHERE clause... mysql SELECT ZoneName - FROM CompanyDNSZones - LEFT JOIN CompanyDetails ON CompanyDetails.CompanyID=CompanyDNSZones.CompanyID - WHERE

Re: where clause structures

2002-08-17 Thread Chris Knipe
| || | ZoneServices | set('HasMail','HasMailingList','HasBackupMail','IsMegaDNS','IsSecondary') | | MUL | || - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 17, 2002 11:44 PM Subject: where clause structures

Urgent: lost connections,

2002-08-16 Thread Chris Knipe
Lo everyone, I've implemented replication on my MySQL Server... The master is mysql 3.23 (FreeBSD Ports), and my one and only slave is mysql 3.23 (Win32). I added the slave so that I can have a hardcopy / backup database in the event that I have a data loss on the master. This is all very

Re: can't use the table. What happen, please!!!!!!!!!!

2002-08-09 Thread Chris Knipe
THe PHP's prob still on the test database. You can try mysql_select_db(databasename); before you're query. - Original Message - From: Cliff [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 10, 2002 2:07 AM Subject: Re: can't use the table. What happen, please!!

--bind-address

2002-07-15 Thread Chris Knipe
Lo all, Can MySQL bind to two or more IP addresses? i.e. --bind-address 127.0.0.1 --bind-address x.x.x.x --bind-address y.y.y.y ? Thanks, -- me query - Before posting, please check: http://www.mysql.com/manual.php

Don't even know where to start on this one!!!

2002-06-18 Thread Chris Knipe
Lo all, I don't know if this can be reproduced, whether it's just general coding errors, or whether it's simply a Windows thing But I do my development on a NT 4.0 system, and I've been starting to notice rather weird things I use various languages (Perl, PHP, Delphi, C, etc), all of

Don't even know where to start on this one

2002-06-18 Thread Chris Knipe
Lo all, I don't know if this can be reproduced, whether it's just general coding errors, or whether it's simply a Windows thing But I do my development on a NT 4.0 system, and I've been starting to notice rather weird things I use various languages (Perl, PHP, Delphi, C, etc), all of

Re: Don't even know where to start on this one

2002-06-18 Thread Chris Knipe
My PHP code also use persistent connections, and I don't think this is the problem, but basically, how more queries I throw at MySQL how more my PC crawls down to a halt - even after the application with the queries disconnected from the database. I can understand that my system may take

LEFT JOIN again... Although, this time I think it's a design flaw rather than a query one....

2002-06-16 Thread Chris Knipe
Hiya again, Ok, based on all the info, feedback and help I got the last time, I was able to construct the following query: mysql SELECT weather_data.Temp, -weather_locations.Name - FROM weather_data - LEFT JOIN weather_data ON -

Re: LEFT JOIN again... Although, this time I think it's a design flaw rather than a query one....

2002-06-16 Thread Chris Knipe
Message - From: Peter Normann [EMAIL PROTECTED] To: 'Chris Knipe' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, June 16, 2002 5:44 PM Subject: RE: LEFT JOIN again... Although, this time I think it's a design flaw rather than a query one Sorry, I didn't read the mail through before

Re: LEFT JOIN again... Although, this time I think it's a design flaw rather than a query one....

2002-06-16 Thread Chris Knipe
know what's missing, I wont mind finding out :-) Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: Peter Normann [EMAIL PROTECTED] To: 'Chris Knipe' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, June

Re: table is read only when DB copied from Win to UNIX

2002-06-12 Thread Chris Knipe
Don't copy the physical files. Use mysqldump and mysqlimport instead. Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: Francisco Reinaldo [EMAIL PROTECTED] To: Tonu Samuel [EMAIL PROTECTED] Cc: MySQL

Re: 45 seconds

2002-06-10 Thread Chris Knipe
I have multiple tables on a 166MMX with 64MB ram, all containing more than 250,000 records each Mine takes less than 5 seconds I think there's something wrong at your side :-) Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582

Storing PGP keys

2002-06-08 Thread Chris Knipe
them via the pgp binaries? I'm intending to use PGP keys to establish authentication (trusts) from incoming email messages to register items in a database... Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582

Unique Indexes across multiple columns

2002-06-08 Thread Chris Knipe
Hi again, Not to long ago, I had a query regarding the best way to store IP addresses in a DB, and make sure that they are unique. It was pointed out to me that I could use four smallint columns instead of a varchar to store these numbers, and just implement a UNIQUE index across all four

Re: newbie

2002-06-07 Thread Chris Knipe
INSERT INTO table (column) VALUES ('path'); I'd recommend you goto www.mysql.com and download the manual - then read it. Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: Silmara Cristina Basso [EMAIL

Re: Re: insert

2002-06-07 Thread Chris Knipe
Escape the \ like so: 'c:\\temp\\calc.exe' It's all in the manuals. Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From: Silmara Cristina Basso To: [EMAIL PROTECTED] Sent: Friday

Re: I KNOW one of you LISTers has experienced this

2002-06-06 Thread Chris Knipe
Only users of the Administrators group on NT can start system services by default. Have a look in your user manager for domains, policies, user rights Kind Regards, Chris Knipe MegaLAN Corporate Networking Services Tel: +27 21 854 7064 Cell: +27 72 434 7582 - Original Message - From

Re: Problems starting MySQL as a Service for all users

2002-06-06 Thread Chris Knipe
FOR MY ADMIN ACCOUNT C:\netstat -a -p tcp TCPdynamic:3306 dynamic:0 LISTENING FOR THE REGULAR USER ACCOUNT C:\netstat -a -p tcp TCPdynamic:3306 dynamic:0 LISTENING

sub-queries

2002-06-06 Thread Chris Knipe
Lo all, are sub-queries supported on mysql-max 3.23.49 ?? If they are, what's wrong with the following statement? SELECT monitorhosts.HostID FROM monitorhosts WHERE monitorhosts.HostID NOT IN (SELECT HostID FROM monitorhostgroupdetails WHERE

Re: sub-queries

2002-06-06 Thread Chris Knipe
Dániel [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, June 06, 2002 9:47 PM Subject: Re: sub-queries I'm sorry to disappoint you, but subqueries are NOT supported int any MySQL version, yet. You can read the MySQL manual about it. You can find there when

  1   2   >