Re: How compressable is a typical MySQL database?
would probably be very dependent on the data within the database. if it's a lot of text data, then very compressable, as text typically compresses nicely. if you store a bunch of binary data (images or something), then probably not as much... tar your mysql dir and gzip it, or gzip -9 or bzip2 if you're looking for more compression. test it out. -tcl. On Sun, 17 Feb 2002, George Labuschagne wrote: Hi list, How compressible is a typical MySQL database? Is this more dependent on the type of columns used i.e. a lot of text columns as opposed to a lot of columns containing integer values? The uncompressed size of the database is in the region of about 800-MB. Also will it suffice to only compress the specific sub-directory pertaining to the relevant database below /mysql/ ? George mysql, sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: No Database Encryption
it's not all that dangerous. it just means that you can read your users' passwords. anyone who can read that db table can become any of your users. password fields are just another safeguard against a just in case someone gets read access to this scenario. they also serve to provide more privacy to your users. re: some of your users may not want you / the admins of whatever service you're providing being able to read their passwords. but maybe you want to be able to read your users' passwords, for testing purposes or whatever. -tcl. On Wed, 12 Dec 2001, James McLaughlin wrote: The new programmer for our company is not using the dataType password or any encryption what so ever for our user accounts (accounts that our customers use for getting into our system) in our database. Instead he is using the VarChar dataType. Can someone explain to me how I can exploit this and show them it is very dangerous. Thanks James - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Password encryption
you can use the password() mysql function to crypt it. you cannot retrieve the encrypted password -- only compare input (password() the input) against the saved encrypted password. if the resulting text matches, the password is good. if not, the authentication in your application should fail. -tcl. On Thu, 13 Dec 2001, ST Ooi wrote: How can I encrypt password in database and how can I retrieve the encrypted password? Thanks ST Ooi Malaysia - Original Message - From: Dan Nelson [EMAIL PROTECTED] To: James McLaughlin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, December 13, 2001 7:06 AM Subject: Re: No Database Encryption In the last episode (Dec 12), James McLaughlin said: The new programmer for our company is not using the dataType password or any encryption what so ever for our user accounts (accounts that our customers use for getting into our system) in our database. Instead he is using the VarChar dataType. Can someone explain to me how I can exploit this and show them it is very dangerous. It's only dangerous if a customer can trick your web frontend into displaying the output of SELECT * FROM USERS, for example. If the frontend only uses hardcoded queries, or quotes every user-supplied parameter, there's no problem. In fact, you need the password in plaintext to support a I forgot my password; email it to me feature. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Linux vs. Sun and getting Linux to behave like Sun
they're both behaving similarly, it's just that linux's implementation and display of threads is different than solaris'. the same correlation of threads for connections is there on solaris, you just won't see it on a ps command's output. -tcl. On Thu, 6 Dec 2001, Peter M. Perchansky wrote: Greetings everyone: I've noticed that when mySQL runs on Sun Solaris (6, 7, and 8) there will be two processes running (safe_mysqld and mysqld). And this number of processes running will very rarely change, if at all, without concern over the number of connections or how heavily mySQL is being utilized. On Linux there appears to be a correlation to the number of mysqld processes and how heavily mySQL is being hit (connections, queries, etc.). Questions: 1.Are my observations correct? 2.Is there a way to compile mySQL on Linux so that it behaves like on Sun where by there is the safe_mysqld and mysqld process only no matter the activity? If so, how? Thank you. Peter M. Perchansky, President/CEO Dynamic Net, Inc. Helping companies do business on the Net 420 Park Road; Suite 201 Wyomissing PA 19610 Non-Toll Free:1-610-736-3795 Personal Email: [EMAIL PROTECTED] Company Email:[EMAIL PROTECTED] Web: http://www.dynamicnet.net/ http://www.manageddedicatedservers.com/ http://www.wemanageservers.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ENUM or not ENUM?
check out the "set" type instead of enum. http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Column_types http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET -tcl. On Tue, 20 Feb 2001, [KOI8-R] "îÉËÏÌÉÎ óÅÒÇÅÊ" wrote: Hello I have situation where I can't decide whether to use ENUM type. Here is a situation: table contains records about CarID and its colour(s). Each CarID is allowed to have more than one colour such as red, green, blue. CarID may have just one colour. This is the code I would use to create table Colours: CREATE TABLE Colours( CarID INT UNSIGNED, Colour ENUM("red", "green", "blue"), PRIMARY KEY(CarID)); The question is- how can I create a record of a car that has more than one colour? I also need to link my database with data entry interface, so interface has a tick boxes corresponding to all colours for a car. Currently I have solved the situation this way: there are three tables Colour, Car and Colours. Table Colour stores ColourID and ColourName; table Car stores CarID and CarName; table Colours stores CarID and ColourID, where the primary key is (ColourID, CarID). So I can have more than one colour (if there is a need for it) for one car. I can easily pull out colours to the interface, so user is able to select corresponding colours. Everything works just fine. Is it a sensible approach not to use ENUM and create "transition" table such as above (Colours)? Which way is more efficient? Your help will be very much appreciated. Thanks. Sergey. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Transaction support in MySQL?
http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html#Missing_Transactions http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#BDB -tcl. On Tue, 13 Feb 2001, Eric Kwong wrote: I'm wondering if MySQL supports transaction? Since I have an application to use MySQL JDBC to perform several insert statements and then do a rollback, all data saved to the database without rolling back. -Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: aborted connections?
thanks for the reply. i found a followup on this problem from sasha ("Follow up on aborted connections bug in 3.23.31"), but wading through the archive searching for the original thread hasn't ended up being successful yet. anyone know offhand in which thread this was originally discussed? not all of these errors are coming from php connections. does php have some related issue with this also? -tcl. ps- i like these informative changelog entries: . "Fixed security bug in something (please upgrade if you are using a earlier MySQL 3.23 version)." . "Fixed buffer overflow bug when writing a certain error message." On Tue, 23 Jan 2001, Maciek Uhlig wrote: Read the archives. The detailed story can be found there. Use newest MySQL and newest PHP CVS. These errors will go away. Maciek -Original Message- From: tc lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 3:56 AM To: [EMAIL PROTECTED] Subject: aborted connections? we're seeing a lot of errors like these in our error log files from mysql: 010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY' host: `ZZZ' (Got an error reading communication packets) i haven't investigated too too much about this yet, but i was wondering what common problems this error might be associated with. i'll keep looking through the manual, but suggestions would of course be wonderful. the connections are over ethernet/tcp, and the eth interfaces on the mysql server are showing 0 errors after months of uptime, so i'm guessing it's not a tcp/ip issue, as the wording of that error might suggest. -tcl. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL vs Oracle
er, what? did i miss something? heh. -tcl. On Mon, 22 Jan 2001, Nathan Cook wrote: Note: As of version 3.2.3gamma Mysql Supports Sub-Selects. .:: Nathan Cook [ [EMAIL PROTECTED] ] ::. Systems Network Administrator :: Programmer [ phone - 208.343.3110 ][ pager - 208.387.9983 ] - Original Message - From: "Scott Gerhardt" [EMAIL PROTECTED] To: "Ann Ricchiazzi" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, January 22, 2001 12:10 PM Subject: RE: mySQL vs Oracle Hello Ann, The answer to you question depends on how you plan to use the database (i.e. financial trancactions, serving data on the web etc.) as well as financial considerations. MySQL is free and Oracle is expensive. Here are some questions you should answer: 1.) Do you need full Transaction support (commit roll-back)? 2.) Do you need subselect and union queries? 3.) Do you need Triggers and Stored Procedures? 4.) Do you absolutely need Foreign Key support? If you anwered YES to any of the above go with Oracle, Sybase, Frontbase, Openbase etc. otherwise, MySQL is an excellent choice. MySQL is very fast and probably faster than Oracle in most cases but I have no documented proof (Oracle doesn't like having their benchmarks published). I know this isn't a definite answer and you are on a tight deadline. Hope this helps just the same. ___ Scott A. Gerhardt P.Geo. Gerhardt Information Technologies [EMAIL PROTECTED] ___ I am trying to choose between mySQL and Oracle for a Linux server. My specific questions are: 1) Will mySQL handle 3000 hits/day well? 2) Does mySQL handle multi-media file formats? For example, if I want to store audio clips, or Flash movie clips, or PowerPoint presentations, can I do so? We make the decision this decision at 3:00 today. Your advice will be most helpful. Thanks, Ann - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bdb table stability / what to watch out for?
in the mysql manual, i noticed: "Even though Berkeley DB is in itself very tested and reliable, the MySQL interface is still considered beta quality. We are actively improving and optimizing it to get it stable very soon." a team i'm in is considering trying bdb tables for some things for a queue table of sorts. seeing if the row-level granularity of bdb tables or transaction support can help us. i'm wondering what is yet considered unstable about bdb tables, or what we should watch out for or test if we try using it under a good amount of load. i saw the note about deleting tables when not in auto commit mode. anything else that is a known or unconfirmed but possible issue that we could possibly help test out? comments more than welcome! -tcl. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
aborted connections?
we're seeing a lot of errors like these in our error log files from mysql: 010122 17:38:52 Aborted connection 177373 to db: 'XXX' user: 'YYY' host: `ZZZ' (Got an error reading communication packets) i haven't investigated too too much about this yet, but i was wondering what common problems this error might be associated with. i'll keep looking through the manual, but suggestions would of course be wonderful. the connections are over ethernet/tcp, and the eth interfaces on the mysql server are showing 0 errors after months of uptime, so i'm guessing it's not a tcp/ip issue, as the wording of that error might suggest. -tcl. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php