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
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
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
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]
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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]
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 ?
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
-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
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
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
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`)
[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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
43 matches
Mail list logo