Re: Fw: Server-Client
I could not understand what you try to do. But generally mysql runs on a server machine and the clients connect to it. Every client program you write can connect to mysql server seperately. If you want and need you can also write a server program too. But you have to be more clear about your problems and purpose to get a good answer. [EMAIL PROTECTED] wrote: Hi all, I think that I should ask the question like that. I want to run MySQL on 14 client. What am I do. I try but There is a problem that i can't find... Please help me. Hseyin DEMRA stikbal Furniture Int. - Original Message - From: Mike Hillyer [EMAIL PROTECTED] To: Hseyin DEMIRAG [EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 6:03 PM Subject: RE: Server-Client Can you be more specific? A client application written on a test machine that also houses the server will just need a different IP address in it's DSN/Connection String and a copy of MyODBC on the new client machine. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Hseyin DEMIRAG [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 8:54 AM To: 1MySql - MySql Subject: Server-Client Hello, I coded a program by using VB 6.0 I will use this program on network(nearly 12 user). is it necessary to code two different program for both of server and client. Or, Can I solve this problem by MYSQL Control Center. Hseyin DEMRA stikbal Furniture nt. -- Veysel Harun Sahin [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ip address why shows diff. ?
Hello, I have loaded MYSQL Version 4.0.12, and also loaded MySQL Control Centre 0.8.10-beta, on Win 98 Now when i go to command prompt and issue the command as mysql show processlist; ++--++---+-+--+---+--+ | Id | User | Host | db| Command | Time | State | Info | ++--++---+-+--+---+--+ | 2 | ODBC | 127.0.0.1:1046 | NULL | Sleep | 8| | NULL | | 7 | root | 127.0.0.1:1056 | mysql | Sleep | 460 | | NULL | | 8 | root | 127.0.0.1:1058 | NULL | Sleep | 459 | | NULL | | 10 | ODBC | 127.0.0.1:1060 | NULL | Query | 0| NULL | show processlist | ++--++---+-+--+---+--+ 4 rows in set (0.00 sec) so i can see my ip is diplayed as 127.0.0.1 but when i use MySQL GUI Control Centre it displays my actual ip which is configured in network neighbourhood or TCP/IP settings of Windows 98 i.e. 10.170.1.184 why is this discrepency, i think it should show my ip 10.170.1.184 on command prompt also when i issue command show processlist; Regards Neeraj Vasudeva
MySQL tables performance question
Hello, I have a table where misc data are stored. Right now this table has about 30 columns, but for sure it will be more in the near future. So I wonder how the big number (50-100) of table's columns affect for MySQL DB performance. Maybe it's better to create more tables rather than more table's columns ?? Marek Lewczuk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ip address why shows diff. ?
Neeraj Vasudeva [EMAIL PROTECTED] wrote: I have loaded MYSQL Version 4.0.12, and also loaded MySQL Control Centre 0.8.10-beta, on Win 98 Now when i go to command prompt and issue the command as mysql show processlist; ++--++---+-+--+---+--+ | Id | User | Host | db| Command | Time | State | Info | ++--++---+-+--+---+--+ | 2 | ODBC | 127.0.0.1:1046 | NULL | Sleep | 8| | NULL | | 7 | root | 127.0.0.1:1056 | mysql | Sleep | 460 | | NULL | | 8 | root | 127.0.0.1:1058 | NULL | Sleep | 459 | | NULL | | 10 | ODBC | 127.0.0.1:1060 | NULL | Query | 0| NULL | show processlist | ++--++---+-+--+---+--+ 4 rows in set (0.00 sec) so i can see my ip is diplayed as 127.0.0.1 but when i use MySQL GUI Control Centre it displays my actual ip which is configured in network neighbourhood or TCP/IP settings of Windows 98 i.e. 10.170.1.184 why is this discrepency, i think it should show my ip 10.170.1.184 on command prompt also when i issue command show processlist; There was a bug in SHOW PROCESSLIST in this version of MySQL. The bug was fixed in 4.0.13. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
selec using first letter
hi all, i have this table filled with names. Does anybody know how I can write a select statement which selects all names starting with a certain letter in the alphabet or a strane sign like [0...9 )(*[EMAIL PROTECTED]|?/,.] ??? any tips or help are most welcome! Regards Wilbert Enserink -- mysql,select - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: select using first letter
Hi Using the Square brackets with the characters within it and then a wildcard after the closing square bracket works except for looking for special square brackets. hi all, i have this table filled with names. Does anybody know how I can write a select statement which selects all names starting with a certain letter in the alphabet or a strane sign like [0...9 )(*[EMAIL PROTECTED]|?/,.] ??? any tips or help are most welcome! Regards Wilbert Enserink This communication is for use by the intended recipient and contains information that may be privileged, confidential or copyrighted under applicable law. If you are not the intended recipient, you are hereby formally notified that any use, copying or distribution of this e-mail, in whole or in part, is strictly prohibited. Please notify the sender by return e-mail and delete this e-mail from your system. Unless explicitly and conspicuously designated as E-Contract Intended, this e-mail does not constitute a contract offer, a contract amendment, or an acceptance of a contract offer. This e-mail does not constitute a consent to the use of sender's contact information for direct marketing purposes or for transfers of data to third parties. Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean http://www.DuPont.com/corp/email_disclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Introduction
Hi all, hope I can learn a lot from this mailing list! _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with mysql-crashes
Hey folks, before posting to the bugs-list I would like to try it here to get some help :). Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine. Its not reproducible nor I know a query which does it. (The log shows that at the end, so no query :-( : Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x5e13a478 is invalid pointer thd-thread_id=2223573 ) The server is the standalone db-server for one accessing webserver, its running RedHat-Linux 7.2 with all their latest patches. Kernel 2.4.19-XFS with MySQL running on an XFS-filesystem. No replication but query-cache enabled. Ok but now the worse thing started for 2 times I already got this problem in the logs: Number of processes running now: 16 mysqld-max process hanging, pid 17193 - killed mysqld-max process hanging, pid 17191 - killed mysqld-max process hanging, pid 17190 - killed mysqld-max process hanging, pid 17145 - killed mysqld-max process hanging, pid 17144 - killed mysqld-max process hanging, pid 17098 - killed mysqld-max process hanging, pid 17025 - killed mysqld-max process hanging, pid 16987 - killed mysqld-max process hanging, pid 28393 - killed mysqld-max process hanging, pid 28392 - killed mysqld-max process hanging, pid 28391 - killed mysqld-max process hanging, pid 28389 - killed mysqld-max process hanging, pid 28388 - killed mysqld-max process hanging, pid 28387 - killed mysqld-max process hanging, pid 28386 - killed mysqld-max process hanging, pid 28385 - killed 030722 20:46:26 mysqld restarted Afterwards there is a init-process taking 99% from one CPU. The first time I tried to reboot the machine, which didn't work as the shutdown process was hanging then. Any ideas whats wrong and how to fix it? Didn't see a mention of a fix for that problem in the 4.0.14-changelog, will it still fix it? Thanks in advance, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: selec using first letter
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 23 July 2003 03:59, W. Enserink wrote: hi all, i have this table filled with names. Does anybody know how I can write a select statement which selects all names starting with a certain letter in the alphabet or a strane sign like [0...9 )(*[EMAIL PROTECTED]|?/,.] ??? any tips or help are most welcome! Select * from tblname where fldname like 'A%'; This would select all records where fldname starts with A. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQE/HmZ1jeziQOokQnARAi+iAKCW5OkKSQ/5gG3UkeWNzfcsmuy3IwCgnd6d Mh6hxN49jKvWvp4y2BvWi5A= =1q3P -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_install_db crash
Hi, Tue, 22 Jul 2003 18:15:59 -0700 (PDT) tarihinde MySQL [EMAIL PROTECTED] soyle yazdi: DF I am compiling MySQL 4.0.14 with GCC 3.2.3, Glibc 2.3.1 and Linux DF 2.4.21 on a x86. ... DF CFLAGS=-O2 -march=athlon CXX=gcc CXXFLAGS=-march=athlon -O2 DF-felide-constructors ./configure --prefix=/usr/local/mysql DF--with-charset=latin5 --without-docs DF--with-mysqld-ldflags=-all-static--disable-shared DF--with-client-ldflags=-all-static --without-innodb M I had a somewhat similar experience, but with version 3.23.57. I used M my normal configure options (from gcc 2.95.3) and my perlAPI scripts M all had serious difficulties. I retried without specifying any M options to configure, and everything is fine [so far]. I noticed that M the 'build from source' help only refers to gcc 2.95.3 for x86. I know... But it also says that compiling with GCC 3.2 should be safe. I compiled GCC 2.95.3 on my system, compiled MySQL with using it but the same problem resides with mysql_install_db. I then noticed that this mailing list is also available through Google Groups. The search I made was more efficient than the one I made on the lists.mysql.com site. I found two or three similar cases, without -all-static flags they had success. Yes, I did too. I am using Slackware, this is reproducable under Slackware 9.0 and later (-current). But Slackware 8.1 seems fine. I had thought it was a GCC 2/3 debate, it seems not. I could only downgrade GLIBC too. I wonder, is this a Slackware issue? I do want to statically link everything :-) Doruk -- FISEK INSTITUTE - http://www.fisek.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Full-Text for InnoDB Unicode
As far I remember full-text doesn't work with utf-8. Anybody knows the estimated time when it will be supported ?? I next few months 4.1 version will be ready to use (I hope so...) and I wish to use utf-8 charsets, but very important issue is full-text search. I'm also curious with InnoDB support for Full-Text search. Best regards, Marek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL on a website
Hi, I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of this? I've created an ASP web interface to an Access database and read/written to it like that in the past so I assume it's the same for MySQL. Daniel _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Succeeded!!!Two Servers on Windows and ONE my.ini file
Hello, Your solution has succeeded. Thank you very much. All the servers are running well! Iulian Teodosiu, Economist/Analyst Programmer, Primaria Falticeni, Falticeni Town, Romania, Europe - Original Message - From: Primaria Falticeni [EMAIL PROTECTED] To: MySQL LIST [EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 10:45 PM Subject: Re: Two Servers on Windows and my.cnf/my.ini groups Yes, that's the problem. Until now I started the two servers from the command line/batch file/service and each server had its own my.ini. The two servers are in replication: one master and another slave. Two days ago I read that I can use a unique my.ini for the both servers; and MySQL for Windows is searching for the ini file in an unique place. I tried to find that mysqld_multi tool in the MySQL Win package but no trace of it. But the ideea sounded very interesting to me so I tried to find the answer for Win MySQL in this list. Thank you very much, I'm happy to use this elegant and clean solution, tommorrow I'll put both to start by the unique my.ini file. Sincerely, Iulian Teodosiu, Economist/Analyst Programmer, Primaria Falticeni, Falticeni Town, Romania, Europe - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Primaria Falticeni [EMAIL PROTECTED]; MySQL LIST [EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 10:08 PM Subject: Re: Two Servers on Windows and my.cnf/my.ini groups At 20:12 +0300 7/22/03, Primaria Falticeni wrote: Hello and thank you for the info, As I said earlier, I already did the other ways of starting multiple servers. But from these docs I lived with the idea that one/unique my.cnf is able to start two servers on Windows. Must I see that two configuration files is needed? I'm not sure what you're asking. Do you mean that you want to run two servers as services, and you want to use a single my.cnf file to store the options for them? If so, then you use the approach of specifying a service name after the --install option, and using an option group corresponding to the service name in the option file. Each server will have a different service name, so each server also reads a distinct option group name in the option file. If that's not what you want to do, please clarify. Thanks. Iulian - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Primaria Falticeni [EMAIL PROTECTED]; MySQL LIST [EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 7:51 PM Subject: Re: Two Servers on Windows and my.cnf/my.ini groups At 19:37 +0300 7/22/03, Primaria Falticeni wrote: Hello, I run two MySQL servers on Windows with the two services. I read in the docs that it exists a way to identify the servers in my.cnf by groups and about a tool from Linux to manage the groups. How can I start a server on Windows through the my.cnf/my.ini 's groups? If by Linux tool you mean mysqld_multi, it's inapplicable to Windows. For instructions on running multiple servers on Windows, have a look in the MySQL manual here: http://www.mysql.com/doc/en/Multiple_servers.html Thanks Anticipated, Iulian -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- 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] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- 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: MySQL on a website
Hi, I doubt you will find free host for MySQL because you seem to use ASP, which is really not commun and i have not seen many host (paid host) provide ASP may be i have looked at the wrong place. Anyhow if you decide to use php then you will have more chance to find free host with MySQL, I think portland.co.uk might provide free MySQL/host but not sure anymore, I have also seen but it has been at least 2 years ago, someone offered only database space not webhost so you had to connect to mysql or whatever database they provided from outside. Anthony - Original Message - From: Daniel Glenfield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 1:08 PM Subject: MySQL on a website Hi, I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of this? I've created an ASP web interface to an Access database and read/written to it like that in the past so I assume it's the same for MySQL. Daniel _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- 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: Can run two versions of MySQL in Windows 2000?
I'm sorry, I'm very new at this. I only downloaded the live version last week. Where do I find the setting you are referring to? By attempt to run the servers, perhaps this is a correct answer to your question: I am only using this for learning purposes. I am hoping to attain new skills and thought that SQL was a good place to start (since I believe it to be the base for many database languages (DBIV (or whatever version they're up to today, Oracle, Sybase, Peoplesoft, etc.) and perhaps if I lose my job this will broaden my choices in looking for a new position/career. If this is not a correct answer to your question, please clarify. Finally, thank you, I will change the name of the folder as you suggest. George -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 4:42 PM To: Degan, George E, JR, MGSVC; [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 14:15 -0500 7/22/03, Degan, George E, JR, MGSVC wrote: Thanks. I have been fighting with this all afternoon, now it seems I can get to 4.1.0 and not 4.0.13. My databases still seem to be there but I can't point to them either in mysql or in mysqlcc/DBManager. I guess I have moved port 3306 to the 4.1.0 database. How do I name, say, 3307 as the 4.0.13 database? First, you're better off not installing 4.1 (or any version) in a directory with a pathname that contains spaces. I suggest renaminng c:\4.1 Alpha to c:\4.1-Alpha. Second, tell us more about your setup. You're asking us to diagnose the problem with little more information than it doesn't work. What are your settings? How are you attempting to run the servers? Thanks. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 12:00 PM To: [EMAIL PROTECTED] Subject: Re: Can run two versions of MySQL in Windows 2000? Degan, George E, JR, MGSVC [EMAIL PROTECTED] wrote: I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0. 4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to launch mysql it brings me to the old version, how do I access the new one without killing the old one? (I have also tried putting 4.1.0 on a totally different machine and linking to it also.) Yes, you can find info about it at: http://www.mysql.com/doc/en/Multiple_Windows_servers.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on a website
For the database/ASP link I created on our intranet all I did was drop an Access database onto the server, and use the address in the ASP code (actually I didn't need to - it was all local). Can I not simply FTP upload the MySQL database to a regular website (that supports ASP) and access it through the pages? Or is this not possible? From: awards [EMAIL PROTECTED] To: Daniel Glenfield [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: MySQL on a website Date: Wed, 23 Jul 2003 13:23:43 +0200 Hi, I doubt you will find free host for MySQL because you seem to use ASP, which is really not commun and i have not seen many host (paid host) provide ASP may be i have looked at the wrong place. Anyhow if you decide to use php then you will have more chance to find free host with MySQL, I think portland.co.uk might provide free MySQL/host but not sure anymore, I have also seen but it has been at least 2 years ago, someone offered only database space not webhost so you had to connect to mysql or whatever database they provided from outside. Anthony _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Contribution: dump_grants
http://www.etsetb.upc.es/download/sources/dump_grants/ DESCRIPTION This tool dumps the permissions granted to the users of the MySQL database. It also could print a report of dangerous grants. USAGE Dump Grants will retrieve the permissions granted as sql commands and will store it in a flat file. The name of the file will have the week day, so historic versions of the permissions can be kept. ARGS --help : This text --version : Prints the version of the tool --hostname : DataBase Server Hostname --backup-dir : Directory where the grants will be stored If it's - the output is the STANDARD OUTPUT --check-domain : Checks the trailing string of the hostname --nodump : Won't store the data. The grants will be only checked. STORING In the backup directory there will be stored the grants. It will keep one week of data like this: mon_grants.sql tue_grants.sql ... CHECK DOMAIN This is a feature not related to dumping the database, but to check the domain of the grants. The way to do it is like this: $ dump_grants --host=SERVERNAME --check-domain=.My.Domain REVOKE USAGE ON big.* FROM 'annmarie'@'%'; REVOKE USAGE ON *.* FROM 'root'@'horta'; The standard error will report the revokes suggested. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database Admin
Hi, I just installed MySQL. Does anybody know where to manage the databases, create, edit and delete tables? Thanks.
**Checking For Modified Rows**
Hi. I need to replicate data (approx. 10,000 records) from a mySQL database into a different (non mySQl) database automatically on a regular basis. I have no control over the mySQL server (apart from allowing ODBC access) so I cannot modify any tables or enable replication etc... My initial thoughts on how to do this are: 1. Execute a query similar to the following to retrieve a list of rows and a unique checksum: SELECT id, md5(id + _ + name + _ + path + _ + comments) from mytable 2. Lookup each id in my local database a) If it doesn't exist add the id and checksum to my local database and add the record into my actions database as a record to replicate. b) If it exists and the checksums are different update my local database and add the record into my actions database as a record to replicate. REPEAT step 2 for all records At this point the actions database would contain a list of all records which have been inserted or modified. The last step would be to determine which records have been deleted. My thoughts where to mark each record in my local database when a match occurred. Any records in my local database which were not marked as matched would be added to the actions database as records to delete and then deleted from my local database. Any thoughts / feedback on this would be appreciated. Cheers. Kev. E-MAIL DISCLAIMER: The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. All information provided, including but not limited to, quotations, system specifications and suggestions concerning hardware/software (and services) configurations are strictly subject to our standard terms and conditions of business, copies of which are available on request. This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
update query using inner join on same table
Hi, I have a query that runs in Microsoft Access against my mysql database just fine. It is: UPDATE discussion_categories AS discussion_categories_1 INNER JOIN discussion_categories ON discussion_categories_1.parent_1_text = discussion_categories.name SET discussion_categories_1.parent_1 = [discussion_categories].[category_id]; I tried to write this in mysql but couldn't figure it out. Is it possible to join a table on itself in mysql? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: problem with mysql-crashes
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Wed, 23 Jul 2003 [EMAIL PROTECTED] wrote: before posting to the bugs-list I would like to try it here to get some help :). Every now and then MySQL-4.0.13 crashes on my Dual-Athlon-MP-machine. Is that a self-compiled binary or one of ours? Its not reproducible nor I know a query which does it. (The log shows that at the end, so no query :-( : Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x5e13a478 is invalid pointer thd-thread_id=2223573 ) Not very helpful. Does this occur under high load only? The server is the standalone db-server for one accessing webserver, its running RedHat-Linux 7.2 with all their latest patches. Kernel 2.4.19-XFS with MySQL running on an XFS-filesystem. No replication but query-cache enabled. What version of glibc is this system running on? Is it 2.2.3 by chance? Ok but now the worse thing started for 2 times I already got this problem in the logs: Number of processes running now: 16 mysqld-max process hanging, pid 17193 - killed mysqld-max process hanging, pid 17191 - killed mysqld-max process hanging, pid 17190 - killed mysqld-max process hanging, pid 17145 - killed mysqld-max process hanging, pid 17144 - killed mysqld-max process hanging, pid 17098 - killed mysqld-max process hanging, pid 17025 - killed mysqld-max process hanging, pid 16987 - killed mysqld-max process hanging, pid 28393 - killed mysqld-max process hanging, pid 28392 - killed mysqld-max process hanging, pid 28391 - killed mysqld-max process hanging, pid 28389 - killed mysqld-max process hanging, pid 28388 - killed mysqld-max process hanging, pid 28387 - killed mysqld-max process hanging, pid 28386 - killed mysqld-max process hanging, pid 28385 - killed 030722 20:46:26 mysqld restarted Afterwards there is a init-process taking 99% from one CPU. The first time I tried to reboot the machine, which didn't work as the shutdown process was hanging then. Any ideas whats wrong and how to fix it? Didn't see a mention of a fix for that problem in the 4.0.14-changelog, will it still fix it? What version of glibc is being used on that system? I noticed that you use the Max binary, which is dynamically linked - so it will use the locally installed libc.so. Is there any special reason for using Max? Or could you try to use our statically linked Standard binary instead? The problem above looks very similar to the problems we had when we linked against glibc 2.2.3 instead of 2.2.5: under high load, a mysqld thread starts eating up all CPU resources on an SMP system. Unfortunately we never found the reason for that - it did not seem to happen when using glibc 2.2.5... Bye, LenZ - -- Lenz Grimmer [EMAIL PROTECTED] Senior Production Engineer MySQL GmbH, http://www.mysql.de/ Hamburg, Germany For technical support contracts, visit https://order.mysql.com/?ref=mlgr -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) Comment: For info see http://quantumlab.net/pine_privacy_guard/ iD8DBQE/HoQOSVDhKrJykfIRAh+MAJ91+kr7H92xcK4JtFhz5HQ3r6LGgwCggT/v OCHlqAabKjd6FnL6PMOmKRg= =U2ag -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database Admin
there must be a binary called 'mysql' ('mysql.exe' on windows). call it, best from the computer where you have installed mysql on: mysql -uroot (if it's not in the PATH: /usr/local/mysql/bin/mysql (i think) or c:\programme\mysql\bin\mysql.exe) now you can enter SQL commands like CREATE DATABASE... CREATE TABLE... INSERT INTO... SELECT... if you're not already familiar with these SQL commands, you should look them up in the mysql manual. -yves -Ursprüngliche Nachricht- Von: Ratmil Torres [EMAIL PROTECTED] An: [EMAIL PROTECTED] Gesendet: Mittwoch, 23. Juli 2003 14:21 Betreff: Database Admin Hi, I just installed MySQL. Does anybody know where to manage the databases, create, edit and delete tables? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on a website
get a broadband connection and host the website yourself Martin - Original Message - From: awards [EMAIL PROTECTED] To: Daniel Glenfield [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 4:23 AM Subject: Re: MySQL on a website Hi, I doubt you will find free host for MySQL because you seem to use ASP, which is really not commun and i have not seen many host (paid host) provide ASP may be i have looked at the wrong place. Anyhow if you decide to use php then you will have more chance to find free host with MySQL, I think portland.co.uk might provide free MySQL/host but not sure anymore, I have also seen but it has been at least 2 years ago, someone offered only database space not webhost so you had to connect to mysql or whatever database they provided from outside. Anthony - Original Message - From: Daniel Glenfield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 1:08 PM Subject: MySQL on a website Hi, I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of this? I've created an ASP web interface to an Access database and read/written to it like that in the past so I assume it's the same for MySQL. Daniel _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- 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: problem with mysql-crashes
Hi Lenz, thanks a lot for your reply! Is that a self-compiled binary or one of ours? It are the MySQL-4.0.13-MAX-RPMs from your site. Not very helpful. Does this occur under high load only? Yeah I know, otherwise I would have tried to generate a reproducible testcase with a given query or such. Any way to have valid pointers there? Nope, the load on that system is mostly around 0.5 with peaks up to 1.5, not something I would call a high load for a dual-system. Also the crashes are at many different times (even in the deep night) so I don't think its related to load :-(. What version of glibc is this system running on? Is it 2.2.3 by chance? Nope, sorry. Its glibc-2.2.4-32. What version of glibc is being used on that system? I noticed that you use the Max binary, which is dynamically linked - so it will use the locally installed libc.so. Is there any special reason for using Max? Or could you try to use our statically linked Standard binary instead? Yeah I could try that instead, maybe I should try with 4.0.13 to see if its a problem of that version. Or should I better try 4.0.14 already? I was hosting a couple of bdb-tables for some time, but no longer now. Currently only myisam and innodb-tables so I could try the standard-built too. The problem above looks very similar to the problems we had when we linked against glibc 2.2.3 instead of 2.2.5: under high load, a mysqld thread starts eating up all CPU resources on an SMP system. Unfortunately we never found the reason for that - it did not seem to happen when using glibc 2.2.5... Hmm, maybe 2.2.4 has the same problem? The problem is that the init-process is taking all the cpu, didn't see a mysql-process doing the same before. Thanks, Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Word index
I would like to know if there is a way of building an index on all the words of a column. We want to have an alphabetical search on all the words of a description of a product. So, how I treat this index when I change a part of the content of this specific column where I want a word index. Jocelyn Garon 418 644-4185
RE: Word index
Mysql column type of full text. Check the docs at http://www.mysql.com/doc/en/Fulltext_Search.html -Original Message- From: Garon Jocelyn [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 11:07 PM To: [EMAIL PROTECTED] Subject: Word index I would like to know if there is a way of building an index on all the words of a column. We want to have an alphabetical search on all the words of a description of a product. So, how I treat this index when I change a part of the content of this specific column where I want a word index. Jocelyn Garon 418 644-4185 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL on a website
Thanks for your help everyone! From: Martin Gainty [EMAIL PROTECTED] To: awards [EMAIL PROTECTED], Daniel Glenfield [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: MySQL on a website Date: Wed, 23 Jul 2003 08:57:54 -0700 get a broadband connection and host the website yourself Martin - Original Message - From: awards [EMAIL PROTECTED] To: Daniel Glenfield [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 4:23 AM Subject: Re: MySQL on a website Hi, I doubt you will find free host for MySQL because you seem to use ASP, which is really not commun and i have not seen many host (paid host) provide ASP may be i have looked at the wrong place. Anyhow if you decide to use php then you will have more chance to find free host with MySQL, I think portland.co.uk might provide free MySQL/host but not sure anymore, I have also seen but it has been at least 2 years ago, someone offered only database space not webhost so you had to connect to mysql or whatever database they provided from outside. Anthony - Original Message - From: Daniel Glenfield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 1:08 PM Subject: MySQL on a website Hi, I'd like to create a website with a MySQL database to store soccer players details like goals scroed for the season. I want to use it to update my fantasy soccer team through this season, does anyone know of a free host that provides MySQL? Or even better, does anyone have experience of this? I've created an ASP web interface to an Access database and read/written to it like that in the past so I assume it's the same for MySQL. Daniel _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- 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] _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL tables performance question
If you are going to be needing to add columns and/or tables, you should probably rethink your data model. I'm not sure what data you are tracking, but perhaps you can consolidate it a bit more. Make your columns into rows with a row type field. A simple example would be tracking phone numbers. Instead of having separate columns for home, work, and mobile, break it out into another table so you can have unlimited phone numbers. Have a descriptor field to indicate what type of phone number it is. You can then add other phone type with ease, like beeper, fax, car, etc. This also has the added advantage of being able to search on all phone numbers in one query, yet also being able to search on just home phones. On Wednesday, July 23, 2003, at 04:26 AM, Marek Lewczuk wrote: Hello, I have a table where misc data are stored. Right now this table has about 30 columns, but for sure it will be more in the near future. So I wonder how the big number (50-100) of table's columns affect for MySQL DB performance. Maybe it's better to create more tables rather than more table's columns ?? -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: update query using inner join on same table
I answered my own question, this works for joining a table on itself and doing an update query: update discussion_categories discussion_categories1, discussion_categories set discussion_categories1.parent_1 = discussion_categories.category_id where discussion_categories1.`parent_1_text` = discussion_categories.name -Original Message- From: Jonathan Patton Sent: Wednesday, July 23, 2003 8:39 AM To: [EMAIL PROTECTED] Subject: update query using inner join on same table Hi, I have a query that runs in Microsoft Access against my mysql database just fine. It is: UPDATE discussion_categories AS discussion_categories_1 INNER JOIN discussion_categories ON discussion_categories_1.parent_1_text = discussion_categories.name SET discussion_categories_1.parent_1 = [discussion_categories].[category_id]; I tried to write this in mysql but couldn't figure it out. Is it possible to join a table on itself in mysql? -- 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]
mysqldump isn't working anymore
Hello, I have been backing up my db with the mysql dump command and it no longer works. This is an example of the command I was running... mysqldump -u dbuser -p -C mydb out.sql but returns this -- MySQL dump 8.21 -- -- Host: localhostDatabase: mydb - -- Server version 3.23.49-log Does anyone have any ideas why this doesn't work anymore? Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How do I show column names in php?
I am using php and mysql and I want to show the column names. How do I go about doing this without hardcoding the headers in my php? Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it possible to protect MySQL database on a Win2k laptop?
I want to put a MySQL 4.1 database on a Win2k laptop but the problem is it contains confidential client information. It has to be Window because applications accessing the database are written in Windows. The problem is laptops do get stolen quite often, even when running on someone's unattended desk. Most security chains can be cut with a small pair of bolt cutters. I have to convince my boss that if the laptop disappears it won't put the company out of business, and me out of a job.g Is it possible to secure the MySQL database on the laptop so if it does get stolen, the information is safe? The password security of Win2k can be easily bypassed by hacking tools so I can't rely on the security of the OS. I could encrypt some of the columns but how does this affect the indexes? I need to use select custname, col2, col3 from table where custname like 'smith% order by custname'. How would encrypting individual columns affect the use of indexes and sort orders? Are the indexes bypassed? There would be millions of rows of data in the table so I still need to use indexes on these encrypted columns both for searching and for sorting. Does anyone have any advice on how to proceed? TIA. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqldump isn't working anymore
Did you try the -q option? Jake Johnson wrote: Hello, I have been backing up my db with the mysql dump command and it no longer works. This is an example of the command I was running... mysqldump -u dbuser -p -C mydb out.sql but returns this -- MySQL dump 8.21 -- -- Host: localhostDatabase: mydb - -- Server version 3.23.49-log Does anyone have any ideas why this doesn't work anymore? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database Admin
There is a nice GUI on the MySQL site called MySQL Command Center. Follow this link http://www.mysql.com/products/mysqlcc/ Ratmil Torres [EMAIL PROTECTED] wrote:Hi, I just installed MySQL. Does anybody know where to manage the databases, create, edit and delete tables? Thanks. - Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software
Re: JDBC 3.08 nightly snapshot from 7/23/2003
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Nils Valentin wrote: Hi MySQL Fans ;-), Is it possible that the 3.08 series allows to connect to 4.0.14 versions but not to the 4.1 alpha-versions ? I get belows error when tryig to connect from DbVisualizer which was working fine until a while ago. I haven't watched it recently, and haven't changed anything I am aware off right now. After I realized the problem I tried many 3.08 versions with the same symptom. Watch were it says Unknown system variable 'autocommit' - which I havent set as far as I know. Best regards HmmmWhat version of 4.1 are you using exactly? Something you downloaded, or built yourself? I use 3.0.8 (+) against MySQL-4.1.1 (basically from the BK tree) daily and don't see this exception. It would be coming from something calling Connection.setAutoCommit(). -Mark - -- Mr. Mark Matthews MySQL AB, Software Development Manager, J2EE and Windows Platforms Office: +1 708 557 2388 www.mysql.com Are you MySQL Certified? http://www.mysql.com/certification/ -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/Hp86tvXNTca6JD8RAhVjAJ91/DBMS+YrZCAJwqv7ohMlUiMMQACghzb/ 9fd53d9kk5peHazg3dOtWl8= =Rx9D -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
symlink of tables
Hi, Is there any way to create a symlink of table in two different databases which belongs to the same user. It will be great help if I get the solution for above mention task. Regards, Haq
RE: What is a good benchmark?
On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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: How do I show column names in php?
you want to show the column names of WHAT? if you want to get those of a previous SELECT..., there's a special function for that. here's some code from my mysql admin module: $fields = array(); while ($meta = mysql_fetch_field($result)) { array_push($fields, $meta-name); } if you want to get the columns of a table in general, you may either use SHOW TABLE STATUS... or DESCRIBE... you can test both in the mysql console and see what they return and how you need to interpret the result. -yves -Ursprüngliche Nachricht- Von: Jake Johnson [EMAIL PROTECTED] An: Mysql [EMAIL PROTECTED] Gesendet: Mittwoch, 23. Juli 2003 16:32 Betreff: How do I show column names in php? I am using php and mysql and I want to show the column names. How do I go about doing this without hardcoding the headers in my php? Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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: update query using inner join on same table
Jonathan Patton [EMAIL PROTECTED] wrote: I have a query that runs in Microsoft Access against my mysql database just fine. It is: UPDATE discussion_categories AS discussion_categories_1 INNER JOIN discussion_categories ON discussion_categories_1.parent_1_text = discussion_categories.name SET discussion_categories_1.parent_1 = [discussion_categories].[category_id]; I tried to write this in mysql but couldn't figure it out. Is it possible to join a table on itself in mysql? Yes, you can do it since version 4.0.4 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How do I show column names in php?
Try: $result = mysql_query(SHOW COLUMNS FROM table_name); while ($row = mysql_fetch_array($result)) { foreach ($row as $key=value) { echo $key = $value; } } -Jackson On Wednesday 23 July 2003 9:32, Jake Johnson wrote: I am using php and mysql and I want to show the column names. How do I go about doing this without hardcoding the headers in my php? Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.91 sec) mysql John -Original Message- From: Bryan Koenig [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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: What is a good benchmark?
Celeron 733 Windows 2000 MySQL 3.23.56-nt 1.63s 1.58s 1.58s Athlon 1GHz Debian 3 inside VMWare 3 (WinXP) MySQL 4.0.14 1.21s 1.22s 1.18s -yves -Ursprüngliche Nachricht- Von: Bryan Koenig [EMAIL PROTECTED] An: [EMAIL PROTECTED] Gesendet: Mittwoch, 23. Juli 2003 16:45 Betreff: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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: What is a good benchmark?
On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.66 sec) -Original Message- From: John Griffin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:02 AM To: Bryan Koenig; [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.91 sec) mysql John -Original Message- From: Bryan Koenig [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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: What is a good benchmark?
Xserve 1ghz - 1.08 sec G3 333mhz - 2.78 sec - John On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] -- --- John May : President http://www.pointinspace.com Point In Space Internet Solutions [EMAIL PROTECTED] LPA Corporate Partner / FSA Associate / ACN Member Lasso 5 + 6 / PHP / MySQL / FileMaker Pro Hosting Now Available! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: What is a good benchmark?
On my 1Ghz Mac PowerBook with 1GB RAM using version 4.0.13 with OS 10.2.6 mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.07 sec) -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ From: Hubbard, Dan [EMAIL PROTECTED] Date: Wed, 23 Jul 2003 08:39:01 -0700 To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.66 sec) -Original Message- From: John Griffin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:02 AM To: Bryan Koenig; [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.91 sec) mysql John -Original Message- From: Bryan Koenig [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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: mysqldump isn't working anymore
Still the same problem, but I am still able to select from the DB using mysql. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. On Wed, 23 Jul 2003, gerald_clark wrote: Did you try the -q option? Jake Johnson wrote: Hello, I have been backing up my db with the mysql dump command and it no longer works. This is an example of the command I was running... mysqldump -u dbuser -p -C mydb out.sql but returns this -- MySQL dump 8.21 -- -- Host: localhostDatabase: mydb - -- Server version 3.23.49-log Does anyone have any ideas why this doesn't work anymore? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RES: What is a good benchmark?
Hello Guys, I have Risc/AlphaServer ES40 with processor EV6 500mhz running RedHat 7.2/Mysql. Could you please send me Bench test ? I like to try tks, Julio -Mensagem original- De: Bryan Koenig [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 23 de julho de 2003 11:46 Para: [EMAIL PROTECTED] Assunto: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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]
Selecting Date Time field, difference in minutes
Hello all, I wonder if is there any way to select from a table all the records which has a Date Field that is at least five minutes old? In other words, I have a table with a date field and I need to select all the records that are older than five minutes, has their date field updated before five minutes. Usually I do it with days by using the to_days() function and comparing the date to now: (to_dayss(now()) - to_days(somedate)). I wonder if I could do the same with minutes. Thanks in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fwd: Mysql primary, foriegn and composite keys. Please advise
Note: forwarded message attached. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com---BeginMessage--- Hi All, I have a database consisting of 2 tables. patient_info ( Patient Information ).Looks like lastname VARCHAR(10) fname VARCHAR(10) ssno INT(9) PRIMARY KEY IDINT(4) AUTO_INCREMENT patientins_info ( PatientInsurance Information) insco VARCHAR(10) insid VARCHAR(10) I want to create chart number based on :- 2 characters of (lastname)+2characters of (fname)+(ID) ( So according to my understanding I will have to generate some kind of composite key ). Also, this chart number will be my primary key in all patient insurance database. Since I am fairly new in database area, I don't know much but I think I will have to define some kind of references/foriegn key relations. My database type is MyISAM. Please advise. Thanks, Girish __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] ---End Message--- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RES: What is a good benchmark?
Hello Guys, AlphaServer EV6 processor 500mhz/1Gm memory with Linux mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.92 sec) mysql Julio -Mensagem original- De: Bryan Koenig [mailto:[EMAIL PROTECTED] Enviada em: quarta-feira, 23 de julho de 2003 11:46 Para: [EMAIL PROTECTED] Assunto: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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]
Didn't find any fields in table 't_table'???
How do I fix this error? My tables have data. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: **Checking For Modified Rows**
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 23 Jul 2003 13:27:53 +0100, Kevin Gale wrote: I need to replicate data (approx. 10,000 records) from a mySQL database into a different (non mySQl) database automatically on a regular basis. I have no control over the mySQL server (apart from allowing ODBC access) so I cannot modify any tables or enable replication etc... Can you create a table? If so, it may be easier to have an audit table that records all the changes to the main table. For replication just dump the audit table and then empty it. - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/HrphsxxMki0foKoRAtS7AJ4nBMElR1qr1LcdE1+g+da3alCX7ACfYeGZ zzDzP2hbhWzsNDl28Zz1NEA= =RJIY -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlcc not coming up in Windows XP
I am trying to run MySQLcc(0.9.2) on Windows XP. When I try to bring it up I get an hourglass for a second, then nothing happens. Has anyone had similar issues or any ideas as to what could cause this? Thanks (mysql, query) Scott Pippin [EMAIL PROTECTED]
RE: Can run two versions of MySQL in Windows 2000?
At 6:32 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: I'm sorry, I'm very new at this. I only downloaded the live version last week. Where do I find the setting you are referring to? By attempt to run the servers, perhaps this is a correct answer to your question: I am only using this for learning purposes. I am hoping to attain new skills and thought that SQL was a good place to start (since I believe it to be the base for many database languages (DBIV (or whatever version they're up to today, Oracle, Sybase, Peoplesoft, etc.) and perhaps if I lose my job this will broaden my choices in looking for a new position/career. If this is not a correct answer to your question, please clarify. It's not. I'll attempt to rephrase my questions. However, I will also suggest that if, as you say, you're very new at this, attempting to run multiple servers before you are comfortable with running a single server is not likely to be very easy. re: your setup: What version of Windows do you have? re: your settings: What options are you using to start the servers? (for example, are you passing options on the command line or storing them in an option file? If an option file, which one and what do its contents look like?) re: how you're running the servers: What command do you use to invoke the servers? Are you starting them from the command line, or installing them as services and running them that way? It is a good idea to explain exactly what you're doing, and to provide any relevant error messages that occur. (By that I mean the text of the error messages themselves -- not just a general description of the failure.) Thanks. Finally, thank you, I will change the name of the folder as you suggest. George -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 4:42 PM To: Degan, George E, JR, MGSVC; [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 14:15 -0500 7/22/03, Degan, George E, JR, MGSVC wrote: Thanks. I have been fighting with this all afternoon, now it seems I can get to 4.1.0 and not 4.0.13. My databases still seem to be there but I can't point to them either in mysql or in mysqlcc/DBManager. I guess I have moved port 3306 to the 4.1.0 database. How do I name, say, 3307 as the 4.0.13 database? First, you're better off not installing 4.1 (or any version) in a directory with a pathname that contains spaces. I suggest renaminng c:\4.1 Alpha to c:\4.1-Alpha. Second, tell us more about your setup. You're asking us to diagnose the problem with little more information than it doesn't work. What are your settings? How are you attempting to run the servers? Thanks. -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 12:00 PM To: [EMAIL PROTECTED] Subject: Re: Can run two versions of MySQL in Windows 2000? Degan, George E, JR, MGSVC [EMAIL PROTECTED] wrote: I have been running 4.0.13 for several weeks now and though I'd like to test 4.1.0. 4.0.13 is under c:\MySQL. I downloaded 4.1.0 under c:\4.1 Alpha\MySQL. When I try to launch mysql it brings me to the old version, how do I access the new one without killing the old one? (I have also tried putting 4.1.0 on a totally different machine and linking to it also.) Yes, you can find info about it at: http://www.mysql.com/doc/en/Multiple_Windows_servers.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Create Temporary Table
Hello, Mysql Version 4.0.11a-gamma When I try and run the following query create temporary table russ1 as select rcust.* from rcust; and I receive the error message: Error Code : 1044 Access denied for user: '[EMAIL PROTECTED]' to database 'customer' (0 ms taken) I can run the query from the command line of the server and the query works correctly. I have run the query GRANT ALL PRIVILEGES ON customer.* TO [EMAIL PROTECTED] In addition, I flushed the privileges, and I stopped and restarted the database. Thank you, for you help in advance. Russell R. Snella
Re: What is a good benchmark?
+--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.91 sec) PIII 850, with 1GB Ram. - Original Message - From: Jim Dickenson [EMAIL PROTECTED] To: MySQL Mail List [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 5:51 PM Subject: Re: What is a good benchmark? On my 1Ghz Mac PowerBook with 1GB RAM using version 4.0.13 with OS 10.2.6 mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.07 sec) -- Jim Dickenson mailto:[EMAIL PROTECTED] Computers for Marketing Corporation http://www.cfmc.com/ From: Hubbard, Dan [EMAIL PROTECTED] Date: Wed, 23 Jul 2003 08:39:01 -0700 To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.66 sec) -Original Message- From: John Griffin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:02 AM To: Bryan Koenig; [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my 1.8GHz p4 with 512Gig of RAM I get: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.91 sec) mysql John -Original Message- From: Bryan Koenig [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM To: [EMAIL PROTECTED] Subject: RE: What is a good benchmark? On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 8:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: RES: What is a good benchmark?
snip On my p4 2gig mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.86 sec) snip I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Dual Athlon 1900+ RedHat 8 512MB RAN (Mysql 3.23.56-log - development box so only 1 user) mysql select BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.61 sec) Dual P3-600 Redhat 7.3 1GB RAM(Mysql 3.23.56-log - busy server) mysql select BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.61 sec) -- Woody In a world without boundaries why do we need Gates and Windows? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bookmarks
At 8:45 +0500 7/23/03, Shahid M. Syed wrote: Hello Does any version (production or future) of mysql supports Bookmarks? What is Bookmark capability in a database context? Regards Shahid M. Syed Karachi, Pakistan http://members.tripod.com/shahid_syed -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
EXPLAIN - Question..
Hello everyone. I have copied the results from and explain on a query that I want to use. And I am wondering if anyone could tell me if these results are bad or good? If everything below is coming up garbled for you I will basically I am using 7 tables and the rows for 6 of the seven are 1 and the the seventh has 190892916 effected. +---++--+-+-+--+---+-+ | table | type | possible_keys| key | key_len | ref | rows | Extra | +---++--+-+-+--+---+-+ | bl| ALL| PRIMARY,receiver | NULL|NULL | NULL | 190892916 | where used; Using temporary; Using filesort | | bm| eq_ref | PRIMARY,sender | PRIMARY | 4 | bl.id | 1 | | | m | eq_ref | PRIMARY,account_login_last_index | PRIMARY | 15 | bl.receiver | 1 | where used | | mi| eq_ref | PRIMARY | PRIMARY | 15 | m.nick | 1 | | | be| eq_ref | PRIMARY | PRIMARY | 15 | m.nick | 1 | where used; Using index; Not exists | | ms| eq_ref | PRIMARY | PRIMARY | 15 | bm.sender | 1 | | | si| eq_ref | PRIMARY | PRIMARY | 15 | ms.nick | 1 | | | z | eq_ref | PRIMARY | PRIMARY | 10 | m.zip,ms.zip | 1 | | +---++--+-+-+--+---+-+
RE: What is a good benchmark?
On my P3 600MHz 256MB RAM, Redhat 8: 1 row in set (2.01 sec) Hubbard, Dan [EMAIL PROTECTED] 07/23/03 11:39AM On my 2 * 2.8Ghz 2GB RAM, Redhat 8: mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.66 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: What is a good benchmark?
personal Win98 Duron650 128MB Mysql 4.0.13 - 1.37 sec busy server Redhat 7.0 Celeron 333 380MB Mysql 3.23.54 - 3.11 sec -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 5:34 PM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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: What is a good benchmark?
1 row in set (0.54 sec) 2x Athlon2100 2GB Ram Linux 2.4.20 -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 9:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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: Database Admin
Ratmil Check out the free dbTools at http://www.dbtools.com.br/EN/ Freddie -Original Message- From: Ratmil Torres [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 23. Juli 2003 14:22 To: [EMAIL PROTECTED] Hi, I just installed MySQL. Does anybody know where to manage the databases, create, edit and delete tables? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can run two versions of MySQL in Windows 2000?
SETUP Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM) SETTINGS Prior to attempting to put on the second server, I wasn't using any options, which was logging me in as [EMAIL PROTECTED] (or more likely [EMAIL PROTECTED]), later I invoked mysql as follows: mysql -h localhost -u root to log in as the root. If you see my treads I was having problems with building temporary tables and was advised to set up a root user, turned out one was set up with the installation so I began using it.). When I started attempting to set up the multiple versions, Victoria Reznichenko directed me to the user manual and was attempting to set it up that way. I shut down the original mysql server and installed the mysql in the 4.1 Alpha folder group with the option mysqld-nt --install mysqld2 which was referenced per the manual in a file called my.cnf as follows: # options for mysqld2 service [mysqld2] basedir = C:/mysql-4.0.14 port = 3308 enable-named-pipe socket = mypipe2 It installed with no errors. Then it instructed I startup the servers as follows: NET START mysql NET START mysqld2 when I did that I got the response: The MySQL service started succesfully. and The mysqld2 service started succesfully. respectively. But when I attempt to invoke MySQL the response is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) (BTW. When I came in today I found out that I could no longer connect to 4.1.0 either. When I left last night, I could connect to 4.1.0, but could no longer connect to 4.0.13. According to windows explorer the database files are still there, but for some reason mySQL can no longer point to them.) How I'm running the servers: they are services in Windows. Though I had nothing to do with that. The setup/install utility handled that for 4.0.13. Do I have to give them a unique name for 4.1.0 so Windows can distinguish 4.1 from 4.0? Better detail? Thanks for not giving up on me! George -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 12:59 PM To: Degan, George E, JR, MGSVC Cc: [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 6:32 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: I'm sorry, I'm very new at this. I only downloaded the live version last week. Where do I find the setting you are referring to? By attempt to run the servers, perhaps this is a correct answer to your question: I am only using this for learning purposes. I am hoping to attain new skills and thought that SQL was a good place to start (since I believe it to be the base for many database languages (DBIV (or whatever version they're up to today, Oracle, Sybase, Peoplesoft, etc.) and perhaps if I lose my job this will broaden my choices in looking for a new position/career. If this is not a correct answer to your question, please clarify. It's not. I'll attempt to rephrase my questions. However, I will also suggest that if, as you say, you're very new at this, attempting to run multiple servers before you are comfortable with running a single server is not likely to be very easy. re: your setup: What version of Windows do you have? re: your settings: What options are you using to start the servers? (for example, are you passing options on the command line or storing them in an option file? If an option file, which one and what do its contents look like?) re: how you're running the servers: What command do you use to invoke the servers? Are you starting them from the command line, or installing them as services and running them that way? It is a good idea to explain exactly what you're doing, and to provide any relevant error messages that occur. (By that I mean the text of the error messages themselves -- not just a general description of the failure.) Thanks. Finally, thank you, I will change the name of the folder as you suggest. George -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 4:42 PM To: Degan, George E, JR, MGSVC; [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 14:15 -0500 7/22/03, Degan, George E, JR, MGSVC wrote: Thanks. I have been fighting with this all afternoon, now it seems I can get to 4.1.0 and not 4.0.13. My databases still seem to be there but I can't point to them either in mysql or in mysqlcc/DBManager. I guess I have moved port 3306 to the 4.1.0 database. How do I name, say, 3307 as the 4.0.13 database? First, you're better off not installing 4.1 (or any version) in a directory with a pathname that contains spaces. I suggest renaminng c:\4.1 Alpha to c:\4.1-Alpha. Second, tell us more about your setup. You're asking us to diagnose the problem with little more information than it doesn't work. What are your settings? How are you attempting to run the servers? Thanks. -Original
Re: What is a good benchmark?
Is it me or do these dual athlons seem rather responsive! I use mySQL 4.0.13 running on FreeBSD 4.8. Pentium 4 2.8Ghz 2GB DDR400 1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec) Andrew. - Original Message - From: Christopher Knight [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 6:46 PM Subject: RE: What is a good benchmark? 1 row in set (0.54 sec) 2x Athlon2100 2GB Ram Linux 2.4.20 -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 9:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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: What is a good benchmark?
Dual P3 933, 2 gig RAM, IDE RAID-5 +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.40 sec) - Original Message - From: Christopher Knight [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 10:46 AM Subject: RE: What is a good benchmark? 1 row in set (0.54 sec) 2x Athlon2100 2GB Ram Linux 2.4.20 -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 9:34 AM To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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]
Difficult count query?
I have two tables: bc_post and bc_message. This is what I have so far: select bc_post.*, count(bc_message.message_to) responses from bc_post left join bc_message on bc_post.post_id = bc_message.message_topostid where bc_post.post_status = '1' and bc_post.user_id = '1' group by bc_post.post_id This gets correct posts but not correct responses. I want to limit the responses (the count) to only those where bc_message.message_to = bc_post.user_id. If I add that statement, I get the correct responses but I lose any posts that do not have any messages (which I do not want to do). How do I retrieve the count (responses) and return 0 if there aren't any? CREATE TABLE bc_post ( post_id int(10) unsigned NOT NULL auto_increment, post_date date NOT NULL default '-00-00', post_details text NOT NULL, post_message text NOT NULL, post_gender1 varchar(7) NOT NULL default '', post_gender2 varchar(7) NOT NULL default '', user_id varchar(25) NOT NULL default '', post_ip varchar(20) NOT NULL default '', post_timestamp timestamp(14) NOT NULL, post_status int(1) NOT NULL default '0', postgeo_id char(3) NOT NULL default '', PRIMARY KEY (post_id) ) TYPE=MyISAM; CREATE TABLE bc_message ( message_id int(10) unsigned NOT NULL auto_increment, message_topostid int(10) NOT NULL default '0', message_from varchar(25) NOT NULL default '', message_to varchar(25) NOT NULL default '', message_message text NOT NULL, message_ip varchar(20) NOT NULL default '', message_timestamp timestamp(14) NOT NULL, message_status varchar(4) NOT NULL default '0', PRIMARY KEY (message_id) ) TYPE=MyISAM; Thank you for any help!!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Difficult count query?--nevermind, I found the answer...
select bc_post.*, count(bc_message.message_to) responses from bc_post left join bc_message on bc_post.post_id = bc_message.message_topostid and bc_post.user_id = bc_message.message_to where bc_post.post_status = '1' and bc_post.user_id = '1' group by bc_post.post_id -Original Message- From: motorpsychkill [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:20 AM To: mysql Subject: Difficult count query? I have two tables: bc_post and bc_message. This is what I have so far: select bc_post.*, count(bc_message.message_to) responses from bc_post left join bc_message on bc_post.post_id = bc_message.message_topostid where bc_post.post_status = '1' and bc_post.user_id = '1' group by bc_post.post_id This gets correct posts but not correct responses. I want to limit the responses (the count) to only those where bc_message.message_to = bc_post.user_id. If I add that statement, I get the correct responses but I lose any posts that do not have any messages (which I do not want to do). How do I retrieve the count (responses) and return 0 if there aren't any? CREATE TABLE bc_post ( post_id int(10) unsigned NOT NULL auto_increment, post_date date NOT NULL default '-00-00', post_details text NOT NULL, post_message text NOT NULL, post_gender1 varchar(7) NOT NULL default '', post_gender2 varchar(7) NOT NULL default '', user_id varchar(25) NOT NULL default '', post_ip varchar(20) NOT NULL default '', post_timestamp timestamp(14) NOT NULL, post_status int(1) NOT NULL default '0', postgeo_id char(3) NOT NULL default '', PRIMARY KEY (post_id) ) TYPE=MyISAM; CREATE TABLE bc_message ( message_id int(10) unsigned NOT NULL auto_increment, message_topostid int(10) NOT NULL default '0', message_from varchar(25) NOT NULL default '', message_to varchar(25) NOT NULL default '', message_message text NOT NULL, message_ip varchar(20) NOT NULL default '', message_timestamp timestamp(14) NOT NULL, message_status varchar(4) NOT NULL default '0', PRIMARY KEY (message_id) ) TYPE=MyISAM; Thank you for any help!!! -- 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: What is a good benchmark?
I get the following on dual Athlon MP 1666MHz 1GB RAM which is 40% cpu loaded mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.64 sec) This result doesn't take into account disk speed I/O etc - so this test will only be relevent for cpu speed. However, If you're worried about performance and want to speed it up a bit, use abbreviated english in your queries like this: mysql SELECT BENCHMARK(100,ENCODE(hi,bye)); +---+ | BENCHMARK(100,ENCODE(hi,bye)) | +---+ | 0 | +---+ 1 row in set (0.32 sec) Only kidding about the abbreviations ;) Andrew -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 15:34 To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- 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: What is a good benchmark?
Is it me or do these dual athlons seem rather responsive! Yay!! I win (so far... heh)! I ran it on one of our servers (not idle... running apache w/ CGIs and db calls ~ 140,000 scripts/day ) We are using as many tricks as we can. 0. mysql 4.0 binary from mysql.com 1. we set the nice to -15 in safe_mysqld (good trick.. be must be carefull not to over do it) 2. my.cnf skip-locking set-variable = lower_case_table_names=1 set-variable = sort_buffer=50M set-variable = record_buffer=2M set-variable = key_buffer=64M set-variable = query_cache_size=5M set-variable = thread_stack=2K set-variable = thread_cache=8 set-variable = thread_concurrency=4 3. Kernel is custom compiled with minimal drivers. Only what hardware is on the system is compiled. No modules. 4. I think the Athlons just preform better too. I use mySQL 4.0.13 running on FreeBSD 4.8. Pentium 4 2.8Ghz 2GB DDR400 1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec) Andrew. 1 row in set (0.54 sec) 2x Athlon2100 2GB Ram Linux 2.4.20 Chris pIII 500 1 row in set (2.59 sec) Jake Johnson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql stops processing
Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out. It doesn't happen everytime there is a high load either. The box just stops processing every query, and we quickly hit the max connection limit. The only solution we've found is to shutdown mysql and restart it -- at which point it works fine for a couple days. We are running mysql 3.23.56 w/ redhat 7.3 and 2.4.20 kernel. Anybody have any suggestions? thanks, joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re-attaching DB to mysql
Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can run two versions of MySQL in Windows 2000?
At 13:01 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: SETUP Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM) SETTINGS Prior to attempting to put on the second server, I wasn't using any options, which was logging me in as [EMAIL PROTECTED] (or more likely [EMAIL PROTECTED]), ODBC is the default user name that clients use on Windows. later I invoked mysql as follows: mysql -h localhost -u root to log in as the root. If you see my treads I was having problems with building temporary tables and was advised to set up a root user, turned out one was set up with the installation so I began using it.). When I started attempting to set up the multiple versions, Victoria Reznichenko directed me to the user manual and was attempting to set it up that way. I shut down the original mysql server and installed the mysql in the 4.1 Alpha folder group with the option mysqld-nt --install mysqld2 which was referenced per the manual in a file called my.cnf as follows: # options for mysqld2 service [mysqld2] basedir = C:/mysql-4.0.14 port = 3308 enable-named-pipe socket = mypipe2 Okay. You don't have any [mysqld] group for the other server, I take it? But that configuration is odd. It appears to apply to a 4.0.14 installation, yet you state that you're using it for your 4.1 installation. What installation directories are you now using for your two MySQL versions? It installed with no errors. Then it instructed I startup the servers as follows: NET START mysql NET START mysqld2 when I did that I got the response: The MySQL service started succesfully. and The mysqld2 service started succesfully. respectively. Okay, that looks good. When you open the Services Manager, I assume it shows lines for services named MySQL and mysqld2 and that they both have a status showing them to be running? But when I attempt to invoke MySQL the response is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Okay. What was the command you used here? What happens if you use this command: mysql -h localhost -P 3308 or this one: mysql -h . -S mypipe2 (BTW. When I came in today I found out that I could no longer connect to 4.1.0 either. When I left last night, I could connect to 4.1.0, but could no longer connect to 4.0.13. According to windows explorer the database files are still there, but for some reason mySQL can no longer point to them.) How I'm running the servers: they are services in Windows. Though I had nothing to do with that. The setup/install utility handled that for 4.0.13. Do I have to give them a unique name for 4.1.0 so Windows can distinguish 4.1 from 4.0? Yes. The Services Manager will show what the service names are. You may want to shut them down, remove them, and then start over. It may be that the presence of existing services is what's messing things up. To stop the services (assuming service names of svc-name-1 and svc-name-2): net stop svc-name-1 net stop svc-name-2 To remove them: mysqld --remove svc-name-1 mysqld --remove svc-name-2 Then start from the beginning, using the mysqld --install instructions in the manual. Better detail? Thanks for not giving up on me! Yes, much better detail. Thanks. George -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql stops processing
Hi, I don't know what type of applications are using your database but if I had to guess at the problem, I would guess that you have a very slow query which runs every now and again that is locking up certain tables/records causing all the other queries to queue up and eventually running out of connections on the DB. To find out if this is the case, when your server gets into this state run a mysqladmin -v pro and see if all the queries are waiting for a lock to be freed up. Hope this helps, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:45 To: [EMAIL PROTECTED] Subject: mysql stops processing Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out. It doesn't happen everytime there is a high load either. The box just stops processing every query, and we quickly hit the max connection limit. The only solution we've found is to shutdown mysql and restart it -- at which point it works fine for a couple days. We are running mysql 3.23.56 w/ redhat 7.3 and 2.4.20 kernel. Anybody have any suggestions? thanks, joe -- 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: What is a good benchmark?
I got disappointing results compared with the ones posted here:with a dual xeon 2Ghz, 2GB ram, freebsd 5.1, mysql mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (1.10 sec) Any idea how to improve it? The cpu is 90% idle average. following my.cnf and configure options... my.cnf -- [mysqld] log-bin set-variable = max_connections=700 set-variable = max_connect_errors=100 safe-show-database set-variable = wait_timeout=120 set-variable = interactive_timeout=120 set-variable = myisam-recover=BACKUP,FORCE set-variable = key_buffer_size=500MB set-variable = sort_buffer_size=5M set-variable = read_buffer_size=2M set-variable = table_cache=512 set-variable = max_delayed_threads=0 set-variable = max_user_connections=25 set-variable = query_cache_size=50M set-variable = thread_cache_size=100 # INNODB innodb_data_home_dir = /var/mysql/data/INNODB innodb_buffer_pool_size = 80M innodb_additional_mem_pool_size = 5M innodb_log_buffer_size = 20M -- configure: ./configure \ --enable-static \ --with-innodb \ --without-berkeley-db \ --with-mysqld-user=mysql \ --without-debug \ --without-docs \ --without-gemini \ --without-mit-threads \ --without-perl \ --without-readline \ --without-docs \ --with-mysqld-ldflags=-all-static \ --enable-thread-safe-client \ --enable-local-infile \ --enable-assembler \ --with-extra-charsets=complex \ --with-named-thread-libs='-DHAVE_GLIBC2_STYLE_GETHOSTBYNAME_R -D_THREAD_SAFE -I/usr/local/include/pthread/linuxthreads -L/usr/local/lib -llthread -llgcc_r -llstdc++ -llsupc++' \ --with-comment='Superb Mysql Server' \ --localstatedir=/var/mysql/data \ --prefix=/var/mysql/mysql-4.0.13-2003-jul-08 Thanks for any hint... Andrew Braithwaite wrote: I get the following on dual Athlon MP 1666MHz 1GB RAM which is 40% cpu loaded mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.64 sec) This result doesn't take into account disk speed I/O etc - so this test will only be relevent for cpu speed. However, If you're worried about performance and want to speed it up a bit, use abbreviated english in your queries like this: mysql SELECT BENCHMARK(100,ENCODE(hi,bye)); +---+ | BENCHMARK(100,ENCODE(hi,bye)) | +---+ | 0 | +---+ 1 row in set (0.32 sec) Only kidding about the abbreviations ;) Andrew -Original Message- From: Jake Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 15:34 To: Mysql Subject: What is a good benchmark? I ran this benchmark on my pIII 500 and was wondering what everyone else was getting? mysql SELECT BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- -- Gustavo Baratto - Programming and Technical Support [EMAIL PROTECTED] * (604) 638-2525 ext. 408 Technical support web-site: http://support.superb.net Superb Internet Corp. Ahead of the Rest - -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re-attaching DB to mysql
Is the backup a mysqldump or a copy of the data files? Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:48 To: 'Mysql' Subject: Re-attaching DB to mysql Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- 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: What is a good benchmark?
At 01:45 PM 7/23/2003, you wrote: Is it me or do these dual athlons seem rather responsive! Yay!! I win (so far... heh)! Beat you by a nose. (Of course I had to run it 2 or 3 times to shave a couple hundreds of a second off the times)g A single P4 2.4 Ghz 1g RAM running MySQL 4.1.0 Alpha running on Win2k no less. Yes, you were beaten by a single horse CPU running on a Windoze machine (how are you going to live it downg). I'm surprised no one has 3ghz CPU's out there. I never thought my computer was that fast. Maybe it was the wind direction? Mike mysql select BENCHMARK(100,ENCODE(hello,goodbye)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (0.53 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re-attaching DB to mysql
Copy of the data files :-( - Henrik -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:04 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Is the backup a mysqldump or a copy of the data files? Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:48 To: 'Mysql' Subject: Re-attaching DB to mysql Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- 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]
Is it necessary to compress tables?
Does MySQL automatically handle deleted row cleanup, or is it necessary to periodically do this manually for tables with a lot of deletions? If it's manual, what are the SQL commands to do this? Also, what happens when changes are made to a field definition? From, say, int to smallint, or tinyint to int, or varchar(255) to varchar(10)? Do temporary tables get created and the data copied over, or does unused space end up in the data files, to be collected later? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can run two versions of MySQL in Windows 2000?
My responses are parenthesied in the text below. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:56 PM To: Degan, George E, JR, MGSVC Cc: [EMAIL PROTECTED] Subject: RE: Can run two versions of MySQL in Windows 2000? At 13:01 -0500 7/23/03, Degan, George E, JR, MGSVC wrote: SETUP Windows 2000, Version 5.0 (build 2195, Service Pack 2) (In case it matters, I have about 20 GB available on my 40GB hard drive and 192MB of RAM) SETTINGS Prior to attempting to put on the second server, I wasn't using any options, which was logging me in as [EMAIL PROTECTED] (or more likely [EMAIL PROTECTED]), ODBC is the default user name that clients use on Windows. (Thanks for the input) later I invoked mysql as follows: mysql -h localhost -u root to log in as the root. If you see my treads I was having problems with building temporary tables and was advised to set up a root user, turned out one was set up with the installation so I began using it.). When I started attempting to set up the multiple versions, Victoria Reznichenko directed me to the user manual and was attempting to set it up that way. I shut down the original mysql server and installed the mysql in the 4.1 Alpha folder group with the option mysqld-nt --install mysqld2 which was referenced per the manual in a file called my.cnf as follows: # options for mysqld2 service [mysqld2] basedir = C:/mysql-4.0.14 port = 3308 enable-named-pipe socket = mypipe2 Okay. You don't have any [mysqld] group for the other server, I take it? But that configuration is odd. It appears to apply to a 4.0.14 installation, yet you state that you're using it for your 4.1 installation. What installation directories are you now using for your two MySQL versions? (Sorry for the confusion, the my.cnf file had two parts to it, I only copied the part about mysqld2, didn't realize the first one was relevant. Here is the entire file (I copied the previous one from the manual, but I did actually run it with the correct directory names): # options for default service (MySql) [mysqld] basedir = C:/mysql port = 3306 enable-named-pipe socket = mypipe1 #options for default service (mysqld2) (mysqld2) basedir = c:\4.1 Alpha\mysql port = 3307 enable-named-pipe socket = mypipe2 It didn't seem to understand the line enable-named-pipe though as when I tried running the following files: my-opts1.cnf: [mysqld] basedir = C:/mysql port = 3306 enable named-pipe socket = mypipe1 my-opts2.cnf: [mysqld2] basedir = c:\4.1 Alpha\mysql port = 3307 enable-named-pipe socket = mypipe2 With these commands: mysqld --defaults-file=C:\my-opts1.cnf response: mysqld: ERROR: unknown option '--enable-named-pipe' mysqld-max --defaults-file=C:\my-opts2.cnf response: yesterday it gave a similar one to the above, though when I do it now it responds: 030723 15:09:02 Error message file 'C:\mysql\share\english\errmsg.sys' had only 237 error messages, but it should contain at least 255 error messages. Check that the above file is the right version for this program! 030723 15:09:02 when I invoke it from the folder of the old version. and: mysqld-max: Can't change dir to 'C:\4.1 Alpha\mysql\data\' (Errcode:2) 030723 15:15:06 Aborting 030723 15:15:06 mysqld-max: Shutdown Complete again per instructions from the manual. I have included the error messages when I attempted them above.) It installed with no errors. Then it instructed I startup the servers as follows: NET START mysql NET START mysqld2 when I did that I got the response: The MySQL service started succesfully. and The mysqld2 service started succesfully. respectively. Okay, that looks good. When you open the Services Manager, I assume it shows lines for services named MySQL and mysqld2 and that they both have a status showing them to be running? (Sorry, the Services Manager? I'm not sure what that is.) But when I attempt to invoke MySQL the response is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) Okay. What was the command you used here? (just the same as before: mysql or mysql -h localhost -u root What happens if you use this command: mysql -h localhost -P 3308 or this one: mysql -h . -S mypipe2 (both give the following response: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061), and I tried several Ports, 3308, 3307, 3306, and 3309 in this order) (BTW. When I came in today I found out that I could no longer connect to 4.1.0 either. When I left last night, I could connect to 4.1.0, but could no longer connect to 4.0.13. According to windows explorer the database files are still there, but for some reason mySQL can no longer point to them.) How I'm running the servers: they are services in Windows. Though I had nothing to do with that. The setup/install utility handled that for 4.0.13. Do I have to give them a unique name for 4.1.0 so Windows can distinguish 4.1 from 4.0? Yes. The Services Manager will show what the
error loading mod_auth_mysql
Hi All, I am running mysql-3.23.52 on OS X (10.2.6) and I'd like to install the mod_auth_mysql module for a job I'm working on that used it under a different platform. I compiled the module using: apxs -c -D APACHE1 -L/usr/local/mysql/lib/ -I/usr/include/mysql/ -lmysqlclient -lm -lz mod_auth_mysql.c and installed it: sudo apxs -i mod_auth_mysql.so both of which seemed to go fine. In the httpd.conf file I have put the two lines: LoadModule mysql_auth_module libexec/httpd/mod_auth_mysql.so AddModule mod_auth_mysql.c but when I try to do a graceful restart of apache I get the following response: % sudo apachectl graceful /usr/sbin/apachectl graceful: configuration broken, ignoring restart /usr/sbin/apachectl graceful: (run 'apachectl configtest' for details) % sudo apachectl configtest Syntax error on line 241 of /etc/httpd/httpd.conf: Cannot load /usr/libexec/httpd/libphp4.so into server: (reason unknown) Is there a particular order that this had to go in the httpd.conf file? I can't understand why it is complaining about libphp4. What do you think I'm doing that I should be doing differently? Thanks very much. Colin. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql stops processing
hi, We're pretty careful about preventing that. Also, no queries are moving forward, no inserts, updates, or selects, even the ones on tables that are only a mixture of inserts and selects. joe On Wed, 2003-07-23 at 12:02, Andrew Braithwaite wrote: Hi, I don't know what type of applications are using your database but if I had to guess at the problem, I would guess that you have a very slow query which runs every now and again that is locking up certain tables/records causing all the other queries to queue up and eventually running out of connections on the DB. To find out if this is the case, when your server gets into this state run a mysqladmin -v pro and see if all the queries are waiting for a lock to be freed up. Hope this helps, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:45 To: [EMAIL PROTECTED] Subject: mysql stops processing Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out. It doesn't happen everytime there is a high load either. The box just stops processing every query, and we quickly hit the max connection limit. The only solution we've found is to shutdown mysql and restart it -- at which point it works fine for a couple days. We are running mysql 3.23.56 w/ redhat 7.3 and 2.4.20 kernel. Anybody have any suggestions? thanks, joe -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
HELP WITH mySQL!!!
UGHH HELP!! I need to write a sql statement that will take the data from my table and use it as column headers. For example, If I have a field named GoLiveDate and a field called Qty and a field called Cars: Cars | Qty | GoLiveDate == CarA | 5 | 7/21/2003 CarA | 10| 7/28/2003 CarA | 14| 8/1/2003 CarB | 2 | 7/21/2003 CarB | 3| 7/28/2003 CarB | 4| 8/1/2003 CarC | 7 | 7/21/2003 CarC | 19| 8/28/2003 CarC | 44| 9/1/2003 The results should be CarsJulyAugustSeptember == CarA15140 CarB540 CarC71944 Any help that you could give or point me to where I can find a solution would help. I am getting stuck on making the Month name's of the dates the column headers Thanks, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql stops processing
Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 23, 2003 10:40 PM Subject: RE: mysql stops processing hi, We're pretty careful about preventing that. Also, no queries are moving forward, no inserts, updates, or selects, even the ones on tables that are only a mixture of inserts and selects. what do SHOW PROCESSLIST and SHOW INNODB STATUS print in this situation? Or is it so that you cannot run them because of maxed out connections? You could write script to run them every 5 seconds so that we could see what is happening. Also, if you do CREATE TABLE innodb_monitor(a INT) TYPE=InnoDB; then mysqld will print the output of SHOW INNODB STATUS to the .err file every 15 seconds. What is the CPU usage from 'top' during the hang? 4.0.14 has better diagnostics than 3.23.56. An upgrade might help, but let us wait a couple of days first. joe Regards, Heikki On Wed, 2003-07-23 at 12:02, Andrew Braithwaite wrote: Hi, I don't know what type of applications are using your database but if I had to guess at the problem, I would guess that you have a very slow query which runs every now and again that is locking up certain tables/records causing all the other queries to queue up and eventually running out of connections on the DB. To find out if this is the case, when your server gets into this state run a mysqladmin -v pro and see if all the queries are waiting for a lock to be freed up. Hope this helps, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:45 To: [EMAIL PROTECTED] Subject: mysql stops processing Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out. It doesn't happen everytime there is a high load either. The box just stops processing every query, and we quickly hit the max connection limit. The only solution we've found is to shutdown mysql and restart it -- at which point it works fine for a couple days. We are running mysql 3.23.56 w/ redhat 7.3 and 2.4.20 kernel. Anybody have any suggestions? thanks, joe -- Joe Shear [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: Re-attaching DB to mysql
Hi, If that backup uses the old .ISD .ISM architecture then I would install an old version of MySQL, copy these files into the data dir of that installation and mysqldump them to a file ready for import into your new MySQL v4 install. I'm not aware of any scripts to just munge the old style data into the new but I'm happy to be corrected on that! Cheers, Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 20:05 To: Andrew Braithwaite; 'Mysql' Subject: RE: Re-attaching DB to mysql Copy of the data files :-( - Henrik -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:04 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Is the backup a mysqldump or a copy of the data files? Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:48 To: 'Mysql' Subject: Re-attaching DB to mysql Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- 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: mysql stops processing
Unfortunately, we haven't been able to connect to the database because of the maxed out connections. This happens so fast that the maxed out connections is usually the first sign. I've been hesitant to start the monitor, since this has only been happening once every couple days. It's been becoming more frequent, so I'll try turning them on and see if we get lucky. Top isn't showing that our CPU usage is that high. Last time we saw this, it was around 50% on both procs. Also, we are flushing logs every 5 minutes (this has caused problems in the past). On Wed, 2003-07-23 at 12:56, Heikki Tuuri wrote: Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 23, 2003 10:40 PM Subject: RE: mysql stops processing hi, We're pretty careful about preventing that. Also, no queries are moving forward, no inserts, updates, or selects, even the ones on tables that are only a mixture of inserts and selects. what do SHOW PROCESSLIST and SHOW INNODB STATUS print in this situation? Or is it so that you cannot run them because of maxed out connections? You could write script to run them every 5 seconds so that we could see what is happening. Also, if you do CREATE TABLE innodb_monitor(a INT) TYPE=InnoDB; then mysqld will print the output of SHOW INNODB STATUS to the .err file every 15 seconds. What is the CPU usage from 'top' during the hang? 4.0.14 has better diagnostics than 3.23.56. An upgrade might help, but let us wait a couple of days first. joe Regards, Heikki On Wed, 2003-07-23 at 12:02, Andrew Braithwaite wrote: Hi, I don't know what type of applications are using your database but if I had to guess at the problem, I would guess that you have a very slow query which runs every now and again that is locking up certain tables/records causing all the other queries to queue up and eventually running out of connections on the DB. To find out if this is the case, when your server gets into this state run a mysqladmin -v pro and see if all the queries are waiting for a lock to be freed up. Hope this helps, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:45 To: [EMAIL PROTECTED] Subject: mysql stops processing Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out. It doesn't happen everytime there is a high load either. The box just stops processing every query, and we quickly hit the max connection limit. The only solution we've found is to shutdown mysql and restart it -- at which point it works fine for a couple days. We are running mysql 3.23.56 w/ redhat 7.3 and 2.4.20 kernel. Anybody have any suggestions? thanks, joe -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re-attaching DB to mysql
Thanks for the reply. I started a mysql v3 on a new system with the old backup data directory and type: mysqldump -p henrik henrik.sql This dumps the DB? To restore, I move henrik.sql to the current 4.0.14 server and type: mysql -p henrik henrik.sql except it complains the DB does not exists. I can create the DB in Mysql 4 and then restore (and it works), but it is not clear to me I will have restored everything properly. Sincerely, - Henrik -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:59 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Hi, If that backup uses the old .ISD .ISM architecture then I would install an old version of MySQL, copy these files into the data dir of that installation and mysqldump them to a file ready for import into your new MySQL v4 install. I'm not aware of any scripts to just munge the old style data into the new but I'm happy to be corrected on that! Cheers, Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 20:05 To: Andrew Braithwaite; 'Mysql' Subject: RE: Re-attaching DB to mysql Copy of the data files :-( - Henrik -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:04 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Is the backup a mysqldump or a copy of the data files? Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:48 To: 'Mysql' Subject: Re-attaching DB to mysql Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- 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: Re-attaching DB to mysql
And from the MySQL docs: --clip MySQL Version 3.23 supports tables of the new MyISAM type and the old ISAM type. You don't have to convert your old tables to use these with Version 3.23. By default, all new tables will be created with type MyISAM (unless you start mysqld with the --default-table-type=isam option). You can convert an ISAM table to MyISAM format with ALTER TABLE table_name TYPE=MyISAM or the Perl script mysql_convert_table_format. --/clip--- You could install this halfway house version or just get hold of the perl scripts and run the mysql_convert_table_format script You've got me interested now - I should be doing real work instead... :) Andrew -Original Message- From: Andrew Braithwaite Sent: Wednesday 23 July 2003 20:59 To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Hi, If that backup uses the old .ISD .ISM architecture then I would install an old version of MySQL, copy these files into the data dir of that installation and mysqldump them to a file ready for import into your new MySQL v4 install. I'm not aware of any scripts to just munge the old style data into the new but I'm happy to be corrected on that! Cheers, Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 20:05 To: Andrew Braithwaite; 'Mysql' Subject: RE: Re-attaching DB to mysql Copy of the data files :-( - Henrik -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:04 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Is the backup a mysqldump or a copy of the data files? Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:48 To: 'Mysql' Subject: Re-attaching DB to mysql Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- 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]
large mysql/innodb databases
I was wondering if anyone had any experience with setting up large and fairly high performance databases. We are looking at setting up databases with each machine having somewhere between 500 gigs and 2 terabytes along with a slave box and we'd like to backup everything to tape at a minimum of once a week, but if possible, daily. We're also looking at central storage solutions. However, we're hesitant because that will result in a (very expensive) single point of failure. Of course, we could buy 2, but they are fairly expensive. Has anyone had any experience with setups like this? What kind of backup solutions did you use? We aren't too concerned about the CPU usage as our databases tend to be i/o bound. -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql stops processing
Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:03 PM Subject: Re: mysql stops processing Unfortunately, we haven't been able to connect to the database because of the maxed out connections. This happens so fast that the maxed out connections is usually the first sign. can you keep open the interactive SQL client mysql so that when the hang occurs you would have a connection where to run SHOW PROCESSLIST etc.? I've been hesitant to start the monitor, since this has only been happening once every couple days. It's been becoming more frequent, so I'll try turning them on and see if we get lucky. Top isn't showing that our CPU usage is that high. Last time we saw this, it was around 50% on both procs. 50 % during the hang? Is mysqld taking that much though it is not processing anything? Also, we are flushing logs every 5 minutes (this has caused problems in the past). Regards, Heikki On Wed, 2003-07-23 at 12:56, Heikki Tuuri wrote: Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 23, 2003 10:40 PM Subject: RE: mysql stops processing hi, We're pretty careful about preventing that. Also, no queries are moving forward, no inserts, updates, or selects, even the ones on tables that are only a mixture of inserts and selects. what do SHOW PROCESSLIST and SHOW INNODB STATUS print in this situation? Or is it so that you cannot run them because of maxed out connections? You could write script to run them every 5 seconds so that we could see what is happening. Also, if you do CREATE TABLE innodb_monitor(a INT) TYPE=InnoDB; then mysqld will print the output of SHOW INNODB STATUS to the .err file every 15 seconds. What is the CPU usage from 'top' during the hang? 4.0.14 has better diagnostics than 3.23.56. An upgrade might help, but let us wait a couple of days first. joe Regards, Heikki On Wed, 2003-07-23 at 12:02, Andrew Braithwaite wrote: Hi, I don't know what type of applications are using your database but if I had to guess at the problem, I would guess that you have a very slow query which runs every now and again that is locking up certain tables/records causing all the other queries to queue up and eventually running out of connections on the DB. To find out if this is the case, when your server gets into this state run a mysqladmin -v pro and see if all the queries are waiting for a lock to be freed up. Hope this helps, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:45 To: [EMAIL PROTECTED] Subject: mysql stops processing Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out. It doesn't happen everytime there is a high load either. The box just stops processing every query, and we quickly hit the max connection limit. The only solution we've found is to shutdown mysql and restart it -- at which point it works fine for a couple days. We are running mysql 3.23.56 w/ redhat 7.3 and 2.4.20 kernel. Anybody have any suggestions? thanks, joe -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re-attaching DB to mysql
The mysqldump you use doesn't include the create databease so you'll need to create the henrik DB on the new install. If you keep running it over and over, it will keep inserting the same records over and over again and you'll end up with duplicates. The thing to do is start with an empty db (call it whatever you like) and run the restore just once. This should give you a nice clean backup restore to then do whatever you want with... Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 21:07 To: Andrew Braithwaite; 'Mysql' Subject: RE: Re-attaching DB to mysql Thanks for the reply. I started a mysql v3 on a new system with the old backup data directory and type: mysqldump -p henrik henrik.sql This dumps the DB? To restore, I move henrik.sql to the current 4.0.14 server and type: mysql -p henrik henrik.sql except it complains the DB does not exists. I can create the DB in Mysql 4 and then restore (and it works), but it is not clear to me I will have restored everything properly. Sincerely, - Henrik -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:59 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Hi, If that backup uses the old .ISD .ISM architecture then I would install an old version of MySQL, copy these files into the data dir of that installation and mysqldump them to a file ready for import into your new MySQL v4 install. I'm not aware of any scripts to just munge the old style data into the new but I'm happy to be corrected on that! Cheers, Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 20:05 To: Andrew Braithwaite; 'Mysql' Subject: RE: Re-attaching DB to mysql Copy of the data files :-( - Henrik -Original Message- From: Andrew Braithwaite [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 2:04 PM To: 'Henrik Schmiediche'; 'Mysql' Subject: RE: Re-attaching DB to mysql Is the backup a mysqldump or a copy of the data files? Andrew -Original Message- From: Henrik Schmiediche [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:48 To: 'Mysql' Subject: Re-attaching DB to mysql Hello, I have a backup of a mysql v3.0.18 DB. I need to extract one of the DB's from that backup and place it into my current production v4.0.14 mysql DB. Can this be done? How? Sincerely, - Henrik -- 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: mysql stops processing
On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote: Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:03 PM Subject: Re: mysql stops processing Unfortunately, we haven't been able to connect to the database because of the maxed out connections. This happens so fast that the maxed out connections is usually the first sign. can you keep open the interactive SQL client mysql so that when the hang occurs you would have a connection where to run SHOW PROCESSLIST etc.? I can try, but the ops guys are usually the ones who react, and they often have to reset mysql from home, so they wouldn't have access to open mysql client windows here. I've been hesitant to start the monitor, since this has only been happening once every couple days. It's been becoming more frequent, so I'll try turning them on and see if we get lucky. Top isn't showing that our CPU usage is that high. Last time we saw this, it was around 50% on both procs. 50 % during the hang? Is mysqld taking that much though it is not processing anything? I think its all mysqld -- even when it's not going anything. Could it be thrashing on something? We don't have our max connections set that high (100). When we were using 3.23.52, we had really bad problems with a similar problem but the CPU usage would hit 100%. When we upgraded, the problem went away for a month. Also, we are flushing logs every 5 minutes (this has caused problems in the past). Regards, Heikki On Wed, 2003-07-23 at 12:56, Heikki Tuuri wrote: Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 23, 2003 10:40 PM Subject: RE: mysql stops processing hi, We're pretty careful about preventing that. Also, no queries are moving forward, no inserts, updates, or selects, even the ones on tables that are only a mixture of inserts and selects. what do SHOW PROCESSLIST and SHOW INNODB STATUS print in this situation? Or is it so that you cannot run them because of maxed out connections? You could write script to run them every 5 seconds so that we could see what is happening. Also, if you do CREATE TABLE innodb_monitor(a INT) TYPE=InnoDB; then mysqld will print the output of SHOW INNODB STATUS to the .err file every 15 seconds. What is the CPU usage from 'top' during the hang? 4.0.14 has better diagnostics than 3.23.56. An upgrade might help, but let us wait a couple of days first. joe Regards, Heikki On Wed, 2003-07-23 at 12:02, Andrew Braithwaite wrote: Hi, I don't know what type of applications are using your database but if I had to guess at the problem, I would guess that you have a very slow query which runs every now and again that is locking up certain tables/records causing all the other queries to queue up and eventually running out of connections on the DB. To find out if this is the case, when your server gets into this state run a mysqladmin -v pro and see if all the queries are waiting for a lock to be freed up. Hope this helps, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:45 To: [EMAIL PROTECTED] Subject: mysql stops processing Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out. It doesn't happen everytime there is a high load either. The box just stops processing every query, and we quickly hit the max connection limit. The only solution we've found is to shutdown mysql and restart it -- at which point it works fine for a couple days. We are running mysql 3.23.56 w/ redhat 7.3 and 2.4.20 kernel. Anybody have any suggestions? thanks, joe -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Joe Shear [EMAIL PROTECTED] -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql stops processing
Hi, I believe that MySQL v4 has a superuser privilege level that keeps a connection available even when the regular connections are all used up just for diagnosis/killing etc... May want to try that to get your processlist too. Cheers, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 21:04 To: Heikki Tuuri Cc: [EMAIL PROTECTED] Subject: Re: mysql stops processing Unfortunately, we haven't been able to connect to the database because of the maxed out connections. This happens so fast that the maxed out connections is usually the first sign. I've been hesitant to start the monitor, since this has only been happening once every couple days. It's been becoming more frequent, so I'll try turning them on and see if we get lucky. Top isn't showing that our CPU usage is that high. Last time we saw this, it was around 50% on both procs. Also, we are flushing logs every 5 minutes (this has caused problems in the past). On Wed, 2003-07-23 at 12:56, Heikki Tuuri wrote: Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 23, 2003 10:40 PM Subject: RE: mysql stops processing hi, We're pretty careful about preventing that. Also, no queries are moving forward, no inserts, updates, or selects, even the ones on tables that are only a mixture of inserts and selects. what do SHOW PROCESSLIST and SHOW INNODB STATUS print in this situation? Or is it so that you cannot run them because of maxed out connections? You could write script to run them every 5 seconds so that we could see what is happening. Also, if you do CREATE TABLE innodb_monitor(a INT) TYPE=InnoDB; then mysqld will print the output of SHOW INNODB STATUS to the .err file every 15 seconds. What is the CPU usage from 'top' during the hang? 4.0.14 has better diagnostics than 3.23.56. An upgrade might help, but let us wait a couple of days first. joe Regards, Heikki On Wed, 2003-07-23 at 12:02, Andrew Braithwaite wrote: Hi, I don't know what type of applications are using your database but if I had to guess at the problem, I would guess that you have a very slow query which runs every now and again that is locking up certain tables/records causing all the other queries to queue up and eventually running out of connections on the DB. To find out if this is the case, when your server gets into this state run a mysqladmin -v pro and see if all the queries are waiting for a lock to be freed up. Hope this helps, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 19:45 To: [EMAIL PROTECTED] Subject: mysql stops processing Hi, Has anyone ever had any problems with MySQL w/ all InnoDB tables just stop processing queries? There doesn't seem to be any pattern to it, it happens at times of relatively high load (load avg of 4 on a dual proc) but the CPUs still have plenty of idle time, and the disks aren't maxing out. It doesn't happen everytime there is a high load either. The box just stops processing every query, and we quickly hit the max connection limit. The only solution we've found is to shutdown mysql and restart it -- at which point it works fine for a couple days. We are running mysql 3.23.56 w/ redhat 7.3 and 2.4.20 kernel. Anybody have any suggestions? thanks, joe -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Joe Shear [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: mysql stops processing
Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:23 PM Subject: Re: mysql stops processing On Wed, 2003-07-23 at 13:11, Heikki Tuuri wrote: Joe, - Original Message - From: Joe Shear [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 23, 2003 11:03 PM Subject: Re: mysql stops processing ... 50 % during the hang? Is mysqld taking that much though it is not processing anything? I think its all mysqld -- even when it's not going anything. Could it be thrashing on something? We don't have our max connections set that high (100). When we were using 3.23.52, we had really bad problems with a similar problem but the CPU usage would hit 100%. When we upgraded, the problem went away for a month. The 'thread thrashing' problem of 2002 caused CPU usage to increase by a factor of 100, but it did not stop processing completely. Anyway, we need the diagnostic outputs to conclude anything further. Regards, Heikki -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: large mysql/innodb databases
At 03:08 PM 7/23/2003, you wrote: I was wondering if anyone had any experience with setting up large and fairly high performance databases. We are looking at setting up databases with each machine having somewhere between 500 gigs and 2 terabytes along with a slave box and we'd like to backup everything to tape at a minimum of once a week, but if possible, daily. We're also looking at central storage solutions. However, we're hesitant because that will result in a (very expensive) single point of failure. Of course, we could buy 2, but they are fairly expensive. Has anyone had any experience with setups like this? What kind of backup solutions did you use? We aren't too concerned about the CPU usage as our databases tend to be i/o bound. -- Joe Shear [EMAIL PROTECTED] Joe, You didn't mention what control the backup would have over the database tables: a) MySQL Server can be shut down during backup b) MySQL Server is Up but backup would have exclusive access to the tables being backed up c) MySQL Server is Up and other processes have read only access to tables being backed up d) MySQL Server is Up and other processes have read/write access to the tables being backed up This will help the people on this newsgroup provide you with the correct answer. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: large mysql/innodb databases
Hi, We have similar numbers here. A couple of questions: - are they logfiles that could be rolled over on a daily basis or are they constantly updated huge tables? - is the type of backup you want incremental or a daily/weekly snapshot one? - do you have a requirement for the speed of restore needed in the case of disaster recovery? - is the replicated slave allowed to stop replicating whilst the backup is being performed? Let me know and I think I'll be able to help :) Cheers, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 21:08 To: [EMAIL PROTECTED] Subject: large mysql/innodb databases I was wondering if anyone had any experience with setting up large and fairly high performance databases. We are looking at setting up databases with each machine having somewhere between 500 gigs and 2 terabytes along with a slave box and we'd like to backup everything to tape at a minimum of once a week, but if possible, daily. We're also looking at central storage solutions. However, we're hesitant because that will result in a (very expensive) single point of failure. Of course, we could buy 2, but they are fairly expensive. Has anyone had any experience with setups like this? What kind of backup solutions did you use? We aren't too concerned about the CPU usage as our databases tend to be i/o bound. -- Joe Shear [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]
Restrict UPDATE without WHERE
Is there any way to restrict UPDATE without a WHERE clause? Mohammad Khan Software Engineer Legal Computer Solutions, Inc. 107 Union Wharf Boston, MA 02109 http://www.lextranet.com (617) 227-4469 x 212
Re: Didn't find any fields in table 't_table'???
Jake Johnson wrote: How do I fix this error? My tables have data. But they probably are not owned by mysql. Regards, Jake Johnson [EMAIL PROTECTED] __ Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on Rims, Car Audio, and Performance Parts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Master/Master Asynchronous replication
Currently we have a web based application that is mostly reads (4:1 r/w). It is using a single MySQL database server. Is there any way to have two database servers in a master/master configuration such that writes to either database server are replicated to eachother. Basically even though we have a 4:1 ration of read/write the writes happen often enought that when the database goes down the app stops working. I know how to get this working in Oracle (insert big laugh here) but Oracle is cost prohibitive. Any pointers? Any suggestions? If this is available in the latest version that would be great. Thanks /Joe -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: large mysql/innodb databases
The data is constantly updated. There are 3 or 4 huge tables, and several smaller tables. We would love to have an incremental solution that is *guaranteed* to be correct, but we haven't found a way to do that, so what we've been thing is we'd do a complete snapshot once a week, and do incremental backups of one form or another every day. The replicated slave is allowed to stop replicating during backup. There is no absolute requirement on the time needed to restore. We'd like most disaster recovery to go fairly quickly, but we realize that on our budget, that a major disaster could cause us fairly significant downtime. On Wed, 2003-07-23 at 13:43, Andrew Braithwaite wrote: Hi, We have similar numbers here. A couple of questions: - are they logfiles that could be rolled over on a daily basis or are they constantly updated huge tables? - is the type of backup you want incremental or a daily/weekly snapshot one? - do you have a requirement for the speed of restore needed in the case of disaster recovery? - is the replicated slave allowed to stop replicating whilst the backup is being performed? Let me know and I think I'll be able to help :) Cheers, Andrew -Original Message- From: Joe Shear [mailto:[EMAIL PROTECTED] Sent: Wednesday 23 July 2003 21:08 To: [EMAIL PROTECTED] Subject: large mysql/innodb databases I was wondering if anyone had any experience with setting up large and fairly high performance databases. We are looking at setting up databases with each machine having somewhere between 500 gigs and 2 terabytes along with a slave box and we'd like to backup everything to tape at a minimum of once a week, but if possible, daily. We're also looking at central storage solutions. However, we're hesitant because that will result in a (very expensive) single point of failure. Of course, we could buy 2, but they are fairly expensive. Has anyone had any experience with setups like this? What kind of backup solutions did you use? We aren't too concerned about the CPU usage as our databases tend to be i/o bound. -- Joe Shear [EMAIL PROTECTED] -- Joe Shear [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]