AW: Looking for tutorials/examples of ways of accessing mysql via apa che.

Well for java you will have to get a jdbc-driver first. I think, your best choice was think, to get it from here: . A tutorial on this topic can be found here: I suppose, you have Apache with Tomcat as a

how many client connections can Mysql handle?

Hi, just want to know some limits of Mysql. by reading Mysql source code, I have found mysql still using select() to handle connections, so can anyone tell me if Mysql will handle connections less than 1024 in Linux ? I know Mysql uses per thread for client connection, on FreeBSD, threa

Re: Running two "Makes"

Evan James Dembskey wrote: > So - > is it possible to install Gnu make onto teh Dec in a way that it does not > interfere at all with the rest of the system? If so, how do I do it? By default, GNU installs under /usr/local which means, theoretically you can install GNU make on the system wit

MySQL Connection Handle & IPC

Anyone have any ideas on how to store/retrieve an mysql connection handle (object?) via shmget and friends? (in C of course) I have been playing with IPC some and I would think that I should be able to store an open connection handle in shared mem and go back and get it later, stat it and use it.

mysql installation error

I have mysql version mysql-3.23.32.tar.gz , which i am trying to compile along with apache and php on my sun enterprise 220R but after executing mysql and untaring it, in the scripts dir, i have all the files with another extension .sh, which i am not able to execute. now i am not able to procee

Running two "Makes"

Hi, I believe that MySQL needs to be compiled with GNU make. I have to install MySQL on a Dec Alpha running Digital UNIX V4.0D (Rev. 878). There are a number of apps running on the Dec that require the native make to work. So - is it possible to install Gnu make onto teh Dec in a way that it do

Binary data

hi I am pretty new at this and would like to know how does one store a binary blob to the mysql DB ie I would like to store a jpeg to the db Thanks Barry Radloff R&D Media24 - Before posting, please check: http://www.mysql

Mysql_install_Db.sh...cannot execute.

Hello... I have mysql version mysql-3.23.32.tar.gz , which i am trying to compile along with apache and php on my sun enterprise 220R but after executing mysql and untaring it, in the scripts dir, i have all the files with another extension .sh, which i am not able to execute. now i am not able

Re: Backup?

Steve Ruby wrote: > > Scott Baker wrote: > > > > That's the way that I do. I setup my server to shutdown the MySQL process > > at 3am, zip up my var directory, and then restart the process. Can you > > copy the data with the server running? > > If you are shutting down the server, why don't yo

Re: Backup?

Scott Baker wrote: > > That's the way that I do. I setup my server to shutdown the MySQL process > at 3am, zip up my var directory, and then restart the process. Can you > copy the data with the server running? If you are shutting down the server, why don't you just copy the files out to th

RE: Backup?

> > Its not recommended to just `cp' your data directory for use > > later. You should always dump the database with mysqldump. > > Eh? > > If you know what you're doing, there's nothing unsafe about it and it > is WAY faster than using mysqldump. You're absolutely right.. but try telling that t

Re: A few queries about optimising MySQL variables

On Tue, Jan 30, 2001 at 10:56:56AM +, Basil Hussain wrote: > > Having just upgraded my MySQL server to the latest 3.23.32 version, > I thought it would be a good idea to have a review of the > configuration and try to optimise the setup further. I hope someone > can help me by answering a few

Re: Query out field names???

If you do a DESC tblNAME; you can go through row by row and check if the Default is NULL On Tue, 30 Jan 2001, Shawn Cummings wrote: > > > > I want to query out the field names where the "Default" is NULL ... so I > can populate an HTML page for input... > > SHOW FIELDS FROM tblNAME; > >

RE: Mysqld eats up RAM and CPU

Let me clarify that those variables in the list Jan mentioned I use mysql default values, others unmentioned I make them near megabytes. Per Andrei replied, I suspect it is due to design/query problems. -Original Message- From: Andrei Cojocaru [mailto:[EMAIL PROTECTED]] Sent: Wed

Re: AND on a many to many table, with arbitrary ANDs

Julien What you're trying to do isn't that uncommon, and I've met the same problems in two major systems that I've built over the last year. My solution was to use SQL up to a point (i.e. limit the complexity of the query) to protect the performance of the server. So, for example, you can read e

RE: Are index file only for querying?

does not matter you are signed up for this mailing list, to unsubscribe send an email to [EMAIL PROTECTED] with any subject or text message your heart desires, but make sure you use the email that you are subscribed with on the mailing list On Wed, 31 Jan 2001, Ha Linh Don wrote: > HEllo, > > M

Re: AND on a many to many table, with arbitrary ANDs

if my understanding is correct just have two joins using ors for the categories :-) On Tue, 30 Jan 2001, Beasley, Julien wrote: > Hello everyone, > > I am in the process of building a search engine on a database. I have two > tables that have a many-to-many relationship: A story table and a cat

RE: Mysqld eats up RAM and CPU

on my server which runs an online game the values are all in the megabytes On Wed, 31 Jan 2001, Tony Shiu wrote: > I wonder the normalization and indexing of tables, Awa the complexity of > queries submitted to server. For those variables you mentioned I use in > production without significantly

AND on a many to many table, with arbitrary ANDs

Hello everyone, I am in the process of building a search engine on a database. I have two tables that have a many-to-many relationship: A story table and a category table. Story Table: --- id | story| --- 1 | Alice in Wonderland 2 | Peter Pan 3 | Pokemon's adventure 4 | Tale

RE: Mysqld eats up RAM and CPU

I wonder the normalization and indexing of tables, Awa the complexity of queries submitted to server. For those variables you mentioned I use in production without significantly slow-down in peak time. -Original Message- From: Matis, Jan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, J

RE: Are index file only for querying?

HEllo, My name is Don , but I am not interested in "msql". May be , you are confused me with another person who is expert in database. Please remove me out of your mail list Thanks -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED]] Sent: Friday, January 26, 2001 11:45 PM To

RE: Looking for tutorials/examples of ways of accessing mysql via apache.

For begining PHP and MySQL this 10-part series is great! http://www.webmasterbase.com/article.php?aid=228&pid=0 To control your database remotely check out http://www.phpwizard.net/projects/phpMyAdmin/ It's very easy to use. Hope this helps! -Daniel -

Replication issue

Is it possible to define multiple masters for a specific server: ie: Updates from different servers all update to a single backup server I'd prefer not to need to set up a circular replication scheme, due to geographical issues, and also data relavance issues. Taking a quick look through the sou

Re: HYPERLINK type column conversion to ???

>What should I convert Access97 HYPERLINK column type to in MySQL? >How do I get Access97 form to look at that new converted column same >way as with native column. >Any suggestions? Everyone in the office was pretty used to clicking >on the link to the file in the form, but now I am not able t

Re: how to get the union of the values in a SET column ?

>Hi again Bob, > > >>I know it's not 'proper' database design and I should have > >>normalized the one-to-many relationships to multiple tables. > >>However, it was fast and gave me a result which worked quickly > >>(and up against a mad deadline). > > > >I think you've just identified the m

Re: normal cpu usage

On Tue, Jan 30, 2001 at 07:38:06PM -0300, Alejandro M. Leonian wrote: > Hi guys..would you be so kind to tell me what's the normal % of cpu > usage per mysqld thread? i get some 10.5 or 12 % peaks, which > frighten me a lil' bit. Thanks! It depends. ;-) I don't think there is a norm. Jeremy -

myODBC time problems in Access

Im trying to use myodbc to enter some data through MS access. The problem is, when I link to the table it shows the data in my data formatted fields all messed up. The data in the mysql table is fine, it is something the odbc driver or access is doing. I read on the Egroup that Scott Baker was

Re: Backup?

On Tue, Jan 30, 2001 at 05:07:40PM -0800, Scott Baker wrote: > That's the way that I do. I setup my server to shutdown the MySQL > process at 3am, zip up my var directory, and then restart the > process. Can you copy the data with the server running? Certainly can. I do nightly on-line backup

Re: Backup?

That's the way that I do. I setup my server to shutdown the MySQL process at 3am, zip up my var directory, and then restart the process. Can you copy the data with the server running? Scott At 04:37 PM 1/30/2001 -0800, you wrote: >On Tue, Jan 30, 2001 at 04:39:19PM -0700, Colin Faber wrote:

Re: Auto-Increment - how can I avoid repeating IDs?

I would suggest developing a link (read: programmer controlled foreign key) over columns that would have a consistent repeatable meaning. This would allow the developer the ability to rebuild keys and relationships with programmer developed utilities without dependence upon the underlying file ha

Re: Backup?

On Tue, Jan 30, 2001 at 04:39:19PM -0700, Colin Faber wrote: > > Its not recommended to just `cp' your data directory for use > later. You should always dump the database with mysqldump. Eh? If you know what you're doing, there's nothing unsafe about it and it is WAY faster than using mysqldump.

Looking for tutorials/examples of ways of accessing mysql via apache.

Hi, I've been struggling over the last couple of weeks to setup perl/DBI/apache/mysql/php and have finally accomplished that part of the task. The task now is to setup databases and access the data via active server pages either in java or php. I don't have a good feel for html, but I understa

Re: 'USE_RAID' in mysql-3.22.32?

On Mon, Jan 29, 2001 at 11:48:29PM +0100, Tonu Samuel wrote: > On Mon, 29 Jan 2001, Brian Reichert wrote: > > > In pawing though the source for mysql-3.22.32 (our current version > > in production), I noticed in acconfig.h, a macro 'USE_RAID', which > > in term seems to set up the use of . > > >

Re: MySQL Tables over Multiple Drives

On Tue, Jan 30, 2001 at 06:51:01AM -0500, Jason Frisvold wrote: > Well, there are a few reasons.. We have a system with 4 8G drives.. If we > use one for root and one to mirror that root, we have 2 drives left. > Now, if we raid those 2 remaining drives (RAID5) we get about 12 Gigs of space > av

Re: How to select the 10 last items from a table?

On Wed, Jan 31, 2001 at 02:02:05AM +0300, Rus wrote: > He need 10 last records ordered by id. > > You also can try this > SELECT *,count(*) as c FROM item GROUP BY ID LIMIT c-10,10 mysql> select *,count(*) as c from lid group by id limit c-10,10; ERROR 1064: You have an error in your SQL syntax

RE: Connectivity to MySQL DB

Hi, You don't need a special process - the MySQL ODBC driver talks directly to the mysqld already running on Solaris. Regards Quentin -Original Message- From: Sanjeev Kabra [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 31 January 2001 11:58 To: [EMAIL PROTECTED] Subject: Connectivity to

Re: Auto-Increment - how can I avoid repeating IDs?

Rus wrote: > > That's strange. I thought that auto_increment field not suppose to use same > value. May be it's problem connected with transaction. Check doc's on > COMMIT. Try to set AUTOCOMMIT=1 It's real. Here is a demonstration. First, the table definition... +-+--+

Re: Backup?

James Ervin wrote: > > Can you restore from a backup of the mysql data directory or do you need to > dump the database in order to be able to restore? I have seen some traffic > on the list that suggests that a dump is the way to go. I backup the data > directory each night, but I would hate to

Re: Backup?

Its not recommended to just `cp' your data directory for use later. You should always dump the database with mysqldump. James Ervin wrote: > Can you restore from a backup of the mysql data directory or do you need to > dump the database in order to be able to restore? I have seen some traffic

Re: How to select the 10 last items from a table?

On Tue, Jan 30, 2001 at 11:48:22PM +0300, Rus wrote: > May be it could work > SELECT * FROM item ORDER BY ID LIMIT count(*)-10,10 mysql> SELECT id FROM lid ORDER BY ID LIMIT count(*)-10,10; ERROR 1064: You have an error in your SQL syntax near 'count(*)-10,10' at line 1 > or > SELECT * FROM S

Re: Insert Problem

My bad, not enough sleep I guess. Thanks, Toby - Original Message - From: "Roger Ramirez" <[EMAIL PROTECTED]> To: "Toby Miller" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 6:33 AM Subject: Re: Insert Problem > Hmmm I don't believe you ca

HYPERLINK type column conversion to ???

What should I convert Access97 HYPERLINK column type to in MySQL? How do I get Access97 form to look at that new converted column same way as with native column. Any suggestions? Everyone in the office was pretty used to clicking on the link to the file in the form, but now I am not able to do

Re: Auto-Increment - how can I avoid repeating IDs?

The most lovely feature of auto_increment is one of the reasons why we switched from interbase to mysql. Instead of having to call a stored procedure every time you need a unique id, or obtain one by triggers, or create a semi-unique one the way you do, one just have a flexible and controlable uni

Re: Auto-Increment - how can I avoid repeating IDs?

> > I am using MySQL ver. 3.22.32 > > When a table has an auto-incrementing ID field and the last inserted > record had an ID of, say, 100, then I delete that record, the database > engine will re-use the 100 value. How can I get the engine to never > repeat an ID value to avoid corrupted data c

Connectivity to MySQL DB

Hi Everybody, I have installed MySQL on Solaris and have even setup the connectivity using MyODBC on windows. I would like to know what I have to execute on Solaris like listener process for Oracle so that when I connect from windows environment I can connect to the database running on Solaris

Re: How to select the 10 last items from a table?

He need 10 last records ordered by id. You also can try this SELECT *,count(*) as c FROM item GROUP BY ID LIMIT c-10,10 or SELECT *,count(*)-10 as c FROM item GROUP BY ID LIMIT c,10 Something should work - Original Message - From: Scott Gerhardt <[EMAIL PROTECTED]> To: Rus <[EMAIL PRO

Backup?

Can you restore from a backup of the mysql data directory or do you need to dump the database in order to be able to restore? I have seen some traffic on the list that suggests that a dump is the way to go. I backup the data directory each night, but I would hate to find out that that is not

Re: Auto-Increment - how can I avoid repeating IDs?

That's strange. I thought that auto_increment field not suppose to use same value. May be it's problem connected with transaction. Check doc's on COMMIT. Try to set AUTOCOMMIT=1 - Original Message - From: Viken Nokhoudian <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January

_slow_ index generation

Please cc [EMAIL PROTECTED] on any response, I'm on the list but I filter to a file, thanks. Can someone (maybe with some MySQL-innards code experience) please explain this problem: Generating an index on the first character of a varchar(70) on a 350 meg table on a PII 366 128 MB Ram, normal ID

Re: Auto-Increment - how can I avoid repeating IDs?

So sprach Viken Nokhoudian am Tue, Jan 30, 2001 at 12:57:50PM -0800: > When a table has an auto-incrementing ID field and the last inserted > record had an ID of, say, 100, then I delete that record, the database > engine will re-use the 100 value. How can I get the engine to never > repeat an ID

normal cpu usage

Hi guys..would you be so kind to tell me what's the normal % of cpu usage per mysqld thread? i get some 10.5 or 12 % peaks, which frighten me a lil' bit. Thanks! AML

Re: Auto-Increment - how can I avoid repeating IDs?

Easiest way, upgrade to 3.23:) Other way: create a table just to make auto_increment IDs and take the number from it each time to put in your original table. Viken Nokhoudian wrote: > > I am using MySQL ver. 3.22.32 > > When a table has an auto-incrementing ID field and the last inserted >

Re: MySQL Tables over Multiple Drives

On Tue, Jan 30, 2001 at 01:13:43PM -0800, Jeremy D. Zawodny wrote: > On Tue, Jan 30, 2001 at 05:08:46PM +, Tim Bunce wrote: > > On Tue, Jan 30, 2001 at 10:57:16PM +0800, Sam Wong wrote: > > > > > > > > So why isn't the --with-raid option set in the binary download version? > > > > > > The file

RE: Auto-Increment - how can I avoid repeating IDs?

Write your own Serial Assigned Key (SAK) routine. Put a table in your database : SAK SAKID auto_increment tinyint table varChar(80) not null field varChar(80) not null nextValue bigint lockedBy varCar(10) Now

[REPLICATION: /var/lib/mysql/master.info corrupted during restart]

>Description: >How-To-Repeat: <1) stop mysqld server (mysqladmin shutdown) 2) restart server (shutdown -r now) or restart mysqld 3) slave will be unable to connect with master as the master.info file is corrupted.> >Fix: >Submitter-Id: >Or

Re: mySQL and Mac OS X Server

Look here for the OSX Server binary source: http://www.mysql.com/downloads/mysql-3.23.html and read this: "Before trying to configure *MySQL* on Mac OS X server you must first first install the pthread package from `http://www.prnet.de/RegEx/mysql.html'". Really... make *SURE* you install the

RE: Auto-Increment - how can I avoid repeating IDs?

Use your own id's. I personally hate auto increment. I do all my work in php so I make my id's like this. srand(time()); $id = md5(uniqid(rand())); This will make a 32 character id. > -Original Message- > From: Viken Nokhoudian [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 30, 2

RE: Auto-Increment - how can I avoid repeating IDs?

Upgrade to 3.23. -- "There cannot be a crisis today. My schedule is already full." --Henry Kissinger > -Original Message- > From: Viken Nokhoudian [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 30, 2001 14:58 > > I am using MySQL ver. 3.22.32 > > When a table has an auto-in

Re: OT: Compiling GCC

Hi, My first recommendation would be to download one of the GCC binaries and use pkgadd to install the product. Go to... http://www.sunfreeware.com/ and select your version of Solaris (2.6) from the menu on the upper right side of the form. Then scroll through the lower right window un

Query out field names???

I want to query out the field names where the "Default" is NULL ... so I can populate an HTML page for input... SHOW FIELDS FROM tblNAME; This shows the fieldnames, and the properties -- but how can I just get a list of the fieldnames where the Default is NULL -- or how can I get this list

Re: Nightly Backup of my database

Don wrote: > > Hi list, > > I'm trying to backup up database in /etc/cron.daily. I've played with > mysql dump with the following syntax: > > mysqldump --opt -p my_dbf.db > my_dbf.backup > mysqldump --opt -p "my_password" my_dbf.db > my_dbf.backup > mysqldump --opt -p my_dbf.db > my_dbf.backup

HYPERLINK type column conversion to ???

What should I convert Access97 HYPERLINK column type to in MySQL? How do I get Access97 form to look at that new converted column same way as with native column. Any suggestions? Everyone in the office was pretty used to clicking on the link to the file in the form, but now I am not able to do

RE: How to select the 10 last items from a table?

SELECT * FROM item ORDER BY ID LIMIT 10 or change to "ORDER BY ID DESC" to get the desired result. - Scott > May be it could work > SELECT * FROM item ORDER BY ID LIMIT count(*)-10,10 > or > SELECT * FROM SELECT * FROM item ORDER BY ID DESC LIMIT 10 ORDER BY ID > > >

Load Balancing.

It seems like I have seen somewhere that load balancing and fail-over-services are available for MySQL, to share the load and mirror the data between two machines. Is this possible and if so where can I read more about it? Thank You, .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems & Network Ad

RE: Error upon order by with group by and join

Hi, Yes, RTFM. Your select result is too big for the configure tmp_table_size, and you are not using --big-tables. Regards Quentin -Original Message- From: Chana Black [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 31 January 2001 09:13 To: [EMAIL PROTECTED] Subject: Error upon order by

RE: Nightly Backup of my database

Hi, Try taking the space out from "-p passwd" Regards Quentin -Original Message- From: Don [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 31 January 2001 09:45 To: msql list Subject: Nightly Backup of my database Hi list, I'm trying to backup up database in /etc/cron.daily. I've played

Re: Nightly Backup of my database

Hi, Well, there's one easy way to do it, but it compromises security just a little bit. mysqldump --opt -u'username' -p'userspassword' my_dbf.db > my_dbf.backup One way to minimize security risks would be to create a user with minimal capabilities to do backups -- only given these limited permis

Re: MySQL Tables over Multiple Drives

On Tue, Jan 30, 2001 at 05:08:46PM +, Tim Bunce wrote: > On Tue, Jan 30, 2001 at 10:57:16PM +0800, Sam Wong wrote: > > > So why isn't the --with-raid option set in the binary download version? > > > > The file will be bigger and slower in result > > I doubt it would be significantly bigger. I

Auto-Increment - how can I avoid repeating IDs?

I am using MySQL ver. 3.22.32 When a table has an auto-incrementing ID field and the last inserted record had an ID of, say, 100, then I delete that record, the database engine will re-use the 100 value. How can I get the engine to never repeat an ID value to avoid corrupted data correlations?

Re: ERROR 1170: BLOB column 'Url' used in key specification without a key length

On Tue, 30 Jan 2001 10:04:47 -0800, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: >This underscores a problem I have found with a few asp-driven >college >websites. Ungodly long URLs are used to address some of their pages. >When I have inquired about this, and how to tell a friend where to >find p

Re: How to select the 10 last items from a table?

May be it could work SELECT * FROM item ORDER BY ID LIMIT count(*)-10,10 or SELECT * FROM SELECT * FROM item ORDER BY ID DESC LIMIT 10 ORDER BY ID - Original Message - From: Karlsson Andreas-andkar01 <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 6:00 PM

Nightly Backup of my database

Hi list, I'm trying to backup up database in /etc/cron.daily. I've played with mysql dump with the following syntax: mysqldump --opt -p my_dbf.db > my_dbf.backup mysqldump --opt -p "my_password" my_dbf.db > my_dbf.backup mysqldump --opt -p my_dbf.db > my_dbf.backup < pswd (pswd contains the pas

RE: (Got an error reading communication packets)

> -Original Message- > From: Matis, Jan [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 30, 2001 9:02 PM > To: [EMAIL PROTECTED] > Subject: (Got an error reading communication packets) > do You have an idea why ? yes... > > > I was searching on deja but I didn't found anything :( H

Install of mysql on AIX fails due to missing member shr.o in module libz.a

From: t199k01 To: [EMAIL PROTECTED] Subject: Install of mysql on AIX fails due to missing member shr.o in module libz.a >Description: Previously, I was failing because module libz.a didn't exist. Per your advice, I installed zlib from gnu. Now, the module appears to be found, but it cannot locate

Error upon order by with group by and join

Hi, I am using mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686). When I try to run the following query: select tb1.fname, tbl1.lname, tbl2.appID, count(tbl2.appID) as count from tbl1, tbl2 where tbl1.id = tbl2.appID group by tbl2.appID order by tbl1.fname I get the following error: ERR

Re: idle CPU

> "TS" == Tim Samshuijzen <[EMAIL PROTECTED]> writes: TS> We're running a large database on a dedicated server. TS> When I look in the list of active processes, I notice that a TS> complicated query takes up no more than about 30 % of CPU. TS> During this time the CPU is more than 60 % idle

(Got an error reading communication packets)

010130 20:58:30 Aborted connection 7 to db: 'dpanews' user: 'newsfeed' host: `web1.somewhere.de' (Got an error reading communication packets) hallo gentlemans .. I have a lot of this type messages in my mysql errorlog file ... do You have an idea why ? I was searching on deja but I didn't fou

one error when I run the Mysql++ sample

I got a error when I run the sample file of Mysql++ , the file is simple1.cc I compile use below command: g++ -g -o mysimple simple1.cc /usr/lib/libsqlplus.so -L/usr/lib/mysql -I/usr/include/mysql/ -lmysqlclient -lnsl -lz -crypt -lsocket -lm and I did not got any erro in compile and link, how

OT: Compiling GCC

Hi, In attempt to see if a core dump in mysql is the result of a broken SUN compiler, as suggested, I am trying to compile gcc 2.95.2 on Solaris 2.6 x86. I have subscribed to gnu-help, but haven't had a response from there yet. Is anyone out there able to help me off the list to get gcc going.

wait_timeout?

I am slowly gaining connections to the database that just sleep. I know these can arise from not closing the database. I am accessing it via MyODBC from Active Server Pages. However, I set wait_timeout to 3600... I have some that have been there for days... just sleeping. Why doesn't MySQL dis

Re: ERROR 1170: BLOB column 'Url' used in key specification without a key length

This underscores a problem I have found with a few asp-driven college websites. Ungodly long URLs are used to address some of their pages. When I have inquired about this, and how to tell a friend where to find particular information, I was simply informed that this was a characterisitic of th

Win mysqlc client anomaly

Does anyone know why the Windows version of mysqlc (the command line client with READLINE support) doesn't support the SOURCE command? Thanks, Mark Chalkley - Before posting, please check: http://www.mysql.com/manual.php

RE: Mysqld eats up RAM and CPU

You've got 1G Ram! Guys, take a look at the my-huge.cnf in the mysql tree (I've forgot which folder) it's not for me :)) it's for customers and because I'm lamer sometimes is 1GB not enough ... huge.cnf - thanx for hint : mysql-3.23.32/support-files/my-huge.cnf.sh look at these ... Do You have

Re: where to get the Mysql++ API class docuementation.?

Sinisa: Thanks, I got it after I download it, I hope the class and method could also be put in the online browse or show a notice so that others could know the download manuel contains the class method. Best Regards Hensen Sinisa Milivojevic wrote: > Hensen Yi writes: > > hi: > > > > Do

RE: Maint Utilities 3.23.32 Core Dumping On SCO 5.0.x

>I am using make 3.79.1. I do not know if that makes a difference. I am >using libz-1.1.3 or zlib-1.1.3. Well I am using the same version of zlib but I am using 3.79 of make. I'll try make 3.79.1 (but I have my doubts). This is strange, I can compile 3.23.28-gamma and all runs OK. But 3.23.32

Re: Access Ports

-Ursprüngliche Nachricht- Von: Van <[EMAIL PROTECTED]> An: Andreas Vierengel <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Datum: 30 January, 2001 16:30 Betreff: Re: Access Ports >Andreas Vierengel wrote: >> >> Try option --skip-gran

Re: MySQL Tables over Multiple Drives

On Tue, Jan 30, 2001 at 10:57:16PM +0800, Sam Wong wrote: > > So why isn't the --with-raid option set in the binary download version? > > The file will be bigger and slower in result I doubt it would be significantly bigger. I believe --with-raid support is a very small and simple layer between m

Re: 'insert_id' finction not working on V3.23.32

I'm guessing you're using PHP? I know when we did some upgrades, the function changed. It used to be mysql_inser_id([result set]), but when we upgraded it now wants mysql_insert_id([mysql link]) I believe it was a change between PHP3 and PHP4, but I could be wrong since we upgraded MySQL at the

Re: MySQL Tables over Multiple Drives

On Tue, 30 Jan 2001, Sam Wong wrote: > Date: Tue, 30 Jan 2001 19:32:05 +0800 > From: Sam Wong <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: MySQL Tables over Multiple Drives > > Yes, you've to recreate the tables with RAID option (read the manual for > details) > and move and link t

Re: Mysqld eats up RAM and CPU

You've got 1G Ram! Guys, take a look at the my-huge.cnf in the mysql tree (I've forgot which folder) - Original Message - From: "Matis, Jan" <[EMAIL PROTECTED]> To: "'Sam Wong'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, January 31, 2001 12:46 AM Subject: RE: Mysqld eats up

Re: Maint Utilities 3.23.32 Core Dumping On SCO 5.0.x

On Tue, 30 Jan 2001, Grimes, Dean wrote: > I have upgraded from MySQL-3.23.28-gamma to MySQL-3.23.32 and I am having > problems with some of the maintenance utilities core dumping with a memory > fault. However, MySQL itself runs fine. The problem utilities are: > > mysqldump - core dumps immediat

RE: Mysqld eats up RAM and CPU

what about this ? 2*PII 450 MHZ 1G RAM data on hardware raid port= 3306 socket = /tmp/mysql.sock user= mysql skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= wait_timeout=

Re: Mysqld eats up RAM and CPU

keybuffer=0? tablecache=0? For complicated query, Mysql may search the harddisk for stuff again, the it holds the query for sometimes...and then some more connection come in, as a result, more ram and cpu is consumed May I suggest you to lower down the max connection, and tune up the caching/buff

'insert_id' finction not working on V3.23.32

We are running a program which uses the 'mysql_insert_id' function to get the id of an AUTO_INSERT key field. This used to work fine with MySQL V3.22, but now we've upgraded to V3.23.32 it doesn't seem to be working. The function simply returns the same value the whole time the program is runn

RE: Mysqld eats up RAM and CPU

What sort of hardware are you running? - Amount of RAM - CPU speed. > > Hi There.. > I'm running mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu > (i686) on a RedHat 6.1 Os. > The server is installed and the configuration is almost by default. > The problem is that most of the time the m

mySQL and Mac OS X Server

Hello all - I'm a new mySQL user and am interested to know if anyone has successfully installed mySQL in the Mac OS X Server environment - if so, is there a precompiled binary or install instructions for the platform? Thanks and sorry for the newbie question. Doug -- Doug Dockery [EMAIL PROTE

Re: MyODBC - Long varchar

We have a rather complex C++ app that uses MySQL, as well as MSSQL7 and Oracle in conjunction with Microsoft's Transaction Server. After considerable trial and error, we have foudn we need to use four of the options which effect the behaviour of MyODBC ... - Don't optimize column width - Return

number of tables in a db

I have several tables in my db that can potentially become *very* large *very* quickly. I was thinking about creating a table for each user of my database to keep data separate and allow each table to be 4GB due to OS restrictions. How many tables can a database have in it? or should i create a

Re: idle CPU

the answers make sense thanks everybody! Tim Samshuijzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-ma

Re: idle CPU

Yes tim, buy better/faster hard drives and/or put more memory in your machine. this 60% idle is the time your proc is waiting for the hard drive reading data. - Original Message - From: "Tim Samshuijzen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 30, 2001 4:03 PM

  1   2   >