Fw: Innodb table space getting filled up without any increase in actual rows!!

2004-03-02 Thread Sp.Raja
I missed attaching the trace file! Sorry !! Regards, Sp.Raja > Original Message > From: "Sp.Raja" <[EMAIL PROTECTED]> > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Date: Wed, Mar-3-2004 1:13 PM > Subject: Innodb table space getting filled up without any increase in act

Innodb table space getting filled up without any increase in actual rows!!

2004-03-02 Thread Sp.Raja
Hi List, My tablespace is getting filled up so quick when no. of transactions increase without number of rows increasing considerably. I have a test client which adds and deletes row dynamically maintaining number of rows at any instant between 20 and 60. When I run this test client, after so

Re: Benchmarking/optimization of MySQL

2004-03-02 Thread Sasha Pachev
Bostjan Skufca (at) domenca.com wrote: Hello, for the last few days I've been running benchmarks from sql-bench directory and tunning server parameters and I have few questions. Firstly I would like to note that benchmarks were run on two different but similar machines: Machine ONE: Dual Xeo

Re: Danger in installing binary for another architecture...

2004-03-02 Thread Sasha Pachev
Jonathan Villa wrote: Ok, I've always used intel machines, but this time I'm stuck using a AMD Athlon(tm) XP 1900+ The only AMD I see for download is the AMD64, which is not what I have and also gives me a warning before installation... So, which should I use? There is Linux (x86, libc6) Linux

Re: Mysql version 4.0.x ,LOCKS and Transactions

2004-03-02 Thread Sasha Pachev
Luiz Rafael Culik Guimaraes wrote: Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb If you program a certain way, you can run into deadlocks which will result in rolled back transactions th

Re: Client connection error

2004-03-02 Thread Sasha Pachev
Andre MATOS wrote: Hi, I am trying to connect from one computer that has MySQL installed (client) in another one that also has MySQL (server). Using this command: C:\mysql\bin>mysql.exe -u root -h server.com -p Enter password: * ERROR 2003: Can't connect to MySQL server on 'server.com' (1006

Re: MySQL speed problem

2004-03-02 Thread Sasha Pachev
Andre MATOS wrote: Hi, I faced a speed access problem today with the MySQL. In the morning was working well and fast, but after lunch when I tried to access the MySQl using Apache+PHP it was terrible. For just a select, it took 2 a 3 minutes to process. I checked the log files from Apache and P

Re: read only table 'user' at install

2004-03-02 Thread Jonathan Villa
They are currently set to 775...(which I would prefer to have them unreadable by the world and only group and owner) anyway, I changed them to 777 for testing and still received the same message. On Tue, 2004-03-02 at 22:13, Sahil Aggarwal wrote: > check file permissions on the database director

Re: Benchmarking/optimization of MySQL

2004-03-02 Thread Peter Zaitsev
On Tue, 2004-03-02 at 19:00, Bostjan Skufca (at) domenca.com wrote: Bostjan, At first I shall mention you have set up your experiment the hardest way for comments. You have different hardware, different MySQL versions and different MySQL settings. Normally you would like to change only one of t

Benchmarking/optimization of MySQL

2004-03-02 Thread Bostjan Skufca (at) domenca.com
Hello, for the last few days I've been running benchmarks from sql-bench directory and tunning server parameters and I have few questions. Firstly I would like to note that benchmarks were run on two different but similar machines: Machine ONE: Dual Xeon 2.4 533MHz FSB 4GB RAM SCSI raid 10 (

Re: Query Speed in Terminal vs. PHP

2004-03-02 Thread Saqib Ali
Is index defined on all of your tables? Saqib Ali - http://validate.sf.net < (X)HTML / DocBook Validator and Transformer On Tue, 2 Mar 2004, Chris Fowler wrote: > I have a query that is admittedly inefficient in that it is doing > multiple OR clauses and joining multiple tables.

Danger in installing binary for another architecture...

2004-03-02 Thread Jonathan Villa
Ok, I've always used intel machines, but this time I'm stuck using a AMD Athlon(tm) XP 1900+ The only AMD I see for download is the AMD64, which is not what I have and also gives me a warning before installation... So, which should I use? There is Linux (x86, libc6) Linux (S/390) Linux (IA64)

read only table 'user' at install

2004-03-02 Thread Jonathan Villa
Ok, I have installed MySQL many times and have never come across this... when try to run ./bin/mysqladmin -u root password 'new-password' I get the following ./bin/mysqladmin: unable to change password; error: 'Table 'user' is read only' I've never had this happen, and unfortunately do not kn

Newbie - SELECT Query Help

2004-03-02 Thread D F
hello, I want to select a column twice but get the results using two different conditions. SELECT tbl.colA, tbl.colA from tbl where tbl.info = B (the first colA) and tbl.info = C (for the second colA) I hope this makes sense. Thanks __ Do you Yahoo!? Yahoo! Se

Re: Problems Installing

2004-03-02 Thread Kevin Williams
Marie, Welcome to the wonderful world of Linux! Glad to hear your making the jump:) One of the major drawbacks (or bonuses depending on your point of view) is that you have to be familiar with the command line. You mentioned you are on Redhat. There are two options here--either you could sel

Re: Query Speed in Terminal vs. PHP

2004-03-02 Thread Daniel Kasak
Chris Fowler wrote: I have a query that is admittedly inefficient in that it is doing multiple OR clauses and joining multiple tables. However, the query runs at an acceptable speed if I am in a terminal session and run the query directly in the terminal. On the other hand, when PHP performs th

Problems Installing

2004-03-02 Thread Marie Salas
Hello, I'm very new to this Linux OS, and just downloaded MYSQL and I'm having a problem. I downloaded your Mysql version Linux (x86, libc6) and once downloaded I was unpacking the files from "File-Roller" that was part of the Linux Redhat installation. When I went to extract the files and sa

Query Speed in Terminal vs. PHP

2004-03-02 Thread Chris Fowler
I have a query that is admittedly inefficient in that it is doing multiple OR clauses and joining multiple tables. However, the query runs at an acceptable speed if I am in a terminal session and run the query directly in the terminal. On the other hand, when PHP performs the same query for use

Re: Mysql version 4.0.x ,LOCKS and Transactions

2004-03-02 Thread Daniel Kasak
Luiz Rafael Culik Guimaraes wrote: Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb Regards Luiz I haven't had any problems. Did your friend elaborate? -- signature Daniel Ka

Mysql version 4.0.x ,LOCKS and Transactions

2004-03-02 Thread Luiz Rafael Culik Guimaraes
Dear Friends Talking with an friend, he told he that mysql 4.0.x has many problems with lock and transactions, is this true. All table that i use are innodb Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

Client connection error

2004-03-02 Thread Andre MATOS
Hi, I am trying to connect from one computer that has MySQL installed (client) in another one that also has MySQL (server). Using this command: C:\mysql\bin>mysql.exe -u root -h server.com -p Enter password: * ERROR 2003: Can't connect to MySQL server on 'server.com' (10060) However I am a

Re: CREATE TABLE IF NOT EXISTS behavior (should it add rows if the table doesn't exist?)

2004-03-02 Thread Paul DuBois
At 14:42 -0800 3/2/04, Mark Brunkhart wrote: I apologize if this has been discussed or reported as a bug (I searched a bit but couldn't find mention of it). When you create a table using the CREATE TABLE IF NOT EXISTS...SELECT syntax, what is the correct behavior if the table already exists? It sho

Building MySQL with Visual Studio .NET 2003

2004-03-02 Thread Matt Solnit
Hi everyone. Has anyone tried building MySQL with Visual Studio .NET 2003? I find two problems: 1) The files /strings/Strings.asm and /strings/Strxmov.asm do not compile due to a command-line parameter in the custom-build call to ml.exe. It seems the upgrade from the .dsp file shipped with the

Re: Inserting and Grant users

2004-03-02 Thread Andre MATOS
On Tue, 2 Mar 2004, Michael Stassen wrote: > > Andre MATOS wrote: > > > Hi, > > > > I insert a new user to access the MySQL database. I have 4 databases plus > > the mysql database. I want that this user can run the select instruction > > just into one database, so I did this: > > > > [prompt

CREATE TABLE IF NOT EXISTS behavior (should it add rows if the table doesn't exist?)

2004-03-02 Thread Mark Brunkhart
I apologize if this has been discussed or reported as a bug (I searched a bit but couldn't find mention of it). When you create a table using the CREATE TABLE IF NOT EXISTS...SELECT syntax, what is the correct behavior if the table already exists? I had thought that no action at all would be ta

MySQL speed problem

2004-03-02 Thread Andre MATOS
Hi, I faced a speed access problem today with the MySQL. In the morning was working well and fast, but after lunch when I tried to access the MySQl using Apache+PHP it was terrible. For just a select, it took 2 a 3 minutes to process. I checked the log files from Apache and PHP and I could not

Re: Dream MySQL Server?

2004-03-02 Thread PeterWR
Hi Alec, You are not mentioning the "application", if this is a web-based application/interface or some "internal heavy stuff". I'm running Windows 2000 and MySQL (and are happy, sleep fine every night !) for web-sites, and have only a P4 1.6 processor - and this is working very fine so far. So,

Re: UNION

2004-03-02 Thread vpendleton
A union is designed to integrate two+ result sets into one. Can you not just join the tables together and perform a sum in the select clause? >> Original Message << On 3/2/04, 3:46:30 PM, Lorderon <[EMAIL PROTECTED]> wrote regarding UNION: > Hello All, > I wan

Re: UNION

2004-03-02 Thread Lorderon
> the only why i know how to do this is to write the ind sums to a new table > and then sum that table.. How you do it with a new table? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql vs. MySQL

2004-03-02 Thread David Quenzler
My machines have several mysql RPMs installed as part of a SuSE UL 1.0 base configuration. RPMs are all lower-case of the form 'mysql, mysql-client, mysql-devel, mysql-shared', etc. Upgrade RPMs are available as MySQL, mixed case, no longer all lower-case. Is this a cosmetic issue only, am I

Re: bookings

2004-03-02 Thread Gerald Taylor
How would I benifit from a stored procedure? Stored procedures live with your data and can be called directly from inside queries. They can be customized to do what you want to the data before mysql gives it to you (SELECT) or after you feed it in, which is what you want for an insert. so your

Re: Dream MySQL Server?

2004-03-02 Thread Sasha Pachev
[EMAIL PROTECTED] wrote: I have a requirement for a system that is of the order of 8-10 times the size of my current system. Unfortunately (a) I don't know how many times larger it actually is, and (b) my current system, while very happy, even relaxed, on its current hardware, has not yet been su

UNION

2004-03-02 Thread Lorderon
Hello All, I want to sum a column from several tables while using UNION.. something like this: (SELECT SUM(price) FROM table1) UNION (SELECT SUM(price) FROM table2) This results in 2 rows that sums each table seperatedly.. but I want to sum the column from both tables together.. I usually ha

Re: no one can log on any more

2004-03-02 Thread vpendleton
What version of Irix are you on again? Not meaning to inject this late but did you have a look at this section in the MySQL manual? http://www.mysql.com/doc/en/SGI-Irix.html >> Original Message << On 3/2/04, 3:05:39 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regard

Re: no one can log on any more

2004-03-02 Thread Sasha Pachev
Bernd Jagla wrote: Hi there, I have some weird sql statements that seem to eat up all resources from mysqld. Once I have two of them running at the same time no one can log on any more. Simple queries involving distinct get a out of memory error. We have tried changing the index buffer size from

Re: bookings

2004-03-02 Thread Kevin Waterson
This one time, at band camp, Sasha Pachev <[EMAIL PROTECTED]> wrote: > * if your application is not going to be deployed for a year or so or if you > have enough confidence in MySQL alpha, use stored procedures in the bleeding > edge MySQL 5.0 How would I benifit from a stored procedure? Kind

Re: no one can log on any more

2004-03-02 Thread Bernd Jagla
- Original Message - From: <[EMAIL PROTECTED]> To: "Bernd Jagla" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, March 02, 2004 3:43 PM Subject: Re: no one can log on any more Are you sure you allotted 512MB for both read_buffer and sort_buffer_size? Try reducing the

Re: no one can log on any more

2004-03-02 Thread Martijn Tonies
> Are you sure you allotted 512MB for both read_buffer and > sort_buffer_size? Try reducing these values so that the total is roughly > 80 percent of your total physical memory. > > >> Original Message << > > On 3/2/04, 2:26:31 PM, Bernd Jagla <[EMAIL PROTECTED]>

Re: Dream MySQL Server?

2004-03-02 Thread colbey
Never think enough is enough.. Current operation levels can easily be pushed many times their current level/ratio in a short matter of time, and databases can grow rapidly (Even tho it's not identified here) I have spec'd boxes before based on someone reccomendations for load, and then found 2

Re: no one can log on any more

2004-03-02 Thread vpendleton
Are you sure you allotted 512MB for both read_buffer and sort_buffer_size? Try reducing these values so that the total is roughly 80 percent of your total physical memory. >> Original Message << On 3/2/04, 2:26:31 PM, Bernd Jagla <[EMAIL PROTECTED]> wrote regardi

Re: Dream MySQL Server?

2004-03-02 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote: I'd go with raid 1+0 ... Be a shame to have that much cpu power and become I/O bound.. This way you've got 4 disks feeding the cpu's instead of 2.. Better performance than raid 5, and only 2 more disks than your current config. If you have 8 GB of RAM and 4 GB of database,

Re: no one can log on any more

2004-03-02 Thread Bernd Jagla
- Original Message - From: <[EMAIL PROTECTED]> To: "Bernd Jagla" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, March 02, 2004 3:14 PM Subject: Re: no one can log on any more The database server becomes unresponsive to new threads? What is the result of the following

Re: no one can log on any more

2004-03-02 Thread vpendleton
The database server becomes unresponsive to new threads? What is the result of the following equation? key_buffer_size + ( (read_buffer_size + sort_buffer_size) * max _connections ) ... Is this larger than you physicall memory? >> Original Message << On 3/2/04, 2

Re: bookings

2004-03-02 Thread Kevin Waterson
This one time, at band camp, Mark Maggelet <[EMAIL PROTECTED]> wrote: > I don't know how you're charging weekly rates, but you could just > check if daysbooked>=7 and knock a percentage off total. I was thinking of having each day of a period charged as the weekly period rate divided by 7. But t

Re: Mysql 4.1.1 crashes

2004-03-02 Thread vpendleton
Did you run a stack trace? >> Original Message << On 3/2/04, 9:02:15 AM, "Nisim," Lior <[EMAIL PROTECTED]> wrote regarding Mysql 4.1.1 crashes: > hi > My server crashes on sub qurey , can any one help ? > ---

Re: no one can log on any more

2004-03-02 Thread Bernd Jagla
The system is working fine. There is no error message when logging on from the command line. You just don't get to the prompt. On the web you obviously get a time-out error. We are running 4.0.12-standard-log I guess the substring function doesn't make any use of temp tables etc since it is workin

Re: bookings

2004-03-02 Thread Gerald Taylor
Kevin Waterson wrote: I am (trying) to make a booking systems. Currently I have a table with 3 timestamps that record bookingDate, bookingFromDate and bookingToDate I have another table that records 'seasons'. This table contains two timestamps that record seasonStartDate and seasonEndDate also I h

Re: no one can log on any more

2004-03-02 Thread vpendleton
What error message, if any is thrown when someone attempts to log in when the two queries are running? Is the system as a whole performing slowly? What version of MySQL are you running? >> Original Message << On 3/2/04, 1:37:34 PM, Bernd Jagla <[EMAIL PROTECTED]

Mysql 4.1.1 crashes

2004-03-02 Thread Nisim, Lior
hi My server crashes on sub qurey , can any one help ? --- 040302 16:32:20 mysqld started 040302 16:32:20 InnoDB: Started; log sequence number 0 60169 /tmp/mysql/mysql_4.1.1/bin/mysqld: ready for

Re: bookings

2004-03-02 Thread Mark Maggelet
here's a quick and dirty way to do it: 1) make the seasons table look like this: dayofyear int season enum('winter','spring','summer','fall') rate decimal(5,2) 2) populate 'seasons' with 1-366 for dayofyear and the corresponding season and daily rate. 3) to get the total rate do a query like:

Re: Dream MySQL Server?

2004-03-02 Thread colbey
I'd go with raid 1+0 ... Be a shame to have that much cpu power and become I/O bound.. This way you've got 4 disks feeding the cpu's instead of 2.. Better performance than raid 5, and only 2 more disks than your current config. On Tue, 2 Mar 2004 [EMAIL PROTECTED] wrote: > > > > > I have a requ

RE: Load Data and Timestamps

2004-03-02 Thread vpendleton
Correct, the timestamp field will be updated if the value is not specified. But, the value is being specified by the empty string. You can try specifying the columns you want and see if this forces MySQL to auto populate your timestamp fields. >> Original Message <<<

Re: no one can log on any more

2004-03-02 Thread Bernd Jagla
table: text_data type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows 133856002 Extra: Using where No temp tables created, no i/o problem, no swapping. B - Original Message - From: <[EMAIL PROTECTED]> To: "Bernd Jagla" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]>

RE: Load Data and Timestamps

2004-03-02 Thread Boyd E. Hemphill
Mark: I am not familiar with timestamp, but you may need to explicitly specify a NULL value in the timestamp column for the loader. Hope this helps Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. Life is not a journey to the grave arriving safely in a well preserved body, but ra

RE: Who can help the Newbie???

2004-03-02 Thread Boyd E. Hemphill
Rand: I think you referring to the MySQL command line program. Download MySQLCC from the site, install it and fire away. It is a bit unstable at times, but it is a nice tool IMHO. If you want to learn DOS (do your mean Unix?) then try Sam's publishing. I have had good luck with the xxx in 21 d

Re: no one can log on any more

2004-03-02 Thread vpendleton
Can you post the explain plan? I would be interested to see if temp table tables are being created or if the system is swapping or if the the temp tables are so large that the entire system begins to act poorly. >> Original Message << On 3/2/04, 12:35:20 PM, Bern

RE: Load Data and Timestamps

2004-03-02 Thread Mark Riehl
Sorry for the confusion, maybe I wasn't clear in the question. I reread my post and thought it might be misunderstood. The data in my CSV file isn't all zeros, but the timestamp column in my table is all zeros. According to the timestamp docs, auto update of the first timestamp column occurs if

Who can help the Newbie???

2004-03-02 Thread Randal
I am very new to this database thing. I don’t want to clog up the board with all the basic questions that I need answered. I have been cataloging contact info and other things in MS Excel for years. I am familiar with the base concepts of a database; I think, but I have no idea what goes on in a

Re: Load Data and Timestamps

2004-03-02 Thread vpendleton
An invalid datetime, or in your case, an empty value, will be set to the nearest zero value representation. >> Original Message << On 3/2/04, 1:06:50 PM, Mark Riehl <[EMAIL PROTECTED]> wrote regarding Load Data and Timestamps: > All - I'm running MySQL 4.0.13 u

Re: Dream MySQL Server?

2004-03-02 Thread Mark Maggelet
> Scanning a PC manufacturer's website, it seems easy to get 4x2.5GHz > Xeon, 1Mb L3, 8Gb ram, dual 15000 rpm Scsi with Raid 1 (for > performance as well as reliability). > > Does this sound balanced for a MySQL engine? Or what would other > people advise? I think you're better off with 4hd's and

Load Data and Timestamps

2004-03-02 Thread Mark Riehl
All - I'm running MySQL 4.0.13 under Red Hat 9. I've defined a table, and the last column is a timestamp type. +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+-

Re: Need help with ledger type query

2004-03-02 Thread charles kline
Boyd, Thank you very much for the design help... this is just what I am looking for, just wasn't clear how to best do it :) BTW, you can use a case statement to help with signing the number properly. I just discovered this the other day and am really tickled with it! I am not very experienced w

Hardware devices price-list

2004-03-02 Thread miguel
Response -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql vs. MySQL

2004-03-02 Thread David Quenzler
My machines have several mysql RPMs installed as part of a SuSE UL 1.0 base configuration. RPMs are all lowercase of the form 'mysql, mysql-client, mysql-devel, mysql-shared', etc. Upgrade RPMs are available as MySQL, mixed case, no longer all lowercase. Is this a cosmetic issue only, am I a

Re: no one can log on any more

2004-03-02 Thread Bernd Jagla
There are no indices on the new table. Top looks normal: approx 100-150% usage (out of 800% [8 cpus]) There is no major i/o problem: sar -d says that less than 2% of io are used. The only problems in this direction might be connected with memory and the associated parameters in mysql. The file sys

RE: Need help with ledger type query

2004-03-02 Thread Boyd E. Hemphill
Charles: I am not quite sure by what you mean, " How do I get it to show me as I like, one in and one out per line, rather then an in for every out and vice-versa?" It seems for your example below you want a result set of 4 rows I don't think your design is appropriate, however your suggestion a

Re: no one can log on any more

2004-03-02 Thread vpendleton
When the queries in question are running, what does top look like? With an insert that large it may be beneficial to disable any keys that may be active on the target table and re-enable them after the data has been loaded. >> Original Message << On 3/2/04, 12:08

Re: Need help with ledger type query

2004-03-02 Thread vpendleton
If you are wanting a checkbook like display then each entry is either a debit or credit and each is on its own line. Your query will display this. I would add an ifnull to display a zero when the the debit/credit is null. >> Original Message << On 3/2/04, 10:50:1

Re: no one can log on any more

2004-03-02 Thread Bernd Jagla
An explain on the select statements reveals that no index is used and that all 133856002 rows are searched. Do you think that using a new index would make much of difference? I think it has something to do with some system/mysql parameters that can be adjusted. I also don't understand why no one e

Re: no one can log on any more

2004-03-02 Thread vpendleton
What does the explain plan reveal? >> Original Message << On 3/2/04, 9:05:17 AM, Bernd Jagla <[EMAIL PROTECTED]> wrote regarding no one can log on any more: > Hi there, > I have some weird sql statements that seem to eat up all resources from > mysqld. > Once I

The employee

2004-03-02 Thread miguel
Empty -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Need help with ledger type query

2004-03-02 Thread charles kline
Hi all, I have 3 tables: tbl_users id | user --- 1 | charles tbl_ins id | in |date|user 1 | 100.00 |timestamp |1 2 | 50.00 |timestamp |1 tbl_outs id | out|date|user

Re: complicated select statements and out of memory errors

2004-03-02 Thread Sasha Pachev
Bernd Jagla wrote: Hi there, I have some rather complicated sql statements that seem to eat up all resources from mysqld. Once I have two of them running at the same time no one can log on any more. Simple queries involving distinct get a out of memory error. We have tried changing the index buf

Re: bookings

2004-03-02 Thread Sasha Pachev
Kevin Waterson wrote: I am (trying) to make a booking systems. Currently I have a table with 3 timestamps that record bookingDate, bookingFromDate and bookingToDate I have another table that records 'seasons'. This table contains two timestamps that record seasonStartDate and seasonEndDate also I h

Re: memory issue: paging, disk activity, table size -> was: optimizing a select statement

2004-03-02 Thread Sasha Pachev
Karthik Viswanathan wrote: Thanks for the information. Before I try to further look into the query, I would like to know if there is some memory issue. Its strange since the speed for executing same query differs. Its a Mac G5 with just 1GB ram. I could see lot of pageouts in the top command. Th

Re: Inserting and Grant users

2004-03-02 Thread Michael Stassen
Andre MATOS wrote: Hi, I insert a new user to access the MySQL database. I have 4 databases plus the mysql database. I want that this user can run the select instruction just into one database, so I did this: [prompt]$ mysql u root p Welcome to the MySQL monitor. Commands end with ; or \g. Yo

re digest

2004-03-02 Thread Joseph McNamara
how do I get the digest form instead of individual emails? - Do you Yahoo!? Yahoo! Search - Find what you’re looking for faster.

Re: Inserting and Grant users

2004-03-02 Thread Victoria Reznichenko
Andre MATOS <[EMAIL PROTECTED]> wrote: > Hi, > > I insert a new user to access the MySQL database. I have 4 databases plus > the mysql database. I want that this user can run the select instruction > just into one database, so I did this: > > [prompt]$ mysql u root p > Welcome to the MySQL moni

Re: Remove a RPM Installation

2004-03-02 Thread Egor Egorov
"Rafael Diaz Valdes" <[EMAIL PROTECTED]> wrote: > > Please how can I remove a RPM installation. I used = > MySQL-server-4.1.1-1.i386.rpm to install MySQL, but how can I delete it. > rpm -e MySQL-server-4.1.1-1.i386.rpm -- For technical support contracts, goto https://order.mysql.com/

Re: Working around Insert ... Select

2004-03-02 Thread Egor Egorov
"Boyd E. Hemphill" <[EMAIL PROTECTED]> wrote: > I am attempting to move two columns of data into a large table by using > the insert into . select . construct. My problem is that I need to > join to the table I am inserting to. To get around this my idea is to > create a temporary database and p

Re: Query cache and queries with non-english characters

2004-03-02 Thread Egor Egorov
"G B U" <[EMAIL PROTECTED]> wrote: > Recently I've come around that mysql (4.1.0 at least) treats different > queries containing non-english characters (in my case characters from > cp1251 charset) as the same query and therefore returns wrong results. > For example the following queries are regard

From me

2004-03-02 Thread miguel
Cya -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Working around Insert ... Select

2004-03-02 Thread Michael Stassen
Perhaps I'm misunderstanding what you want, but could you create your temporary table as the result of your construct, then insert it into your table? If I'm reading you correctly, I think that would involve less data in the temporary table, so might be faster overall. Something like: CREA

Inserting and Grant users

2004-03-02 Thread Andre MATOS
Hi, I insert a new user to access the MySQL database. I have 4 databases plus the mysql database. I want that this user can run the select instruction just into one database, so I did this: [prompt]$ mysql u root p Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection

Re: Xserve G5

2004-03-02 Thread Brett Harvey
> Has anyone had any experiences running MySQL on a Xserve G5 with Macintosh OSX? We are thinking of purchasing some new hardware to run our MySQL server. The > 64-bit architecture is something we would like to take advantage of. I've had great success running it on my 4-year old Mac laptop

no one can log on any more

2004-03-02 Thread Bernd Jagla
Hi there, I have some weird sql statements that seem to eat up all resources from mysqld. Once I have two of them running at the same time no one can log on any more. Simple queries involving distinct get a out of memory error. We have tried changing the index buffer size from 256M to 2G, no cha

Re: Remove a RPM Installation

2004-03-02 Thread Curtis Maurand
rpm -e Curtis On Tue, 2 Mar 2004, Rafael Diaz Valdes wrote: > > Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to > install MySQL, but how can I delete it. > > -- -- Curtis Maurand mailto:[EMAIL PROTECTED] http://www.maurand.com -- MySQL General Mail

Re: Optimising LIMITs

2004-03-02 Thread Sasha Pachev
Richard Davey wrote: Hi all, I have what is probably a quite standard question and would love to know how you would all approach this scenario: I have a table in a database that has approx. 190,000 records in it. The table is currently 128MB in size and I'm happy that it is well constructed with n

RE: Remove a RPM Installation

2004-03-02 Thread Bob Cohen
> Please how can I remove a RPM installation. I used > MySQL-server-4.1.1-1.i386.rpm to install MySQL, but how can I > delete it. shell> rpm -e MySQL-server-4.1.1-1 should do the job, assuming that "MySQL-server-4.1.1-1" is the correct name. You can verify the package name by typing shell> rpm

excuse me!!!!

2004-03-02 Thread Rafael Diaz Valdes
Excuse me, I think that my email server have a problem, -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Remove a RPM Installation

2004-03-02 Thread Rafael Diaz Valdes
Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to install MySQL, but how can I delete it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Remove a RPM Installation ( OVER KILL ) ( OVER KILL ) ( OVER KILL ) ( OVER KILL ) ( OVER KILL )

2004-03-02 Thread danegron
rpm -e MySQL-server-4.1.1-1.i386.rpm Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to install MySQL, but how can I delete it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTEC

Re: Remove a RPM Installation

2004-03-02 Thread Christopher Ferry
rpm -ev for instance for below package rpm -ev MySQL-server-4.1.1-1 -Chris On Tue, 2004-03-02 at 09:09, Rafael Diaz Valdes wrote: > Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to > install MySQL, but how can I delete it. signature.asc Description: This i

Remove a RPM Installation

2004-03-02 Thread Rafael Diaz Valdes
Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to install MySQL, but how can I delete it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Remove a RPM Installation

2004-03-02 Thread jeffrey_n_Dyke
Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to install MySQL, but how can I delete it. -- if this was the exact package you installed with try rpm -e MySQL-server-4.1.1-1.i386.rpm you can also query for the installed packages with rpm -q mys

Re: Remove a RPM Installation

2004-03-02 Thread Richard Davey
Hello Rafael, Tuesday, March 2, 2004, 2:09:13 PM, you wrote: RDV> Please how can I remove a RPM installation. I used RDV> MySQL-server-4.1.1-1.i386.rpm to install MySQL, but how can I RDV> delete it. So far I have received 11 copies of this message - each has a unique "created" date so either my

Re: Xserve G5

2004-03-02 Thread Brent Baisley
I would have to agree, and I'm mostly a Mac person in a Mac shop. The controller chips that ship with the Opterons are optimized for that chip and the RAM they use. The throughput they can get is phenomenal. As far as I know, the XServer G5's aren't shipping yet, but will be soon. I don't think

Dream MySQL Server?

2004-03-02 Thread Alec . Cawley
I have a requirement for a system that is of the order of 8-10 times the size of my current system. Unfortunately (a) I don't know how many times larger it actually is, and (b) my current system, while very happy, even relaxed, on its current hardware, has not yet been subjected to the full rig

Re: Remove a RPM Installation

2004-03-02 Thread Victor Medina
POST only once to the list On Tue, 2004-03-02 at 10:09, Rafael Diaz Valdes wrote: > Please how can I remove a RPM installation. I used MySQL-server-4.1.1-1.i386.rpm to > install MySQL, but how can I delete it. -- |...| | _

Working around Insert ... Select

2004-03-02 Thread Boyd E. Hemphill
Hello to all: I am attempting to move two columns of data into a large table by using the insert into . select . construct. My problem is that I need to join to the table I am inserting to. To get around this my idea is to create a temporary database and populate it with the table then join to

  1   2   >