Can anyone give me a hand with this?

I've got a usage file that I have accumulated from various places, pieced it together to do basically what I need. It tallys up a particular dial-up users time online for a given month. The only problem I am having is it shows days, hours and min online. I would like to see if I can convert t

Re: Getting an empty result set is what I want!

Sure! Try this: SELECT * FROM table WHERE 1=2 -ms - Original Message - From: "Scott Teglasi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 10:42 PM Subject: Getting an empty result set is what I want! Hi all, this is Scotty. I wanted to know if it's possi

Getting an empty result set is what I want!

Hi all, this is Scotty. I wanted to know if it's possible to have MySQL return a resultset even though there are no results. I want this so that I can retrieve field information on each field that's in the query. (field type, length, etc). I know I can use describe or show columns to get the t

Re: Memory Leak

On Fri, Mar 28, 2003 at 10:46:52AM -0800, Jeff Kilbride wrote: > I've heard some bad things about turning off swap on Linux. I think it was > on Jeremy Z.'s Blogger page. If he sees this maybe he can comment. It really depends on the kernel too. Newer (2.4.19+) kernel are much better than those a

Re: About database design

Here's some of my faves -> http://www.devshed.com/Server_Side/MySQL -> http://www.linux-mag.com/2001-06/mysql_02.html -> http://www.phpbuilder.com/columns/barry2731.php3 -> http://www.databasejournal.com/sqletc/article.php/1428511 also saw some talk of db admin tools - if you are doing php

Re: Databases go away... But why?

On Fri, Mar 28, 2003 at 11:15:42PM -0500, Bill Leonard wrote: > One of our servers has been acting up recently... There is about 400 > databases on the machine, about 1000 requests per hour. > > Every so often, once every couple days or so, the databases just disappear. > Doing a show databases co

Re: mysql.sock

> What's the full pathname? /etc/my.cnf? Correct. J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

Re: mysql.sock

At 21:10 -0800 3/28/03, Joseph Bannon wrote: > Pretty new: 3.22.2. Only been around, oh, 5 years or so. :-) Well, looks like I've had my head in a hole. Here is my my.cnf file contents. Can you tell me what's wrong? What's the full pathname? /etc/my.cnf? [mysqld] datadir=/home/mysqldb soc

Re: mysql.sock

> Pretty new: 3.22.2. Only been around, oh, 5 years > or so. :-) Well, looks like I've had my head in a hole. Here is my my.cnf file contents. Can you tell me what's wrong? [mysqld] datadir=/home/mysqldb socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe

Re: mysql.sock

At 20:52 -0800 3/28/03, Joseph Bannon wrote: > My mistake. my.cnf. It should be in /etc or /var/lib/mysql. If not, you can create one. Is the my.cnf a new thing? Before today, I'd had never heard of it. Pretty new: 3.22.2. Only been around, oh, 5 years or so. :-) -- Paul DuBois http://www.k

embedded select / left join question

This is probably a real newbie question, but, since that's what I am... Using MySQL 3.23, I have two tables, for instance: ContestEntries: id, entrant, contestNumber, etc. Entrant: id, name, etc. There are multiple contests, and Entrants can enter as many as they like. So, Entra

Re: mysql.sock

> My mistake. my.cnf. It should be in /etc or > /var/lib/mysql. If not, you can > create one. Is the my.cnf a new thing? Before today, I'd had never heard of it. J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your

Re: mysql.sock

My mistake. my.cnf. It should be in /etc or /var/lib/mysql. If not, you can create one. - Original Message - From: "Joseph Bannon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 10:28 PM Subject: Re: mysql.sock > > Specify the location in my.

Databases go away... But why?

One of our servers has been acting up recently... There is about 400 databases on the machine, about 1000 requests per hour. Every so often, once every couple days or so, the databases just disappear. Doing a show databases command yields an empty set. Actually sometimes, it shows 1 or 2 in there.

Re: mysqld ending at start up

> What I mean is the permission of mysql database > directory and data. Seems you already solved the > problem. Yeah, I figured out what you ment. > issue the command 'mv /var/lib/mysql What I ment was, when I installed mysql, I set the prefix as /home/mysql, however, the var directory for m

Re: mysql.sock

> Specify the location in my.conf or ...create a sym > link in /tmp. Where is the my.conf file? J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Mailing List

Re: mysql.sock

Specify the location in my.conf or ...create a sym link in /tmp. - Original Message - From: "Joseph Bannon" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 8:50 PM Subject: mysql.sock > The mysql.sock file is being saved at the location > below > > /var/lib/

MySql, PHP, and Dates

I'm experienced with SQL, but new to MySql and PHP, which I'm using together to create a dynamic web site. Right now, I'm having minor difficulties with date formatting. It seems that when I retrieve a date from MySQL into PHP, it shows up as a string instead of a date data type, with format

mysql.sock

The mysql.sock file is being saved at the location below /var/lib/mysql/mysql.sock ...which causes me to get this error... ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) How can I fix this? Thanks, Joseph _

Re: mysqld ending at start up

> I face the same problem a month ago. > see your mysql database permission; it should be 750 > (minimum) and belong to > mysql user and group. YEAH! That did it. Thanks a million! Also, how do I move the var directory to another location? J.

Re: mysqld ending at start up

> What's your log say? > > Should be in /var/lib/mysql/.err I don't have one. But there is a mysql.sock. J. __ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com -- MySQL General Ma

Re: mysqld ending at start up

What's your log say? Should be in /var/lib/mysql/.err -jeff On Fri, 2003-03-28 at 18:32, Joseph Bannon wrote: > I installed mysql 4 today and ran mysqld_safe. Here is > what I get back... > > [EMAIL PROTECTED] admin]# Starting mysqld daemon with > databases from /var/lib/mysql > 030328 05:22:3

mysqld ending at start up

I installed mysql 4 today and ran mysqld_safe. Here is what I get back... [EMAIL PROTECTED] admin]# Starting mysqld daemon with databases from /var/lib/mysql 030328 05:22:36 mysqld ended What is wrong? Thanks, Joe. __ Do you Yahoo!? Yahoo! Pl

Re: compressed replication

On Fri, Mar 28, 2003 at 11:54:42PM +, Andy Smith wrote: > Can replication be compressed? Yes. > Is it already in a binary format which could not be compressed > further? It's a binary format (sort of) but not compressed. > If run through openssl would that serve to compress it too? Yes, or

Re: About database design

VisioModeler does have docs on db design, but AFAIK the download edition will not generate a MySQL database creation script from the model--you need the Enterprise edition for that. There is an open source database modeller, argoURL (http://argouml.tigris.org/), that is pretty good, but it does no

compressed replication

Can replication be compressed? Is it already in a binary format which could not be compressed further? If run through openssl would that serve to compress it too? Also, there are a couple of references to compressed client connections in the manual. Does this work and is it indeed compressed, o

Re: About database design

At 04:40 PM 3/28/2003, you wrote: Where can a newbie go to learn how design and build a database quick. Thanks David David, That's like saying to a sales person at a home center mega store, "How do I design an build a house real quick". Well, it takes time to learn database design and M

RE: Storing Images in MySQL

> I assumed to store the data in mysql you did something like uuencode and > inserted that data into the db? > Could the decode method be different on redhat 7.3? > > -Original Message- > From: vernon [mailto:[EMAIL PROTECTED] > Sent: Friday, March 28, 2003 2:19 PM > To: [EMAIL PROTECTED] >

Re: About database design

At 04:40 PM 3/28/2003, you wrote: Where can a newbie go to learn how design and build a database quick. Thanks David David, That's like saying to a sales person at a home center mega store, "How do I design an build a house real quick". Well, it takes time to learn database design and M

RE: About database design

Richard Dice is a friend of mine, and has done a wonderful tutorial on "Choosing the right database system" that I found marvelous, at webmonkey: http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial1.ht ml Regards, Kelly Black Sprint PCS Performance Engineering Irvine, Ca. 9

About database design

Where can a newbie go to learn how design and build a database quick. Thanks David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: optimal selects and indexes ?

On 28 Mar 2003 at 10:08, Steve Phillips wrote: > SELECT sum(bytes) FROM tb_ipdata_0303 WHERE (source_ip > 3329275903 AND > source_ip < 3329276160) OR (dest_ip > 3329275903 AND dest_ip < 3329276160) > AND (time > 1048802400 AND time < 1048805999); Using "OR" like that prevents indexes from bei

Re: How to use GRANT for Network Client?(for newbie)

At 18:15 + 3/28/03, Terrance Win wrote: Hello Everybody, I have a MySQL server in my W2K server DNS=Network.srv. User name 'Admin' and password ='password' is for Admin purpose in Server. Database name = 'TestDB' IP for server = 192.168.111.2 So I set up grant GRANT ALL o

Re: conencting to mysql server on windows from windows

At 13:07 -0800 3/28/03, Prachi Shah wrote: Hi, I recently set up mysql 4.0.12 on my Windows2000 machine. I would like users to be able to access/create tables with their login. I created new users and granted them with required priviledges. The users will also be connecting from Windows machines.

Re: How to limit the mysqld process use

On Fri, Mar 28, 2003 at 07:08:27PM -0300, Enrique L. Schamann wrote: > Is there a way to limit how much of the processor % any of the mysqld > processes could use ? There's nothing specific to MySQL, no. But your operating system may provide such features in a more general way. -- Jeremy D. Zawo

RE: optimal selects and indexes ?

When ever you use an index on multiple columns remember that mysql uses the concept of leftmost prefix. I'll explain with an example from one of your key make-ups below If you have dest_ip and source_ip in your select statement idx_time_dest_ip_source_ip would not work, because time is your leftm

Re: optimal selects and indexes ?

At 10:08 -1100 3/28/03, Steve Phillips wrote: Hey there, I have a database where i am collecting netflow records, the number of entries in a table after a day or so reaching toward the millions of rows I am trying to pull hourly reports, summarizing the byte count's for the hour previous and w

RE: Storing Images in MySQL

I assumed to store the data in mysql you did something like uuencode and inserted that data into the db? Could the decode method be different on redhat 7.3? -Original Message- From: vernon [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 2:19 PM To: [EMAIL PROTECTED] Subject: Storin

How to limit the mysqld processor use

Is there a way to limit how much of the processor % any of the mysqld processes could use ? Regards, -- Enrique Luis Schamann Gerente de Infraestrutura Salutia - Tecnologia e Saúde Ed. Panambi Rua Geraldo Flausino Gomes, 61 - cj. 112 04575-060 - Brooklin Novo São Paulo, SP Brasil Tel.: ++55-11-3

How to limit the mysqld process use

Is there a way to limit how much of the processor % any of the mysqld processes could use ? Regards, -- Enrique Luis Schamann Gerente de Infraestrutura Salutia - Tecnologia e Saúde Ed. Panambi Rua Geraldo Flausino Gomes, 61 - cj. 112 04575-060 - Brooklin Novo São Paulo, SP Brasil Tel.: ++55-11-

optimal selects and indexes ?

Hey there, I have a database where i am collecting netflow records, the number of entries in a table after a day or so reaching toward the millions of rows I am trying to pull hourly reports, summarizing the byte count's for the hour previous and writing this out to a csv file My query current

Storing Images in MySQL

Hey all, I'm using phpNewsAds and am wanting to store images in MySQL. I have this working on my Red Hat 7.2 Box and am moving to a new server running Red Hat 7.3 and of course, after moving the database the images are not being dispalyed. The database, however, is working. I'm assuming that

conencting to mysql server on windows from windows

Hi, I recently set up mysql 4.0.12 on my Windows2000 machine. I would like users to be able to access/create tables with their login. I created new users and granted them with required priviledges. The users will also be connecting from Windows machines. I intend to use Perl DBI and mysql-DBD modu

Re: Merge MySQL's data directly into Acrobat forms, without programming

On Fri, Mar 28, 2003 at 10:51:48AM -0500, Patrick wrote: > Yeah, 'Desktop Class' cross-platform with RPC and Client/Server no less. We > have MySQL deployed on over 15+ servers across multiple OS's with clients > written in C, C++, VB and PHP. Oh yeah, I have it on my W2K desktop too! > > I guess

RE: weekly data query

Try the function DATE_FORMAT in this syntax DATE_FORMAT(col,"%U"); I don't know if %U is exactly what you want but DATE_FORMAT can format any date column into nearly any format you wish to display. -Original Message- From: Jasmine [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 11

RE: MySQL, Snort & ACID

Bruce is correct. If you need to do a query based on a time frame, try something like timestamp >= NOW() - interval X seconds; // where X is your value for your timerange in the past. If the timestamp column has a key the above addition will use it. Using unix_timestamp or mysql functions in gener

weekly data query

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 thanks for your reply but let me be more specific in my question. the week() function returns a particular week based on 53 weeks in a year. but I want to be able to return data that exists within a particular week based on a time period that I specify

Re: Need help to control relay-bin log size

On Fri, Mar 28, 2003 at 06:10:55PM +0100, Vidar wrote: > Hi > > I know that you may set max binlog size with the max_binlog_size > variable. However, is it possible to control the size of the > relay-bin logs on the slave servers as well? I don't believe it's documented (yet?) but I seem to reme

Re: Memory Leak

I've heard some bad things about turning off swap on Linux. I think it was on Jeremy Z.'s Blogger page. If he sees this maybe he can comment. DeepBlue, take a look in the "support-files" directory under your MySQL install directory. There are 4 example my.cnf files for various memory/box configura

RE: Keys & indeces

No that key is not nessary -Original Message- From: Mattias Barthel [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2003 7:57 AM To: '[EMAIL PROTECTED]' Subject: Keys & indeces Hello! Is there a need for adding an index to a key which already primary? >From the dump file it would look

How to use GRANT for Network Client?(for newbie)

Hello Everybody, I have a MySQL server in my W2K server DNS=Network.srv. User name 'Admin' and password ='password' is for Admin purpose in Server. Database name = 'TestDB' IP for server = 192.168.111.2 So I set up grant GRANT ALL on TestDB.* TO [EMAIL PROTECTED] IDENTIFIED B

RE: AW: AW: multiple mysqld-max running ?

On 28-Mar-2003 Gerald Fehringer wrote: > Hi Joseph, > > all connects are from localhost, no external connect and i never > saw this behavior on a bsd box ?! > FreeBSD as a default builds with it's own thread library, You'll only see the parent server thread. You can build the MySQL server with

Can't start mysql if installed outside the 'compile time' directory

The reason is that if 'basedir' is read from 'my.cfg' then 'bindir' is not set to $basedir/bin but to /compile-time-dir/bin >How-To-Repeat: 1) Install mysql in a directory other than the one for which it was compiled. 2) Configure /etc/my.cnf to work with this ne

Union Problems? Me too!

It seems that the union has problems when some values returned in the selects are nulls like in left joines. Instead of seeing Nulls the rows inherit the value of the previous row. Which make a real mess. I did how ever found a work around. I use coalesce(myfield,space(30)) as myfield anywhere a

AW: sub-selects and php

>You did not show us your actual insert statement, but >You can not insert into a table listed anywhere in the select. sorry,man. i should have been given you the whole thing: here it comes: db one with table person (firstname,name,email,phone,fax,hashval,flag,etc...) and table hashvalue (

AW: AW: multiple mysqld-max running ?

Hi Joseph, all connects are from localhost, no external connect and i never saw this behavior on a bsd box ?! thanks geri -Ursprungliche Nachricht- Von: Joseph Bueno [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 28. Marz 2003 16:10 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re:

Re: MySQL, Snort & ACID

Dusty Hall wrote: DB queries and inserts are taking a very long time to complete. Speeding these up would be my goal. Here's a snippet from my slow_queries log # Time: 030328 10:28:20 # [EMAIL PROTECTED]: acid_user[acid_user] @ localhost [] # Query_time: 17 Lock_time: 0 Rows_sent: 0 Rows_

Need help to control relay-bin log size

Hi I know that you may set max binlog size with the max_binlog_size variable. However, is it possible to control the size of the relay-bin logs on the slave servers as well ? Will the relay-bin logs be deleted automaticly by mysqld or are there a manuall procedure for doing this ? I am running

Union problem ?

Hi, it seems that when there is an 'union' in a query it transforms the 'null' to '0' when the field is a number, and more over, I think the result is wrong... I am using the 4.0.12 mysql server for Win32 in a Windows NT server. this is the query... select id, name from customer union all select

Re: MySQL, Snort & ACID

At 10:35 -0600 3/28/03, Dusty Hall wrote: Hey gang, not to sure if I should be posting to this list or not but I'm having terrible performance problems with MySQL on a high end system. I believe I've done enough reading through the Doc's to post to this list. The system is a Dual 1Ghz with 2GB of

MySQL, Snort & ACID

Hey gang, not to sure if I should be posting to this list or not but I'm having terrible performance problems with MySQL on a high end system. I believe I've done enough reading through the Doc's to post to this list. The system is a Dual 1Ghz with 2GB of Ram running Redhat 8.0, MySQL 3.23, PHP 4.

Random result and split over several pages

Hi! I was wondering: is there any way to make mysql remember the last random or to return the limit in exactly the same order? I want to achieve a random on a result on which I use Limit in the sql. Greetings Victor -- "I wish Bill Gates the best, I really do. I just think he and Microsoft a

RE: mySQL on Windows 2000 Server

Hi, I have MySQL running on a machine at work and a (dev) machine at home. Both machines are running W2K. The machine at home is an old PIII with 256Meg of memory, the machine at work is a new P4 2.0GHz with 512Meg of memory. My home machine also has a heavier load relative to the CPU than my m

Keys & indeces

Hello! Is there a need for adding an index to a key which already primary? >From the dump file it would look something like this: PRIMARY KEY (id) KEY id (id)< Is this nescesary ? ); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:htt

RE: weekly timestamp query

On 28-Mar-2003 Jasmine wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi > just a question.. wondering if anyone knows how to query for Weekly data > (e.g. > Week 1 , Week 3... and so forth) from a table that includes the > "timestamp" > column in a format of ("-mm-dd hh:mm:s

Re: sub-selects and php

You did not show us your actual insert statement, but You can not insert into a table listed anywhere in the select. Udo Schubert wrote: hi there! i'm wondering about these sub-selects and the mysql-version peroblems they cause! somewhere on mysql.com is said: sub-selects need mysql version

More MYSQL daemon on same WIN2K server

Hi, i've a problem. I must put two Mysql server daemon on same WIN2K server, but i don't know set two different my.ini file. If i run the service interactively I'm able to set to the service a different path for my.ini file, but when i start winmysqladmin he create a new my.ini file under c:\winnt.

Re: Trouble creating foreign keys

You have several problems. Both tables have duplicate keys. You don't have a (c_id) key in table2 to add a constraint to. William Hambleton wrote: I can't seem to be able to create foreign keys. Here are my create procedures and the error I am receiving. CREATE TABLE `test1` ( `a_id` smallint(

Re: Numbering within groups

If it is MYISAM: ALTER TABLE projected ADD COLUMN partnumber INT UNSIGNED NOT NULL AUTO_INCREMENT , ADD UNIQUE KEY (projectid,partnumber); If you don't want to keep the automatic incrementing of the partnumber for each project, then drop the key. Renger van Nieuwkoop wrote: Hi I have the follow

Re: Merge MySQL's data directly into Acrobat forms, without programming

Yeah, 'Desktop Class' cross-platform with RPC and Client/Server no less. We have MySQL deployed on over 15+ servers across multiple OS's with clients written in C, C++, VB and PHP. Oh yeah, I have it on my W2K desktop too! I guess I may be being a little sensitive, but I think one should take car

Re: AW: multiple mysqld-max running ?

Hi, mysqld creates a few threads at startup (3, I think) plus one thread per active connection. The manual explains it better than myself: http://www.mysql.com/doc/en/MySQL_threads.html Chances are that you have 8 clients connected. Once again, your mysql server TOTAL memory usage is 40Mb. If this

AW: multiple mysqld-max running ?

hi joseph, thank you, but still where is defined that it should start 11 threads ?? i don't wanna allocate so much memory for a small server ! thanks /geri -Ursprungliche Nachricht- Von: Joseph Bueno [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 28. Marz 2003 15:44 An: [EMAIL PROTECTED]

Re: mySQL on Windows 2000 Server

Neil: MySQL on Windows 2000 Server is excellent. We have installed about client 80 systems that incorporate MySQL. Some are running on Unix, some Linux, about a third on Windows NT Server, and the balance (40+ systems) are running on either Windows 2000 Server or Win2K Advanced Server. We have n

AW: sub-selects and php

>Does the PHP user have insert authority? grant insert,alter,select on theTable to phpuser; you mean this? php user is the user with whom the php file connects to the db right? i executed every statement from the shell as that user,too! best regards udo -- MySQL General Mailing List

Re: multiple mysqld-max running ?

Hi, ps,top,.. on Linux show threads as processes. What you see is ONE process (mysqld) with 11 threads sharing 40Mb of memory. Check http://www.mysql.com/doc/en/Memory_use.html Regards, Joseph Bueno Gerald Fehringer wrote: hi list fellows, os: suse linux 8.1 myqld: mysql-max-4.0.12-pc-l

sub-selects and php

hi there! i'm wondering about these sub-selects and the mysql-version peroblems they cause! somewhere on mysql.com is said: sub-selects need mysql version 4.1 and up! BUT: i have a statement insert into foo select bar from bartable; this thing works if i enter it on the mysql-shell. (also wi

Re: database size

Dear Friends First thanx for all of to ans me but I feel that i put the question in wrong way. Actually i created 5 databases other than default one that is mysql and test I created the 5 different database for my client and i want to resitrct them for particulary size limt. So is this possibl

Trouble creating foreign keys

I can't seem to be able to create foreign keys. Here are my create procedures and the error I am receiving. CREATE TABLE `test1` ( `a_id` smallint(6) NOT NULL default '0', PRIMARY KEY (`a_id`), KEY `a_id` (`a_id`) ) TYPE=InnoDB; CREATE TABLE `test2` ( `b_id` smallint(6) NOT NULL default

Re: hi

The first step is to get a working example- WARNING: you may have to compile the library to get it working on your platform.. Good Luck, Martin - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 28, 2003 2:08 AM Subject: re: hi > On Th

Problem with Connecting remote MySQL (RH8.0)

Hi, I've been facing problem while trying to access remote MySQL database using PHP. It is working fine with the local database. I did in the following way: Created a user on the database with [EMAIL PROTECTED] identified by 'password'; Warning: Warning: Lost connection to MySQL server duri

Problem while accessing remote database

Hi, I've been facing problem while trying to access remote MySQL database using PHP. It is working fine with the local database. I did in the following way: Created a user on the database with [EMAIL PROTECTED] identified by 'password'; Warning: Warning: Lost connection to MySQL server duri

multiple mysqld-max running ?

hi list fellows, os: suse linux 8.1 myqld: mysql-max-4.0.12-pc-linux-i686 i'm using innoDB and a standard my.cnf (medium) config file. every time i start the mysqld, there are over 11 deamons running, each one with 40MB ! the same constellation on a freebsd 4.6.2, same mysqld vers

weekly timestamp query

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi just a question.. wondering if anyone knows how to query for Weekly data (e.g. Week 1 , Week 3... and so forth) from a table that includes the "timestamp" column in a format of ("-mm-dd hh:mm:ss") . Thanks - -- Jasmine Chua -BEGIN PGP

re: Memory Leak

The variables we change are the following:   set-variable = key_buffer=32Mset-variable = max_allowed_packet=1Mset-variable = table_cache=512set-variable = sort_buffer=512Kset-variable = record_buffer=512Kset-variable  = max_connections = 500 It's 500 max connections and the server has 512 Kb

Numbering within groups

Hi I have the following problem: I have a database with two fields "projectid" and "partner". Here some data: Projectid / Partner 1 / A1 2 / A2 2 / B2 3 / A3 3 / B3 3 / C3 4 / A1 4 / B4 ... I want to number the partners for every project, e.g. Projectid / Partner / Partnernumber 1 / A1/1 2 /

re: Re: [OT] destructive / negative / pathology testing *help, help!*

On Friday 28 March 2003 11:53, Henning Heil wrote: > Does anyone have more 'phantasies' on that? I think, there are no solutions that are ready for that kind of job. Maybe you better make a 'test suite' by yourself? -- For technical support contracts, goto https://order.mysql.com/?ref=ensit

re: please help me

On Friday 28 March 2003 13:59, Ing.Peter Misovic wrote: > i have deleted mysql database, > can i restore it with start defaults ? mysql_install_db is your solution. :) > Thailon, Slovakia -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored b

re: Memory Leak

On Friday 28 March 2003 11:23, DeepBlue wrote: > I'm experiencing a memory leak problem on a server with runs Mysql 3.23.55 > with 1000 simultaneous users. > > It's an athlon XP 1800 with 512 Mb ram. > > Befor starting Mysql, webmin shows 350 Mb free memory, but after starting > mysql server it go

re: mySQL on Windows 2000 Server

On Friday 28 March 2003 11:23, Neil Tompkins wrote: > Has anyone installed mySQL on Windows 2000 server, can you tell me your > experiences, or should I look for another option ? MySQL is a native win32 application and runs excellent on Win2k. It's a good choice. -- For technical support

Problem with Linux

Hi, I experience problems connecting to my MySQL 3.23.55 on Linux Debian from a Windows client: through the MyODBC connection everything is fine but direct access through development tools like Delphi/dbExpress doesn't work. Of course, the params and privileges are correct (username,pass,port,I

please help me

i have deleted mysql database, can i restore it with start defaults ? Thanks, Thailon, Slovakia -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

All Tables MyISAM and still InnoDB Datafiles?

Hi! > "Stephan" == Stephan Amann <[EMAIL PROTECTED]> writes: Stephan> Hi all! Stephan> I've downloaded the binary distribution Stephan> mysql-standard-4.0.9-gamma-sun-solaris2.9-sparc-64bit.tar.gz from Stephan> www.mysql.org. Stephan> I have a couple of databases on this installation, wit

Re: "Soon"?

Hi! On Mar 27, Martin Gainty wrote: > Hej Michael- > > In order to to see 4.1 mysqladmin working > I started to compiling the 4.1 source obtained from bitmaker > Originally I had 1000 errors with 1000 unresolved link errors.. > I am down to about 50 on both counts > > God Tur- > Martin You, ob

RE: granting privileges using wildcards

Just run mysql in it's own little "jail" with --user=mysql # or some username you add to the tables... Regards, Kelly Black -Original Message- From: Dimitar Haralanov [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 26, 2003 4:18 PM To: [EMAIL PROTECTED] Subject: Re: granting privileg

RE: sum() using group, and duplicates problems...

Don This is more help than I ever anticipated, and I certainly thank you very much. Let me digest / re-program this. If there's anything I can do you for, just let me know. Thanks lots! Regards, Kelly W. Black Linux was very clearly the answer, but what was the question again? -Origin

Re: [OT] destructive / negative / pathology testing *help, help!*

Egor, all, in addition to my first posting and to clear things up a bit: I am a little step further at the moment, in general you can say negative testing is going beyond the borders of normal (load, stress, fail-over, UAT, etc.) testing. Some aspects of negative testing in my (just reached and

re: hi

On Thursday 27 March 2003 06:18, Hridyesh Pant wrote: > i am just new for MySql,can any body tell be from where i have to start > learn MySql for Unix or Linux. Take this brand new Paul's book: http://www.mysql.com/portal/books/item-75.html It's really excellent. That will help. > Thanks.

Join Statement

Greetings MySQL folk, New to MySQL.here goes. Have db with following tables : Client : ClientID | ClientName | Address | Distance | ContactName | ContactNo Jobs : JobID | ClientID | JobDate | JobDistance | JobWorkDone | JobTimeTaken | JobTypeID JobTypes : JobTypeID | JobDesc I need to cre

re: MySQL connection problem

On Thursday 27 March 2003 07:48, rajup at hydbad dot tcs dot co dot in wrote: > I really don't know whether it is a bug in mysql 4.0.12. > I've downloaded 4.0.12 and installed succesfully on my PC(WIN2k with > SPack2). I've changed the bind-address to "localhost" in my.ini and > re-started mysql.

re: link from Access to MySQL

On Friday 28 March 2003 01:02, Rich Allen wrote: > i found in the ODBC faq how to link from mysql to access, can this be > done in reverse? link from access to mysql? What do you mean by that? MySQL can be used as a backend for Access, i.e. you can create an Access application that could be us

  1   2   >