Re: Problems with x86_64 mysql-standard-4.1.12

Pete Harlan wrote: Hi, and then it never comes back, presumably from the "auto_increment" test. If I run the auto_increment test alone (i.e., "./mysql-test-run auto_increment"), it fails in this same way. When it's hung, mysqld isn't using any CPU. Also.. CPU isn't the only thing you shoul

Re: Problems with x86_64 mysql-standard-4.1.12

Pete Harlan wrote: In addition to failing the tests, I deployed the server on Machine 1 for a while and it failed quickly, with a simple insert hanging up and "kill " being unable to kill it. (The thread's state was "Killed", but it didn't go away and continued to block other threads from acces

Re: Foreign keys - No action - Errors

My understanding is that RESTRICT and NO ACTION share the same behavior. http://dev.mysql.com/doc/mysql/en/innodb-foreign-key-constraints.html * |NO ACTION|: In |ANSI SQL-92| standard, |NO ACTION| means /no action/ in the sense that an attempt to delete or update a primary key

Foreign keys - No action - Errors

I have some problem with Foreign Key settings. I use MySQL 4.12, MySQL Query Browser 4.16 and Windows XP. Restrict and Cascade is Ok but when I try to set No action it wont work. Sometimes there is no error message and it seams that the change is saved. But when I check there is no changes. W

Any limit for MyODBC connections?

Hi, Is there any database login restriction for myODBC? meaning there is any upper limit of number of connections? Please help me in this. Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this mes

How to get the name of the last failed FK constraint

Hello, I have an InnoDB table running on MySQL 4.1.11 with multiple FK constraints. I'm accessing it via JDBC from Java. When an FK constraint fails with error 1216 I need to know which of the constraints failed. SHOW INNODB STATUS returns the following output ... CONSTRAINT `u_regis

Problems with x86_64 mysql-standard-4.1.12

Hi, MySQL is not getting very far through "make test" on 64-bit Debian, MySQL 4.1.12. I've tried precompiled and self-compiled, and on two different machines, both of which have been in use for a long time and both of which run MySQL 4.0 (and its tests) without a problem. On one machine:

db/mysql rookie request

MySQL guys: I am new to databases, MySQL, and anything outside of my world of UNIX system administration. A former colleague of mine set up MySQL on our backup server and I would like to interface with the database to get reports. I have read a little and understand a few things. I have taken t

RE: MYISAM MYI

Are the the FK on your largest columns? So if you have a char(255) and it's index - for each row added you will have added an additional 255 bytes added to your index as well as your data file. If you want to optimize a table use OPTIMIZE TABLE or myisamchk -r -S -a // when the server is off

MYISAM MYI

I have a MYISAM table that has both the MYD and MYI files growing at similar rates. We have this same database installed in other locations and the MYI file stays static but the MYD grows. From the docs I can see that the MYI file contains the index information. There are three foreign keys in t

Re: How to implement views in mysql 4.12 version

Hi, Waiting for v5 for views, you can prepare them in inline view (subqueries): select ... from (select ...) Mathias Selon Duncan Hill <[EMAIL PROTECTED]>: > On Monday 23 May 2005 20:01, Dayakar wrote: > > Please give me solutions at the earliest as mirgration from oracle to mysql > > is start

Re: MySQL give up on a query after a certain length of time

> Normally such different behavior for same queries is > weird. Do you use an official binaries or from Debian? I use those from Debian: http://packages.debian.org/testing/misc/mysql-server-4.1 Thanks, Jacob > Jacob Friis Larsen <[EMAIL PROTECTED]> wrote: > > >> Check with SHOW PROCESSLIST in w

Re: How to implement views in mysql 4.12 version

On Monday 23 May 2005 20:01, Dayakar wrote: > Please give me solutions at the earliest as mirgration from oracle to mysql > is started and i need to meet the solution as soon as possible. 4.1 does not support views. As documented in the online documentation: "Views (including updatable views) are

Re: How to implement views in mysql 4.12 version

At 0:31 +0530 5/24/05, Dayakar wrote: Hello, I want a solution to implement the views in mysql 4.12 version. It is urgent. Earlier our database was oracle and our search of database is done using views. I want to implement the same in mysql 4.12 version. Does any one know how to do it. Plea

Re: How to implement views in mysql 4.12 version

On Monday 23 May 2005 02:01 pm, Dayakar wrote: > I want a solution to implement the views in mysql 4.12 version. It is > urgent. Earlier our database was oracle and our search of database is done > using views. I want to implement the same in mysql 4.12 version. You need version 5.0.4.. http://de

How to implement views in mysql 4.12 version

Hello, I want a solution to implement the views in mysql 4.12 version. It is urgent. Earlier our database was oracle and our search of database is done using views. I want to implement the same in mysql 4.12 version. Does any one know how to do it. Please give me solutions at the earliest as m

Re: varchar to text

I think that is absolutely a bad idea. Not only are you splitting data that should logically be together, you will need to add three indexes and perform three searched to get at the data. You typical index only indexes from the start of the field, so even if you split the data, you can't do con

RE: varchar to text

After some thought into this, I believe that I may actually need to eventually "search" this field, and may need an index on it. After talking to others at the office, they think that maybe I should try and create three varchar(254) fields and tie them together. Therefore I can have a larger des

RE: complicated query | no Sub query

Anoop kumar V wrote: > well - actually it might not be the last 2 days - i just want 2 of > the latest records for every task regardless of what date it is in > the table. Okay, now I think I understand what you need - and if I am correct, this looks like one of the m

vcc options not in documentation?

Ooops, it would help if I put in the error message Configuration: mysql - Win32 Debug Linking... mysqlclient.lib(mf_pack.obj) : error LNK2001: unresolved external symbol _my_access ../client_debug/mysql.exe : fatal error LNK1120: 1 unresolved externals E

vcc options not in documentation?

Having trouble building 5.0.x, 4.1.12 builds fine The very first program to link bombs, I'm thinking some dll is not registered, or a change in build directions between 4.1.x and 5.0.x the error is less than helpful, as I'm a dba not a programmer. Any sugestions? I can build 5.0.3, but not 5.

RE: complicated query | no Sub query

Anoop kumar V wrote: > 1. It returns data about only one id_secr_rqst - I want it to return > data about every id_secr_rqst in the table. So, if I understand you correctly (sorry, having a bad day), you want all records for the past two days? Assuming this, you could u

Re: 2 Joins in 1 Query

Cut and paste bites me again. The portion (cut out accidentally) should have been: FROM Weeks w LEFT Bookings b on WEEK(b.Booking_Start_Date) = w.Week_Number LEFT JOIN Projects p ON p.Project_Id = b.Project_ID sorry all! Shawn [EMAIL PROTECTED] wrote on 05/23/2005 12:20:05 PM:

Re: complicated query | no Sub query

Thanks Peter - but I see two issues: 1. It returns data about only one id_secr_rqst - I want it to return data about every id_secr_rqst in the table. 2. Limit IMO is mysql specific (I hope I am wrong) is there something generic so I dont need to bother about which database I am running it again

Re: 2 Joins in 1 Query

"shaun thornburgh" <[EMAIL PROTECTED]> wrote on 05/23/2005 10:18:29 AM: > Hi, > > The following query produces the number of bookings per project grouped by > week: > > SELECT WEEK(Booking_Start_Date) AS "WEEK", > SUM(IF(B.Project_ID = "23", 1,0)) AS `Project A`, > SUM(IF(B.Project_ID = "42",

Here is your documents.

The message cannot be represented in 7-bit ASCII encoding and has been sent as a binary attachment. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 2 Joins in 1 Query

In article <[EMAIL PROTECTED]>, "shaun thornburgh" <[EMAIL PROTECTED]> writes: > Hi, > Unfortunately that doesnt work, I need to LEFT JOIN Bookings to Weeks > but keep the current join on Projects there as well, any ideas? So what you would need is something like that: Weeks LEFT JOIN (Bookings

Here is your documents.

The message cannot be represented in 7-bit ASCII encoding and has been sent as a binary attachment. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Changing DB name

Hello. Similar question was asked before. Search in archives. For example see: http://lists.mysql.com/mysql/173781 [EMAIL PROTECTED] wrote: > Is there a way to change the name of a database? What has happened is = > that > our test db has now become the production db and so I want t

Re: MySQL give up on a query after a certain length of time

Hello. Normally such different behavior for same queries is weird. Do you use an official binaries or from Debian? Jacob Friis Larsen <[EMAIL PROTECTED]> wrote: >> Check with SHOW PROCESSLIST in what state your query hangs. > > It hangs while sending data. I only ask for 7 rows, and

Re: Query Issue on Large DB

Hello. > records) takes a long time and drains memory to the point I have to > reboot the system. Here is the status after a single large query is What version of MySQL do you use? I'm not familiar with msyslog, so what queries takes such long time? In what state does the weird queries

Re: Problem connecting to 4.1 server

Hello. You may compile MySQL from source by yourself with enabled debugging, if an official binaries don't include it. See: http://dev.mysql.com/doc/mysql/en/windows-source-build.html I suggest you to forward your message to win32 list: http://lists.mysql.com/win32 Nicholas

Re: Wide eyes

Critters wrote: > Is a table with say 5,000,000+ records possible? Certainly. I've got some sideline app that's currently working it's way through about 15mill rows. I think it takes up about 3Gb diskspace for the moment. > What are the things to look out for with this amount of data? Not m

RE: complicated query | no Sub query

Hi Anoop Try: SELECT t1.id_secr_rqst, t2.name_rec_type, t1.dt_aud_rec FROM isr2_aud_log t1, isr2_aud_log t2 WHERE t1.id_secr_rqst = t2.id_secr_rqst AND t1.name_rec_type='Exception Resource' ORDER by t1.dt_aud_rec DESC LIMIT 2; Peter Normann -- MySQL General Mailing List For list archives:

RE: 2 Joins in 1 Query

shaun thornburgh wrote: > Unfortunately that doesnt work, I need to LEFT JOIN Bookings to Weeks > but keep the current join on Projects there as well, any ideas? Sorry, Shaun. I misunderstood what you were trying to accomplish first. How about something along these lin

complicated query | no Sub query

hi All, I need to create a query using no subqueries as I use 4.0.23 which does not support subqueries. I cannot upgrade for some compellimg reasons (the product does not support anything later than 4.0.23nt as of now). I also cannot use any thing that is native to mysql - in the sense that the

RE: 2 Joins in 1 Query

Hi, Unfortunately that doesnt work, I need to LEFT JOIN Bookings to Weeks but keep the current join on Projects there as well, any ideas? From: "Peter Normann" <[EMAIL PROTECTED]> To: "'shaun thornburgh'" <[EMAIL PROTECTED]>, Subject: RE: 2 Joins in 1 Query Date: Mon, 23 May 2005 17:13:42 +

RE: 2 Joins in 1 Query

shaun thornburgh wrote: > SELECT WEEK(Booking_Start_Date) AS "WEEK", > SUM(IF(B.Project_ID = "23", 1,0)) AS `Project A`, > SUM(IF(B.Project_ID = "42", 1,0)) AS `Project B` > FROM Bookings B INNER JOIN Projects P USING (Project_ID) > WHERE B.Booking_Type = "Booking" > AND

Re: Wide eyes

Thankyou very much, at this stage we just wanted to know it *can* be done. Thanks again -- David Scott - Original Message - From: "Jay Blanchard" <[EMAIL PROTECTED]> To: "Critters" <[EMAIL PROTECTED]>; Sent: Monday, May 23, 2005 3:39 PM Subject: RE: Wide eyes [snip] Is a table with

RE: Wide eyes

[snip] Is a table with say 5,000,000+ records possible? What are the things to look out for with this amount of data? Could the database be split over several database servers? Is there anywhere on the mySQL site about "huge databases"? [/snip] Yes. We have several tables with well over 100 mil

Wide eyes

Hi The company I work for is putting together a quote for a site, the client has wide eyes and is proposing 5,000,000 users and other large figures for elements which we intend to use MySQL for. So the questions: Is a table with say 5,000,000+ records possible? What are the things to look out f

Changing DB name

Is there a way to change the name of a database? What has happened is that our test db has now become the production db and so I want to rename the database. Chris Hood  -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

2 Joins in 1 Query

Hi, The following query produces the number of bookings per project grouped by week: SELECT WEEK(Booking_Start_Date) AS "WEEK", SUM(IF(B.Project_ID = "23", 1,0)) AS `Project A`, SUM(IF(B.Project_ID = "42", 1,0)) AS `Project B` FROM Bookings B INNER JOIN Projects P USING (Project_ID) WHERE B.Bo

Re: varchar to text

Hi, I we can, one should ask if it is a good solution ? text can't be indexed as a varchar. You will need full-text indexing, or a b-tree index on a length-limited : mysql> create index titi on toto2(t); ERROR 1170 (42000): BLOB/TEXT column 't' used in key specification without a key length mysql>

Re: varchar to text

You can safely change varchar to text, since they are the same data type. ALTER TABLE table_name CHANGE field_name field_name TEXT But, as always, make sure you have a recent backup. There is always the possibility that your computer will crash in the middle of the operation due to a stray ga

RE: varchar to text

Changing types to larger shouldn't be an issue. If you are changing to smaller, of course you are going to truncate the data more. You do not need to move the data out and then back in again unless you really want to. mysql> ALTER TABLE tbl_name CHANGE `col1_old_name` `col1_new_name` text default

varchar to text

Hello, I created a table that uses a varchar(254) size field, and found out that the customers data is being truncated. It needs to be larger. Currently there are about 500 records (it is a description field) in the column. Upon reading the docs, it looks like I need to use a "text" type column.

Re: Access to MySQL from Linux command line

Export as CSV. MySQL command line client. Run a script with LOAD DATA INFILE. Chris On 5/23/05, Andrew Dixon - MSO.net <[EMAIL PROTECTED]> wrote: > Hi Adam. > > I need to get all the data. > > Andrew > > > Adam wrote: > > >Drew, > > > >That's vague. Specifically what do you want from th

Re: Access to MySQL from Linux command line

Hi Adam. I need to get all the data. Andrew Adam wrote: Drew, That's vague. Specifically what do you want from the Access database (e.g. schema, data, etc.)? A-

Access to MySQL from Linux command line

Hi All. Does anyone know of any tools to convert a MS Access file to MySQL from the Linux command line? Thanks. Andrew

Re: MySQL give up on a query after a certain length of time

> Variables are net_read_timeout and net_write_timeout : I don't think I can use net_read_timeout to timeout a query. "Net Read Timeout: The time required in seconds to wait for more data from a connection before aborting the read." Jacob -- MySQL General Mailing List For list archives: http://l

ANN: Database Workbench 2.7.1 released

Features and fixes: http://www.upscene.com/news/20050523.htm Database Workbench supports: - Borland InterBase ( v4.x - v7.x ) - Firebird ( v1.x ) - MS SQL Server/MSDE ( v6.5, 7, 2000, MSDE 1 & 2 ) - MySQL 4, 4.1 - Oracle Database ( 8i, 9i, 10g ) If you experience any problems with this new version, d

Re: MySQL give up on a query after a certain length of time

Hi, forget previous email, Variables are net_read_timeout and net_write_timeout : mysql> show variables like '%timeout'; +--+---+ | Variable_name| Value | +--+---+ | connect_timeout | 5 | | delayed_insert_timeout |

Re: MySQL give up on a query after a certain length of time

Hi, in the conf one use minus "-", in the command line it's generally underscore "_". the variables should be network_timeout Mathias Selon Jacob Friis Larsen <[EMAIL PROTECTED]>: > On 5/20/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > There is a variable called --network-timeout ! You c