Re: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

Hi Mike, I've asked this question a year ago on the Borland forums but didn't get any replies. Do you know of any websites (non-programming related) that are using Interbase/Firebird for their primary webserver database? I don't mean programmer hangouts like www.mers.com or www.tamaracka.com

Re: Performance problems using 1GB Linux server and trying to avoid swapping

Hi, On Tue, Dec 16, 2003 at 10:23:05PM +1100, Chris Nolan wrote : How heavy is your usage of TEMPORARY TABLES? I don't use them much myself, but I'm sure that the others on the list will have something to say in that regard. Here are the relevant numbers: Created_tmp_disk_tables

Re: Performance problems using 1GB Linux server and trying to avoid swapping

On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote : In the last episode (Dec 16), Markus Fischer said: I'm investigating a performance problem with mysql server set up. The server is running linux with 1GB ram. I'ld like to tune the configuration of the server to use as much RAM

Run Time Error-'3027'-Cannot Update Database or Object is Read Only

Hello All, I am Swetha.I am facing the above mentioned problem while adding/updating a recordset in the my_dao table.I tried a lot i am not getting the reason for this.So please let me know the reason the solution for this problem. With Regards, Swetha.

please give me help in important decision!

hello, i'm working on a java-jsp-page with mysql-connection. now i've created a test-system with myisam-tables where the tables are just read. my plans for next weeks are, to make the owner of the site capable of entering/changing his data by his own - web-based and multi-user-capable. as

Re: please give me help in important decision!

Hi Hans, i'm working on a java-jsp-page with mysql-connection. now i've created a test-system with myisam-tables where the tables are just read. my plans for next weeks are, to make the owner of the site capable of entering/changing his data by his own - web-based and multi-user-capable. as

Re: Run Time Error-'3027'-Cannot Update Database or Object is Read Only

hi swetha, Pl. check the privilege tables for the user access. -Aman. Swetha S.N. wrote: Hello All, I am Swetha.I am facing the above mentioned problem while adding/updating a recordset in the my_dao table.I tried a lot i am not getting the reason for this.So please let me know the reason

Re: MySQL with SSL enabled

rmck [EMAIL PROTECTED] wrote: I am in the process of installing Mysql 4.0.17. I need to have Mysql with SSL enabled. Does this feature come enabled with the binary download? Or do I need to download the source and compile it? Official binaries are compiled without SSL support. Any

Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ?

Juri Shimon [EMAIL PROTECTED] wrote: Thanks for reply! 1. mysql -u root -e create database t; show create database t; drop database t 2. mysql -u root -e use_mysql; create database t; show create database t; drop database t 1.| t| CREATE DATABASE `t` /*!40100 DEFAULT CHARACTER

Re: please give me help in important decision!

Hi Hans, Please reply to the MySQL list instead of personally. hi martijn, thank you very much for your help. my replies are further down... * if yes: how can i change them for the real-system (the homepage), that uses packed myisam-tables (because there is no writing, only reading from db!).

Re: Sporadic myisam table corruption.

Hi, either this should be properly debugged (if the problem persists with 4.0.17) or it is a hardware glitch. MyIsam tables have proven quite stable anch changing to InnoDB might be looking for trouble (if hardware is the culprit). But it's true that InnoDB could be much more efficient in your

show processlist

Hi, show processlist displays processes with state statistics, what does this status means. Documentation doesn't say much A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sporadic myisam table corruption.

Hi all! I also agree with you, it might be a hardware problem, but i also must note, that in a environment with very often writes to the db, myisam tables are not always the best choice, that's why i suggested a change to InnoDB tables, a problem with sql or logic is more likely to happen that a

Run Time Error-'3027'-Cannot Update Database or Object is Read Only

Hello All, I am Swetha.I am facing the above mentioned problem while adding/updating a recordset in the my_dao table using DAO recordset.I tried a lot i am not getting the reason for this.So please let me know the reason the solution for this problem. With Regards, Swetha.

Query help

I have two tables, customer table and a company table The customer table has an ID field that is 8 characters long. The first 4 characters are the company code. We just added a company table that has an id field that contains that companies id code. We also added a field to the customer table

Query Help 2

Damn fat fingers and MS Outlook. I sent the Query Help message before I was finishes typing. Sorry... I have two tables, customer table and a company table The customer table has an ID field that is 8 characters long. The first 4 characters are the company code. We just added a company table

Re: How boolean full-text search finds matches?

Hi! On Dec 17, Matt W wrote: Hi, Just have a couple more full-text search inquiries here. :-) I'm not exactly clear on how matching rows are found when searching for 2 or more required words: '+word1 +word2'. I understand that it can't currently know which word occurs less, so that it

Re: MySQL on NetWare?

Hi Chris We're running MySQL on NetWare6.5 with good performance stability. About 20GB with InnoDB and a simple replication enabled (M - S). This database will grow up to 200GB in a year (with 400 active connections). We did tests and we liked. We'll set up another 2 servers to run a 100GB

Problem with EQ_REF and ALL

Someone please help me... I have 2 queries (in the end I end up joining them with a LEFT JOIN, but they don't work properly) SELECT * FROM tbl_v_batch b LEFT JOIN tbl_v_levering l ON l.ver_lev_id = b.batch_lever_id LEFT JOIN tbl_klanten k ON k.klant_id = l.ver_lev_klant_id This one gives ALL

RE: Comparing date fields (Delphi programmers take note)

Thanks for all those who helped me with this a few days ago (I've only now had the chance to get back to programming). As someone correctly surmised, I am using Delphi and connecting to mySQL via a TQuery (actually a TZQuery, via Zeos components). What I have discovered is that 1. mySQL doesn't

Re: Sporadic myisam table corruption.

torsdag 18. desember 2003, 13:24, skrev Victor Medina: I also agree with you, it might be a hardware problem, but i also must note, that in a environment with very often writes to the db, myisam tables are not always the best choice, that's why i suggested a change to InnoDB tables, a problem

Re: Comparing date fields (Delphi programmers take note)

Hi, Interesting. Thanks for all those who helped me with this a few days ago (I've only now had the chance to get back to programming). As someone correctly surmised, I am using Delphi and connecting to mySQL via a TQuery (actually a TZQuery, via Zeos components). What I have discovered

Re: Problem with EQ_REF and ALL

Hi, Have you indexed the fields you're using in the JOIN clauses? Dobromir Velev [EMAIL PROTECTED] - Original Message - From: Koen Van Mulders [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 18, 2003 15:45 Subject: Problem with EQ_REF and ALL Someone please help

Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ?

- Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] Sent: Thursday, December 18, 2003 1:36 PM Subject: Re: Fw: Bug in 4.1.1 Internationalization on Windows2000 ? You can use: SELECT SUBSTRING_INDEX(CONVERT(USER() USING cp1251),'@',1); SELECT

Re: Query Help 2

How about: update RemoteStation set company=substring(ID,1,1); Jeff McKeon wrote: Damn fat fingers and MS Outlook. I sent the Query Help message before I was finishes typing. Sorry... I have two tables, customer table and a company table The customer table has an ID field that is 8 characters

Countries, cities, states database

Hi, I searching for a database, with the 'complete' world Countries, cities, states Just like http://www.datingplace.com/servlet/NewRegistration I need for an academic study. Thanks, Augusto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Problem with EQ_REF and ALL

I think they are all indexed, yes. I have an index on : bb.ver_id b.batch_bestel_id k.klant_id (k1 is the same) b.batch_lever_id l.ver_lev_id Tnx in advance

Fw: Problem with EQ_REF and ALL

- Original Message - From: Dobromir Velev To: Koen Van Mulders ; [EMAIL PROTECTED] Sent: Thursday, December 18, 2003 3:14 PM Subject: Re: Problem with EQ_REF and ALL Hi, Have you indexed the fields you're using in the JOIN clauses? Dobromir Velev [EMAIL PROTECTED] - Original

Fw: Problem with EQ_REF and ALL

I think they are all indexed, yes. I have an index on : bb.ver_id b.batch_bestel_id k.klant_id (k1 is the same) b.batch_lever_id l.ver_lev_id Tnx in advance I am new to this mailinglist thing, so i don't know how to reply :-$ Sorry... - Original Message - From: Dobromir Velev To:

transactions and create table (was Questions about MySQL implementation)

What is the official word on doing a CREATE TABLE inside a transaction? Can I do one without causing the transaction to commit? By experiment, it appears that 4.0.14 allows this, although, even if the CREATE TABLE is for an InnoDB table, a ROLLBACK doesn't remove the created table. It appears

Re: transactions and create table (was Questions about MySQL implementation)

Bill, http://www.innodb.com/ibman.php#Implicit_commit: 8.7 When does MySQL implicitly commit or rollback a transaction? MySQL has the autocommit mode switched on in a session if you do not do SET AUTOCOMMIT=0. In the autocommit mode MySQL does a commit after each SQL statement, if that

Re: Countries, cities, states database

Hello Augusto, You might be able to use the list of weather stations available from WMO at URL: http://www.wmo.ch/index-en.html Among other thing it contains the country and station name (or city name). I know that NWS/NOAA also have that list but it seems that the list is not available right

Long Query Times

Hi all, I am curious to know if the query times I'm seeing are reasonable or not. Here's my situation: I am using a database to keep up with web statistics. The table is currently growing at about 2 million records a day. The sample table I am working with has right at 4 million rows. When I

Re: Problem with EQ_REF and ALL

Can you please send the tables structure. This happens when the fields you are using in the JOIN clause are with different types fro example when trying to join a VARCHAR with INT Dobromir Velev [EMAIL PROTECTED] - Original Message - From: Koen Van Mulders [EMAIL PROTECTED] To: [EMAIL

Problem with MySQL 4.1.1 and german charset

Hi! I compiled mysql 4.1.1 today and used the following config: #v+ --with-character-set=latin1 \ --with-collation=latin1_german1_ci \ --with-extra-charsets=all #v- ./configure and make worked fine, but make test failed: #v+ cd mysql-test ; ./mysql-test-run Installing Test Databases

Re: Query Help 2

yes, it should work, but should not be 1,1 ? or simply: UPDATE RemoteStation SET company=LEFT(ID, 4); ? gerald_clark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] How about: update RemoteStation set company=substring(ID,1,1); Jeff McKeon wrote: Damn fat fingers and MS

Re: Performance problems using 1GB Linux server and trying to avoid swapping

In the last episode (Dec 18), Markus Fischer said: On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote : Raising sort_buffer_size and join_buffer_size may also help if your queries pull a lot of records. From what I read from the manual, sort_buffer_size is only used for

4.1

W2000 Server I installed the 4.0.17-nt version. I downloaded the 4.1, there is no Setup or install .exe !!! So I copied the files which was in the zip file on the 4.0 files, ans I can’ t start the service next: too long to start … Do you know the problem, and why there is no setup file in the

Problem Installation

I have a installation problem in the my server. After of command ./scripts/mysql_install_db appear the o error: Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031217

Re: Problem Installation

Here's another hintfrom the mysql site: http://www.mysql.com/information/presentations/presentation-oscon2000-27 19/index.html Increase number of open files for system and for the SQL server. (add ulimit -n # in the safe_mysqld script). Also --

convert dynamic page to html page

Hi I build a online catalog linked to mysql db. Now my client wants the site on a cdrom. What is the fastest way to convert the product pages into static html format? -- Kind regards, Paul. Gondwana [EMAIL PROTECTED] http://www.gondwanastudio.com -- MySQL General Mailing List For list

Re: convert dynamic page to html page

On Thursday 18 December 2003 17:46, Paul Godard wrote: Hi I build a online catalog linked to mysql db. Now my client wants the site on a cdrom. What is the fastest way to convert the product pages into static html format? -- wget --mirror ? -- MySQL General Mailing List For list

Re: Query Help 2

DId I type that? I meant 1,4 I left it as substring because that was what he tried. ¿n©_ ¡E¢X ¡¸ wrote: yes, it should work, but should not be 1,1 ? or simply: UPDATE RemoteStation SET company=LEFT(ID, 4); ? gerald_clark [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] How about:

Help me - please

Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 031217 14:32:34 Warning: setrlimit couldn't increase number of open files to more than 256 (request: 510) 031217 14:32:34

Re: Performance problems using 1GB Linux server and trying to avoid swapping

On Thu, Dec 18, 2003 at 10:37:46AM -0600, Dan Nelson wrote : In the last episode (Dec 18), Markus Fischer said: On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote : Raising sort_buffer_size and join_buffer_size may also help if your queries pull a lot of records. From

Re: localhost

* Dan V [EMAIL PROTECTED] [2003-12-17 02:03 +0100]: When I check the status it says [EMAIL PROTECTED] How do I change that to [EMAIL PROTECTED] What's wrong with localhost? Connecting to localhost makes your client use a socket or pipe, which is faster and more secure than the tcp connection it

database output

When I make request from mysql database, I want each resulting value to appear on a particular table cell - that is, a user would see the results placed appropiately in relevant table cells like color under color heading, size under size heading etc. Can someone give me some clue on how I can

AW: MySQL GUI tool

I'm using DBTools DBManager Professional - it's free : http://www.dbtools.com.br/EN/dbmanagerpro.php Freddie -Ursprüngliche Nachricht- Von: Amanullah [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 18. Dezember 2003 03:57 An: [EMAIL PROTECTED] Cc: MySQL List Betreff: Re: MySQL

Re: Connector/J 3.0.9 Unexpected end of input

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bill Ataras wrote: I upgraded to Connector/J 3.09 from 2.0.14. After some hours, the driver looses it's connection and will not reconnect (despite setting reconnect=true). The error starts as follows below. I rollback to 2.0.14 and everything is

Re: Long Query Times

At 09:43 AM 12/18/2003, you wrote: Hi all, I am curious to know if the query times I'm seeing are reasonable or not. Here's my situation: I am using a database to keep up with web statistics. The table is currently growing at about 2 million records a day. The sample table I am working with has

Combining tables

I have a live feed datasource that inserts into 8 different tables( but they are all the same layout only differennt regions) and i am not allowed to change this since it is from a customer. As with Oracle you can create a materialized view that will combine those eight tables into one physical

Cantonese Chinese character set

I am building a site that will call up text data stored in a db by language and need to add Cantonese to the list of languages it will use. What sources would be suggested to find out what I need to do to get this to work. And I think this will be stored as a multi-byte character set. So,

Re: Combining tables

In the last episode (Dec 18), Arnoldus Th.J. Koeleman said: I have a live feed datasource that inserts into 8 different tables( but they are all the same layout only differennt regions) and i am not allowed to change this since it is from a customer. As with Oracle you can create a

Re: Long Query Times

an index on any appropriate data (date, sum) should also help tremendously. Thomas Danny Melton [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all, I am curious to know if the query times I'm seeing are reasonable or not. Here's my situation: I am using a database to keep up

Re: Help me - please

On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote: 031217 14:32:34 Warning: setrlimit couldn't increase number of open files to more than 256 (request: 510) It might be worth putting a ulimit -n 1024 (or some other decent number) in the rc.d script that starts

Regd Sub Queries

hello every one, i am in the process of converting my database from access to mysql ... now tat i have started working with mysql i have realized that my subqueries wont work here ... i read the article on how to handle some of the simple subqueries with joins ... my subquery is as follow and i

Binaries for PocketPC

Hi, Does anyone know of a MySQL distribution for the PocketPC? Thanks, Matt --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003 -- MySQL General Mailing List For list

Re: Regd Sub Queries

Sandeep N Seshadri wrote: hello every one, i am in the process of converting my database from access to mysql ... now tat i have started working with mysql i have realized that my subqueries wont work here ... i read the article on how to handle some of the simple subqueries with joins ... my

Regd Sub Queries

Could you please tell me more about the pass through queries. i dont have an idea abt it sandeep -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

? about user and db table

Hi, I'm trying to uderstand the difference between these tables (mysql.user, mysql.db) v.4.0. I want user usera from hostname1 to connect to hostname2 which is where the Mysql db is running and have only select priv on db db_1. Hostname1 has mysql clients on it. Host: mysql select * from

Re: Regd Sub Queries

Sandeep N Seshadri wrote: Could you please tell me more about the pass through queries. i dont have an idea abt it sandeep Sure. Create a new query in Access. Instead of adding tables to the query design view like normal, simply click the 'query' menu, and select 'SQL Specific', and then

Updating table1 from table2

Hi: I am new to MySQL and can not find how to do this. I am running 4.0.16. Table1 has the correct values for a common field. Table 2 (the real one) needs to be updated from t1 via a common field. Can this be done with joins. And if not what is the best way. Thanks for any suggestions. _

FIXED: Access crash when connected to MySQL and left inactive

Hi all. Microsoft have *finally* fixed the long-standing bug in Access where if you left it connected to MySQL ( and apparently Oracle too ) and inactive for a few minutes, it would crash, apologising: Microsoft is incredibly sorry for the inconvenience ... please contact us regarding this

Re: Binary install instructions wrong?

Has anyone done this before? I can't be the only one that likes custom paths/directories! :) [EMAIL PROTECTED] Thanks to the remote control I have the attention span of a gerbil! There are 10 types of people in the world. Those who understand binary, and those who don't. - Original

help me!!!how to write such sql in mysql?

in sql: insert into table select from ... can select from a remote data base server such as sqlserver using odbc as 'SELECT * into test01 FROM Fund IN [ODBC] [ODBC;Driver=SQL Server;UID=admin;PWD=;Server=(lacal);DataBase=CMBXMDM;]'in access. thanks!

Re: Updating table1 from table2

Try something like this: INSERT INTO table1 (common_field) SELECT common_field FROM table 2; - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 19, 2003 10:42 AM Subject: Updating table1 from table2 Hi: I am new to MySQL and can not find how to

Question

Dear friends, I downloaded mysql on windows 98. I entered cd c;\mysql_install_db It is responding as too many parameters Can anyone advice how to fix it, please. Delmar

Re: Question

At 09:34 PM 12/18/2003, [EMAIL PROTECTED] wrote: Dear friends, I downloaded mysql on windows 98. I entered cd c;\mysql_install_db It is responding as too many parameters Can anyone advice how to fix it, please. Delmar Take out the semi colon and put in a colon if you are trying to change to a

Re: show processlist

Hi Andrius, Yes, I've wondered about this before too, but wasn't exactly sure what it meant either. :-) So I just decided to see where this state is set in the code, and it's when the make_join_statistics() function is called. I think that function checks key distribution and things to see

memory trap

031218 20:53:48 InnoDB: WARNING: over 4 / 5 of the buffer pool is occupied by InnoDB: lock heaps or the adaptive hash index! Check that your InnoDB: transactions do not set too many row locks. Starting InnoDB InnoDB: Monitor to print diagnostics, including lock heap and hash index InnoDB: sizes.

Locking the tables

Hi all, I have mysql verison 3.23.58 and all tables in a database say test_database are of MyIsam types. I want to put write lock on a(set of) table(s), so that only i can insert into it and no body else unless i remove the write lock. How can i achieve it?? Please help me out .. Thanks in

Re: Locking the tables

Hello Binay. Friday, December 19, 2003, 1:53:01 PM, you wrote: B I want to put write lock on a(set of) table(s), so that only i B can insert into it and no body else unless i remove the write lock. B How can i achieve it?? AFAIR, you usu. do that with: LOCK TABLE mytbl WRITE; // do smth. here