Re: Upgrading from 3.23 to 4.0 Problem
I think that fastest way to get round this (mite be wrong) is to use the binary. Then all you need to do is change the sym link! This is a bit of a work round but should work? Simon - Original Message - From: Ross O [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 19, 2004 9:12 AM Subject: Upgrading from 3.23 to 4.0 Problem Im trying to upgrade 3.23 on my redhat 9 machine. I have one lone perl-dbd-mysql libmysqlclient dependency that is throwing me off. when i try to upgrade it wont go. so i try to uninstall that perl rpm and it says its mysql 3.23 needs it and when i try to uninstall mysql 3.23 it says the perl dbd needs it. how do i get around this catch? __ Do you Yahoo!? Yahoo! Mail SpamGuard - Read only the mail you want. http://antispam.yahoo.com/tools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Data lost
I hope this helps. What table format are you using? When did data loss happen eg. after power loss? Yes do use the MySQL tools to repair the tables. Also you could run the bin logs back in to MySQL so all sql changes are run on the table again. The other thing to think about is locking tables can copying them to back up. This way you just have to lock db and copy back! Simon - Original Message - From: Kelvin Leung [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 3:23 AM Subject: Data lost My client reported the a case to me. He said one mysql table lost some of the data. The table structure is shown as follows: +---+---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+---+--+-+-+---+ | uid | varchar(32) | | PRI | | | | createdate| datetime | YES | | NULL| | | lastmoddate | datetime | YES | | NULL| | | num_of_files | int(13) | YES | | NULL| | | createby | varchar(32) | YES | | NULL| | | field_107666797596432 | varchar(255) | YES | MUL | NULL| | | field_107666798773233 | varchar(255) | YES | MUL | NULL| | | field_107666808467434 | varchar(255) | YES | MUL | NULL| | | field_107666809745535 | decimal(13,5) | YES | MUL | NULL| | | field_107666813934636 | varchar(255) | YES | MUL | NULL| | | field_107666815016037 | varchar(255) | YES | MUL | NULL| | | field_107666815625938 | text | YES | | NULL| | +---+---+--+-+-+---+ The fields field_x lost data in most of the records, but no data was lost on other fields. Do you think it is possible? I'm guessing that it is caused by the corrupted index file. Does it help if I repair the index file? Your suggestion is greatly appreciated as I need to suggest my client how to recover the data. --- Kelvin Leung IPOS Computer Systems Limited http://www.iposcsl.com/ Mobile: +852 9199-5852 Tel: +852 2329-0345 Fax: +852 2329-0343 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Speed of MyISAM vs. InnoDB
Is it just not the case that InnoDB table have to do more as they have more functionality and so take more time? Simon - Original Message - From: Ji Matjka [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 10:38 AM Subject: Speed of MyISAM vs. InnoDB Hi all, I'm using mysql 4.0.17 and I have this problem with speed of innodb database: I have simple command like select count(*) from table1, or select field1, field2 from table1. The table1 and has more than cca 10.000 rows (most of the fields are integer, only several varchars and several memos) and its type is InnoDB. Then the query lasts too long, at least several seconds, sometimes more than 5. If I convert it to MyISAM then the query lasts usually less then 0.3 second. If the table is small (cca less than 5.000 rows) then there is not big difference... Is it normal, that InnoDB isn't able to access large table as quickly as MyISAM? Or is there any parametr to set to make InnoDB run faster? I need to use InnoDB because it supports transactions and MyISAM not... thx Jiri Matejka [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem Installation
Here's another hintfrom the mysql site: http://www.mysql.com/information/presentations/presentation-oscon2000-27 19/index.html Increase number of open files for system and for the SQL server. (add ulimit -n # in the safe_mysqld script). Also -- http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html#Server_pa rameters Any help? Simon - Original Message - From: Carlos André Moura de Amorim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 18, 2003 6:10 PM Subject: Problem Installation I have a installation problem in the my server. After of command ./scripts/mysql_install_db appear the o error: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031217 14:32:34 Warning: setrlimit couldn't increase number of open files to more than 256 (request: 510) 031217 14:32:34 Warning: Changed limits: max_connections: 100 table_cache: 73031217 14:32:35 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h gray.ecmal.br password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com please, somebody help me!!! *** Carlos Andre Moura de Amorim -- Funcionario UNCISAL -- Tecnico de Informatica CEFET-AL -- Acad. de Mecicina UNCISAL -- Fone: (0xx82) 9904-0117 *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Backup question.
Has any one use LVM to take a snapshot in MySQL and use this to back up data? Simon -Original Message- From: Paco Martinez [mailto:[EMAIL PROTECTED] Sent: 18 November 2003 10:00 To: Christensen, Dave; 'Richard Reina'; [EMAIL PROTECTED] Subject: Re: Backup question. Is there any problem executing rsync /var/lib/mysql/data/ from one host to another host and therefore having same file in obth machines?? Is it unsafe this method ?? Could be crashed meanwhile transferring ?? Thanks !!! - Original Message - From: Christensen, Dave [EMAIL PROTECTED] To: 'Richard Reina' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:20 PM Subject: RE: Backup question. Yes, you can do it like this: Prompt mysqldump --add-drop-table --host=source.IP.addr.spec -uuser -ppassword databasename | mysql -uuser -ppassword I've found that it helps things if you add --no-data to the source side on the first pass, then remove that clause and run it again. Dave -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:54 PM To: [EMAIL PROTECTED] Subject: Backup question. I would like to backup databases from a linux MySQL server to another linux machine on the same private network but I don' see in the docs how I can do this with mysqlhotcopy or mysqldump. Is there any way to do this besides using ftp. Any help would be appreicated. Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: I need the opposite of BINARY
CONCAT turns every this in to a string then puts them together? LIKE is not case sensitive with string? When is this turned in to BINARY? What have I missed please Simon -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 15:38 To: [EMAIL PROTECTED] Subject: I need the opposite of BINARY Hi, I do the following: somequery ... WHERE CONCAT(anumber, aname) LIKE '12SomeString' As explained in the manual this is treated as a BINARY comparison i.e. case of the letters matter. I need a case independent comparison here. Is there a way to get the usual behaviour of LIKE in this case? (besides translating all characters to LOWER which is IMHO no elegant solution). TIA Thomas Spahni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Starting the mySQL Server
On UNIX you need to run a creat datbase using scripts/mysql_install_db Simon -Original Message- From: Larry Wasserman [mailto:[EMAIL PROTECTED] Sent: 20 October 2003 16:30 To: [EMAIL PROTECTED] Subject: Starting the mySQL Server I cannot start the MySQl Server. I am running Windows XP. I checked the error file and get the following message. 031020 10:11:56 InnoDB: Started 031020 10:11:56 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 031020 10:11:56 Aborting What do I need to do for my mysql.hosts file? Where should it be located? _ Larry Wasserman Two Prudential Plaza Enterprise Marketing Automation180 North Stetson, Suite 5200 SAS Institute Inc. Chicago, IL 60601 mailto:[EMAIL PROTECTED] Phone: 312-819-6800 x8826 Pager Phone: 888-446-6597 Fax: 312-240-0342 SAS ... The Power to Know -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Check for data before inserting
Why would the REPLACE statement not work? Simon (ps mite have missed some thing if so sorry) -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: 17 October 2003 14:08 To: Mike Knox Cc: '[EMAIL PROTECTED]' Subject: Re: Check for data before inserting Mike Knox wrote: Traditionally, I'd take the following approach 1) Update - assume it's there 2) If update fails (0 rows) do an insert Thats assuming that the update case is more prevalent. If the row is unlikely to be there - insert and do the update if you get a duplicate key. You have to lock the table first, or another user might insert the record between 1 and 2. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Parallel Processing
This is down to the OS. As MySQL is multy threaded its all down to SMP support. Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 16 October 2003 12:25 To: [EMAIL PROTECTED] Subject: Parallel Processing I've been reading the online docs and asking around about MySQL's ability to perform parallel processing. It does not appear to support such functionality. Maybe this is intentional, or I missed something in the manual. I have a 4 way Intel server that I'd like to be able to contain certain user's queries to certain processors. Does anyone know of a method/tricks/techniques to achieve this? RedHat Linux 9 MySQL 3.23.54 Thanks in advance, Tony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Newbie Q: how to send the records of a table to a file and th en print them out?
http://www.mysql.com/doc/en/SELECT.html Look at INTO OUTFILE for what you need. Simon -Original Message- From: Wang Feng [mailto:[EMAIL PROTECTED] Sent: 29 September 2003 08:54 To: [EMAIL PROTECTED] Subject: Newbie Q: how to send the records of a table to a file and then print them out? Greetings, I use WinXP and MySQL. I have a customer table, which contains about 200 records. Now I want to print all the records of the table out. How can I achieve that? Can I send them to a .doc OR .txt file before printing? cheers, feng -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
NFS and MySQL
Hi I know that there are two problems when using NFS and MySQL. One is speed. My question is that with a good filer like a Netapps with Gig Ethernet would speed stop being a problem? Two locking. Why is this a problem? Do locks get missed when righting from the system to the filer? Thanks for any help on this Simon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Managing big tables
Hi The only thing I can say is that if you optimise the table often there is less work for it to do so you table will be left locked for shorter time. I have not looked in to this but if you use the RAID option. I don't know if splitting the table up you could just work on one bit at a time?? Simon -Original Message- From: Alexander Schulz [mailto:[EMAIL PROTECTED] Sent: 15 July 2003 13:35 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Managing big tables Hello, i've got a little problem, we're using mysql with two big tables (one has 90 Mio. Rows (60 Gb on HD), the other contains nearly 200.000.000 (130 Gb on HD). Now we want to delete some rows from these tables to free diskspace. It seems that MySQL frees the harddisk-space which was used by these rows only after optimization, which lasts very long on these tables. Both tables are dynamic in terms of row-format what seems to extend the time needed for optimization. I tried to convert the smaller one to fixed-row-format, which increased the disk-space of its data-file from 30 Gb to 60 Gb. This would not be the problem, but some SQLs which are run daily on this table now run 4 times slower than with dynamic structure. So, my questions are: 1) Did i something wrong while converting to fixed row-format ? (i found no indication) 2) Is the fixed structure really faster on optimization ? 3) Can anybody confirm the slow-down on big tables when converted from dynamic to fixed ? (on small tables fixed were faster) I'm running SuSE Linux, Kernel 2.4.20, the above behaviour could be reproduced with our productive server (MySQL 3.23) and with a test server (MySQL 4.0.12). thanks in advance, alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Ideal setup
As much memory as you can get you hands on (we have 4 gig). As fast disks as you can get. Then a good multi threading operating system (64 bit would be nice). Simon -Original Message- From: mixo [mailto:[EMAIL PROTECTED] Sent: 09 July 2003 08:58 To: [EMAIL PROTECTED] Subject: Ideal setup Perfomance matters the most. So, what would be the ideal setup for permomance in Mysql? Machine specs: PIII 1.0 GHz 640 MB Ram 36 Gig Hd partions as follows: /dev/sda1 linux swap1 Gig /dev/sda2 / 11 Gigs /dev/sda3 /var 11 Gigs /dev/sda4 Free 11 Gigs /dev/sda4 is not currently mounted, so that in future when redhat has new releases, the insallation can be made without changing the existing installtion -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysqld problem
Try this in mysql/bin/perror Tells you what the error code means. ---snip--- ./perror 13 Error code 13: Permission denied ---snip--- Simon -Original Message- From: Grzegorz Golofit [mailto:[EMAIL PROTECTED] Sent: 04 June 2003 08:36 To: [EMAIL PROTECTED] Subject: Mysqld problem I have problem with running mysqld I installed the following rpm packages incladed with RedHat 7.1 (Seawolf) edition cd`s which I am running on my machine: -mysql-3.23.36-1 - mysql-server-3.23.36.1 - mysql-devel-3.23.36-1 First I tried to initialize as a root tables with following command: mysql_install_db and then typed in safe_mysqld . I got the following inforamtion on the screen: Starting mysql deamon with database from /var/lib/mysql and then mysqld ended. In the /var/log/mysqld.log file I had the following information: mysql started /usr/libexec/mysqld: Can`t find file ' ./mysql/host.frm' (errno: 13) mysqld ended I couldn`t see any mysql tables or databases in mentioned above file. Could you tell me what I did wrong My Linux kernel is 2.4.2-2 on i686 and the glibc is glibc-2.2.2-10. This is partitionless instalation. My hardwear is: Athlon 1.8 XP Thanks in advance Gregory -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: images with mysql
I had a go with putting a image into MySQL and it did not work. But what I did do is put the directory and image location /image/smile.jpg. This is very good way to use the index of the db and the speed of the file structure. Sorry if this was not what you were looking for but I hope it helps a bit. Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 20 March 2003 09:34 To: [EMAIL PROTECTED] Subject: Re: images with mysql Hi! I have a problem with my MySQL I need to have some a images related with an item for example -- ! author ! date of birth an death ! image! -- How can I define the field for the images? I have read that LONGBLOB could be useful for large objct like images, but I can't understand how to set it in my database... Thank you in advance stefano -- S t e f a n o C a r d o Debian GNU-Linux user - 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
Problems installing supper-smack
Hi I am installing MySQL's supper-smack on Linux. The problem is that it will not 'make'. It errors on two files 'die.cc' and 'gen_data.cc'. If in add '#include cstdlib' to die.cc and '#include cstring' to gen_data.cc in will 'make' and 'make install'. But then will not work. It runs with out any errors but there is no output and only thing that dose happen is data is added to the test table. Can any one tell me what I have missed? Thanks Simon - 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: Newbie question...
No this is not right. How are you creating the tables? How are you entering the data? Where are you putting them? e.g. /mysql/var/your_table.frm What type of table are you using? Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:29 To: [EMAIL PROTECTED] Subject: Newbie question... Hi ppl!. I'm running Mysql Server 4.0.10 in Win XP. And every time i shutdown the service, i loose all data inside the tables? Is this normal, i've i forget something? Thankz, Nando - 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
FW: Newbie question...
The table type HEAP is in MEMORY table so if you turn off or cash you loss your data. The up side is speed. Try table type = MyISAM Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:43 To: Simon Green Subject: Re: Newbie question... Well i've created the tables using the MySQL control center. The program that is inserting the data, is a program develop by me in delphi. But it work fines. If i insert some data and go to mySQL Control Center the data is there. All fields with no problem. I installed mySQL server in 2 different pc's, with the same problem. Every time i stop the service, all data is gone. The tables type is HEAP. They're located at /mysql/data/ - Original Message - From: Simon Green [EMAIL PROTECTED] To: 'Fernando Morais' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, February 25, 2003 1:30 PM Subject: RE: Newbie question... No this is not right. How are you creating the tables? How are you entering the data? Where are you putting them? e.g. /mysql/var/your_table.frm What type of table are you using? Simon -Original Message- From: Fernando Morais [mailto:[EMAIL PROTECTED] Sent: 25 February 2003 13:29 To: [EMAIL PROTECTED] Subject: Newbie question... Hi ppl!. I'm running Mysql Server 4.0.10 in Win XP. And every time i shutdown the service, i loose all data inside the tables? Is this normal, i've i forget something? Thankz, Nando - 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: Highly Reliable MySQL Installations
Hi Richard What we do is use Master Slave set-up on MySQL. So the Master dose all the work and the slave is like a host standby that we do backups from. We use Heartbeat (HA project) with all requests going to one IP. As soon as MySQL fails on box one the IP address is past to the slave. Another system pages us. I do not allow the Master backup until some one has looked at it. We have one Linux box and one FreeBSD to prevent OS problems. Simon -Original Message- From: Richard Morton [mailto:[EMAIL PROTECTED]] Sent: 20 February 2003 11:58 To: MySQL List Subject: Highly Reliable MySQL Installations Hi, I am looking for advise on producing a MySQL platform which is reliable (i.e. fault resilient). I am not sure how, using MySQL's technology I can have two systems each one mirroring the other, and if the primary server fails, how the system can automatically use the other server for all DB access. What is the avg latency on the slave server in Replication? Any Ideas or Suggestions on this? Thanks Richard - 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: Checking existence of a table.
show tables from databasename; Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 17 February 2003 16:11 To: [EMAIL PROTECTED] Subject: Checking existence of a table. What query would I use to check for an existence of a table within a database? I'm currently writting a set of scripts in php. Is this possible with MySQL or do I need to create a condition within PHP? Thanks, Ed mysql - 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: beginner stuff; cant create database
Put the error number in to perror in ../mysql/bin It will then tell you what the error is about. ---snip--- /usr/local/mysql/bin$ ./perror 13 Error code 13: Permission denied ---snip--- This is an operating system error. Simon -Original Message- From: wiley [mailto:[EMAIL PROTECTED]] Sent: 03 February 2003 04:44 To: [EMAIL PROTECTED] Subject: beginner stuff; cant create database Easy question for beginner. Why am I getting this error ? I just installed Mysql and I'm trying to create a database. Beginner stuff... E:\mysqladmin create TestDB mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'testdb'. (err no: 13)' thanks in advance for anything... - 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: What is faster?..
The fastest way would be to use C. But the reason for using a DB would be. 1. Access to data. You could use PhPMyAdmin or some thing you put together to update the policy so making managing the data easy (possibly so non tickers should make changes). 2. If the data you are getting needs to be retrieved relationally. How I would set up you web sit is.. MySQL backend with just text fields storing the data. Put some perl/php/C/ruby together to fetch the data. Feed this into some XML. Then feed this to XHTML and use CSS. .NET mite be worth looking at to? Hope this helps a bit? Simon -Original Message- From: Justin Cook [mailto:[EMAIL PROTECTED]] Sent: 31 January 2003 02:32 To: [EMAIL PROTECTED] Subject: What is faster?.. Hello- I am in the early stages of setting up a website running mysql. The idea is for the user to be able to compare insurance policies and choose the best one. I want to give them the option of choosing several insurance plans and compare them side by side. My question is would it be faster/more efficient to: a) Store policy wording in html format in a mysql table; or b) generate them from a perl script example user chooses plan a and plan b - hits the compare button to see policy wording compared side by side - would it be better to call it from the mysql table or a perl script? I thank you in advance. Justin - 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: SELECT UPDATE
Did the update work? I would expect it did and is just reported that you have not added or taken away any rows. Simon -Original Message- From: Daniele Lo Re [mailto:[EMAIL PROTECTED]] Sent: 28 January 2003 14:24 To: [EMAIL PROTECTED] Subject: SELECT UPDATE Hi everybody. I got a really weird behaviour from Mysql, while doing some select and update queries. I made a select, something like: SELECT Something FROM WHERE and the result was not empty. But when I tried to make an update: UPDATE..WHERE , with THE SAME WHERE clause, result was empty. I'm sure that it's not reguarding permissions, and rows were not updated yet, that is UPDATE returned: Matching rows = 0 Updated rows = 0. A MATCH() search was used in the queries. Does anybody have ideas. Thanks Daniele - 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
Replication.
Hi I have two questions about replication on MySQL. One: How far behind can a SLAVE get on reading the BIN log before not being able to catch up? My SLAVE was off for 4 days and it just seams as if it can not catch up. Two: On SHOW SLAVE STATUS one of the fields in called Skip_conunter. Due to an error I ran SET SQL_SLAVE_SKIP_COUNTER=n. The number in the Skip_conunter is about the same number as I set skip to, but every time I do a SHOW SALVE STATUS it shows a different number. What dose Skip_counter mean and so why is the number changing. Thanks Simon - 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: Mandatory server downtime?
There are two ways I use to dynamic backup. One lock table can copy it. Use some think like hotcopy. The only down side can be that if the table is very big the lock can queue two may questions. The other way it to use replication can make the backup from the slave. If it is taking up to an hour are they doing a full systems backup? Simon -Original Message- From: Clemente [mailto:[EMAIL PROTECTED]] Sent: 21 January 2003 10:44 To: [EMAIL PROTECTED] Subject: Mandatory server downtime? Hi there, My hosting company tells me that they need to take down the MySQL server every day for 30 to 60 minutes to make a backup. This is the quote: Please note that mysql is shutdown daily sometime between 3am and 9 am US eastern for 30 minutes to an hour. This is get a good backup of all mysql databases on the server during the daily backup process. Is this normal? This implies that my dynamic generated web site is down during a 2.1% to a 4.2% of the time (not counting any other server down time). I hear that normal down times for web sites are more like 1% or less. Is this really necessary? Does MySQL requires to be shutdown to generate a good backup? Any comments are welcome. Thanks a lot. -- Clemente Zamora GlobalReservas (http://www.clementezamora.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: index problem
In the first statement you are selecting * (ALL the row) from tbl1 with no restricting comment (e.g. where) so if you are going to select every thing in the table you do not need to use the index (MySQL uses B-tree). Simon -Original Message- From: Prasanth Krishna [mailto:[EMAIL PROTECTED]] Sent: 16 January 2003 09:31 To: [EMAIL PROTECTED] Subject: index problem hi i have a database with a single table say tbl1 with an index on a particular field say col1. when i say select * from tbl1; it doesn't use the index on that table. but if i say select col1 from tbl1; it uses the index. how to make mysql use the index on col1 for the first query? thanks in advance. Prasanth - 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 Error
The error that you have is normally that MySQL in not running. If it is running then MySQL client can not find the sock file. I should not think you will have to reinstall. Simon -Original Message- From: Daniel Florian [mailto:[EMAIL PROTECTED]] Sent: 15 January 2003 13:11 To: [EMAIL PROTECTED] Subject: Mysql Error When I try to connect to the MySql server on localhost I get the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) I am not quite sure what this means. I am running Mac OS X 10.2.3. Before I upgraded from 10.1, I had no problems, but now am unable to connect at all. Is it possible to remove MySql (and how do I go about it) so that I can reinstall it again? Sorry if these are stupid questions, but I can't seem to find how to uninstall MySql in the manual. Thanks -- Daniel Florian [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] (work) - 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: Foreign keys
Use table type =Innodb for foreing keys and transacionts...etc and type =myisam for speed Simon -Original Message- From: Octavian Rasnita [mailto:[EMAIL PROTECTED]] Sent: 14 January 2003 10:20 To: MySQL Subject: Foreign keys HI all, I've read the following text in a book: ANSI SQL supports a special kind of key called a foreign key. Foreign keys help protect database integrity by enabling the database to manage things such as the deletion of rows with dependent relationships in other tables. Though MySQL supports the ANSI syntax for foreign keys, it does not actually use them to perform integrity checking in the database. This is a situation in which the introduction of a feature would cause a slowdown in performance with little real benefit. Applications themselves should generally worry about foreign key integrity. What does this mean? Does MySQL allow using foreign keys or not? Thanks. Teddy, Teddy's Center: http://teddy.fcc.ro/ Email: [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
RE: Solaris Performance
Hi Andy Is MySQL loading the tables in to memory? MySQL AB say running MySQL on 64bit system should be faster. Sorry I can not be more help. Simon -Original Message- From: Andy Eastham [mailto:[EMAIL PROTECTED]] Sent: 13 January 2003 15:34 To: [EMAIL PROTECTED] Subject: Solaris Performance Hi, I've got a mysql application that was developed on win32 and linux that is now going to be deployed on a Sun E250 Solaris 9 box with 3 36Gb non raided SCSI disks. No problem I thought - the performance is fine on my PIII 850MHz laptop, so it will rock on an E250... Not the case - the laptop seems to be performing at twice the speed of the E250 for a simple select from a table of 55 million simple rows (just 3 floating point numbers per row - the .MYD file is 700Mb and the .MYI index file is 2.7Gb). It takes 1.2 seconds on the laptop and 2.5 seconds on the sun. This is a big problem, as I have to do three of these queries plus processing and return in under 10 seconds. The laptop takes 6 seconds, the Sun takes 12. I've got a Linux PIII 933MHz Dell Server which at least half as much again faster than the laptop. I've increased the key cache to 250Mb on the Sun (it's at the default on the laptop), but no radical difference was apparent. The Sun install is pretty much out of the box, apart from the file system organisation. MySQL has its own disk. I'm running the 32 bit variants of MySQL. Would the 64 bit be any different (Solaris 9 is installed with 32 bit and 64 bit support)? Has anyone got any similar experience? Can any one recommend trying anything? Any help, comments or suggestions would be very much appreciated. Thanks very much, Andy [mysql 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: When is learning chargeable to a client?
It is up to you, but for a guide have a look at what MySQL training cover and if you know that then you are up to speed? Simon -Original Message- From: Jeff Snoxell [mailto:[EMAIL PROTECTED]] Sent: 08 January 2003 09:25 To: [EMAIL PROTECTED] Subject: When is learning chargeable to a client? Hi, I suppose this may be slightly off topic and not really relevant to a mysql mailing list, sorry... but... I've spent the last month getting up to speed with MySQL with much help from you guys and Mr DuBois' book. I've done this because an existing client of mine has a system which works with a database engine we developed in house for cheap and cheerful little database applications but their requirements have increased to a point where our little engine is running at max throttle. I proposed that I convert their setup to work with MySQL and said that I would not charge for my time spent learning how to use MySQL. My question is: when developing _any_ software it's almost always a bit of a learning process. I'm always referring to reference manuals etc. etc. whenever I'm developing, even in the languages I'm most familiar with. So where do I draw the line? How can I identify a reasonable point at which it's fair to start logging some hours down to my client? Many thanks, Jeff Snoxell - 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: [OT] Re: InnoDB vs. MySQL performance Issue
I know this is a emotive subject but PLEASE drop it from the MySQL list. Thanks Simon - 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: Backups mechanism
What we have done it right a small script: It logs on to the MySQL server. It then locks the databases and tables we have put in a config file. Simply copies the data files to a new directory. Unlocks the tables. Once this is done (copy if fast) you can tar or zip up the copied files. Simon -Original Message- From: Jonas Widarsson [mailto:[EMAIL PROTECTED]] Sent: 07 January 2003 15:07 To: [EMAIL PROTECTED] Subject: Backups mechanism Hello world! Every attempt I have made to find a decent way of backing up a database ends up with tons of reading to show hundreds of ways to do database backups. I want to know which way to do complete backups is most commonly used by professional users. (Windows and Linux) I have pleasant experience from Microsoft SQL Server 2000 where backung up is very confident, easy to understand and just a matter of a mouse click. Is there any similarily convenient way to do this with mysql, for example: * a shell script (windows / Linux) that works as expected without days of configuration? * scheduled backups, complete or differential? * GUI-solution ??? (mysql control center does not even mention the word backup) Backup is such an important issue. Why does it seem like it is something that the developers don't care about? - 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: column name
ALTER TABLE Simon -Original Message- From: Gianluca Carnabuci [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 16:30 To: [EMAIL PROTECTED] Subject: column name Hi all, I guess it's a dumb question for you guys, but MySql manual doesn't seem to offer newbies a great deal of help on this one: how do I change a column name? Gian - 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: InnoDB crash?
Have you looked if there is a problem with page0page.c ? Simon -Original Message- From: Ervin Gerke [mailto:[EMAIL PROTECTED]] Sent: 10 December 2002 12:07 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: InnoDB crash? Got this one after a power failure. My system is Redhat 7.3, kernel 2.4.18-18.7.x, MySQL-4.0.5a-beta-Max. Let me know if you need any more information. err.log reads: 021210 14:00:41 InnoDB: Started /usr/sbin/mysqld-max: ready for connections 021210 14:00:43 InnoDB: Assertion failure in thread 7176 in file page0page.c line 450 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16773120 read_buffer_size=131072 Number of processes running now: 1 mysqld-max process hanging, pid 4201 - killed 021210 14:00:43 mysqld restarted - 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: total idiot
There is data in the logs. So you mite be able you use them to recreate the data? Simon -Original Message- From: Justin French [mailto:[EMAIL PROTECTED]] Sent: 09 December 2002 09:05 To: MySQL Subject: total idiot Okay, Let's just say I made a stupid mistake, and deleted an entire table's contents, rather than just one row. And let's also assume that the CD burn which has the latest back-up of this data has shit itself, and won't work. I'm still waiting to hear from the ISP about their own back-up, but i'm assuming the worst. Does MySQL remember anything itself? Does it have any back-up mechanisms? Justin French http://Indent.com.au Web Development Graphic Design - 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: Serwer Hardware p4 or pIII ?
Its more to do with the amount of memmory than its speed. As MySQL will try and load as much data (tables) into memmory as posible the more the better. The next thing is disc speed. Simon -Original Message- From: Nicolas MONNET (Tech) [mailto:[EMAIL PROTECTED]] Sent: 04 December 2002 15:46 To: Helmut Apfelholz Cc: [EMAIL PROTECTED] Subject: RE: Serwer Hardware p4 or pIII ? On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote: --- Simon Green [EMAIL PROTECTED] wrote: MySQL uses memory and HDD the most and so processor speed is not so important. Well, processor speed is also important, on some of our servers processors are almost 100% occupied. If your bottleneck is memory speed, you will see 100% CPU usage even if the CPU actually spend 99% of its time idle, waiting for data to come in. I'm not too up to date on the latest RAM technology, but I hear there's several types of DDR, the most expensive one being significantly faster. Or is it? Anyone care to share some insight on this? - 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: Serwer Hardware p4 or pIII ?
MySQL uses memory and HDD the most and so processor speed is not so important. So I would go with what ever costs me the less. Also how you OS works with the processors will be important. What OS are you going to got for? Threads and OS limits will also play a big part with speed. Simon -Original Message- From: Helmut Apfelholz [mailto:[EMAIL PROTECTED]] Sent: 04 December 2002 13:10 To: [EMAIL PROTECTED] Subject: Serwer Hardware p4 or pIII ? Hi, I am assembling mysql only server. I am planning 2Gb RAM, 4 x 15k SCSI disks. However I cannot decide if I should get 2 p4 processors or 2 tuallatin pIII. I could not find any mysql specif?c benchmarks, that would show which processors I should use. I will be running linux on the server. Could anyone share his/hers experience with me ? TIA Helmut SQL, mysql, database __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.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: Replication - if the master fails...
Once server 1 is down you should be able to set server 2 master and then point dns to server 2 and all should be good for server 1 to come back as slave. If you did not set server 2 as slave it would still work as a master the only problem is how to point the questions to server 2! Dynamic DNS? Simon -Original Message- From: Stephen Patterson [mailto:[EMAIL PROTECTED]] Sent: 04 December 2002 23:27 To: mysql list Subject: Replication - if the master fails... We're currently operating 1 MySQL server and are investigating methods for having a primary and secondary server (with the secondary taking over if the primary fails). I know about replication in MySQL, and was thinking of using that to keep the secondary in sync, if the primary should fail, is it possible to set up the secondary in its place? The docs don't seem to clear on that. - 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 and large fields
A LONGBLOB can store 4294967295 bytes A LONGTEXT can srote 4294967295 bytes Simon Green -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: 03 December 2002 11:20 To: [EMAIL PROTECTED] Subject: MYSQL and large fields We have switched over from Microsoft Access to MySQL because we were unable to store large files. 2-3 pages of written text. But M. Access kept messing with the data. MySQL has Blob types that can store large amounts of Data. So, can MySQL store 2-3 pages of text or would this be a limitation. I have tested a few pages and found no problems but I thought I would ask anyway. From what I remember large number of characters should not be in databases. But in our case we are trying to stream line our calendar production. - 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: Error in SELECT
See Notes -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 14:01 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Error in SELECT Hi, I have the following statement that is causing a syntax error: sLearnerSQL = SELECT * From LearnerDetails WHERE Title=' sTitle ' AND FName=' sFName ' AND LName=' sLName ' AND Add1=' sAdd1 ' AND Add2=' sAdd2 ' AND Town=' sTown ' AND County=' sCounty ' AND PostCode=' sPostCode ' AND CurrentlyEmployed=' sCurrentlyEmplyed ' AND TelPref=' sTelPref ' AND TelOther=' sTelOther ' AND TelMobile=' sTelMobile ' AND Email=' sEmail ' Next three lines have no '' AND SourceOfEnquiry= sSourceofEnquiry AND EnqTakenBy= sEnqTakenBy AND DOB= sDOB AND Status=' sStatus ' AND Notes=' sNotes No '; at end Simon - 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 Replication
Not out of the box. You would have to right some code to do this. The best way to do this is get every one who rights code to set up to hosts at the top of there code. Simon -Original Message- From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]] Sent: 21 November 2002 09:48 To: Jon Frisby Cc: [EMAIL PROTECTED] Subject: R: Mysql Replication I want do build a mysql cluster. The master receive all queries. Then, the master write, update, delete, ecc.. the slaves answer SELECTs If this is impossible, which is the utility to have slaves??? -Messaggio originale- Da: Jon Frisby [mailto:[EMAIL PROTECTED]] Inviato: mercoledì 20 novembre 2002 21.10 A: Massimo Bandinelli Oggetto: RE: Mysql Replication No. Why would you wish to do so? -JF -Original Message- From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 7:22 AM To: [EMAIL PROTECTED] Subject: Mysql Replication A question: I've a Mysql System with a Master and two slave. Can I configure my master to automatically forward the select queries to = the slaves? Massimo Bandinelli System Administrator - Register.it S.p.A. - Gruppo DADA tel +39 199 REGIST (+39 199 734478) fax +39 035 3230312 http://we.register.it mailto:[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: SCHEMA, ARCHITECTURE ???
For speed multiple or single database makes no difference. For SQL I would stick with one if all the data is related. Index any thing you are going to select on. So if you have a user database you would index name and password not there age and job title. Simon - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Monday, November 11, 2002 2:02 PM Subject: SCHEMA, ARCHITECTURE ??? Hello All, How do I determine the best architecture for my MySQL database? Do I create multiple databases or do I create only one database with multiple tables? (Any general rules of thumb?) How do I know if I need to use Keys, Indexes or other features in order to optimize the database? - 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: version ?
3.23.55 Production 4.2.2 is ALPHA 4.0.4 is BETA So if you are runing a production server go for 3.* If you can risk it go for 4.0.4 (should be ok) and if you want to have some fun 4.2.2 Simon -Original Message- From: P. Fawcett [mailto:fawcett;bard.edu] Sent: 13 November 2002 16:05 To: [EMAIL PROTECTED] Subject: version ? what mysql version is recommended for running w/apache 1.3.26 php 4.2.2? i'm having trouble getting mysql config'd w/these wonder if i should avoid/lean to any particular versions? - 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: setting passwd?
pp p Look like you need a 'p' :-) Simon -Original Message- From: P. Fawcett [mailto:fawcett;bard.edu] Sent: 13 November 2002 16:28 To: MySQL Mailinglist Subject: setting passwd? after install binary mysql 3.23.49: must be something obvious but i'm missing it - how come i can't set root user passwd? simple syntax error? [root@a bin]# ./mysqladmin -u root -p password pp Enter password: i enter p again ./mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)' # - 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: Scrolling Databases
select * from table_name limit 1; or limit 2,1; I hope this helps a bit? Simon -Original Message- From: Beauford [mailto:beauford.2003;rogers.com] Sent: 12 November 2002 15:04 To: [EMAIL PROTECTED] Subject: Scrolling Databases Hi, I have created a contact database using Mysql and want to be able to scroll back and forth through the database. Even after I have done a search and found a record, I want to be able to scroll back or forth from that point on. I am using PHP4 to display the results. This may be something easy to do, but I have not found any documentation on it, and with my newbie skills at both Mysql and PHP, I haven't been able to put it together. Can someone point me in the right direction. TIA - 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 CPU usage skyrocketing
See links form mail list. http://jeremy.zawodny.com/blog/archives/000203.html#000203 http://jeremy.zawodny.com/blog/archives/000264.html#000264 Simon -Original Message- From: Bogdan TARU [mailto:bgd;icomag.de] Sent: 07 November 2002 10:35 To: [EMAIL PROTECTED] Subject: MySQL CPU usage skyrocketing Hi, I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high loads of the machine, without any apparent reason. We have a new project using this MySQL engine, with lots of inserts/deletes. But it happens that in the mornings, when nobody makes any kind of access to the database, we still have a MySQL daemon eating up 99% of CPU. If I log in as 'root' to the mysql server and make a 'show processlist', the only process in the 'query' command is mine ('show processlist'), all the others are in sleep mode (with NULL info). Is there any periodic maintanance/optimization work that the mysql server is doing? If so, why does it take so long? Can I schedule it sometimes during the night (and if so, how?) Thanks, bogdan iCom Media AG Kirchweg 36 Koln, 50858 Germany Phone: +49-(0)221-485-689-16 Fax : +49-(0)221-485-689-20 Mobile:+49-(0)173-906-46-01 - 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 uses 98% CPU
I like FreeBSD so it pains me to say it but the penguin has it. As threads are so important to MySQL Linux it just better at this at the moment (we will see what happens with V5 FreeBSD). MySQL was developed on Suns Slowlaris so it is a bit more native to Linux... Simon PS the devil will be back :-) -Original Message- From: Toni [mailto:toni;clad4.com] Sent: 06 November 2002 09:18 To: [EMAIL PROTECTED] Subject: Re: MySql uses 98% CPU Thank you everybody for the info. I am considering switching to linux, do you think it is worth it? Does MySql perform better on linux than on a freebsd box overall? Much appreciated Toni Vall - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Nicolas MONNET (Tech) [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, November 04, 2002 4:07 PM Subject: Re: MySql uses 98% CPU On Mon, Nov 04, 2002 at 12:37:15PM +0100, Nicolas MONNET (Tech) wrote: We get the same thing on FreeBSD machines quite often, and it's not related to the actual work being done; MySQL can sit idle but use up all CPU. It happens after a few days/weeks of uptime. That's a known bug in FreeBSD's threading implementation. Disable name resolution and it'll go away. Some details are here: http://jeremy.zawodny.com/blog/archives/000203.html#000203 and http://jeremy.zawodny.com/blog/archives/000264.html#000264 Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 90 days, processed 1,874,326,961 queries (240/sec. avg) - 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
CPU size
One we know how much data we are going to store we can calculate HDD size. Then we look at the types of question we are going to use on the DB and combined with the size of data we now know how mush memory we should need. But how do I know what CPU I will need to run this? I know we need to look at what type of CPU (P,PII,PIII,PIII,AMG,XEON..etc) but there must be some rule of thumb for MySQL ? Simon PS have looked on web and mail list and can not find this :-( - 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
Web server
Hi I am putting together a MySQL server for the ISP I work for. We are going to provide a mysqld for each web user. I plan on using mysqld_multi for this. But what I can not work out is how much CPU and memory I will need for each user. As this is a generic system all I need is a average system! If any one can point me to where I can find this out please. Thanks Simon - 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
mysqld_multi
How much CPU per mysqld_multi user would be needed? I work for an ISP and would like to give 100 users a mysqld each How do a calculate the CPU's I would need? Thanks Simon Hoping to give MySQL to all? - 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: Urgent Help needed
It looks like you have a dynamic IP your end and the mysql server is looking for a fixed IP. Try name based DNS form your PC. Simon -Original Message- From: [EMAIL PROTECTED] [mailto:manuvi;eth.net] Sent: 18 October 2002 09:38 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Urgent Help needed Hi all, I have used the following script to connect our remote database from my local machine. The PHP script is at my local machine. When I tried to connect the database, instead of connecting to the IP provided in the script, it is searching the Dynamic IP of my Internet Service Provider. and getting the following error. Script in my local machine is : ?php mysql_connect(216.180.237.200,let_rot,vindb) or die (cannot connect to mysqld); mysql_select_db(lnet_bbay) or die(cannot select database); ? The IP 216.180.237.200 is the IP provided by my Web space provider. The error message is, Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in c:\apache\htdocs\depots\temp\bomy\connect.php on line 2 Warning: MySQL Connection Failed: Access denied for user:'[EMAIL PROTECTED]' (Using password: YES) inc:\apache\htdocs\depots\temp\bombay\connect.php on line 2 cannot connect to mysqld The IP 203.100.234.139 is the Dynamic IP of my Internet Service Provider. Please help me to sort out the problem. Regards, Vinod. - 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: Select statement paramter
ESCAPE Mite help...? Simon MySQL - 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: Privileges - Does Anybody knows how to answer to me?
OK two thinks to lookat 1. Use GRANTS as you will not have so much truble with them 2. Use mysqlaccess this will tell you if you have got the privileges right.. If a user can select in 'user' table then he can do so on all databases. (what ever is set in 'db') If a user can select in 'db' table then he can do so on that database (what ever is set in 'table_priv') Simon -Original Message- From: Alexander Burbello [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:49 To: [EMAIL PROTECTED] Subject: Privileges - Does Anybody knows how to answer to me? Hi, I read the book, but there is not explain about it. I would like to know when I give privileges to the user, in the table level, and after I give privileges in the database level. Do I replace the privileges? There are two tables ('db' and 'tables_priv') in mysql database. I gave privileges, for example, to the table 'tables_priv', I give only 'select' privilege to the table Tb01. But I give other privileges, now to the table 'db'. I gave 'insert', 'delete' and 'update' privileges to the database 'Test'. Now the user has privileges to: - 'select' the table 'Tb01' - ''insert', 'delete' and 'update' the database 'Test'. Right --- What can he do? Can he insert or delte on the table tb01? Can he select data in all the tables of the database 'Test'? Regards 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: performance et tuning question
I can do a bit. set-variable= max_user_connections = 100 set-variable= max_connections = 500 So if you change max_connections to = 1000. Then set max_user_ connections to the max you what any one IP/host/user to have this will help. The number of simultaneous connections will also be down to your OS so check with that. Another thing to check is that all the connections are dropped after use and so do not hang about and use up threads. Simon -Original Message- From: Amadou Toure [mailto:[EMAIL PROTECTED]] Sent: 14 October 2002 11:13 To: [EMAIL PROTECTED] Subject: performance et tuning question HELLO, we 're using mysql 3.23.49 on a dedicated server (dual processor 933Mhz) with 1,5Gb of RAM and another web server access to the database for dynamic web pages. Our problem is too many connections message, i thing that the mysql daemon is overload because we have up to 4 pages visited and this number grow daily. does someone cant tell me how in details process to do the following things : * tuning mysql * improve performances * configure to allow mysql to hit up to 1000 simultaneous connections thanks Amadou Toure http://www.sentoo.sn - 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: I could't find my.cnf
The file you are looking for is my-huge.cnf, my-large.cnf, my-medium.cnf, ny-small.cnf. Should be under /mysql/share/ Copy to /etc/ and edit for you needs. Simon -Original Message- From: Perumal [mailto:[EMAIL PROTECTED]] Sent: 11 October 2002 06:23 To: [EMAIL PROTECTED] Subject: I could't find my.cnf Dear sir/madam, Please anybody could give me an idea for the below: I installed mysql-max5.1.tar on linux machine but I could not find a file my.cnf over installation directory to set my.cnf to the mysqld file. Regards, Perumal. - 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: copy one database to another
SELECT INTO TABLE! Simon -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Sent: 11 October 2002 06:31 To: Scott Pippin; [EMAIL PROTECTED] Subject: Re: copy one database to another Greetings... I dont think that there is any SQL statement to do that. As of changing the name, You can just go to the data directory of MySQL and change the name of the directory of the database. MySQL stores each database as a directoyr so changing the name of the directory will change the name of the database. I have tried this with MyISAM and ISAM tables, not sure of other table types. Rgds Insane SQLyog - The Definative GUI for MySQL http://www.webyog.com/sqlyog - Original Message - From: Scott Pippin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 11, 2002 4:25 AM Subject: copy one database to another I have one database(test) i would like to copy over to (test1). Ehat is the syntax to do this? Is there any to just change the name of the database? Thanks in advance (query, mysql) - 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: Moving databases
If it on the same system just stop the old mysqld and stat the new one pointing at the same mysql/var/. OR copy the table across useing cp or mv...it should just work (did for me)... This is all unless you are useing a new table format but you could use ALTER TABEL TYPE.. Simon -Original Message- From: Bravismore Mumanyi [mailto:[EMAIL PROTECTED]] Sent: 10 October 2002 12:35 To: MYSQL Subject: Moving databases How can I retain databases I created using MySql 3.23 in Mysql 4.0? - 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: Can't create a new thread error
Sets number of connectons per user/host set-variable= max_user_connections = 100 Sets total number of connections. set-variable= max_connections = 500 Also see number of threads for FreeBSD at www.FreeBSD.org Also in MySQL log on and do a show processlist and see how many connocetons you have. Simon -Original Message- From: Varshavchick Alexander [mailto:[EMAIL PROTECTED]] Sent: 02 October 2002 09:31 To: [EMAIL PROTECTED] Subject: Can't create a new thread error Hi people, Why such a message appears at random times when connecting to mysql: ERROR 1135: Can't create a new thread (errno 35). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug The system is FreeBSD 4.5 with mysql 4.0.2, and there is a lot of available memory. May be mysql is not configured optimally, if so which options should I try tweaking in my.cnf? Any other suggestions? Thanks Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) - 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: Another 'Too many connections' question...
Too many connections Is the message you get when all are used up. The limit is about 1000 (Linux) but can be set higher. With MySQL you can set a limit for each user. So I would set this to say 100 for each user and 1000 in total. What courses this is pconnects or threads that will not drop. If you use pconnects and don't re use them client side these can had around till they are dropped (8 hours standard). The other thing that can happen is when a table is locked by backups or a log question other connections can get backed up. Hope this helps Simon -Original Message- From: Tom Norwood [mailto:[EMAIL PROTECTED]] Sent: 21 August 2002 10:55 To: mysql-list Subject: Another 'Too many connections' question... A couple of weeks ago I came across this error which effectively closed down our site. Two things: (1) I am using Perl DBI to interface mySQL is there any way to effectively capture such errors and provide an alternate web page? I guess there has to be, but I experimented with the 'PrintError' and 'RaiseError' with little joy. (2) At present our MySQL needs are provided by our ISP by means of a shared server (dedicated to MySQL I think!). The 'max_connections' variable (SHOW VARIABLES) is currently set to 300, which seems a bit on low side for a server with 770 databases (SHOW DATABASES) with I don't know how many tables. What causes this error, 'any' connection, admin type connections, etc.? And does this error require a server/mysqld restart on the part of our ISP? They were typically unhelpful when I spoke to them (hope that's not due to ignorance.) Have been looking at dedicated hosting for a while now, but finding the cash and moreover the time to move is proving a slow process. Any help gratefully Rx'd, Tom. - 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: Save Image (GIF or JPEG) file in the database ?
Have a look at http://www.mysql.com/doc/B/L/BLOB.html Simon -Original Message- From: Khanh Pham [mailto:[EMAIL PROTECTED]] Sent: 02 August 2002 09:59 To: [EMAIL PROTECTED] Subject: Save Image (GIF or JPEG) file in the database ? Hello ladies gents, I am new to MySQL. I wonder if I can save a picture in the database, then I can load into a JSP. The perfect example is an employee page ! Thanks in advance for your helps ! /Khanh - 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: a newserver would be better than this mailing list
There is one. Go to http://www.mysql.com/newsletter/ Simon -Original Message- From: Bart Burkhardt [mailto:[EMAIL PROTECTED]] Sent: 30 July 2002 10:12 To: [EMAIL PROTECTED] Subject: a newserver would be better than this mailing list hello list, i think it would be better to have a mysql news server instead of this email list. i will name some reasons that i think of, correct me if i am wrong.. - with a newsgroup you only select the messages that you want to read or where you can give an answer on. - with this email list my mailbox fills with too many single messages, replys are not threaded (no plus sign to expand thread) - when i go on vacation, and return, i would have a mailbox that is flooded causing that my other messages could not be delivered. - using a newsgroup server is less waste of cyberspace because it is centrally located - a mysql newsserver could seperate different subjects like; installation / advanced query / communication / bugreport / announcements / ideas / platform sections.. - there are probably more reasons to setup a newsserver So my question, why this mailing list, why not a newsserver? Bart - 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
Selecting from one table to UPDATE another.
What I am trying to do in MySQL. Table1 UserID ProductID Old_UserID 1 2 4 2 3 5 Table2 UserID ProductID 4 Null 5 Null Table1 has new correct data. Table2 has old incorrect data. The link is Table2.UserID and Old_UserID What I need to do is update Table 2 with the new data from Table 1, But I can not get this to work..e.g. UPDATE Table2.ProductID SET Table2.ProductID = Table1.ProductID WHERE Table1.Old_UserID = Table2.UserID REPLACE will not work as these are not KEY fields. Once I have done the ProductID I should then be able to do the UserID using the ProductID (as all values in one table are unique). Help Simon - 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: Tee Shirt
I went on the Official training course near London (VERY good). But did not get a tee shirt :-( Simon -Original Message- From: Mike Jones [mailto:[EMAIL PROTECTED]] Sent: 19 July 2002 11:05 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Tee Shirt I got one when I went on an Official MySQL training course. There again it doesn't fit me so my wife is wears it. Cheers, Mike Wouter van Vliet [EMAIL PROTECTED] 19/07/2002 09:47:00 Yeah .. I want it too :) .. please tell us ! -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. -Oorspronkelijk bericht- Van: Simon Green [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 18 juli 2002 10:27 Aan: Mysql (E-mail) Onderwerp: Tee Shirt Hi All Some thing that is a bit lighter Where can I get a MySQL Tee Shirt? We now have a FreeBSD devil and a Linux Penguinin my department All I would like it a Dolphin to keep up! Simon - 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
Tee Shirt
Hi All Some thing that is a bit lighter Where can I get a MySQL Tee Shirt? We now have a FreeBSD devil and a Linux Penguinin my department All I would like it a Dolphin to keep up! Simon - 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
INSERT SELECT and VALUES
Hi All I am trying to copy data from one table to another using in MySQL INSERT INTO table1 SELECT table2 statment but I would like to add some fixed values to this and so some thing like. INSERT INTO table1 SELECT table2 VALUES ('A','B'); But I can not find if this can be done or how Thanks Simon - 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 FreeBSD LinuxThreads
Hi Ken I have had a look on FreeBSD.org and can only find a ref to polling as a subroutine that is used if the system crashing. What douse this number? And so how will it effect MySQL? Thanks Simon -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: 16 July 2002 16:07 To: Oleg Borodkin; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL FreeBSD LinuxThreads Hi Oleg, I have similar problems on FreeBSD with one or two slow queries hogging the CPU. I am running native threads. I am looking at a parameter in the kernel (/usr/src/sys/i386/conf/LINT). It is the HZ parameter and has to do with polling frequency. The default is 100, I am experimenting with values from 1000 to 5000. You might give this a try. You will need to build a new kernel. I am not sure this will have any effect on MySQL. This is only a suggestion. Best of Luck, Ken - Original Message - From: Oleg Borodkin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, July 15, 2002 3:24 PM Subject: MySQL FreeBSD LinuxThreads Hello, I have noticed that MySQL server almost hangs up the system while processing a big table (perl script using fetchrow). I didn't experienced this before - may be it's because of LinuxThreads? MySQL launches 38 running processes, but shows only 10 mysql query threads (they are all sleeping except 2 or 3). Thanking you in advance, Oleg Borodkin - 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: RAID
RAID --with-raid splits tables up to stop size problems or put one table on more than one disk. So is not required for hardware raid. Simon -Original Message- From: Ismael Touama [mailto:[EMAIL PROTECTED]] Sent: 09 July 2002 10:26 To: [EMAIL PROTECTED] Subject: RAID Hi, This is my first post... I'm on redhat 7.2, using apache 1.3.23 (patched) on a PowerEdge 2500 in RAID 1 and I want to install MySQL 3.23.51... Must I set to configure the --with-raid ? Do you have good link for documentation ? I reach for in google...i'm late... thanx bbsc ism - 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
Cartesian Product
Sorry I should have made this a bit clear. I have to tables with users names in them. All I need is a list on the Usernames that are in one column but not the other. The problem is like Mr DuBois said, is that I get every possible match like a matrix (I think?). So how do I get the values that are just not it one column? Thanks Simon -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: 27 June 2002 05:00 To: Simon Green; Mysql (E-mail) Subject: Re: Cartesian Product At 13:22 +0100 6/26/02, Simon Green wrote: Hi When I run my MySQL question I get what I think is a cartesian product? SELECT table1,Username FROM table1, table2 WHERE table1.Username != table2.Username; If I just run'=' then no problem but it seems to what to match every thing with every thing and so I run out of memory. Is there a way to do a distinct match? Thanks Simon What do you mean by distinct match? Your != query is effectively a cartesian product that retrieves all but the diagonal elements of the matrix. - 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
Cartesian Product
Hi When I run my MySQL question I get what I think is a cartesian product? SELECT table1,Username FROM table1, table2 WHERE table1.Username != table2.Username; If I just run'=' then no problem but it seems to what to match every thing with every thing and so I run out of memory. Is there a way to do a distinct match? Thanks Simon - 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
Cartesian Product
Hi When I run my MySQL question I get what I think is a cartesian product? SELECT table1,Username FROM table1, table2 WHERE table1.Username != table2.Username; If I just run'=' then no problem but it seems to what to match every thing with every thing and so I run out of memory. Is there a way to do a distinct match? Thanks Simon - 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
Out of memory on simple question.
Hi After running this simple question I get this error. I have looked at the my.cnf file and all looks fine and the system has 1.256 G of memory. Can some one please tell me where I have gone wrong. select in_names.Username from in_names, in_names2 where in_names.Username != in_names2.Username; ./mysql: Out of memory (Needed 8164 bytes) ERROR 2008: MySQL client run out of memory Simon PS Both tables are indexed. - 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: Out of memory on simple question.
Thanks for this... So I think I need some joins! Simon -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: 24 June 2002 12:19 To: Mysql (E-mail) Cc: Simon Green Subject: Re: Out of memory on simple question. * Simon Green After running this simple question I get this error. I have looked at the my.cnf file and all looks fine and the system has 1.256 G of memory. Can some one please tell me where I have gone wrong. select in_names.Username from in_names, in_names2 where in_names.Username != in_names2.Username; ./mysql: Out of memory (Needed 8164 bytes) ERROR 2008: MySQL client run out of memory If you have many names in these tables, this will consume a lot of memory, yes. You are asking for all combinations of names where the name is not the same. This is an example with only five names in each table: mysql create table in_names (Username varchar(30)); Query OK, 0 rows affected (0.02 sec) mysql insert into in_names values(aaa),(bbb),(ccc),(ddd),(eee); Query OK, 5 rows affected (0.01 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql create table in_names2 select * from in_names; Query OK, 5 rows affected (0.03 sec) Records: 5 Duplicates: 0 Warnings: 0 mysql select in_names.Username,in_names2.Username - from in_names, in_names2 - where in_names.Username != in_names2.Username; +--+--+ | Username | Username | +--+--+ | bbb | aaa | | ccc | aaa | | ddd | aaa | | eee | aaa | | aaa | bbb | | ccc | bbb | | ddd | bbb | | eee | bbb | | aaa | ccc | | bbb | ccc | | ddd | ccc | | eee | ccc | | aaa | ddd | | bbb | ddd | | ccc | ddd | | eee | ddd | | aaa | eee | | bbb | eee | | ccc | eee | | ddd | eee | +--+--+ 20 rows in set (0.00 sec) I selected both names, so that you can see what is going on. Each name in one table is matched with _every_ name in the other table, except the one that is the same... just as you asked for. :) -- Roger - 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: GRANTs and %
GRANT ALL ON newstesting.* TO 'clients'@'%' IDENTIFIED BY '123'; TO Simon -Original Message- From: Kaan Oglakci [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 09:05 To: '[EMAIL PROTECTED]' Subject: GRANTs and % Thanks Dan And Okan for replying to my email but I have tried what you have said but I still get the same problem. GRANT ALL ON newstesting.* 'clients'@'%' IDENTIFIED BY '123'; ERROR 1064: You have an error in your SQL syntax near ''clients'@'%' IDENTIFIED BY '123'' at line 1 GRANT ALL ON newstesting.* clients@'%' IDENTIFIED BY '123'; ERROR 1064: You have an error in your SQL syntax near 'clients@'%' IDENTIFIED BY '123'' at line 1 any ideas what is going on? MySQL is server version: 3.23.36 Thanks, Kaan - 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: problem with mysql threads on freebsd
We are ruing a box with freeBSD and MySQL with twin processors It looked like it was using only on processor but we decided that it was the way FreeBSD's threads work? There seems to be two problems with ruing MySQL on FreeBSD. One: Seems not to use both processors (on twin system) Two: All ways a load on 1 even when the system in not at hi load (seem to go down when it is!) What is up with freeBSD or MySQL. Simon -Original Message- From: Leo De Geer [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 09:35 To: Alexander V Zubchenko Cc: Dicky Wahyu Purnomo; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: problem with mysql threads on freebsd On Tuesday 11 June 2002 09.57, Alexander V Zubchenko wrote: Greetings! On Tue, 11 Jun 2002, Leo De Geer wrote: but in my case its not good to have it that way im having one dedikated dual server for the sql and now im yust using one cpu for the sql questions. i nead it to start sub conections to the sql to serv all my conections good. In such case provide, please additional info. AFAIU, You want to use both cpu for sql, in other words, optimal use of Your server. Than, do You recompile (or compile) kernel with SMP support (afaik, this is only arch for multicpu systems, supported by fbsd)? You can b sure, that if mysql will run separate process for each request, it will slowdown perfomance, but never increase it. In fact, balancing load on many cpus is OS task. And multithreaded processes _must_ b processed similarly to multiprocess environment (but i don't know, how exactly fbsd smp-support built). Check Your kernel config /usr/src/sys/i386/conf/name. You may find also this name interesting: LINT - list [almost?] all options recognized in config-file. With respect, Alexander V Zubchenko,E-Mail: [EMAIL PROTECTED] System Administrator, WWW: http://www.hermes-comp.zp.ua/ Hermes-comp, Ukraine, Zaporizhzhya, Geroev Stalingrada 50 phone/fax: +380 612 64-19-72 the kernel is runing both cpu. and the balancing is working good on everything but the sql! i have on my linux sql server aproximatly 100 simultanius conections that du you think that the standard memory size of 128 do you think i nead to put it up to 256 meg in the kernel -- MVH C. Leo De Geer www.dinsignal.com www.ktv.se www.teknikshoppen.nu - 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 problem
What happend when you ran scripts/mysql_install_db ? Also when you run the databases with --skip-grant-tables as soon as you grant a user acess and flush privileges it will then use the grant tables (I think).. Simon -Original Message- From: Simona D'Ambrosio [mailto:[EMAIL PROTECTED]] Sent: 10 June 2002 14:32 To: [EMAIL PROTECTED] Subject: mysql problem Hi! I am new to mysql and this is my problem. The daemon runs well but I can start it only with --skip-grant-tables option, otherwise nothing will work. I set the password for the root user but when I exit the Mysql monitor and try to get in again, no password is request. When I set the password I entered flush privileges, but it returns 0 rows affected, if I try with mysqladmin it returns You have no privileges. Please, help me... I am almost out of mind for this! Simona - 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: Mirroring / synchronizing two MySQL servers on different machines.
There are two ways to do this. One open a hole in the firewall. Two put a second Ethernet card in each system and use this for BIN updates. Simon -Original Message- From: Agris [mailto:[EMAIL PROTECTED]] Sent: 31 May 2002 09:17 To: [EMAIL PROTECTED] Subject: Mirroring / synchronizing two MySQL servers on different machines. Hello! Can anyone help me in this situation - S1: One MySQL on FreeBSD with direct connection to internet; S2: One MySQL on FreeBSD without direct connection (just intranet); I can't connect to S2 from non-intranet but I can connect to S1. What I need is to synchronize S1 and S2 realtime or, at least, once in an hour (updating two tables in one database) automatically. Is it possible, and if is, how? _ Agris Pudans IT Specialist Metro Leo Burnett - 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: Running Multiple MySQL Servers on the Same Machine
You have to look a bit more. There is lots about runing MySQL on windows. It also will not get the MS SQL worm that is about So just have a nother look it will be woth it. Simon PS start.. http://www.mysql.com/doc/W/i/Windows_installation.html -Original Message- From: Inbal Ovadia [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 13:29 To: [EMAIL PROTECTED] Subject: Running Multiple MySQL Servers on the Same Machine Hi all, I want to run multiple mySQL servers on my machine. Can i do this on windows 2000 or just on Unix? because the manual talk about Unix. How can i do this on windows? thanks - 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: changing column name
ALTER TABLE tablename CHANGE oldname newname VARCHAR(40) Simon -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED]] Sent: 30 May 2002 15:37 To: MySql Mail List Subject: changing column name Hi Can anyone plz give me the query for chaning the column name of an existing table(which does not affect the elements of that column). I hope there is a way to do that. Any help appreciated Thanx Anil - 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: killing mysql-threads?
wait_timeout 8 hours as standard Simon -Original Message- From: Anatol Mayr / HEXAGON [mailto:[EMAIL PROTECTED]] Sent: 28 May 2002 09:26 To: [EMAIL PROTECTED] Subject: killing mysql-threads? Is it possible to set a variable to kill mysql-threads which sleeps for a time e.g. 5 hours? Which variables have to be set therefore? Regards, Anatol - 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 Query Speed
Sounds about right. How have you got your my.cnf set? Have you got RAID on you HDD? Simon -Original Message- From: Florian Wilken [mailto:[EMAIL PROTECTED]] Sent: 23 May 2002 10:17 To: [EMAIL PROTECTED] Subject: MySQL Query Speed Hello our database consists of one table with approx. 150 columns. We have a query going over 11 columns (most tinyint, int and some varchar) Out of 217237 rows the query found 56 matches. Without Indexing, the query took 2,55 seconds. With Indexing, the query took 0,04 seconds. The database and query is currently being tested on the following computer: AMD Athlon(TM) XP1700+ (1500MHz), 768MB RAM MySQL 3.23.41 unter SuSE Linux 7.3 (Kernel 2.4.10-4GB) Is the speed of the query (2,55 sec, respectively 0,04 seconds) reasonable ? With the Index, should the query even be faster than 0,04 seconds ? Thanks for your Help. Flo - 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
FreeBSD threads
Hi We using FreeBSD 4.5 and MySQL 3.23.49 with native threads... It uses a lot of CPU and mite not be using both CPU's? So we have seen that compiling with Linux threads can help Do with just ./configure --with-named-threads-libs=??? What is the complete statement? And do we need to put any thing more for freeBSD? Thanks for any help Simon - 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: Triggers
I think this is some thing that should be in on V4.1... Have a look at things to do on the site Simon -Original Message- From: Uma Shankari T. [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 08:28 To: [EMAIL PROTECTED] Subject: Triggers Hello All, Is Mysql supports sql triggers ...??.. Is anyone know this pls tell me.. Thanks in advance Uma - 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 users setup.
Look in db mysql.user to see what users can do what. GRANT ALL ON *.* TO user@% IDENTIFIED BY password; Simon -Original Message- From: Unix Newbie [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 10:15 To: [EMAIL PROTECTED] Subject: Mysql users setup. Hello all! I am just starting out with learning mysql and I have run into some speed bumps that are mostly my configuration. I have set up mysql running on a Mac OS X box with php running a particular software package called phpESP. Works great (a bit slow, but great). Now, in order to have my system go live the head honchos decided that my department could not have the mysql database and the webserver on thes same machine (security reasons). Now I have read some of the docs regarding doing this, whatever user accesses the database has to have the IP that it will be coming from set up after the @ symbol. Well, can I change an existing user to have access from any location, and how would I see if that is already set up for this user? Sorry for the newbie questions, but docs, urls, or pretty much anything will get me started thanks so much! Terry. - 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: user problem
If you are ruing as user mysql do chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/var chgrp -R mysql /usr/local/mysql Change to sute tast (or what you database is) Simon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 24 April 2002 13:51 To: [EMAIL PROTECTED] Subject: Fw: user problem I have mysql installed on a linux platform. I have no problem running every thing as root. When I try to run mysql as a user other than root, I entered command use mysql. I get error 1044:access denied for user:@localhost to database 'mysql'. is there a file that I need to change the permissions on or change the group in a var or usr subdirectory. Thank you for your help on this matter. Kenn Ward - 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: super-smack on FreeBSD
Hi List I know super-smack was writing for Linux but I am trying to get it to work on FreeBSD. Has any one done this or is there a another many threaded bench mark software out there for MySQL ? Thanks Simon - 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
super-smack
I am trying to compile super-smack on a FreeBSD-4 systems. I have got some thing working but it sill not right. Running it gives me. %super-smack -d mysql select-key-mysql.smack 10 1000 super-smack: Unsupported database type Is my copy just broken? If so what is the best way to compile on FreeBSD? Thanks Simon - 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: search problem
When I so a search on www.mysql.com I get this! ---snip--- Warning: Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug in /production/data/nweb/public/udmsearch/mysql.php on line 25 Error: Could not connect to mysql: ---snip--- Simon Green Internet Systems Engineer -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. - 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: check, analyze and optimize table
Would you not be better of just runing myisamchk from crontab? Simon ./myisamchk Ver 1.52 for unknown-freebsdelf4.1 at i386 By Monty, for your professional use This software comes with NO WARRANTY: see the PUBLIC for details. Description, check and repair of ISAM tables. Used without options all tables on the command will be checked for errors Usage: ./myisamchk [OPTIONS] tables[.MYI] Global options: -#, --debug=... Output debug log. Often this is 'd:t:o,filename` -?, --help Display this help and exit. -O, --set-variable var=option Change the value of a variable. -s, --silentOnly print errors. One can use two -s to make myisamchk very silent -v, --verbose Print more information. This can be used with --describe and --check. Use many -v for more verbosity! -V, --version Print version and exit. -w, --wait Wait if table is locked. Check options (check is the default action for myisamchk): -c, --check Check table for errors -e, --extend-check Check the table VERY throughly. Only use this in extreme cases as myisamchk should normally be able to find out if the table is ok even without this switch -F, --fast Check only tables that hasn't been closed properly -C, --check-only-changed Check only tables that has changed since last check -f, --force Restart with -r if there are any errors in the table. States will be updated as with --update-state -i, --information Print statistics information about table that is checked -m, --medium-check Faster than extended-check, but only finds 99.99% of all errors. Should be good enough for most cases -U --update-state Mark tables as crashed if you find any errors -T, --read-only Don't mark table as checked Repair options (When using -r or -o) -B, --backupMake a backup of the .MYD file as 'filename-time.BAK' --correct-checksum Correct checksum information for table. -D, --data-file-length=# Max length of data file (when recreating data file when it's full) -e, --extend-check Try to recover every possible row from the data file Normally this will also find a lot of garbage rows; Don't use this option if you are not totally desperate. -f, --force Overwrite old temporary files. -k, --keys-used=# Tell MyISAM to update only some specific keys. # is a bit mask of which keys to use. This can be used to get faster inserts! -r, --recover Can fix almost anything except unique keys that aren't unique. -n, --sort-recover Force recovering with sorting even if the temporary file would be very big. -o, --safe-recover Uses old recovery method; Slower than '-r' but can handle a couple of cases where '-r' reports that it can't fix the data file. --character-sets-dir=... Directory where character sets are --set-character-set=name Change the character set used by the index -t, --tmpdir=path Path for temporary files -q, --quick Faster repair by not modifying the data file. One can give a second '-q' to force myisamchk to modify the original datafile in case of duplicate keys -u, --unpackUnpack file packed with myisampack. Other actions: -a, --analyze Analyze distribution of keys. Will make some joins in MySQL faster. You can check the calculated distribution by using '--describe --verbose table_name'. -d, --description Prints some information about table. -A, --set-auto-increment[=value] Force auto_increment to start at this or higher value If no value is given, then sets the next auto_increment value to the highest used value for the auto key + 1. -S, --sort-indexSort index blocks. This speeds up 'read-next' in applications -R, --sort-records=# Sort records according to an index. This makes your data much more localized and may speed up things (It may be VERY slow to do a sort the first time!) Default options are read from the following files in the given order: /etc/my.cnf /usr/local/mysql/var/my.cnf ~/.my.cnf The following groups are read: myisamchk The following options may be given as the first argument: --print-defaultsPrint the program argument list and exit --no-defaults Don't read default options from any options file --defaults-file=# Only read default options from the given file # --defaults-extra-file=# Read this file after the global files are read -Original Message- From: Peter Romianowski [mailto:[EMAIL PROTECTED]] Sent: 09 April 2002 12:08 To: [EMAIL
Privileges for backups
I have got a backup script that locks the MySQL tables then use cp(unix) to copy the tables. It then tar, then zips them up. So my queston is what is the minimum privileges that this MySQL back user needs just to lock tables? Thanks Simon Green -- Live Life in Broadband www.telewest.co.uk - 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
Privileges for backups
I have got a backup script that locks the MySQL tables then use cp(unix) to copy the tables. It then tar, then zips them up. So my queston is what is the minimum privileges that this MySQL back user needs just to lock tables? Thanks Simon Green -- Live Life in Broadband www.telewest.co.uk - 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: How to start the MySQL server
usr/local/mysql/bin/safe_mysqld --user = mysql or ./safe_mysqld --user = mysql Have a look at /mysql/bin/var/hostname.err.log Hope this helps Simon -Original Message- From: Hammer [mailto:[EMAIL PROTECTED]] Sent: 03 April 2002 10:19 To: [EMAIL PROTECTED] Subject: How to start the MySQL server Dear friends, I'm running RedHat Linux, I just downloaded the ~.tar.gz mysql file in my /usr/local directory and uncompressed it. Now I can get the target directory but I don't know how to start the server. I tried: ./bin/safe_mysqld --user=root but it doesn't work for me. Any help is warmly welcome. Regards, Yao - 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: Privileges for backups
I have got a backup script that locks the MySQL tables then use cp(unix) to copy the tables. It then tar, then zips them up. So my queston is what is the minimum privileges that this MySQL back user needs just to lock tables? Thanks Simon Green -- Live Life in Broadband www.telewest.co.uk - 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
All threads used up!
We have a problem with other system.. When a service that uses the MySQL database loops and so creates to many connects to the DB it uses up all the available connections. So we have DOS from aware own server. I know that we can limit the connections used over 1 hour but I need to set a max connections for each server. Is there a way to limit connections to one port per IP? FreeBSD 4.4 MySQL Latest Stable Thanks Simon - 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
All threads used up
We have a problem with other system.. When a service that uses the MySQL database loops and so creates to many connects to the DB it uses up all the available connections. So we have DOS from aware own server. I know that we can limit the connections used over 1 hour but I need to set a max connections for each server. Is there a way to limit connections to one port per IP? FreeBSD 4.4 MySQL Latest Stable Thanks Simon - 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 DATABASE BACKUP
Yes and no If you are taking info from a live database you would have it in a steady state to copy it. This means locking the tables. But once you have a copy of the table all you would need to do is update the changes from the logs. Using replication for this I is the most simple way but would mean a second copy of MySQL but you would only need a low spec system.. I hope this helps... Simon -Original Message- From: Kathy Reyes [mailto:[EMAIL PROTECTED]] Sent: 19 March 2002 21:37 To: mysql Subject: MYSQL DATABASE BACKUP I am trying to backup a table in mysql without locking my tables it this posible - 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: delete old mysql users
We asked on the MySQL training last year and were told that this is a manual job... Just have to delete entree for each table. Unless some one else knows different? Simon -Original Message- From: Steve Wright [mailto:[EMAIL PROTECTED]] Sent: 18 March 2002 16:52 To: [EMAIL PROTECTED] Subject: delete old mysql users Hello, I have a system running MySQL with old user accounts I wish to remove. I am looking for a command to delete all user that do not have access to any databases. Does anyone know of such a command ?? With Thanks, Steve. - 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
SSL
Hi All Do any of you use SSL option in MySQL and if so are there and performance problems when connecting to MySQL? Thanks Simon Green -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. - 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
Date for V4
I have looked at the MySQL site and can not find a revised date. I'm using V4 on a test box and it is better, but now I am putting together a production box and have to stick with V3. Is there a revised time table? snip MySQL 4.0 until it is released in beta version later Q4/2001 snip Simon PS sorry I know it not the most interesting on questions - 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 3.23.41 on RH7.2
You could just log on and use update on the user table... Or try entering a blank password? Simon -Original Message- From: BUNTER MATTHEW [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 15:32 To: [EMAIL PROTECTED] Subject: MySQL 3.23.41 on RH7.2 --- Reçu de RVIDOI.BUNTERMA 04 72 96 57 7712/03/02 16.32 All, Installed MySQL as part of my setup. Server is running, I can connect as root with no password. I attempt : mysqladmin -u root -p password 'newpassword' I get : Enter password : blahblahblah root@localhost rejected I looked at the user table and there are blank spaces for root both on the machine name and for localhost. Why can I not change the password for root? Any ideas? Regards, Matt 12/03/02 16.32 Envoyé à --- - 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: User / Group Permissions
Some use of the Host table in db mysql mite do what you need? Simon -Original Message- From: Jason Joines [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 17:25 To: MySQL Users Subject: User / Group Permissions Does MySQL support creation of groups so you can grant specific permissions to a group of users instead of having to do this to each individual user? Jason Joines - - 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