Need help on mysql crashing.

2006-07-27 Thread myssr
Hi, My mysql is crashing. Below table has the values it logs in the .err file before restarting. I am using the large.cnf file. The parameters I have changed are below. Rest are default values. #for performance SSR log=/var/log/mysql-queries.log join_buffer_size=1M max_connections=300 query

Re: is INNER join so much slower than LEFT join ?

2006-07-27 Thread Ow Mun Heng
On Fri, 2006-07-28 at 07:08 +0100, C.R.Vegelin wrote: > But when I run it with INNER join is takes more than 2 hours !!! > In both cases the query applies to 9.571.220 rows matched with 0 changed. > Any idea why INNER join is so much slower ? Inner Joins joins everything, it's like a cartesian jo

is INNER join so much slower than LEFT join ?

2006-07-27 Thread C.R.Vegelin
Hi List, I have the 2 MyISAM tables using mySQL version 5.0.15-NT: Table countries: `ID` smallint unsigned NOT NULL default '0', `Code` char(2) default NULL, `Name` char(30) default NULL, ... PRIMARY KEY (`ID`) Table data `Country1` smallint unsigned NOT NULL default '0', `Country2` smallint uns

Re: why size of table c united from table a and b are bigger than a+b ?

2006-07-27 Thread chylli
The default charset of c is utf8, and that of a and b is latin1. Maybe charset cause size of table increased? -- Thanks & Regards Chylli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: why size of table c united from table a and b are bigger than a+b ?

2006-07-27 Thread chylli
chylli <[EMAIL PROTECTED]> writes: > Chris <[EMAIL PROTECTED]> writes: > >> >> Because you're adding all columns from a and b into it. >> >>> It is too slow. Has anyone better methods to do that work? >> >> Drop the indexes on c and create them at the end. >> Each row that's being added, it's upda

Re: why size of table c united from table a and b are bigger than a+b ?

2006-07-27 Thread chylli
Chris <[EMAIL PROTECTED]> writes: > chylli wrote: >> I run following command : >> use db1; >> insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on >> (a.id=b.id); > > Do you have an index on a.id and b.id ? > >> size of table a and table b is: >> [EMAIL PROTECTED] ls -l ../db

Re: identify process that created the connection

2006-07-27 Thread Ravi Prasad LR
This blog may help, http://www.xaprb.com/blog/2006/07/23/how-to-track-what-owns-a-mysql-connection/ Cheers, Ravi Rithish Saralaya wrote: Hello people. Is it possible to find the process that invoked the mysql thread, given a mysql thread id? We have a web application that runs on Linux-Apa

Re: Mysqlcheck issues

2006-07-27 Thread Chris
Dirk Bremer wrote: I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM tables. I have an issue where occasionally an index (MYI) file becomes corrupted. I do not know why this occurs. To combat this issue, I tried running the following command every half-hour: mysqlcheck -Aamov --a

Re: allow access to all users within a network..

2006-07-27 Thread Chris
bruce wrote: hi... i'm trying to figure out how to allow all users on machines within my network access to a mysql db... i've tried: grant access all on *.* to '*'@'%' grant access all on *.* to '%'@'%' grant access all on *.* to @'%' with no luck.. What errors do you get when you try to

RE: Mysqlcheck issues

2006-07-27 Thread Logan, David (SST - Adelaide)
The trouble with myisamchk is that it requires the server to be offline. This may not be suitable. Do you have a bad area on the disk? The easiest way would be to stop the server briefly, rename the index thus keeping it occupying the potentially bad part of the disk and recreate the index. This w

Re: Mysqlcheck issues

2006-07-27 Thread Dilipkumar
Hi, Instead of mysqlcheck you can use myisamckh to recover the data's. As myisamchk -r -o *.MY* Thanks & Regards Dilipkumar - Original Message - From: "Dirk Bremer" <[EMAIL PROTECTED]> To: Sent: Thursday, July 27, 2006 8:32 PM Subject: Mysqlcheck issues I am using MySQL server 4.1.

Re: how to move datadir to a different file system

2006-07-27 Thread Dilipkumar
Hi, If the tables are not in use you can tar -cvzf filename.tar.gz the datadir and move it to the new server, but you should use the same mysql version. Thanks & Regards Dilipkumar - Original Message - From: "Bhartia, Saurabh" <[EMAIL PROTECTED]> To: Sent: Friday, July 28, 2006 3:16

Re: newbie..foreign key clarification

2006-07-27 Thread Chris
Grass Cake wrote: I'm still unsure about foreign keys..even after reading the doc file and Paul Dubois 3rd edition My doubt is...how much constraint is applied.( probably a bad explanation) If i have a table 'Customers' with the primary key being 'CustID' Then i have a table 'LastVisit' wi

newbie..foreign key clarification

2006-07-27 Thread Grass Cake
I'm still unsure about foreign keys..even after reading the doc file and Paul Dubois 3rd edition My doubt is...how much constraint is applied.( probably a bad explanation) If i have a table 'Customers' with the primary key being 'CustID' Then i have a table 'LastVisit' with a foreign key 'C

allow access to all users within a network..

2006-07-27 Thread bruce
hi... i'm trying to figure out how to allow all users on machines within my network access to a mysql db... i've tried: grant access all on *.* to '*'@'%' grant access all on *.* to '%'@'%' grant access all on *.* to @'%' with no luck.. thanks -bruce -- MySQL General Mailing List For li

Re: why size of table c united from table a and b are bigger than a+b ?

2006-07-27 Thread Chris
chylli wrote: I run following command : use db1; insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on (a.id=b.id); Do you have an index on a.id and b.id ? size of table a and table b is: [EMAIL PROTECTED] ls -l ../db1/a.* -rw-rw 1 mysql mysql 9230 May 10 15:41

Disable specific storage engines WITHOUT recompiling?

2006-07-27 Thread Michael Loftis
Hi, I know that bdb has --skip-bdb, and innodb has the ability to be disabled at startup but what about federated, csv, archive, etc? My problem is I don't want to recompile and I don't want to carry a different binary version in our local repository just for the one or two machines on which

Re: Adding Foreign Key Fails

2006-07-27 Thread Jesse
By that I hope you mean there is an index on confinvitems.InvDetID _and_ confinvdet.ID Yes, there is. Could be a record in confinvitems that has an InvDetID that doesn't exist in ConfInvDet. Check with something like: SELECT InvDetID FROM confinvitems WHERE InvDetID NOT IN (SELECT ID FROM Con

Re: MySQL With a HUGE Config

2006-07-27 Thread Chris
Dyego Souza Dantas Leal wrote: I have a Dell P2800 SERVER WITH: Red Hat AS 4 ( 64 bit machine) 6 GB of RAM Dual Xeon DUALCORE 2.8Ghz with 2MB of L2 Cache I will use MySQl 5.0 and InnoDB, exits a config to use all power of this server ? the developer guys can send-me a config ? There is a

how to move datadir to a different file system

2006-07-27 Thread Bhartia, Saurabh
Everything was installed under / file system ( linux ) need to move all existing databases also to new file system ( say /mysqldata ) Can I simply change in my.cnf and copy files to new location ? Thanks Saurabh

Re: Select query problem

2006-07-27 Thread Dan Bolser
Barry wrote: Nenad Bosanac schrieb: Hi I have one problem that i can`t resolve. still need advice or is it solved? IF!!! you need IF!! :) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL With a HUGE Config

2006-07-27 Thread Dyego Souza Dantas Leal
I have a Dell P2800 SERVER WITH: Red Hat AS 4 ( 64 bit machine) 6 GB of RAM Dual Xeon DUALCORE 2.8Ghz with 2MB of L2 Cache I will use MySQl 5.0 and InnoDB, exits a config to use all power of this server ? the developer guys can send-me a config ? Heikki , you can send - me a config too ?

Re: Replication vs. Clustering

2006-07-27 Thread Brent Baisley
It's important to read the "How much RAM" part if you are running any version lower than 5.1. In 5.0 and lower clusters store all information in memory, which can be a very limiting factor. My experience with replication is that it is fairly quick, in seconds at most rather than minutes. One ty

MySQL Connector/J 5.0.3 Has Been Released

2006-07-27 Thread Mark Matthews
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, MySQL Connector/J 5.0.3 a new version of the Type-IV all-Java JDBC driver for MySQL has been released. This is the first generally-available, production release of Connector/J 5.0. Notice that Connector/J 3.1 has supported all MySQL-5.0 features

Re: Newbie

2006-07-27 Thread Peter Brawley
Naser, Md Abu wrote: Hi All, I am very new. I wish to do some exercise before I go to real business. Could anyone advise me any tutorial link or resources for beginner? Some tutorials are listed at http://www.artfulsoftware.com/dbresources.html. Also you might want to look at http://www.a

Newbie

2006-07-27 Thread Naser, Md Abu
Hi All, I am very new. I wish to do some exercise before I go to real business. Could anyone advise me any tutorial link or resources for beginner? With best regards, Abu Naser School Of Life Sciences Heriot-Watt University Edinburgh EH14 4AS Email: [EMAIL PROTECTED] Phone: +44(0)13145182

Re: Adding Foreign Key Fails

2006-07-27 Thread mark addison
On Wed, 2006-07-26 at 08:58 -0400, Jesse wrote: > I am trying to add a foreign key to one of my tables. When I execute the > following SQL Code: > > ALTER TABLE `bpa`.`confinvitems` ADD CONSTRAINT `FK_confinvitems_1` FOREIGN > KEY `FK_confinvitems_1` (`InvDetID`) > REFERENCES `confinvdet` (`ID`)

RE: operation with alias

2006-07-27 Thread Jay Blanchard
[snip] i have a question, i want to do something like this select 10 as a, 1 as b, (a+b) as c; im want to get something like this a | b | c - 10 | 1 | 11 how can i do this... i want to do that becouse i get a big value from a sub big subquery, so i don't want to make again the su

operation with alias

2006-07-27 Thread obed
Hi all, it's me again jeje !!! i have a question, i want to do something like this select 10 as a, 1 as b, (a+b) as c; im want to get something like this a | b | c - 10 | 1 | 11 how can i do this... i want to do that becouse i get a big value from a sub big subquery, so i don't

why size of table c united from table a and b are bigger than a+b ?

2006-07-27 Thread chylli
I run following command : use db1; insert into db2.c select a.a, a.b, a,c, b.d, b,e ... from a left join b on (a.id=b.id); size of table a and table b is: [EMAIL PROTECTED] ls -l ../db1/a.* -rw-rw 1 mysql mysql 9230 May 10 15:41 ../db1/a.frm -rw-rw 1 mysql mysql 880880528 Jul 17 01

identify process that created the connection

2006-07-27 Thread Rithish Saralaya
Hello people. Is it possible to find the process that invoked the mysql thread, given a mysql thread id? We have a web application that runs on Linux-Apache-MySQL-PHP; and I sometimes see numerous mysql threads in sleeping mode when I run mytop. I think the sleeping mysql threads could be due t

Mysqlcheck issues

2006-07-27 Thread Dirk Bremer
I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM tables. I have an issue where occasionally an index (MYI) file becomes corrupted. I do not know why this occurs. To combat this issue, I tried running the following command every half-hour: mysqlcheck -Aamov --auto-repair --use-frm

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Brent Baisley
Do a "show status" and check on what mysql is doing. I would start by looking at: threads_created - if this is high, increase your thread_cache_size. This means MySQL is busy creating and destroying threads instead of reusing them. This can take a toll on the OS. Opened_tables - if this number

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread rouvas
On Thursday 27 July 2006 17:00, Martin Jespersen wrote: > I doubt apache is to blame. 5 seconds for a query on a website is > extremely slow, so if that is your "normal" results, then you have a > problem there already. I've been building database driven websites for > around 11 years and i don't t

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Miles Thompson
At 09:38 AM 7/27/2006, Ratheesh K J wrote: Hello all, Stuck up with a major problem. Urgent hlp required MySQL seems to be performing too bad during heavy load on the server. Queries which normally take around 5 secs to complete are taking more than 1000 secs to complete during load. What

Re: MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Martin Jespersen
I doubt apache is to blame. 5 seconds for a query on a website is extremely slow, so if that is your "normal" results, then you have a problem there already. I've been building database driven websites for around 11 years and i don't think i can remember a single time i went into production wit

RE: Replication vs. Clustering

2006-07-27 Thread Jimmy Guerrero
Hello, Your description is fairly accurate and we can boil it down even further... Replication is Asynchronous, Cluster is Synchronous, in regards to how data is replicated. Keep in mind that in Cluster, the MySQL Servers really only act as SQL interfaces for the data in the Cluster, it is the N

MySQL performing too badly under heavy load - urgent hlp needed

2006-07-27 Thread Ratheesh K J
Hello all, Stuck up with a major problem. Urgent hlp required MySQL seems to be performing too bad during heavy load on the server. Queries which normally take around 5 secs to complete are taking more than 1000 secs to complete during load. What could be the reason. Show processlist shows man

Replication vs. Clustering

2006-07-27 Thread Jesse
I think I know the difference, but wanted to make sure. What is the difference between Replication and Clustering? My understanding is that in Replication, changes made on the Master Server are downloaded to a Slave server periodically, and thus, the slave server is up-to-date within a few mi

Re: Need Restore Help

2006-07-27 Thread Jesse
I don't know why they renamed it again ?!? For better explanation and comparison take look here: http://www.mysql.com/network/compare.html http://www.mysql.com/products/database/ http://www.mysql.com/products Thank you. Those links were very helpful. I don't know why I can't seem to find anyt

Looking For How test database performans on different hardware

2006-07-27 Thread Vahric MUHTARYAN
Hello , I want to test Mysql , on Dual Intel Xeon 2MB Cache CPU and Dual AMD Opteron platforms for looking differents which one is better then other ! I found something but I want to asl to list , is there anybody have an experiance about this type tests ! Regards Vahric MUHTARYAN Sistem M

Re: Need Restore Help

2006-07-27 Thread Remo Tex
Jesse wrote: Strange it ran just fine here on my 5.0.22-nt with sample MyISAM table `alumni`... Is your table `alumni` MyISAM or Innodb? It is MyISAM. Here are few more pointers: 1. If it is possible *always* try latest version first when solving problems. In your case 5.0.22 I think... Y

Re: yum version 5.*

2006-07-27 Thread Duncan Hill
On Wednesday 26 July 2006 22:16, Karl Larsen wrote: > I am using Red Hat Fedora Core 4 and I wanted to yum mysql version 5 > of any other and find with Core 4 I can yum only mysql version 4. > > I imagine Core 5 might be able to yum mysql version 5 but not > certain of that. Is there a way