long query status info

hi, i'm running a big query across a table containing more than 137 million rows comparing them to another one with about 4000 rows and i'm wondering how long it will still take... is there a way to see how many operations have been made and how many are left? as you can see it already took

long query status info

hi, i'm running a big query across a table containing more than 137 million rows comparing them to another one with about 4000 rows and i'm wondering how long it will still take... is there a way to see how many operations have been made and how many are left? as you can see it already took

Determine version of *.frm, *.MYD and *.MYI

annot be read Unfortunately I'm unable to access the disk anymore, so I cannot see what version of the server generated these. How do I do that? Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SV: Determine version of *.frm, *.MYD and *.MYI

I know it a 4.1... But as I compiled it my self it is not so easy to figure it out And it might take a while to trial-n-error all 4.1.x Nils -Oprindelig meddelelse- Fra: sheeri kritzer [mailto:[EMAIL PROTECTED] Sendt: fr 05-05-2006 20:28 Til: Nils Lastein Cc: mysql@lists.mysql.com

SV: Determine version of *.frm, *.MYD and *.MYI

Well... It did document it In my wiki... which is gone... Nils -Oprindelig meddelelse- Fra: sheeri kritzer [mailto:[EMAIL PROTECTED] Sendt: fr 05-05-2006 21:57 Til: Nils Lastein Cc: mysql@lists.mysql.com Emne: Re: Determine version of *.frm, *.MYD and *.MYI No backups? And you

Re: [SPAM] - Unable to install mysql - Bayesian Filter detected spam

-new-mysql-user.php I hope that you find this info useful. Best regards Nils Valentin Tokyo / Japan http;//www.be-known-online.com On Tuesday 14 June 2005 06:58, Yannick wrote: > Kevin, > > In addition to that, the ZORUM database works because when I stop mysql, > the followin

Re: Need help

Hi Shreedjhar, Are you aware of this paper ? http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf It may perfectly answer most of your questions. Best regards Nils valentin Tokyo / Japan http'//www.be-known-online.com On Saturday 18 June 2005 22:01, mad

Unique Id generation

Hi all, I try to generate a unique id for each row in a Mysql-InnoDB Table. Because of many deletes I can’t use an auto_increment column. After a Mysql restart, the next value for an auto_increment-column is max(auto_increment-column)+1, and I need a really unique id. My first solution looks

Re: RE: Unique Id generation

> >I try to generate a unique id for each row in a Mysql-InnoDB Table. > >Because of many deletes I can't use an auto_increment column. > >After a Mysql restart, the next value for an auto_increment-column is > >max(auto_increment-column)+1, and I need a really unique id. > > > [JS] See if the

Re: Unique Id generation

> Why would the auto_increment not work for you? The only case where you > would have a problem is if the last record was deleted before mysql > shutdown. If you are really concerned about this unique scenario, > insert a dummy record before shutdown to guard against it and delete > the dummy reco

Re: Trying to create a new table in memory.

wrong? You use the memory storage engine If I am getting it right? Does MySQL report that it's out of memory (table full error) or does the OS do so? Are there any indexes (might double the data for your small table)? regards Nils -- MySQL General Mailing List For list archives:

Re: MySSQL on HP-UX

ts! Did you do that? Is there a user called "mysql"? regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Does Update allow for aliases?

e SQL. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql data into CSV file. / (Errcode: 13)

t write to your home directory. Try using /tmp instead or some dir mysqld can write to. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Load Balance on MySql

. Do you store the content in the database or just links to files? regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Two Databases

ECT * FROM db2.table) If db2 on a other mysql server, it is possible to use the federated storage engine of MySQL. - -- Nils Jünemann Database and System Administration studiVZ | Saarbrueckerstr. 38 | 10405 Berlin | phone +49-(0)30-405042715 www.studiVZ.net | fax +49-(0)30-28093887 | ce

Re: How to "cast" a column ?

a VARCHAR. This doesn't seem to make sense if this is not a very rare corner-case. Either both columns should be INT or VARCHAR. BTW, how can I get the number of rows examined (like in slow queries log) from mysql command line ? Run: EXPLAIN [query] have a look at the "rows" co

Re: Query headaches

id && item_status.supplier_id = i.supplier_id && item_status.group_id = 1) WHERE i.product_id = products.product_id && i.item_stock > 0 the field products.product_id is not defined at this place, because the subquery is specified in the field list and not join

Re: error 99(?) : can't connect to MySQL server

me more insight on that topic: http://www.mysqlperformanceblog.com/2006/11/12/are-php-persistent-connections-evil/ Don't be confused with the PHP mentioned, the first paragraphs apply to TCP/IP and mysql as whole. regards Nils -- MySQL General Mailing List For list archives: http://li

Re: NOT EMPTY, like NOT NULL

Hi Js, js wrote: Is there any easy way to implement 'NOT EMPTY' constraint? There currently is no support for CHECK Constraints in MySQL, at least to my knowing. So you'd have to go with a trigger. regards Nils -- MySQL General Mailing List For list archives: http://lists.mys

Re: SQL_CALC_FOUND_ROWS using ODBC driver

ECT FOUND_ROWS() returns exactly one record *CONTAINING* the number of found rows. So you have to access the resultset to get the actual number of rows. SELECT SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by the way. regards Nils -- MySQL General Mailing List

Re: SQL_CALC_FOUND_ROWS using ODBC driver

Nils Meyer wrote: > SELECT SQL_CALC_FOUND_ROWS doesn't make much sense without a where clause by the way. LIMIT, not where. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld got signal 11;

ocate about 2GB of RAM in total. You might want to check that. How big is your InnoDB buffer pool? regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysqld got signal 11;

value) and yesterday i increased to 500MB. But i did not touch the innodb_buffer_pool_size this still have 8 MB. Your buffer pool is a bit small, if you use innodb heavily. The innodb_additional_mem_pool is way to large I think the size could be lowered to something around 30MB. regards Nils

Re: mysqld got signal 11;

Michael Fernández M. wrote: Remember that you have to stay under 2GB total memory allocation! I think you hit that limit. Sorry, but why do you say that?, because of the 32 bits kernel? Yes exactly. Depending on kernel version you can allocate something between 2 or 2.7GB. Until 2GB it's sa

Re: unauthenticated user

| That's just fine. The user is in login state, so he/she/it is not yet authenticated. There might be a DNS issue slowing down login, you might check if you can reverse lookup the hostnames of the connecting users. regards Nils -- MySQL General Mailing List For list archives: http://lists.

Re: Mysql and FOREIGN KEY

Hi, Micol lupen wrote: FOREIGN KEY(of_idvillaggio),REFERENCES villaggio(idvillaggio) ^^^ check here! ON UPDATE CASCADE ON DELETE RESTRICT)ENGINE=INNODB; No comma before REFERENCES. REFERENCES is part of the foreign key definition. regards Nils -- MySQL General

Re: Growing innodb size

;ll see how it has been set up. Do you want a fixed size or should it grow automatically? Anyways, you might want to check this documentation: http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html NOTICE: You should not send privileged and confidential information to a maillinglist ;)

Re: InnoDB: Assertion failure

ernel. You have to decrease mysql memory usage. regards Nils (I have a dejá-vu here, did you post that question before?) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Disk parition full

5.1 series. You can use symbolic links to move some databases or even tables to another location. Other solution might be to move *all* databases to /var and change the datadir setting in my.cnf accordingly. Regards Nils [1] http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html

Re: Adding a new autoincrement field to an existing table

key. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Google like search string to be implemented

" I think MySQL fulltext search in boolean mode would be the perfect choice for that: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html You can use search strings like your example with that directly. regards Nils -- MySQL General Mailing List For list archives: http://lists

Re: drop stored procedures in prepare statment

re > statment. > > Is it a lack of feature in MySQL-5.0 version ?? Exactly. MySQL doesn't support dropping/creating functions/procedures or triggers in functions or triggers. regards Nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: monitor multiple mysql servers with no 3306 access

olled and polls the MySQL instances via local socket. nagios or hyperic HQ [1] can do that. Hyperic HQ looks a lot cooler than nagios. regards Nils [1] http://www.hyperic.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Weighting searches

Hi John John Nichel wrote: The db is MySQL 4.1.20 and the column synonyms_misspellings has a FULLTEXT index on it (the db is set to index on 3 characters). Can anyone help me understand why it's not rating the one with the match three times higher than the one with the match twice, and point

Recreating primary index on MyIsam table

shouldnt be too difficult, but perhaps I am just too long in front of the screen. ;-) Best regards Nils Valentin Tokyo / Japan www.be-known-online.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Recreating primary index on MyIsam table

Hi Peter, thanks a bunch, I new that it must have been something simple like this. I am just no programmer. ;-) Thanks a bunch !! Best regards Nils Valentin Tokyo / Japan On Sunday 10 April 2005 23:41, Peter Brawley wrote: > Nils, > > >So the task is to recreate the current

Re: Version 4.1.1

, > Dan -- kind regards Nils Valentin Tokyo/Japan http://www.be-known-online.com/mysql/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Auto Increments and Other Keys

> All - Running MySQL 4.0.17 under Red Hat 9, using MyISAM tables. > > I'm trying to add the auto_increment attribute to column in a table that > already has a primary key defined. Here is the table I'm trying to > create: > > > CREATE TABLE IF NOT EXISTS dataTypes ( > id int unsigned NOT NULL AU

Re: RedHat-9

Also bear in mind that the file ~/.my.cnf or var/lib/mysql/.my.cnf will take precedence over /etc/my.cnf which should set only the global settings. Please let me know once more the mysql server version you are using mysql> SELECT VERSION(); Best regards Nils Valentin Tokyo/Japan 2003年 5月

Re: changing mysqld deamon ownership.

Hi Alan, you would have to do mysql -u root -p and then enter the password to connect. best regards Nils Valentin Tokyo/Japan 003年 5月 31日 土曜日 04:02、2Hosts.com さんは書きました: > Hi Nils, > > So if I su to root and try to start mysql, I get the following... does that > mean I'm se

Re: Creating new users

Hi Barry, 2003年 5月 31日 土曜日 00:30、あなたは書きました: > Thanks Nils. I can remotely connect to the database. I removed the local > host entries for the bdancis account (the same name as the remote login) > and added a new entry for [EMAIL PROTECTED] but was still not able to log on > locally e

Re: MYSQL DB PROBLEM

Hi Adam, there was a similar thread within the last 24 hours. try SHOW VARIABLES LKE '%time%'; Best regards Nils Valentin Tokyo/Japan 2003年 6月 1日 日曜日 14:47、Adam Murphy さんは書きました: > I am trying to insert a table ibf_posts > > into a localhost database using the MYSQL control

Re: MySQL Errno: 2013

Hi Kevin, I dont think its the switch. I would like to try the following variables: net_read_timeout 60 net_write_timeout 60 long_query_time 30 Please let me know if this was of any help. Best regards NIls Valentin Tokyo/Japan 2003年 5月 30日 金曜日 23:33、Kevin A. Miller さんは書きました: > N

Re: Practical samples for table types

Hi Everybody, our server was down for 8 hours. I applogize in case anybody did try to access the table chart. Its up and running and of course I would appreciate any feedback. http://www.knowd.co.jp/staff/nils/mysql-ttf.html Best regards Nils Valentin Tokyo/Japan 2003年 5月 30日 金曜日 17:34

Re: Query problem

Hi everybody, I hope ASAFP stands for something like AS Soon AS Feasable Possible ;-) We are not going to swear are we ? Best regards Nils Valentin 2003年 6月 2日 月曜日 07:30、Sparky Kopetzky さんは書きました: > I have a view I need to create from several tables where I'm looking up one > v

Re: SELECTing last occurences from a table

In this case you would need to add a timestamp and check for the latest timestamp. This price should be taken for your query. Something like SELECT * FROM food WHERE timestamp(MAX); Thats my guess - anybody please correct me if I talk rubbish here Best regards Nils Valentin Tokyo/Japan

Re: SELECTing last occurences from a table

;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 2日 月曜日 08:55、Mateusz さんは書きました: > > SELECT * FROM myTable ORDER BY COLUMN_WHICH_CONTAINS_INSERTED_DATE ASC > > LIMIT > > > 1; > > COLUMN_WHICH_CONTAINS_INSERTED_DATE is a column which contains the date > > that >

Re: Inserting data?

g any data record , you will have to update this only once, while in the previous sample you will have to update it several times (time consuming). While this is a complex topic I would suggest to read some articles from www.devshed.com about database normalization Best regards Nils Valentin T

MYSQL Documentation

rs. Table or OS errors still will need to be added. I was hoping that somebody else might find it useful as well. There is no eye candy etc. - its really just the plain information. http://www.knowd.co.jp/staff/nils/ Best regards -- ==== Valenti

Re: Query problem

OOh thats fine then isnt it ? ;-) Best regards Nils Valentin 2003年 6月 2日 月曜日 22:47、Sparky Kopetzky さんは書きました: > No, not swearing - just As Soon As Financially Possible!!! > > Robin > > *** Still need an answer if someone can help * > > > - Original Mes

Re: Slackware 9.0 and MySQL 3.23.56

d chgrp to change it to mysql's Linux user account (ps -u). Then it will start without any problems. Best regards Nils Valentin 2003年 6月 3日 火曜日 01:[EMAIL PROTECTED] さんは書きました: > I recently installed Slackware 9.0 from ISO onto a box and cannot get > mysql to run on it. It gives the error

Re: ft_boolean_default='AND'

No swearing please, we are not on holiday ;-) Best regards Nils Valentin 2003年 6月 3日 火曜日 07:14、electroteque さんは書きました: > myisam/ft_static.c'. > > so i have to edit this and recompile ? what a pain in the ass , i'll have > to try and format it then > -Original Me

Re: control center question

and then click on " use the following database" and enter your database name. Press apply, disconnect and connect again and voila ! Best regards Nils Valentin Tokyo/Japan 2003年 6月 3日 火曜日 04:55、Fabio Bernardo さんは書きました: > Hi there, I´m using control center 0.9.1-beta and when I st

Re: cant grant privileges?!

How do you login to mysql ? mysql -u user -p -h localhost should do it. You dont even need "-h localhost" in this case. Best regards Nils Valentin Tokyo/Japan 2003年 6月 3日 火曜日 11:31、Kalin Mintchev さんは書きました: > hi everybody... > > i just installed mysql 4.0.13 on a redhat

Re: Replication problems (server_errno=1236)

Hi Calvin, I am not sure which table format you use, but somehow I assume you use innodb. If I remember correctly than Innodb will need all log files. If only one is missing than thats it, you get the error described. - anybody please correct me if I talk rubbish here Best regards Nils

Re: cant grant privileges?!

PHP is a different topic you have to use a procedure called "mysql_pconnect". However that is well documented in several PHP documents. Best regards Nils Valentin 2003年 6月 3日 火曜日 11:44、Kalin Mintchev さんは書きました: > On Tue, 3 Jun 2003, Nils Valentin wrote: > > How do

Re: MYSQL Privileges

/Server_Side/MySQL/Grant_Tables/page1.html http://www.devshed.com/Server_Side/MySQL/Administration/page1.html They also offer printer friendly formats. I hope you dont think ... hmm just another document ;-). They are really worth the time. Best regards Nils Valentin Tokyo/Japan 2003年 6月 3日 火曜日

Re: cant grant privileges?!

Hi Allann, Ajos, Mysql List members As far as I know the flush privileges is not necessary when using GRANT. flush privileges is only used after you updated the privilege database "mysql" manually using INSERT or UPDATE. Somebody please correct me if I am wrong. Best regards Nil

Re: Regarding inoperable symbolic links in Win2K Pro

Hi Charles, Having spoken to "somebody" from MySQL AB in person last month here in Tokyo I know that the problem seems to be adressed currently. What I dont know is when, how and which new mechanism will be applied to the mailing list. Best regards Nils Valentin Tokyo/Japan 2003年

Can't open privilege tables: Table 'mysql.host' doesn't exist

30:49 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 030604 09:30:49 mysqld ended Any reply much appreciated. -- ==== Valentin Nils Internet Technol

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

, perhaps my.cnf and/or mysql itself. Best regards Nils Valentin 2003年 6月 4日 水曜日 12:36、Nils Valentin さんは書きました: > Hi Mysql list members, > > I added a Innodb database to the existing MyISAM databases and now MySQL > doesnt start up. From the InnoDB logfile I saw this error message &g

Re: FW: MySQL for our production reporting data warehouse

wever you can follow up on the change logs in the documentation on www.mysql.com http://www.mysql.com/doc/en/News.html Best regards Nils Valentin Tokyo/Japan 2003年 6月 5日 木曜日 04:02、Sonia Ghadially さんは書きました: > > -Original Message- > > From: Sonia Ghadially > > S

Re: MySQL List Stats for May, 2003

I am not sure if I will use it often, but definitely well done ;-) Very clear organization of the data. Thats definitely something which will be highly appreciated by most list members (and MySQL AB) I am sure !! Best regards Nils Valentin Tokyo/Japan 2003年 6月 5日 木曜日 06:55、Bill

Re: [Correction] MySQL List Stats for May, 2003

Hi Bill, Such a pitty. For a moment I thought I am the new No.1 ;-) (see previous posted data) Best regards Nils Valentin Toko/Japan 2003年 6月 5日 木曜日 07:29、Bill Doerrfeld さんは書きました: > --- > Please ignore my prior post on this. The numbers were wrong as it > tur

Re: detailed FULLTEXT index and search help needed

table which you dont use in the WHERE clause of your SQL statement ? Anybody please correct me if I talk rubbish here ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 5日 木曜日 02:25、H M Kunzmann さんは書きました: > Hello All. > > I have a table that is about 1.5GB with about 400 records. >

Re: authentification intranet

Dont forget "FLUSH PRIVILEGES" ;-) otherwise you might be wondering why the new settings dont apply. Best regards Nils Valentin 2003年 6月 5日 木曜日 02:55、jinal jhaveri さんは書きました: > I guess the problem is with your authentication. Mysql 4.1 uses a new auth > schema. You might want

Re: Can't open privilege tables: Table 'mysql.host' doesn't exist

your advice and I am in process of repairing this, however I would really appreciate if I could also technically understand why this is. This case I can learn and step up ;-) Do you mind explaining why this is ? Best regards Nils Valentin 2003年 6月 4日 水曜日 21:09、Heikki Tuuri さんは書きました: &

Re: nested ORDER BY statements

Hi David, can't give you detailed advice but I believe you look for SELECT...GROUP BY ... ORDER BY Please see the docs like "info mysql". Best regards Nils Valentin Tokyo/Japan \ 2003年 6月 4日 水曜日 22:37、Dave Terrio さんは書きました: > Hello - I'm a relative newcomer to dev

Re: MySQL Errno: 2013

Hi Kevin, thats alright, let me know when it worked, thats what I want to hear ;-) Best regards Nils Valentin 2003年 6月 5日 木曜日 00:12、Kevin A. Miller さんは書きました: > Nils: > > sorry for the delay getting back to you. > > this morning we modified the variables mentioned below. Followin

Re: mysqldump

all data and delete the rest which is not needed. Thats very easy done on the command line (in case you use MyISAM) or you can edit the backup file directly. Best regards Nils Valentin Tokyo/Japan 2003年 6月 3日 火曜日 17:55、Massimo Petrini さんは書きました: > It is possibile to make an export d

forming foreign keys

pointing me to the right direction ? Any help much appreciated. -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp http://www.knowd.co.jp/staff/nils/mysql-error-codes.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

Re: detailed FULLTEXT index and search help needed

work around the problem and also be able to reduce the maintenance for the future. Please let me know if I went down the wrong way ;-) or if I missed the spot again ;-). Best regards Nils Valentin Tokyo/Japan 2003年 6月 5日 木曜日 02:25、H M Kunzmann さんは書きました: > Hello All. > > I have a tabl

Re: How to empty the cache?

join_buffer_size myisam_sort_buffer net_buffer_length tmp_table_size I guess if you lookup any of the variables above you will quickly sort out the ones which applies to your question and the ones that don't. Sorry, but with the information given I am unable to be more precise. Best regards Nils Val

Do all mysql versions from 4.1 support sub selects?

Hi Mysql List, Will all mysql versions (std, max and debug) from 4.1 support sub selects or will this only be included f.e in the max version ? Best regards -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For

Certification study quide from Dubois, Hinz and Pedersen

- no info on www.amazon.com so far. Best regards -- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Certification study quide from Dubois, Hinz and Pedersen

position most. That would be marvelous, but we dont want to reach for the stars.. ;-) Best regards Nils Valentin Tokyo/Japan nils(at)knowd.co.jp 2003年 6月 10日 火曜日 00:31、あなたは書きました: > Nils, > > > Hello Paul Dubois, Stefan Hinz, Carsten Pedersen, > > Ah! How did you find ou

Re: array/pointer question

Arrays are coming from version 5.0 as far as I know the plans. Best regards Nils Valentin 2003年 6月 9日 月曜日 23:49、Ioana さんは書きました: > Hello, I have just recently started learning mysql, and was wondering if > it supports arrays/pointers(for linked lists) of any types, and if so, > wh

Re: Certification study quide from Dubois, Hinz and Pedersen

Hi Paul, 2003年 6月 10日 火曜日 01:26、Paul DuBois さんは書きました: > At 1:08 +0900 6/10/03, Nils Valentin wrote: > > > > > >Hello Stefan, > > > >well I have my sources ... ;-) .. I guess its no secret ,especially as it > > was announced on the UC. > > > >I

Re: arrangement of fields in a table

Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 02:40、Mojtaba Faridzad さんは書きました: > Hi, > > I need to define for example 100 fields in a table. 8 of them are more > important and many queries just need these fields. Should I define them > before the other fields in the table or it doe

Re: diff between 7.2 and 8.0 rights?

e that nobody of your customers ever finds this mailing list ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 03:36、Obantec Support さんは書きました: > Hi > > I have 2 servers both with 3.23.56-1 installed via rpm's > > proteus2 which is running RedHat 7.2 on 1 cpu

Re: Trouble with SELECT AS syntax

xx" but no reserved words please ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 10:53、Becoming Digital さんは書きました: > Despite my review of the manual, I cannot get my SELECT AS statements to > work. Every attempt returns Error 1064. My statements, which appear to be > in

Re: Trouble with SELECT AS syntax

Jim was faster ;-), ..but I am getting there. Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 11:18、Jim Winstead さんは書きました: > On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote: > > SELECT item_name AS name, item_desc AS desc FROM food; > > 'desc

Re: Trouble with SELECT AS syntax

I posted a page containing the reserved words at http://www.knowd.co.jp/staff/nils/ In case it is of any help for somebody. Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 11:18、Jim Winstead さんは書きました: > On Mon, Jun 09, 2003 at 09:53:12PM -0400, Becoming Digital wrote: > &g

InnoDB question(s)

data related to the not anymore useable database ? Of course I could step through the log files trying to find the correct "CREATE DATABASE dbname" statement, but having seen the innodb log file sizes I would appreciate another solution ;-) PS: Didn't happen with serious da

Re: InnoDB question(s)

the orginal dbname). Best regards Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 14:55、Becoming Digital さんは書きました: > http://www.innodb.com/ibman.html#Backing_up > > See the section on Forcing Recovery. > > Edward Dudlik > Becoming Digital > www.becomingdigital.com > &g

Re: forming foreign keys

Hi Victoria, 2003年 6月 10日 火曜日 19:16、Victoria Reznichenko さんは書きました: > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > > I try to create foreign keys in a innodb database. I read through some > > threats and the manual, and several online resources, but som

Re: Practice test

remy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.13: up 7 days, processed 221,412,201 queries (349/sec. avg) -- Valentin Nils Internet Technology E-Ma

Re: alter table blocks other tables!

gt; card. Linux software RAID usually performs quite well. > > Jeremy I disagree with Jeremy, I think depending on your request type you will definitely see performance differences, the question is if they apply to your needs ;-). > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux

Re: droping foreign key

HiJoe, thats not supported yet. You will have to recreate the table to remove the foreign key. Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 10:13、Joe Gaffney さんは書きました: > Can someone help with trying to remove a foreign key constraint from a > table. Each time I run the alter

Re: droping foreign key

Hi Joe, Yup, thats what it means. I try to make some - what I believe will be useful - documents extracting the info from this mailing list responses. So far it looks more like a construction place but you are free to browse at my site: http://www.knowd.co.jp/staff/nils Best regards Nils

Re: forming foreign keys

| | +---++--+--+-+---+-+--++--++-+ Any comments appreciated. Nils Valentin Tokyo/Japan 2003年 6月 10日 火曜日 22:52、Nils Valentin さんは書きました: > Hi Victoria, > > 2003年 6月 10日 火曜日 19:16、Victoria Reznichenko さんは書きました: > > "Nils Valentin" <[EMAIL PROTECTED]> wrote: > &

Re: forming foreign keys

in another way f.e mysql> ALTER TABLE db ADD CONSTRAINT FOREIGN KEY (Host) REFERENCES user (Host); ERROR 1216: Cannot add or update a child row: a foreign key constraint fails But as you can see I get another error. Any comment much appreciated. Best regards Nils Valentin Tokyo/Japan

Re: Unicode(ucs2) setup question

Hi Yuji Error 2 means the file doesnt exist. (here: '/usr/local/share/mysql/charsets/ucs2.xml'). Please make sure the file is in the foldr specified and not misspelled. Best regards Nils Valentin Tokyo/Japan Japanese: 宜しくお願いします 2003年 6月 11日 水曜日 14:44、Yuji Sato さんは書きました: > I&

Re: Unicode(ucs2) setup question

yourself ? Do you want to create your own character set ? My guess is that you perhaps wanted to use the new UTF-8 charcater set. Is that right ? Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 15:04、Yuji Sato さんは書きました: > Hi Nils, > > I have no ucs2.xml in the "/usr/loc

Re: Unicode(ucs2) setup question

Hi Juan, I understood Yuji is using OS FreeBSD 4.8 DB MySQL4.1.0-alpha Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 16:54、Juan Sebastian Alarcon さんは書きました: > In wich version of Windows do you have compiled mysql? > > I have Win XP and I need a mysql version that works with

Re: forming foreign keys

Hi Victoria, I thought so, but also if I try somthing similar like: ALTER TABLE db ADD FOREIGN KEY (Host) REFERENCES user (Host); I get the same error. BTW: Can I change the order of the keys ? Best regards Nils Valentin 2003年 6月 11日 水曜日 17:17、Victoria Reznichenko さんは書きました: > &q

Re: forming foreign keys

? Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 21:20、Nils Valentin さんは書きました: > Hi Victoria, > > I thought so, but also if I try somthing similar like: > > ALTER TABLE db ADD FOREIGN KEY (Host) REFERENCES user (Host); > > I get the same error. > > BTW: Ca

Re: Printing table descriptions

se you want to print them regularly) ? ;-) Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 22:29、Fernando Gerent さんは書きました: > Hi! > > I need to print the description of all tables in my database. The problem > is, there are about 200 of them, and the only way I know to do this

Re: Printing table descriptions

Martin, my compliment. Excellent answer. I completely forgot about the -d option for mysqldump. Best regards Nils Valentin Tokyo/Japan 2003年 6月 11日 水曜日 22:32、Martin Waite さんは書きました: > On Wed, 2003-06-11 at 14:29, Fernando Gerent wrote: > > Hi! > > > > I need to print t

  1   2   3   4   >