Re: Re: Message

*** SECURITY WARNING *** Our email gateway has detected that your message to hdebruyne msgid=<[EMAIL PROTECTED]> may contain hazardous embedded scripting or attachments, or has has been rejected by our site security policy for some other reason. If you have a question, please reply to this notific

RE: unable to resolve hostname...

I have run into this countless times. The 'easiest' way to fix this is to set your hostname back to localhost, run the scripts/mysql_install_db, then change your hostname back to whatever you need it to be. I don't understand why it happens, I just know that is the 'easiest' way to fix it. J.R.

ANN: Advanced Data Generator, MySQL Edition, 1.0.3 released

Dear ladies and gentlemen, Upscene Productions is happy to announce a new beta of the database developer tool: "Advanced Data Generator" (version 1.0.3) A fast test-data generator tool that comes with a library of real-life data, presets and much more. This new release consists of four versions:

Font coloring

hi ,   i have some mysql tables in my mysql database . It is included "status" field . In the status field , it is maintainig "up" , "down" status. SO i want to add colors for this status. up = green down = red how can i do that ? can some body help me ..plz   thanx in advance curl

Re: Font coloring

> hi , > > i have some mysql tables in my mysql database . It is included "status" field . > In the status field , it is maintainig "up" , "down" status. > SO i want to add colors for this status. > up = green > down = red > how can i do that ? can some body help me ..plz I think this ques

C API Prepared Statements under Debugging mode in MySQL 5.0.0.

Hello MySQLians, As per debugging the sample C coding I have made some more changes and observed that the execution of all the C API is working fine, after complete execution the server become unstable and resetted. When I involved in debuging the C coding I found that it has allocated too much

InnoDB or MySQL error ?

The script of database are uploaded to: support.mysql.com/pub/mysql/secret The name is sqlreg_italo.sql.gz I'am testing with MySQL 4.0.18-pro on Debian Linux Box. Kernel 2.4 and 2.6 There is an error in MySQL optimizer !!! test: mysql> SET FOREIGN_KEY_CHECKS=0; Query OK, 0 rows affected (0.

Re: InnoDB or MySQL error ?

If there's a bug in the optimiser, you'll find it's in the "higher levels" of the codebase. InnoDB doesn't have any SQL optimisation code in it, so any bugs in this area aren't in InnoDB. Regards, Chris Dyego Souza Dantas Leal wrote: The script of database are uploaded to: support.mysql.com/

"explain" tree like structure? Code available? Examples?

Hi, I was wondering if there's a neat way to get the "explain" output in a tree-like structure so it can be visualized in an easy way. Is it possible to get it into a tree-structure at all? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL

Re: "explain" tree like structure? Code available? Examples?

Hmm The question is, does MySQL's optimiser do enough planing to result in a tree of any non-trivial interest? I love MySQL as much as the next geek with a significant other that loves dolphins, but I'm not sure that MySQL 4.0 would provide a lot of data for funky tree-drawing (MS SQL tool

Re: InnoDB or MySQL error ?

Dyego, http://www.mysql.com/doc/en/JOIN.html LEFT JOIN means an 'outer join'. I think it does NOT force the join order. STRAIGHT JOIN forces the join order. Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Ba

Re[2]: InnoDB or MySQL error ?

Heikki: Hi, I would like to explain what is going on with the straight_join when it is used with my database. Suppose the command bellow: explain select table1 left join table2 on A=B left join table3 on C=D where ID = 1; When it is executed on one of our servers, mySql uses

Re: Re[2]: InnoDB or MySQL error ?

Dyego, - Alkuperäinen viesti - Lähettäjä: "Dyego Souza Dantas Leal" <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Tuesday, March 02, 2004 3:09 PM Aihe: Re[2]: InnoDB or MySQL error ? > Heikki: > > Hi, > >I would like to e

[Stats] MySQL List: February 2004

-- Searchable archives for this list are available at -- ==

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

Remove a RPM Installation

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]

how can I remove a RPM installation

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

Hello! rpm -e MySQL-server-4.1.1-1 Best Regards! On Tue, 2004-03-02 at 10:08, 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. -- |...

Re: Remove a RPM Installation

> 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 -- Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[E

Re: Remove a RPM Installation

Please, do not post more than one time the same question On Tue, 2004-03-02 at 10:08, 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

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

Re: Remove a RPM Installation

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. -- |...| | _

Dream MySQL Server?

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: Xserve G5

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

Re: Remove a RPM Installation

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: Remove a RPM Installation

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

Remove a RPM Installation

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

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

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

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

Remove a RPM Installation

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]

excuse me!!!!

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]

RE: Remove a RPM Installation

> 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

Re: Optimising LIMITs

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

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

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 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: Xserve G5

> 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

Inserting and Grant users

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: Working around Insert ... Select

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

From me

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

Re: Query cache and queries with non-english characters

"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

Re: Working around Insert ... Select

"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: Remove a RPM Installation

"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: Inserting and Grant users

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 digest

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

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: memory issue: paging, disk activity, table size -> was: optimizing a select statement

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: bookings

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: complicated select statements and out of memory errors

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

Need help with ledger type query

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

The employee

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

Re: no one can log on any more

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

Re: no one can log on any more

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: Need help with ledger type query

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

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

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

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

mysql vs. MySQL

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

Hardware devices price-list

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

Re: Need help with ledger type query

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

Load Data and Timestamps

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: Dream MySQL Server?

> 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

Re: Load Data and Timestamps

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

Who can help the Newbie???

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

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

Re: no one can log on any more

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: Who can help the Newbie???

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: Load Data and Timestamps

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: no one can log on any more

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

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: Dream MySQL Server?

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: bookings

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:

Mysql 4.1.1 crashes

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: no one can log on any more

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]

Re: bookings

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

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: Mysql 4.1.1 crashes

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: bookings

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: no one can log on any more

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: no one can log on any more

- 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: Dream MySQL Server?

[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

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?

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

> 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: no one can log on any more

- 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: bookings

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

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: no one can log on any more

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

UNION

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: Dream MySQL Server?

[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

  1   2   >