RE: Secure way of storing passwords in the database

2003-11-07 Thread Erik Osterman
Right, you should really use a 1-way hashing algorithm like SHA1. If the user forget's their password, require them to change it.. which is good practice anyways, since someone else might have found it for them! The general idea with 1-way hashing algorithms is that you compare the result of hashi

Re: multitable sum problem

2003-11-07 Thread Leo
i think you should have a sales person table that hold unique id for each sales force such as salesrep (id,etc..) | 101 | ... | | 102 | ... | so you can alter the query into select salesrep.id, sum(ifnull(salesinvoices.invamt,0)) as curramt, sum(ifnull(lysalesinvoices.lyinvamt,0)) as lyamt fro

Does MySQL support hindi language

2003-11-07 Thread Nitin
Hi all, I have a project in hand, where I need to accept and show data in Hindi language, storage doesn't matter. Is that possible with MySQL, if yes, what do I need to configure? How do I do it, any help or ideas? Regards Nitin

RE:sql question

2003-11-07 Thread Leo
>SELECT forum_categories.id AS `id` , forum_categories.name AS `name` , >forum_categories.createdby AS `createdby` , >forum_categories.order AS `order` ,DATE_FORMAT( forum_categories.created,"%m/%d/%y >%l:%i %p" ) AS `created` , >COUNT( forum_topics.id ) AS `topics`, SUM(forum_posts.id)

Re: Maybe easy, maybe hard SELECT puzzle :)

2003-11-07 Thread Leo
>But it I want all records from Table1 that have features 'A01' _and_ 'B02', >clearly >SELECT * from Table1 JOIN Features USING(id) WHERE >Features.FeatureCode='A01' AND Features.FeatureCode='B02' doesn't work. okay maybe this one is a more stupid and complex solution :) but i think it should wor

Re: Secure way of storing passwords in the database

2003-11-07 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Luis, et al -- ...and then Luis Lebron said... % % Any suggestions of a "secure" way of storing membership passwords (for a % website) in a mysql database? Should I use sha, aes, des??? Do you really need to be able to decrypt and get the plaintext

Strategies for optimizing a read-only table

2003-11-07 Thread Jonathan Terhorst
I could have sworn I posted this once before, but apparently it got lost somewhere. Apologies if you're seeing this twice: I'm wondering what I can do with MySQL to optimize reads (SELECTs) on a read-only table where data will never be INSERTed or UPDATEd. Okay, that's not entirely correct--the

Maybe easy, maybe hard SELECT puzzle :)

2003-11-07 Thread Jonathan Terhorst
I can't figure out if this is actually challenging or if it's a stupid question. Table1 is a normal old relation that describes a bunch of objects: Table1 (id INT PRIMARY KEY NOT NULL, Name varchar(255), Size int) etc. Associated with each Table1 record is a variable-length of 3-byte alphanumeric

AMD64 Performance

2003-11-07 Thread Wendell Dingus
I've recently gotten an AMD Opteron 64-bit machine for MySQL testing and eventual deployment. I have a web server with MySQL and 48 databases of roughly 36GB total, stored as INNODB. The current server is a dual Xeon 2.8Ghz machine with 4GB RAM. Since it's 32-bit about 1.2GB is the highest I can ge

Re: Can't set myisam_repair_threads

2003-11-07 Thread Matt W
Hi, Yes, that's what I was gonna say. It's not in 4.1.0 because it was released *before* 4.0.13. Matt - Original Message - From: "Jeremy Zawodny" Sent: Friday, November 07, 2003 6:45 PM Subject: Re: Can't set myisam_repair_threads > On Fri, Nov 07, 2003 at 02:00:39PM +0100, Eric Jain

Re: Issues with Mysql 4.0 and PHP in a production environment

2003-11-07 Thread Jeremy Zawodny
On Fri, Nov 07, 2003 at 07:59:36AM -0600, Luis Lebron wrote: > Anything that breaks a script (unsupported functions, changes, etc.) or that > causes performance problems. I'm still not sure what you're looking for. A list of known bugs, maybe? It's trivial to do something in MySQL that breaks a

Re: ROWID

2003-11-07 Thread Jeremy Zawodny
On Thu, Nov 06, 2003 at 01:02:31PM -0800, Mike Brando wrote: > > > -Original Message- > > On Thu, Nov 06, 2003 at 09:59:41AM -0800, Wan, Wenhua wrote: > > > Hi there, > > > > > > Both Oracle and Informix use ROWID to uniquely represent the location of > > > each row of data in a table. RO

MySQL Success Story

2003-11-07 Thread Aftab Jahan Subedar
Dear Lists & MySQL, I have just released the site www.DhakaStockExhcnageGame.com which uses MySQL database and CGICC heavily. "I Like MySQL, cuz, I can twist,turn,roll and whatever I want with its MySQL C API". Thank you MySQL, you all are really good. Dont become sooo commercial. Aftab Jahan

Re: Can't set myisam_repair_threads

2003-11-07 Thread Jeremy Zawodny
On Fri, Nov 07, 2003 at 02:00:39PM +0100, Eric Jain wrote: > >From http://www.mysql.com/doc/en/News-4.0.13.html: "Added multi-threaded > MyISAM repair optimisation and myisam_repair_threads variable to enable > it." > > The variable is also documented in > http://www.mysql.com/doc/en/SHOW_VARIABLE

Re: Very strange problem

2003-11-07 Thread Jeremy Zawodny
On Fri, Nov 07, 2003 at 09:16:03AM -0800, Eric Anderson wrote: > > A little explaination: [snip] > The threads connecting from the 1U (192.168.0.2) all start to block up > as expected, but when the length query on the e450 stops running, the > threads from the 1U stay blocked, and all NEW thread

Re: performance while creating indexes

2003-11-07 Thread Jeremy Zawodny
On Fri, Nov 07, 2003 at 05:03:43PM -0600, William Baker wrote: > Sorry for the slow reply. I was battling SCSI controller bugs as well > as database issues. I have given up on the software raid for now > because it is unstable. Really? I've run Linux software RAID quite happily on several sys

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

2003-11-07 Thread Jan Pieter Kunst
At 13:21 -0500 07-11-2003, Gabriel Ricard wrote: [1.8 GHz G5:] select: Total time: 1428 wallclock secs (67.50 usr 25.18 sys + 0.00 cusr 0.00 csys = 92.68 CPU) [dual 2.0 GHz G5:] select: Total time: 146 wallclock secs (42.52 usr 33.74 sys + 0.00 cusr 0.00 csys = 76.26 CPU) How the select po

Urgent Pl: problem with rename the field name: IN

2003-11-07 Thread karthikeyan
how to rename a field name "IN" to something else.. I could not use alter table tbl_name change IN NEW mediumtext; Pl. suggest how to rename particular "field name" for all the tables in a database thanks M.Karthikeyan -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Re: performance while creating indexes

2003-11-07 Thread William Baker
Sorry for the slow reply. I was battling SCSI controller bugs as well as database issues. I have given up on the software raid for now because it is unstable. Back to the subject at hand: performance. You are right, the "load" is meaningless outside the context of a specific machine...and of

Re: single quotes in database

2003-11-07 Thread Peter Burden
[EMAIL PROTECTED] wrote: You can use addslashes and stripslashes when inserting and selecting respectively. addslashes will turn your name into O\'connel. and stripslashes will bring it back to the displayable format. check out php.net/addslashes php.net/stripslashes An alternative is to use

sql question

2003-11-07 Thread Chris Edwards
Hi Using mysql 3.23.54 I'm trying to join three tables. categories, topics, posts. I just want the categories to print out, with the number of topics in each category, and the number of posts in each topic. ex output: Category | Topics | Posts Cat One | 3

Re: aes encryption bug

2003-11-07 Thread Herb Rubin
Paul, Is there a limitation on having a TINYBLOB as a primary key? Herb On Thu, 2003-11-06 at 19:24, Paul DuBois wrote: > At 15:29 -0800 11/6/03, Herb Rubin wrote: > >Paul, > > > >I did try VARCHAR(16) BINARY and it still failed to INSERT in a NOT NULL > >column. > > > >The encrypted string see

64bit gcc build on Red Hat Enterprise Linux 3 (RHEL3) for Linux on POWER

2003-11-07 Thread Matthew Davis
Hello, World. I successfully built a 64bit MySQL for SuSE Enterprise Linux Server 8 (SLES8) for Linux on POWER. The SLES8 gcc implememtation has two separate toolchains for 32 and 64 bit. However, RHEL3 has a biarch gcc implementation, where the -m64 flag is used to tell the compiler/linker t

Re: Cronjob / rights problem - 2:nd try.

2003-11-07 Thread Bernard Clement
Hello Anders, Sorry, I did not go through the end of your message. You also have a problem with psql which is, I think, the equivalent of mysql for PostgreSQL. Do you need PostgreSQL? If not, you should deactivate it. For your problem with mysqladmin, most probably specifying the switch --hos

MySQL Control Center

2003-11-07 Thread Dennis Strickland
Are there any help files for MySQL Control Center at this time? Dennis H. Strickland SatisFacts Research, LLC 2360 W. Joppa Road., Joppa Concourse Building Suite 322 Lutherville, MD 21093 Toll Free: 866.655.1490 ext. 103 Fax: 866.655.1491 Local: 410.583.9080

Re: Cronjob / rights problem - 2:nd try.

2003-11-07 Thread Bernard Clement
Hello Anders, NOTE: I am actually using SuSE 8.2 Pro Edition. However, those CRON jobs seem to be at the same place irrelevant of the distro (RedHat or SuSE). Therefore, I doubt that SuSE Linux Standard Server 8 has changed that. If the problem occurs once a day then it is within the script

Re: mysql processes

2003-11-07 Thread Gabriel Ricard
On Friday, November 7, 2003, at 01:21 PM, Hugh Beaumont wrote: Hi List, I've searched the archives and the web many times in the past for answers to the following questions but never really got a complete understanding of what is going on. Hopefully someone on the list will be able to take the

Cronjob / rights problem - 2:nd try.

2003-11-07 Thread Anders Norrbring
[Second try, the first one rendered a few hints that didn't help] I've set up a new MySQL server on a box with multiple IP addresses, and the SQL server only binds to ONE of these addresses. Also, I've been changing some user rights in the SQL setup, and now I get a cronjob error, related to use

How do I distinguish between a TEXT and BLOB field

2003-11-07 Thread David Ritter
Hello, I am having trouble finding a way to tell if a result set field I am looking at is from a TEXT column or BLOB column since the C API lumps both types together under FIELD_TYPE_BLOB. Does anyone have any advice on a method to distinguish between these two types? Thanks! Dave

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread Jeff Mathis
kevin, i tend to think the consultant really just read something that microsoft sent him. it doesn't sound like he's qualified to suggest one database or another. We've been usinf mysql for a year now. We use InnoDB tables, which give us primary key/foreign key constraints and transactions. We've

RE: Loosing "é" characters in DB insertion

2003-11-07 Thread Yves Arsenault
The only language I installed on this box is English... would that be why? Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 14:16 To: 'Yves Arsenault'; Victor Pendleton; 1Mysql Subject: RE: Loosing "é" characters in DB insertion The Red Hat

RE: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread John Griffin
What about MySQL-max/SAPDB? I believe that it was completely omitted in the consultants report but has many of the features you need. I would also like to ask a question; do you need stored procedures, triggers or views for your application? There are a number of high volume, high quality sites

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread KEVIN ZEMBOWER
Nestor, thanks for your question. The platform will actually be dictated by the SQL engine, not the other way around, which is more typically the case. If we go with MS SQL Server, we'll build a separate host, NT I would guess, to host it. I'm only responsible for Unix and Linux boxes here, so

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread Brent Baisley
It sounds like a copy and paste from Microsoft, but that is just my guess. An objective recommendation with show pluses and minuses of both. It most definitely does not sound like this consultant is qualified to suggest a database product. What about PostgresSQL, Oracle, Sybase, DB2? They all a

Re: SQL [Q] how to migrate 4.0 -> 4.1

2003-11-07 Thread Andrey Kotrekhov
SQL mysql Hi, All. Other question is: Can I create case sensitive field with right ordering of national characters. > > HI, All! > I have a question. > I migrate from 4.0.14 to 4.1.0 but: > the 4.0.14 show me: > mysql> desc statname; > +--+-+--+-+-

Re: aes encryption bug

2003-11-07 Thread William R. Mussatto
Paul DuBois said: > At 15:29 -0800 11/6/03, Herb Rubin wrote: >>Paul, >> >>I did try VARCHAR(16) BINARY and it still failed to INSERT in a NOT >> NULL column. >> >>The encrypted string seems to be equivalent to the NULL value even >> though it visually looks like some kind of data. >> >>Herb > > Ok

Re: Issues with Mysql 4.0 and PHP in a production environment

2003-11-07 Thread Gabriel Ricard
We've been using PHP 4.3.x and MySQL 4.0.x for a few months now on our production systems and had encountered only one problem unrelated to PHP (an issue where LOAD DATA FROM MASTER would wipe out all of the tables in the database, even if it was just using wildcard replication for a few tables

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread Nestor Florez
I have not work with it but postgres is supposed to work great in /BSD/Linux/Unix/solaris environment Which platform are you using? :-) Nestor A. Florez >>> "Martijn Tonies" <[EMAIL PROTECTED]> 11/7/2003 10:08:53 AM >>> Hi Kevin, > Martijn, thank you very much for your analysis. >I hope othe

multitable sum problem

2003-11-07 Thread David Katz
I have the following two tables: salesinvoiceslysalesinvoices salesrepidsalesrepid invamt lyinvamt I am trying to get a current year and last year sum for each sales rep. The problem is it looks like it is resuming each file for each record

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

2003-11-07 Thread Gabriel Ricard
On Friday, November 7, 2003, at 03:06 AM, Jan Pieter Kunst wrote: Hardware: 1.8 GHz G5 with 1GB RAM Panther (Mac OS X 10.3) doesn't have the sudden slowness in the 'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther is faster than total time for Jaguar (5561.00 secs vs. 677

mysql processes

2003-11-07 Thread Hugh Beaumont
Hi List, I've searched the archives and the web many times in the past for answers to the following questions but never really got a complete understanding of what is going on. Hopefully someone on the list will be able to take the time to set me straight. I have a typical php + mysql + linux s

Re: Additive UPDATE

2003-11-07 Thread "Héctor Villafuerte D."
Héctor Villafuerte D. wrote: Héctor Villafuerte D. wrote: Hi all! I need to perform what I've called an "additive UPDATE". The logic is the next: (1) There's a historic table (HISTORY) with two fields: mysql> create table history (ID char(7) primary key, VAL int(12)); (2) There's a new table eve

RE: Stupid permission question

2003-11-07 Thread Victor Pendleton
query your use table and see if the anonymous user is still present. You will need to delete this account and flush privileges. -Original Message- From: Steven Lefevre [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:33 AM To: [EMAIL PROTECTED] Subject: Stupid permission quest

Re: Benchmark differences: Mac OS X - Linux

2003-11-07 Thread Gabriel Ricard
On Friday, November 7, 2003, at 09:05 AM, David Steinbrunner wrote: The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The Linux machine was a default SuSE 8.0 installation. ext2 as the filesystem? No idea about journaling. No SCSI or RAID, just an internal IDE disk. Both machines a

RE: Loosing "é" characters in DB insertion

2003-11-07 Thread Victor Pendleton
The Red Hat client does not display the 233 the same as the MS client. The underlying data should be the same. Try to dump the decimal values of the data in question and see if 233 is present where it is supposed to be. -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread Martijn Tonies
Hi Kevin, > Martijn, thank you very much for your analysis. >I hope others will continue to join in. So do I :-) > With regard to your point quoted below, are you referring to PostgreSQL, and would that be a > stronger competitor to MS SQL Server 2000 than either the current version of MySQL or

RE: Loosing "é" characters in DB insertion

2003-11-07 Thread Yves Arsenault
Red Hat 9. Looking at the data through Webmin, it appears as though the text is correct in the DB in certain fields, in some others, there are strange characters... I think the clients db may have had slight errors... In any effect, the web interface that is run off this DB doesn't display the 'é

Stupid permission question

2003-11-07 Thread Steven Lefevre
Hey folks - I have an installation of mysql 3.23 from debian stable, installed with apt-get. I'm trying to create users but I'm running into problems. I'm using phpmyadmin, and myabe that's the problem, I don't know. Here's something that confuses me: $> mysql -uanna -p Enter password: Welcome

RE: Very strange problem

2003-11-07 Thread Eric Anderson
> Is anything being logged in the error log? Nope. My 'wait_timeout' was set to 120 seconds, I reduced that down to 60 seconds but I don't think that will help because once it gets "stuck" in this blocked thread thing, it never recovers.. any subsequent connections never actually process, until t

RE: MySQL query question

2003-11-07 Thread Andy Eastham
Chris, You're almost there! select * from temp where col2 like concat('%',col1, '%'); Andy > -Original Message- > From: Chris A. Mattingly [mailto:[EMAIL PROTECTED] > Sent: 07 November 2003 17:01 > To: [EMAIL PROTECTED] > Subject: MySQL query question > > > I've searched around on the li

RE: Loosing "é" characters in DB insertion

2003-11-07 Thread Victor Pendleton
What operating system does the MySQL server reside? The ASCII representation for é is 233. Is this the same value for the host machine? -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:27 AM To: Victor Pendleton; 1Mysql Subject: RE: Loosi

RE: Very strange problem

2003-11-07 Thread Victor Pendleton
Is anything being logged in the error log? -Original Message- From: Eric Anderson [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:16 AM To: [EMAIL PROTECTED] Subject: Very strange problem A little explaination: We've got two servers, e450 (3.23.47) and 1U (4.0.14). These

RE: Loosing "é" characters in DB insertion

2003-11-07 Thread Yves Arsenault
The è caracter is being changed to a square... Yves -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: 7 novembre 2003 13:19 To: 'Yves Arsenault'; 1Mysql Subject: RE: Loosing "é" characters in DB insertion Are the é being replaced by another character? -Orig

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread KEVIN ZEMBOWER
Martijn, thank you very much for your analysis. I hope others will continue to join in. With regard to your point quoted below, are you referring to PostgreSQL, and would that be a stronger competitor to MS SQL Server 2000 than either the current version of MySQL or MySQL 5? Thanks, again, for

RE: Loosing "é" characters in DB insertion

2003-11-07 Thread Victor Pendleton
Are the é being replaced by another character? -Original Message- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 10:05 AM To: 1Mysql Subject: Loosing "é" characters in DB insertion Hello, I just took over a site from a client, he used an Access DB, the D

Re: Need help comparing MySQL to MS SQL Server

2003-11-07 Thread Martijn Tonies
Hi Kevin, > I'm a system administrator for a small (200 people) branch of a large university/medical school. I've worked with MySQL and use it as my database of choice for web-based dynamic content. I would not consider myself an experienced, professionally-trained, knowledgeable database adminis

Very strange problem

2003-11-07 Thread Eric Anderson
A little explaination: We've got two servers, e450 (3.23.47) and 1U (4.0.14). These two machines have a private connection between them (192.168.0.1 and 192.168.0.2). The e450 is the master server, and the 1U has a copy (no replication) of some basic data, so it can run server-intensive pages.

HELP is missing

2003-11-07 Thread Andy Thiel
Hi I'm attempting to use your mysql control center v. 0.9.3 beta. I want to load information into a database from a file, but am having problems. Why don't you have any HELP contents? Thanks, Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

MySQL query question

2003-11-07 Thread Chris A. Mattingly
I've searched around on the lists archives and even did some googling, but I'm having trouble finding the answer to this question. Given that I have a table with 2 columns (say col1, col2) I want to be able to search for the value of col1 in the value of col2. Let's say that in one instance co

Re: aes encryption bug

2003-11-07 Thread Herb Rubin
Paul, TINYBLOB does seem to hold the value properly. I can't use a TINYBLOB in a primary key. Is this not allowed? The ALTER statement complains that I am using a column without a length specified. Herb On Thu, 2003-11-06 at 19:24, Paul DuBois wrote: > At 15:29 -0800 11/6/03, Herb Rubin wrote:

Need help comparing MySQL to MS SQL Server

2003-11-07 Thread KEVIN ZEMBOWER
I'm a system administrator for a small (200 people) branch of a large university/medical school. I've worked with MySQL and use it as my database of choice for web-based dynamic content. I would not consider myself an experienced, professionally-trained, knowledgeable database administrator, mor

Re: single quotes in database

2003-11-07 Thread jeffrey_n_Dyke
You can use addslashes and stripslashes when inserting and selecting respectively. addslashes will turn your name into O\'connel. and stripslashes will bring it back to the displayable format. check out php.net/addslashes php.net/stripslashes hth Jeff

single quotes in database

2003-11-07 Thread Steve Buehler
I am using PHP/MySQL and am having a problem. We have some names and addresses in the database that have single quotes in them. For instance. There is a town around here called "Lee's Summit". Also names like "O'connel". When I pull from the database it skips these because of the quotes.

Re: How can I become an Expert MySql User?

2003-11-07 Thread mos
At 06:29 AM 11/7/2003, you wrote: HiY'll I've been using MYSQL for a couple of years now. And can write some pretty complex WHERE statements. I've become aware that's really only tip of the iceberg stuff. Can readers suggest a "gentle" path to moving onto JOINS and a more fundamental understanding

Loosing "é" characters in DB insertion

2003-11-07 Thread Yves Arsenault
Hello, I just took over a site from a client, he used an Access DB, the Database contains mostly french text... I've created a dump file to transfer the DB to MySQL, but when I execute the code, the é characters are lost. They're being created as VARCHAR.. I'm not a very experienced MySQL user

Difference between 'mysql_real_query' and 'mysql_send_query'

2003-11-07 Thread Pascal Francq
Hi all, I'm using mysql 4.0.11a and I meet a probleme with mysql_real_query(). It retruns a "commands out of sync" , but my queries are well-ordered. I found another query command called "mysql_send_query()". If I use it, the queries success. But I can't find the difference between mysql_send_que

RE: remote connection

2003-11-07 Thread Curtis Maurand
For some reason, MySQL treats "localhost" as a special case (at least that seems to be the behavior." If you run grant on to user@'%' identified by 'password'; will allow login from anywhere but the localhost. That account must be created seperately. Curtis John Almberg said: > Yes I w

Can't force "Repair by sort"

2003-11-07 Thread Eric Jain
Is there any way to force a "Repair by sort" rather than a (way to slow) "Repair with keycache" when doing an "ALTER TABLE t ENABLE KEYS"? The table in question is 6GB large and contains 100M rows. I have set myisam_sort_buffer_size=512MB myisam_max_sort_file_size=1MB myisam_max_extra_s

Re: Secure way of storing passwords in the database

2003-11-07 Thread Henning Heil
Luis Lebron wrote on 07.11.2003 15:22 Any suggestions of a "secure" way of storing membership passwords (for a website) in a mysql database? Should I use sha, aes, des??? thanks, Hi Luis, try md5 encryption for passwords in your application and write md5-encrypted values to simple v

SQL [Q] how to migrate 4.0 -> 4.1

2003-11-07 Thread Andrey Kotrekhov
SQL mysql HI, All! I have a question. I migrate from 4.0.14 to 4.1.0 but: the 4.0.14 show me: mysql> desc statname; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

2003-11-07 Thread Jan Pieter Kunst
I was wondering if you had journaling turned on in Panther and not in Jaguar? I'm not sure if it would have any effect on selects, I would think it would slow down inserts not selects. You notice the CPU breakdown is different. Journaling was turned on in both cases. JP -- MySQL General Mailin

Secure way of storing passwords in the database

2003-11-07 Thread Luis Lebron
Any suggestions of a "secure" way of storing membership passwords (for a website) in a mysql database? Should I use sha, aes, des??? thanks, Luis R. Lebron Sigmatech, Inc

Max connection

2003-11-07 Thread Kittiphum Worachat
Hi. When MySQL reach max connection can root use mysql client program to login and look for some process that can be kill to release connection. I had ever seen from some web said that some user with PROCESS_ACL privileges can do (can login MySQL reserved 1 connection for user who has PROCESS_

Re: MySQL benchmarks on the G5: Jaguar vs. Panther

2003-11-07 Thread Brent Baisley
Thanks for posting the comparison, it's something I've been meaning to do myself. I was wondering if you had journaling turned on in Panther and not in Jaguar? I'm not sure if it would have any effect on selects, I would think it would slow down inserts not selects. You notice the CPU breakdow

RE: remote connection

2003-11-07 Thread John Almberg
Yes I was already pretty sure it was a rights issue. What I'm trying to do is modify the rights for a particular user so I can log in remotely. The question is what I should use for the host fields in the various tables so that I can log in remotely *and* the web server can log in through local

Re: Benchmark differences: Mac OS X - Linux

2003-11-07 Thread David Steinbrunner
The Mac was HFS+ journaled. Disk: the stock Apple-supplied one. The Linux machine was a default SuSE 8.0 installation. ext2 as the filesystem? No idea about journaling. No SCSI or RAID, just an internal IDE disk. Both machines are really consumer-level machines, no heavy-duty server hardware. That

RE: Issues with Mysql 4.0 and PHP in a production environment

2003-11-07 Thread Luis Lebron
Anything that breaks a script (unsupported functions, changes, etc.) or that causes performance problems. thanks, Luis -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Thursday, November 06, 2003 4:09 PM To: Luis Lebron Cc: Mysql (E-mail); Php-General (E-mail) Subj

myisam_max_sort_file_size not set

2003-11-07 Thread Eric Jain
In my.cnf: [mysqld] key_buffer_size=64M myisam_sort_buffer_size=512MB myisam_max_sort_file_size=100 myisam_max_extra_sort_file_size=0 bulk_insert_buffer_size=64MB ... All variables are set as expected, except myisam_max_sort_file_size, which is set to 4GB. Only if I choose a value smaller

myisam_max_extra_sort_file_size

2003-11-07 Thread Eric Jain
>From the documentation: "If the temporary file used for fast index creation would be bigger than using the key cache by the amount specified here, then prefer the key cache method." Did I understand correctly that if I always want fast index creation whenever myisam_max_sort_file_size is set larg

Can't set myisam_repair_threads

2003-11-07 Thread Eric Jain
>From http://www.mysql.com/doc/en/News-4.0.13.html: "Added multi-threaded MyISAM repair optimisation and myisam_repair_threads variable to enable it." The variable is also documented in http://www.mysql.com/doc/en/SHOW_VARIABLES.html: "If this value is greater than one, MyISAM table indexes during

How can I become an Expert MySql User?

2003-11-07 Thread zzapper
HiY'll I've been using MYSQL for a couple of years now. And can write some pretty complex WHERE statements. I've become aware that's really only tip of the iceberg stuff. Can readers suggest a "gentle" path to moving onto JOINS and a more fundamental understanding of DBs No rude answers please

Re: How to generate data sequences simple way?

2003-11-07 Thread Martijn Tonies
Hi Petr, > I hope someone can help me with the following problem: I have a table > containing integer counters associated with particular datetime like this: > > CREATE TABLE `counters` ( >... >`when` datetime NOT NULL default '-00-00 00:00:00', >`counter` smallint(5) unsigned NOT

Cronjob / rights problem.

2003-11-07 Thread Anders Norrbring
I've set up a new MySQL server on a box with multiple IP addresses, and the SQL server only binds to ONE of these addresses. Also, I've been changing some user rights in the SQL setup, and now I get a cronjob error, related to user rights... My big problem is that I don't even know where I should

Re: Dillema: LIKE vs MATCH - AGAINST

2003-11-07 Thread daniel
Man, if you need a full boolean search, ie more than one word, use fulltext !, it crunches cpu so you need a beasty machine, use like if its just one string you are searching for in a varchar field, use fulltext if you are searching in wads of text. I highly recommend match against though, its the

Dillema: LIKE vs MATCH - AGAINST

2003-11-07 Thread Ciprian Trofin
I'm building a financial-like web site (PHP - MySQL). I was requested to build a search engine for IT. Everything works OK, w/ the exception of a certain component. The owner of the web site will write, each day, a report for the customers. I use TEXT fields to record each section of the report (t

RE: Need ur help ..........

2003-11-07 Thread Andy Eastham
Renuka, Put the file into a location such as /usr/local Gunzip it: gunzip mysqlgui-linux-semi-static-1.7.5.tar.gz Unpack it: tar -xvf mysqlgui-linux-semi-static-1.7.5.tar create a symbolic link from "mysql" to "mysqlgui-linux-semi-static-1.7.5" under /usr/local/ ln -s /usr/local/mysqlgui-linux-sem

How to generate data sequences simple way?

2003-11-07 Thread Petr
Hello, I hope someone can help me with the following problem: I have a table containing integer counters associated with particular datetime like this: CREATE TABLE `counters` ( ... `when` datetime NOT NULL default '-00-00 00:00:00', `counter` smallint(5) unsigned NOT NULL default '0',

Need ur help ..........

2003-11-07 Thread Renuka Prasad
Hi, I downloaded Linux semi static binary of mySQL,mysqlgui-linux-semi-static-1.7.5.tar.gz. Could you please help me,how to install in my system.My OS is Redhat Linux9.0. Warm regards, Renuka Prasad.N

MySQL benchmarks on the G5: Jaguar vs. Panther

2003-11-07 Thread Jan Pieter Kunst
Hardware: 1.8 GHz G5 with 1GB RAM Panther (Mac OS X 10.3) doesn't have the sudden slowness in the 'insert' test that Jaguar (Mac OS X 10.2) has. Total time for Panther is faster than total time for Jaguar (5561.00 secs vs. 6770.00 secs). 'Insert' is faster on Panther than on Jaguar (3316 secs v