Mysql 4.0.x enough stable to be in production ?

Hi all, just one question, i need to use an index on a specific query. This feature in fact : http://www.mysql.com/doc/N/e/News-4.0.0.html << ORDER BY ... DESC can now use keys. >> And this one is only available in mysql 4.0.x. I'll give a try to mysql 4.0 in a test server. But i need some fe

calculated fields

Hello folks! Does MySQL support calculated fields? Maybe this isn't the right name (I don't really know the database theory), so let me explain by example: CREATE TABLE pricelist (product VARCHAR(255), price DECIMAL(10,2), price_with_vat = ROUND(price * 1.22, 1)); Now, the column price_with_vat

alternative to intersect in mySQL

I know that intersect does not work yet with mySQL. I am selecting data from two tables. Results of one select would be 1, 2, 3, 4 . Results of other select 1, 2. Want to print 1, 2. Are there any nice workarounds using PHP or SQL? thanks, -tom ---

Re: MySQL 3.23.44 not using indexes

On Mon, Apr 22, 2002 at 10:26:22PM -0700, Steven Roussey wrote: > Inside the page: > "Any index that doesn't span all AND levels in the WHERE clause is not > used to optimise the query. In other words: To be able to use an index, > a prefix of the index must be used in every AND group." > > [Note

Re: MySQL 3.23.44 not using indexes

A search for 'indexes' brings this as the first result: 5.4.3 How MySQL Uses Indexes http://www.mysql.com/doc/M/y/MySQL_indexes.html Inside the page: "Any index that doesn't span all AND levels in the WHERE clause is not used to optimise the query. In other words: To be able to use an index, a p

Re: multiple mysql daemons in process

This is an artifact of Linux's thread implementation. man 2 clone Also it's not using -that- much memory. Note the SHARE (for memory shared between processes) column. It's not pretty, but it's totally harmless. NOTE: There's always -some- weirdness that goes on with threads implementations b

Cant connect using socket ''(111) for Mysqlgui on linux

Hello All Is there any installation instructions for Mysqlgui1.7.5 on linux. Also i have installed it and while trying to connect it says couldnt connect using Socket''(111) and also can some one throw light on "sql command on connet or Socket" dialog in options window and what showuld really go

multiple mysql daemons in process

Hello list, I have 38 mysqld processes running in one single machine, is it normal? 11:48:43 up 49 days, 15:11, 34 users, load average: 0.02, 0.06, 0.00 275 processes: 265 sleeping, 1 running, 9 zombie, 0 stopped CPU states: 3.2% user, 4.3% system, 0.0% nice, 92.5% idle Mem:900464K

Re: Complex selection

JOIN is what you need. http://www.mysql.com/doc/J/O/JOIN.html Some examples: mysql> SELECT * FROM table1,table2 WHERE table1.id=table2.id; mysql> SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id; mysql> SELECT * FROM table1 LEFT JOIN table2 USING (id); mysql> SELECT * FROM table1

Complex selection

> Well..complex..for me at least! > > I have a table containing story's > All storys have one unique `storyID` > I have another table where I keep track of user's favorite story's. > This table has two columns `clientID`and `storyID` > after a while, you could end up having the following rows in

Question about mysql++ and g++

Ok, i downloaded the mysql++-1.7.8-1.i386.rpm rpm file from RpmFind.net. I have mysql installed already on my machine, o ya and im running linux. I have gcc installed, version 2.96, i think everything installed correctly whe

Re: Execute Queries through Files

do you mean to execute a query that's written in a file? if so, there are two ways: for bournse shell type shells ( including WinNT/2K ) mysql --user=myname --password=mypassword -D dbname -v < file.sql > outfile.log2&>1 for c-shell based shells

Complex selection

Well..complex..for me at least! I have a table containing story's All storys have one unique `storyID` I have another table where I keep track of user's favorite story's. This table has two columns `clientID`and `storyID` after a while, you could end up having the following rows in favorite docum

Slave crashes by large UPDATE in binlog!

Hello! I have a multi-server setup running replication. For some while now the slave server has started flipping out, and we have narrowed it down to that it gets a quite heavy update of several (5000) UPDATE blabla WHERE ID=1 OR ID=2 OR..ID=4999 the slave says "segmentation fault

Re: Execute Queries through Files

Q1: I am not sure what you mean by executing queries through files. Do you mean being able to run a query from a script like this? #!/bin/sh mysql -t -p password -u usename databasename << EOF Select * From mytable; EOF Q2: There are mailing list archives available at http://lists.mysql.com .

aggregate functions, source code

Hi, I'm trying to convert a database I have from M$ Access to Mysql. I've done this pretty successfully but have come across a couple of sticky problems. I have been using first & last aggregate functions within Access for some certain complex queries. It would make my life a lot simpler and mo

Execute Queries through Files

Hi everyone, I know that one can execute queries through files. can anyone please tell me how to do that. I am working on sgi-irix and mysql 3.22.*. also how can i view previous messages on mailing list since i just joined the list yesterday. SMIB, Univ of nebraska. -

table lock - which connection id own's it

AntiSpam - mysql, sql, query Version: 3.23.49a, MyISAM, NT, Solaris My app is 150 daemons writing logs to mysql. The main table is of fixed size but depends on four other tables for foreign keys (hash tables). These tables are uploaded once to the daemon at start-up. Occasionally, a new entry

Re: Having lots of tables

From: Agustín Fernández <[EMAIL PROTECTED]> > Is there any reason to avoid having a large number of tables (which have > the same structure)? You might run into a limit on the number of open file handles, but you'd have to check the MySQL docs for how he handles it, and possibly your OS docs to

C MYSQL Struct

I am having trouble accessing the data in the MySQL struct for C (included in the mysqlclient libraries). I am specifically unable to access the *fields (array?) within the struct. My program fails with segmentation faults whenever I try to access any variables within *fields. Does the mysql_

Having lots of tables

Hi, I have a question on a project i am currently on. I am adapting Phorum (www.phorum.org) to my own portal and have a doubt about MySQL. Phorum creates a table for each discussion forum. However, in the portal i work for, i currently have thousands of items that would potentially need a table (

New Setup

Egor> By default user 'root' has all privileges... Egor> Show me the output of following: Egor> SHOW GRANTS FOR 'root'@'localhost'; mysql> show grants for 'root'@'localhost' -> ; +--- --+ | Grants fo

Re: functions

Actually, W2K has a scheduler built in that works pretty well for basic scheduling needs. If you are using NT 4.0, try and upgrade to SP6a. That SP has the scheduler of W2K built in as well. Bruce - Original Message - From: "Opus" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Mon

Re: functions

For NT and 2000 machines, use the AT command if you want a command line scheduler. The syntax is actually different between them though. I found that it is actually easier to schedule a process to schedule other processes instead of having the process schedule itself again. The FOR command in

Re: Inserting a BLOB using MySQL++

Probably the best bet would be to write the individual attributes to respective database columns. It keeps a few things simpler. It would also allow you to update the database from multible sources (many threads, or many users on the database). Other wise, you would have to serialize the obj

MySQLdb Exception Documentation

Hello All: I'm just learning to use Andy Dustman's MySQLdb for Python. Very easy for this mysql-dummy to learn! It would be very helpful for me to find documentation on the Exceptions thrown by Python for this API. Any advice would be greatly appreciated. TIA -- Tim

ERROR 1045: Access denied for user: 'root@localhost'

> Hello, i'm having a problem accessing mysql database. I don't recall > setting a password for root, but when i try to set that password. This is > happening right after i run mysql_install_db > > [root@omsrh etc]# mysql -u root -p > Enter password:** > ERROR 1045: Access denied for u

Mysql / Job

I am in need of a data base for a website(Php/Mysql), this would be for job posting and advertising by recrutiers. anyone intrested e-mail me direct at [EMAIL PROTECTED] Thank you for your time __ Do You Yahoo!? Yahoo! Games - play chess, bac

versions

Hi, Has anybody heard how the next version of either MyODBC (3.51) or MySQL (4.0.1) are coming along and when they will be declared stable? I started developing with 4.0.1, and although I have had no failures to date, I was said that they would be declared stable in dec/jan. it is now several mo

Re: MySQL 3.23.44 not using indexes

I have some more information about the problem. It seems to be caused by the presence of an OR or IN clause in the WHERE portion of the query. Without the clause, 2.23.44 uses the appropriate indexes, but with the clause it does not. 2.23.41 uses the appropriate indexes in both cases. Here

Re: joins vs excess fields

Hmm, That's what I thought I was doing by putting the common fields of each article type in a single table. I do need to rethink the search functions. Was thinking of a fulltext index on title and article_content fields. basic table is id | type | author | date | last_update | title | keywords

MySQL 3.23.44 not using indexes

MySQL 3.23.44 isn't using indexes when it should and could, even when I try to force it via a "USE INDEX" clause in the SELECT statement. For example, here is what EXPLAIN gives me on a query containing the clause "USE INDEX (bug_status)" on the bugs table: mysql> EXPLAIN SELECT DISTINCT bugs

Re: InnoDB data files created but not used...how to fix ?

Jesper, what may have happened is that InnoDB created the data files, but because memory ran out, it did not have time to update the tablespace header to reflect the size increase by those two data files. Later when you added yet another data file, it increased the size stored in the tablespace

Re: InnoDB and Fulltext Search

Ang, Monday, April 22, 2002, 12:24:58 PM, you wrote: AHK> Quote from mysql online documentations: AHK> "As of Version 4.0.1, MySQL can also perform boolean AHK> full-text AHK> searches using the IN BOOLEAN MODE modifierA AHK> boolean full-text AHK> search can also work even without a FULLTEXT

Re: Mysql Bug Report, Random crashes, reason unknown

Gavin, Monday, April 22, 2002, 6:29:08 PM, you wrote: GW> Description: GW> MySQL Crashes often. GW> How-To-Repeat: GW> Don't know GW> Fix: GW> Don't know GW>Submitter-Id: Gavin Woodhatch GW>Originator: GW>Organization: NetZone Ltd. GW>MySQL support: [none] GW>Synopsis:

Re: MySQL fails to correctly index decimal datatype columns

A test SQL script which duplicates this problem is available via anonymous FTP at the following location: Hostname: ftp.visi.com Directory: /users/chris Filename: test.sql Run the script like this to see the error: mysql -t temp < test.sql The second select statement returns only 2 of the

how to add a special function into MySQL as a command

Hello all , I am now trying to add a special function into MySQL as a command. Anyone who good at it , please give me some precious suggestions , including the related document or some webs which explains it . thank u very much . -- Best regards,

Problem with select statements in Visual Basic

I have a problem in VB trying to use select statements with MySQL. My problem does not occur only with the example below but with ANY select statement I try to make against my MySQL database. Much thanks in advance to anyone that can help me out with this :) This is my code: Private Sub optNoTec

Re: min() bug

Artem, Friday, April 12, 2002, 8:05:37 PM, you wrote: AVR> min return not value from table. AVR> mysql> select min(ord) from cSectText where SectID=932; AVR> +-+ AVR> | min(ord)| AVR> +-+ AVR> | -20020412051744 | AVR> +-

Re: server disconnect

saraswathy, Monday, April 22, 2002, 11:57:14 AM, you wrote: ss> Can anyone tell whats wrong with the server..the connection to server ss> disconnect automaticaly.we have to press refresh button again and again ss> until the its show all the folders...is there anything wrong with ss

Re: load data infile problems

Daniel, Monday, April 22, 2002, 2:31:15 PM, you wrote: DJ> I'm having difficulties with loading values from a text file into my DJ> databse. DJ> I've tried the following and got these errors. last one is with full path DJ> === DJ> mysql> LOAD DATA INFILE "months.txt" INTO TABL

Re: Running Mysql On Host other than localHost

Kevin, Sunday, April 21, 2002, 11:27:06 PM, you wrote: KF> I have the standard tarbal install of mysql. I want to know how do I start KF> the server so that I can access it from another machine. I am running on a KF> linux 6.2 server where the local ip address of the box is 192.168.1.150 and KF>

Re: InnoDB, BDB

Samim, Monday, April 22, 2002, 11:20:48 AM, you wrote: S> This question is probably repeated each week, but I am an absolute beginner S> with MySQL. Sorry for that. I've installed the precompiled binaries for Win, S> and I am very satisfied with MySQL. The only thing I couldn't find is S> support

Mysql Bug Report, Random crashes, reason unknown

Description: MySQL Crashes often. How-To-Repeat: Don't know Fix: Don't know >Submitter-Id: Gavin Woodhatch >Originator: >Organization: NetZone Ltd. >MySQL support: [none] >Synopsis: Random MySQL crashes (1-2 every 24h) >Severity: [ serious ] >Priority: [ m

Re: problem with libmysqlclient_r.so

Andrey Kotrekhov writes: > äÏÂÒÙÊ ÄÅÎØ. > > #1 0x180f0b20 in search_default_file () > from /usr/local/mysql/lib/libmysqlclient_r.so.10 > > Will I need to compile mysql with --with-debug option to see parameters? > > Best regards. > ___ > Andrey Kot

Re: problem with libmysqlclient_r.so

äÏÂÒÙÊ ÄÅÎØ. > Andrey Kotrekhov writes: > > Hello, All! > > > > I have program which try to connect to different mysql servers twice at > > the same time. > > When I use libmysqlclient.so sometimes one or two mysql connection freeze > > in mysql_real_connect > > > > But when I try to use libmysql

Re: Inserting a BLOB using MySQL++

Thi Cao writes: > All, > > I created a C++ class containing a variety of member variables of varying > types such as float, int, char *, etc. If I instantiate an object of this > class, how should I insert this object into my database table? I can > retrieve the individual members and insert th

sub selects

I know that mysql does not support sub selects but I want to be able to do the following: I have a table with all my leads in called leads. The table has a unique ref for each lead called refnumberid I have a table with leads in and products that leads have asked not to be mailed on the table has

Re: load data infile problems

Disregard my last post.. - Original Message - From: "Daniel Jarrett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 22, 2002 11:44 PM Subject: Re: load data infile problems > i figured it out.. it worked when i used local. > > although I keep getting a whole heap of war

Re: load data infile problems

i figured it out.. it worked when i used local. although I keep getting a whole heap of warnings and skipping of records. i think i've got the layout of my txt file wrong.. can anyone direct me to something that'll show me how to format my text file for loading. i find mysql manual a bit cryptic

Re: New Setup

Hi, OK.If you connect from localhost and use the option "-h" you must "put" the alias name from /etc/hosts(if OS is Unix).Try next; use mysql; select Host from user where User='root'; and response is (on my server): %- this is if i wish to connect from any host myx - this is if i wis

Re: functions

Good morning Daniel, From: Daniel Jarrett <[EMAIL PROTECTED]> > ...for mysql to perform daily operations.. You bet, it's called 'cron'. MySQL doesn't have anything like scheduling built in. And, arguably, it shouldn't. Since that type of functionality is the responsibility of the operating

Re: joins vs excess fields

A quick note, I've read Tom's email about using a hanger table and simply don't agree. From: olinux <[EMAIL PROTECTED]> > I have a table with a large number of news articles. For my curiosity, how many article records is "a large number"? A few thousand, or tens of millions? > The question

Inserting a BLOB using MySQL++

All, I created a C++ class containing a variety of member variables of varying types such as float, int, char *, etc. If I instantiate an object of this class, how should I insert this object into my database table? I can retrieve the individual members and insert them that way, but I feel it w

Re: GUI for mySQL

I have to concur, MS Access with ODBC linked tables is not a good solution when those tables contain large amounts of data. I had queries run for hours and then come up with a simple "ODBC Failed" message at the end of it. Maybe Access has improved though. Tod Harter wrote: > Watch out wit

RE: GUI for mySQL

  Hi Pierre,   If you goto the Contribute or Portal section of the MySQL web you'll find many good win32 GUI's.   Our own is one of the oldest (since March 2000) and best available with lots of support, features and many awards below the belt, it is currently being ported to Linux as well, see:

Re: New Setup

### db set up [Linux]> mysql -h localhost -u root mysql> create database db_abc; ### grant to user mysql>grant all on db_abc.* to pp@localhost -> identified by 'pp_pwd'; ### ppp login [Linux]> mysql -h localhost -u pp -p db_abc this is what I had done, have a look the message is becoming mess

Re: problem with libmysqlclient_r.so

Andrey Kotrekhov writes: > Hello, All! > > I have program which try to connect to different mysql servers twice at > the same time. > When I use libmysqlclient.so sometimes one or two mysql connection freeze > in mysql_real_connect > > But when I try to use libmysqlclient_r.so > program crash in

Re: joins vs excess fields

I disagree. Joins can be expensive. Now PERHAPS Tom's suggestion is a good one, but its hard to say. Remember, excess fields can always be left out of a SELECT, so they don't neccessarily cause a performance problem. Some things are true though, fixed length records are more efficient, so if yo

Re: New Setup

Yes - but I haven't got the picture of what you're trying to communicate. I thought I would have to log in as root, to be able to create the user cbaa and allow that user to access the cbaa database. Ian - Original Message - From: "ÅÇ´f¼Ù (Borus.Kung)" <[EMAIL PROTECTED]> To: "Ian Philli

Re: GUI for mySQL

Watch out with using the Jet database engine this way. MS Access tries to keep linked external table views in sync, which means that with large tables and several PCs running Access linked to MySQL over ODBC driver it will bring your network to its knees. The Jet engine will constantly be scann

Re:

I just had the same exact error two days ago. td> checking for termcap functions library... checking for tgetent in -lncurses... no td> checking for tgetent in -lcurses... no td> checking for tgetent in -ltermcap... no td> configure: error: No curses/termcap library found When you installed you

Re: MyODBC multiple connection

I am writing web page using VB script ASP, and cannot work with MyODBC 2.5 of MySQL but can work with 3.5.1 the previous problem is : I made a page using ASP MyODBC, it is working then I try multiple connection, the second trial to open the page failed with a "disastrous error" do anyone know

VIRUS IN YOUR MAIL

V I R U S A L E R T Our viruschecker found the W32/Nimda.gen@MM virus(es) in your email to the following recipient(s): -> [EMAIL PROTECTED] Please check your system for viruses, or ask your system administrator to do so. For your reference, here are the he

InnoDB data files created but not used...how to fix ?

Hi! A couple of days ago I stopped a MySQL server to change a couple of parameters in the my.cnf file and to add 2 data files (InnoDB). When restarting it, MySQL exited because I'd resized the log file size but forgot to delete/move the old ones. Secondly, I had another error because I allocated

A couple of InnoDB questions

Hi! I run MySQL 3.23.49 with InnoDB tables on a AlphaServer 4100 with 4 x 600 MHz EV5.6 CPUs with 8 MB cache. The machine has 4 GB memory. There are about 8 tables. The tables are small in size (only 1-5 GB each) but has alot of rows (usually > 4 million each). There are only a few concurrent se

Strange behaviour with SQL vars and order by

Hi, I'm having a strange problem using SQL vars (@variable) and an order by expression. I have a query that returns a record for each day. Each record has a date (data), a column with the daily total value (uv_views) and other with the accumulated value until the current day (acc_views). The ot

Re: New Setup

Thanks for the idea -- still stuck though Tried connecting to mysql using the -h option, but I still had the same response. (with the -p option as well thanks Borus). Let me check - "Your_Server_Name" I think in my case is localhost I had a look (using the phpMyAdmin tool) at the records in the

load data infile problems

I'm having difficulties with loading values from a text file into my databse. I've tried the following and got these errors. last one is with full path === mysql> LOAD DATA INFILE "months.txt" INTO TABLE months; ERROR 1105: File './date1/months.txt' not found (Errcode: 2) mysq

RE: GUI for mySQL

I would not look at front ends to mySQL. Instead, I would let them keep using access to do this and link them to the mySQL database or get an SQL query tool that allows for graphical queries. Scott -Original Message- From: Pierre du Parte [mailto:[EMAIL PROTECTED]] Sent: Saturday, April

RE: Selecting Information Just Inserted

Isn't it true that for last_insert_id to work that it gets this value from a connection, so if you are using a database library that uses separate connections to the database between server trips that this function does not work (like when doing web programming)? Scott -Original Message-

Re: checksum errors

<> At 09:52 17-4-2002, Michael Widenius shared with all of us: Melvyn> Hi Monty / list, Melvyn> I still didn't change anything with the software, and now other tables, Melvyn> also with FT indexes are crashing - these tables have never had any Melvyn> problems at AIX. Also - the replica (2 se

Re: New Setup

I think you have to use the -p option too and type your password because the GRANT statement specified a password mysql -u root -h Your_Server_Name -p Borus > Hi, > Only the root with the '%' character on the host field from table mysql.user > have full priveleges.Try to connect with "-h" opti

Re: New Setup

Hi, Only the root with the '%' character on the host field from table mysql.user have full priveleges.Try to connect with "-h" option and specify the Host_Name of your server.Should be work. Eg: mysql -u root -h Your_Server_Name Regards, Gelu _ G

Re: problem with libmysqlclient_r.so

Hi, OK.I don't have(NULL) mysql++ experience.Anyway, i believe is something wrong with MYSQL structure initialisation(referencing pointer or some like that).I don't "see" other reason, considering mysql++ use functions from libmysqlclient too. Good luck, Gelu - Original Message - From: An

Re: problem with libmysqlclient_r.so

Hi, I use mysql++ And each object Connection use own MYSQL mysql; mysql_init called in Connection constructor. > Hi, > You use and two different mysql_init ? > Regards, > Gelu > > _ > G.NET SOFTWARE COMPANY > > Permanent e-mail address : [EMAIL

InnoDB and Fulltext Search

Hi, Quote from mysql online documentations: "As of Version 4.0.1, MySQL can also perform boolean full-text searches using the IN BOOLEAN MODE modifierA boolean full-text search can also work even without a FULLTEXT index, although it would be slow. " I know that InnoDB does not support FULLT

Re: InnoDB, BDB

Samim, - Original Message - From: ""Samim"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, April 22, 2002 11:31 AM Subject: InnoDB, BDB > Hello, > > This question is probably repeated each week, but I am an absolute beginner > with MySQL. Sorry for that. I've insta

New Setup

I thank anyone in advance who may be able to help me iron this out. 1. I am setting up mysql on my apache server. I have had it there for a while, but haven't really done much with getting my head round it. 2. I have figured out some shell commands, and have been able to set a root password. 3.

server disconnect

hi everybody, Can anyone tell whats wrong with the server..the connection to server disconnect automaticaly.we have to press refresh button again and again until the its show all the folders...is there anything wrong with installationcan anyone help me sql,query thank

Re: group by help?

You're right, it wasn't the answer I wanted to hear ;-) But it has a ring of truth to it. Thanks for all your help Mick Paul DuBois wrote: > At 13:34 +0100 4/19/02, Mick Watson wrote: > >Thank you :-) > > > >I do realise the SQL is not being used as it should be, but as it is not my > >dat

Re: Got an error reading communication packets ...

Hi, In my case i replace the network switch(fault in power charge module). > 'really strange ... ...and if we think about network mechanism(IP address mapping,network/broadcast ,) it seems it doesn't "sound" so weird. Good luck, Gelu - Original Message - From: Do-Risika RAFIEFERANTSI

functions

maybe i'm wishing on a star here. but is there any way that you can write functions for mysql to perform daily operations.. for example. at a certain time each day mysql automatically ran a query to delete records past a certain date.. ? dan

InnoDB, BDB

Hello, This question is probably repeated each week, but I am an absolute beginner with MySQL. Sorry for that. I've installed the precompiled binaries for Win, and I am very satisfied with MySQL. The only thing I couldn't find is support for transactions, although it was written in the documentat

RE: MySQL, MyODBC and MS Access

Hi !! > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Sunday, April 21, 2002 11:52 PM > To: [EMAIL PROTECTED] > Subject: MySQL, MyODBC and MS Access > > > Hello! > > You are my last chance, reading FAQs and asking in newsgroups > gives no effect. >

How to speed up mods to large table?

Hi! > "Nick" == Nick Arnett <[EMAIL PROTECTED]> writes: Nick> I haven't been able to dig up any specific information about how to get Nick> maximum performance when making changes to large tables. I have a table Nick> that's close to 4 GB, which I'm altering to come up with the best trade-