Re: Help me optimize this query

Thanks for your inputs Eric. I tried this but it couldn't give me any insight abt how can optimize this for space saving of temp tables. Maybe I am not expert enough to interpret this output, so here it is - - Manish Seeing the explain log, it looks to me like you donot have any index defined

Re: Full Text Search - Limits?

Hello. Some information you can find in comments at: http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html EP [EMAIL PROTECTED] wrote: I've looked in the documentation but didn't see any indication of the limit= s of Full-Text Search in terms of how many characters/words it can

Re: Auth Problem

Hello. Try to connect using mysql program. Have you done: FLUSH PRIVILEGES; Jimmy [EMAIL PROTECTED] wrote: Hi there im running a Server with several domains on it. i installed a shop today and i got problems with the user i made for the database. its possible to login

Re: Cannot complete database transfer

Hello. Have you installed clients programs? One package can contain only server (mysqld), another only client programs (mysql). James Sherwood [EMAIL PROTECTED] wrote: I am trying to transfer a database from one linux box to another, both using redhat. On one I performed a

Re: table types

Hello. SHOW TABLE STATUS SHOW CREATE TABLE sol beach [EMAIL PROTECTED] wrote: How do I find out what table type is associated with each of the tables in MYSQL? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET

Re: ERROR 1044 (42000): Access denied for user 'root'

Hello. What says: show grants for current_user(); [EMAIL PROTECTED] wrote: Hi, As the root user I created a DB a populated with tables... but when I want to create a user to handle that DB i get this error message: mysql grant all on db.* to [EMAIL PROTECTED] identified

Re: text retrieval functions

Hello. See: http://dev.mysql.com/doc/mysql/en/BLOB.html http://dev.mysql.com/doc/mysql/en/String_functions.html http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html Alaios [EMAIL PROTECTED] wrote: Hi... I need some function and the appropriate type field s of a table that

Re: MySQL and x86-64

Hello. See: http://lists.mysql.com/mysql/176590 http://lists.mysql.com/mysql/169857 Andreas Ahlenstorf [EMAIL PROTECTED] wrote: Hi! It seems that I need to buy a 64bit server and have some questions regarding the two architectures from AMD (Opteron) and Intel (Xeon with

mysql_install_db problem!!

Hi all, I have cross compiled mysql-4.1.7 (from the source distribution)for an IXP425 based board with Montavista Linux-3.0.When I run mysql_install_db --user=mysql ...It runs into several errors with the following log [EMAIL PROTECTED]: /usr/local# ./bin/mysql_install_db --user=mysql

Estimating disk-space usage using LENGTH(BLOB)

I'm currently trying to write a short SQL expression that will give me a rough estimate of the disk-space usage of a particular bunch of rows in a table. For table 'example': CREATE TABLE `example` ( `id` int(11) NOT NULL auto_increment, `blah` varchar(255) NOT NULL default '', `blah2`

A Beginning User

Hi everybody. I've been testing mysql server for sometime. When I installed the latest version over windows 2000 professional, the mysql service worked for just four hours. I tried to install again and the same problem happened. I'd like to know if anyone had the same kind of problem. Does

RE: A Beginning User

Hi Robert... Of course it works on you platform. It is strange that you've got it to work for four hours though? Did your read any installation instructions? Maybe you've only started the daemon from a command-prompt and then later closed the command-prompt window? Try starting the

Re: Full Text Search - Limits?

On Wed, 15 Dec 2004, EP wrote: Thomas Spahni [EMAIL PROTECTED] wrote: the column type will limit the number of characters per row. A column of type TEXT will hold up to 65,535 characters but with LONGTEXT you can put up to 4,294,967,295 charcters into one row. I have an application with

Function

Hello, Is there a way to create my own function on MySQL (4.0.18)? We have a site where a product can have it´s price in differents currencies, so, I need to make a query that returns the correct product´s price. Thanks, Ronan -- MySQL General Mailing List For list archives:

Re: Restore help! been going 2 weeks

The restore is still running is this normal? How do you all deal with customers that do not have their data for almost 3 weeks, and no end in sight I've had oracle crashes before, the restores were very simple, this is not I am very disappointed with mysql's performance with files over 5 gig

Re: Limit drive usage per thread

Anybody know? Or am I dreaming about oracle features that are not in mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql database

Okay, extreme newbie. I probably just missed it but I went to the mysql site to download the database so that I could use it at work and I am having a problem finding it. The spot I expected it to be in there wasn't a link for it. Anybody got any ideas? ~Melanie~

Re: Using Multiple Selects

While 10 users per minute isn't all that much and your system will probably handle it without a problem, you should always worry about doing 12 queries for a single action. I'm not sure what your data structure is like, a single table with one column for each attribute or one record for each

Re: Function

- Original Message - From: Ronan Lucio [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 16, 2004 7:36 AM Subject: Function Hello, Is there a way to create my own function on MySQL (4.0.18)? We have a site where a product can have it´s price in differents

RE: mysql_install_db problem!!

check the privileges on directories. that error you generally get when user dont have sufficient privileges on directories. please go through the installation steps given in mysql documentation Anil -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday,

Weird problem upgrading from MySQL 4.0.21 to MySQL 4.1.7/InnoDB mysql db

I have a MySQL DBMS running with a mysql DB that apparently is an InnoDB DB, all other DBs in this DBMS are MyISAM. When I try to upgrade, I get the following output: 041215 16:41:53 mysqld started InnoDB: Resetting space id's in the doublewrite buffer 041215 16:41:57 InnoDB: Started; log

Re: MySQL load balancing...

We have fail-over using Linux Virtual Server, now upgrading to Red Hat Cluster Suite. We do not implement load-balancing. Here is why. In order to have full true load balancing, you need to have two or more MySQL database server replicating data to each other in real time. Currently your only

Re: MySQL load balancing...

We also use Linux Virtual Server for load balancing, but only on our read-only cluster. Our current levels of RW traffic do not demand more than one machine. Russell E Glaue wrote: We have fail-over using Linux Virtual Server, now upgrading to Red Hat Cluster Suite. We do not implement

sum() Function and NULL values

Is there any way to make sum() return 0 instead of NULL when one or more of the rows being sum()'d is null? Phrased another way, is there a way to make mySQL treat NULL as 0 when dealing with mathematical functions? Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001

Re: sum() Function and NULL values

Hi Tim, I guess you can add something like this to your statement: SELECT COALESCE( SUM(column) , 0 ) FROM ... /Johan Gustafson, Tim wrote: Is there any way to make sum() return 0 instead of NULL when one or more of the rows being sum()'d is null? Phrased another way, is there a way to make mySQL

Re: moving DB from one box to another.

Ian Sales said: Randy Paries wrote: The problem is I get this wonderfully verbose :-( error message :::ERROR at line 362701 - MySQL can't parse something on line 362701 of your dump file. One possibility is an index named with a keyword, which 3.23.x appears to allow but 4.0.x doedsn't.

Re: optimizing InnoDB tables

I have a question about: If you want to regain some of the space used by the INNODB file you will have to convert all INNODB tables to MYISAM (or dump them to a SQL file), recreate the INNODB file (s) and then recreate the original INNODB tables. So, just to be clear, is this the right

How to enable BDB support?

I have two systems running mysql which I have inherited. On a good day I can spell MYSQL, but I am required to support these DBs. mysql Ver 11.18 Distrib 3.23.51, for pc-solaris2.7 (i386) ; without BDB support +---+---+ | Variable_name | Value | +---+---+ |

RE: (FIXED...)moving DB from one box to another.

Thanks for all your help FYI, I had to add this to the my.cfg set-variable= max_allowed_packet=16M Randy -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 11:55 AM To: [EMAIL PROTECTED] Subject: Re: moving DB from one box to

Re: Help with a join query please

- Original Message - From: shaun thornburgh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 16, 2004 2:02 PM Subject: Help with a join query please Hi, I have (among others) three tables in my database that i am struggling with a join query on. The database holds

MySQL/InnoDB-4.1.8 is released

Hi! InnoDB is the MySQL table type that supports FOREIGN KEY constraints, row-level locking, Oracle-style consistent, non-locking SELECTs, multiple tablespaces, and a non-free online hot backup tool. Release 4.1.8 is mainly a bugfix release. There was a critical bug associated with the

Re: sum() Function and NULL values

Is there any way to make sum() return 0 instead of NULL when one or more of the rows being sum()'d is null? Phrased another way, is there a way to make mySQL treat NULL as 0 when dealing with mathematical functions? You can use ifnull select sum(ifnull(points,0)) from abc; Brad Eacker

Re: koi8r dbd::mysql

Salut! Check the console and locale settings as well as the content of the table (using mysql command-line client). Alexey Wasilyev [EMAIL PROTECTED] wrote: Hello! redhat 2.3 as DBD-mysql-2.9004 perl 5.8.0 MySQL-server-4.1.7-0.i386.rpm from mysql.org [EMAIL PROTECTED]

Re: Double conversion error

Hello. Update works fine on my 4.1.7-debug-log MySQL instance on Linux. May be you should switch to the latest release. Berry, Brett C [EMAIL PROTECTED] wrote: Hello, The create table statement is as follows: CREATE TABLE `call` ( `call_id` int(10) unsigned NOT NULL

Re: No connect to mysql

Hello. [EMAIL PROTECTED] charsets]$ perror 142 MySQL error: 142 = Unknown character set used You should follow the recommendations at: http://dev.mysql.com/doc/mysql/en/Problems_with_character_sets.html What output does the following command produce? myisamchk -dvv host.MYI

RE: sum() Function and NULL values

Jay Blanchard [EMAIL PROTECTED] wrote on 12/16/2004 01:00:00 PM: [snip] Is there any way to make sum() return 0 instead of NULL when one or more of the rows being sum()'d is null? Phrased another way, is there a way to make mySQL treat NULL as 0 when dealing with mathematical functions?

Re: Problems Moving from 3.23 to 4 (Win2k)

Victor Pendleton wrote: A. Clausen wrote: I made a copy of my entire Mysql 3.23 data directory and moved it on to a box with a fresh install of MySQL 4. While the NT service starts up fine (I'm using 4.0.22-nt-max), I can't login. I know that there are supposed to be mods made to the mysql

Weird load issues

Hey, A couple days ago my SQL server started hogging the entire CPU for no reason that I can find. I'm running MySQL 4.0.20 on Slackware 9.1 (i think), kernel version 2.4.22. The process using up all the CPU is the parent process, ie the top level mysql process that starts all the others.

Re: Relative efficiency (in terms of disk io) between REPLACE and UPDATE w/InnoDB

Ahhh, thats very good to know. Thank you. On Wed, 2004-12-15 at 19:09 -0500, Harrison Fisk wrote: No. In InnoDB an UPDATE is done as a DELETE/INSERT internally because it is multiversioning and it has to be able to rollback in case of a problem. So the UPDATE effectively does the

MySQL non-portable with Oracle, MS-SQL, Sybase SQL statements due to ISO non-conformant backslash

Hi all, Does anyone know fo a way to run the server in more of a string-quoting standards compliant mode, so that a generic SQL string quoting function only has to escape single quotes, instead of also '', '\', and '\0'? I've tried the ANSI_QUOTES startup option, but that apparently only

RE: mysql_install_db problem!!

Hi all, Initially, I had also suspected an NFS problem,I tried the same process on a local flash file system on the target board.It still yielded the same problems. the mysql user has complete privileges on the directory (MYSQL's data directory /usr/local/mysql/var/).I had also tested a sample

Re: revoked privileges, but still present

SHOW PRIVILEGES lists the privileges supported by the server. It does not tell you anything about which privileges a user has. This is documented in the manual http://dev.mysql.com/doc/mysql/en/SHOW_PRIVILEGES.html. To see the privileges for [EMAIL PROTECTED], you want SHOW GRANTS FOR

php and mysql

Hi All! I have installed mysql 4.0.20 (went fine, I can connect), apache_1.3.31 (went fine, I can launch the web server) now I have installed php-4.3.9 and when I configure it using ./configure --with-mysql=/usr/local/mysql it goes fine , but when I try to use make, I got an error: checking for

Re: table types

SHOW TABLE STATUS (it includes type/storage engine as one of the returned columns) --bemansell Brian E. Mansell MySQL Professional On Wed, 15 Dec 2004 19:21:24 -0800, sol beach [EMAIL PROTECTED] wrote: How do I find out what table type is associated with each of the tables in MYSQL? --

Re: moving DB from one box to another.

Randy Paries wrote: The problem is I get this wonderfully verbose :-( error message :::ERROR at line 362701 - MySQL can't parse something on line 362701 of your dump file. One possibility is an index named with a keyword, which 3.23.x appears to allow but 4.0.x doedsn't. Edit the dump file

Re: Cannot connect to local server problem

Hello. See: http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html Leandro Melo [EMAIL PROTECTED] wrote: Hi, i built an application which uses MySQL 4.0.17 using Windows XP Professional. Tomorrow, i need to present the application to my client, so i preparing my enviroment in a

RE: mysql database

[snip] Okay, extreme newbie. I probably just missed it but I went to the mysql site to download the database so that I could use it at work and I am having a problem finding it. The spot I expected it to be in there wasn't a link for it. Anybody got any ideas? [/snip] Try here

Re: mysql database

I hope you went at least to www.mysql.com ;) - Second tab Developer Zone. - First tab Downloads from the second menubar. - Select version of your database - Select your OS - Pick a mirror - Have fun Rik Op donderdag 16 december 2004 14:28, schreef Serenity Schindler: Okay, extreme newbie. I

Re: mysql_install_db problem!!

manasvini nandakumar wrote: Hi all, I have cross compiled mysql-4.1.7 (from the source distribution)for an IXP425 based board with Montavista Linux-3.0.When I run mysql_install_db --user=mysql ...It runs into several errors with the following log [EMAIL PROTECTED]: /usr/local#

RE: Restore help! been going 2 weeks

it is not normal. i have restored 90 GB database in 2 days on dell server with 2 GB RAM. Are you able to connect to mysql. if so at mysql prompt type the below command and check what processes are running mysqlshow processlist; if any insert statements are running then restoration process is

Flush_time question and related item

We're running mostly with InnoDB tables, about 5% updates/inserts/deletes, the rest selects, on Windows NT. In setting table_cache to 256 from the default 64, we hoped to improve performance a little, by not having to continually close/open tables. Then we noticed that the opened table count

RE: sum() Function and NULL values

[snip] Is there any way to make sum() return 0 instead of NULL when one or more of the rows being sum()'d is null? Phrased another way, is there a way to make mySQL treat NULL as 0 when dealing with mathematical functions? [/snip] Use an IF... SELECT SUM(IF(myColumn IS NULL, 0, myColumn)) AS

can't get the order I want after inserting new rows

Hi! I have a problem with getting the order I want on a table after new rows have been inserted. I try to simplify it...: I want to have a one-to-one relationship between 'name' and 'full'. Every 'name' (or'full') have one or more 'parts'. The higher the 'score' the lower the 'full', but for my

Help with a join query please

Hi, I have (among others) three tables in my database that i am struggling with a join query on. The database holds dates for Bookings. If Users are Allocated to a particular Project they can be booked. However if a user is booked but then unallocated I want to be able to display all peolple

MySQL 4.1.8 has been released

Hi, MySQL 4.1.8, a new version of the popular Open Source/Free Software Database Management System has been released. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mirror

Re: Limit drive usage per thread

At 12:05 PM 12/13/2004, you wrote: Is there any way to limit drive usage per thread? I have a problem where an update thread will use 100 % of the drive, and simple index searches that should be instant will wait and wait and wait before responding. I dont want one user to kill everybody else

revoked privileges, but still present

Hi, I need some help with privileges issues. I want to create a user, bkup_user, with only Select, Reload, Lock Table privileges. I created the bkup_user with all privileges, and revoked all but select reload and grant (could not find lock table). Command succeeded and I flushed privileges.

myisamchk -r hanging for a long time after fixing indexes

We have a database running Invision Power Board. The table containing the posts (3.000.000 rows) keeps on crashing from time to time, and the index gets corrupt. We stop mysql, and run myisamchk -r tablename, which behaves strangely. First it uses 3-5 minutes fixing the indexes. When the

Re: Help with a join query please

From: Rhino [EMAIL PROTECTED] To: shaun thornburgh [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: Help with a join query please Date: Thu, 16 Dec 2004 14:59:48 -0500 - Original Message - From: shaun thornburgh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 16, 2004

Re: MySQL load balancing...

Kevin A. Burton wrote: Was curious what people on the list are using for load balancing.. there are a number of techniques here but it would be interesting if people could share some real-world experiences HTTP load balancing is pretty well understood but there's not a bunch out there on

RE: sum() Function and NULL values

Thanks for all your responses. I went with the coalesce way - it works like a charm. Thanks again! Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 480-1870 Mobile/Emergencies (516) 908-4185 Fax http://www.meitech.com/ -- MySQL General Mailing List