Re: Aborting a greedy querry from the command line

In the last episode (Jun 19), Chris White said: > On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: > > I've noticed that a Ctrl-C will also leave the query running > > (5.0.22 - Linux) and I've had to use the kill from mysqladmin or > > mysql client to get rid of it. > > Huh,

Re: geometry with MySQL-5.0

Hi, RE: > And finally, you can expect weird messages from mysqladmin. > E.g. mysqladmin --sort-index on the geometry table works for some I meant to say myisamchk, and not mysqladmin. Gaspar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

Re: sort-index on geometry always fails

Hi, John, RE:> > Seems like myisamcheck --sort-index does not work with spatial > > indexing? > or you have a disk error. I tried it on another computer, and -- unfortunately -- the same effect. Also tried it on the same computer, and different partition of the RAID-5 array. I kind of believe th

Re: geometry with MySQL-5.0

Hello Gilles, RE: > I am discovering the Spatial Extensions features of MySQL-5.0 > Is there a way to use a spherical geometry ? (instead of Euclidean) > like for navigation, or on sky coordinates,... As far as MySQL-5.0, I have not found any such feature. I believe it is available in the recent

QUERY

I and a friend have written SQL to big Oracle DB but not much to MySQL on our own computers. I find that there is a QUERY in the list for MySQL but it does nothing much. Also I was glancing through the mamouth MySQL reference manual and saw there are a bunch of tools that can be run outside

Re: FULLTEXT index help

Horst Azeglio wrote: I'm trying to do a MySQL Query but it doesn't work. MySQL version: 4.0.26 When I put only one argument in MATCH, it shows no error but doesn't return anything [quote] SELECT * FROM item WHERE MATCH (nom) against ('Huile');[/quote] or [quote]SELECT * FROM item WHERE MATCH (n

RE: MySQL Performance Question

Dan, thanks for your comments. I think we agree on how things should be configured. I'll keep the number of daemons to a minimum. The sample data I reported earlier is from an existing production system. The new system that we are deploying will be in a 2-node HA Linux configuration. Each node w

Re: Aborting a greedy querry from the command line

On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote: > Hi Chris, > > I've noticed that a Ctrl-C will also leave the query running (5.0.22 - > Linux) and I've had to use the kill from mysqladmin or mysql client to > get rid of it. Huh, that's odd, it should abort everything entirel

RE: Aborting a greedy querry from the command line

Hi Chris, I've noticed that a Ctrl-C will also leave the query running (5.0.22 - Linux) and I've had to use the kill from mysqladmin or mysql client to get rid of it. Regards --- ** _/ ** David Logan *** _/

Re: Aborting a greedy querry from the command line

On Monday 19 June 2006 04:02 pm, Scott Haneda wrote: > Sometimes I will issue something, slip of the fingers, and mysql will chew > on it for hours, the best I can do is control-z to get out of it and log > back in. But, I just learned these processes are still running, and I have > to go in and k

RE: Aborting a greedy querry from the command line

Hi Scott, mysqladmin can issue a kill from the command line. You will have to issue a mysqladmin -u etc. etc. processlist to get the process id from mysql and then you can issue a mysqladmin -u etc. etc. kill Regards --- ** _/

Aborting a greedy querry from the command line

Sometimes I will issue something, slip of the fingers, and mysql will chew on it for hours, the best I can do is control-z to get out of it and log back in. But, I just learned these processes are still running, and I have to go in and kill them by hand. Is there any easy way to abort from the co

RE: Alter table command don't work

I don't think you can do it prior to 4.1: http://dev.mysql.com/doc/refman/4.1/en/charset-general.html MySQL 4.1 can do these things for you: * Store strings using a variety of character sets * Compare strings using a variety of collations * Mix strings with different char

Finding records that do not exist

Mysql 4 still version: 4.0.18 I have users and transaactions, the key is user_id Somehow, a bunch of users were made, and there is a total lack of a transaction record at all. I need to fix this, which means finding the user_id's of those who are not paired with a transaction record. Thanks for

RE: Server Load Question

Dan, good guess! Yes, it's the same application for all customers and the two databases are reference information. Unfortunately, customers are running slightly different versions of the application and the reference information is slightly different as well. :-/ I think what I've decided to do is

Mysqlhotcopy / Perl / DBD::mysql on RHEL 4 x86_64

I'm running on a Xeon 3.8 under RHEL V.4. I wanted to try out mysqlhotcopy, but it says I need DBD::mysql. Cpan gets it for me, but make DBD::mysql dies with the below error. I am using 5.0.18 standard (MySQL-server-standard-5.0.18-0.rhel4). Attempting to install perl-dbd-mysql off the RPMS dir

Re: Server Load Question

Eric, I sent you a note about hardware this morning as well, but here's a further thought - Don't know if this is the case, but is this the exact same application served to 100 different customers? And are Database-2 and Database-3 the same for every customer? Some kind of reference info per

Re: Aborted clients status variable seems increasing -how to tune the server to reduce the same

Like I said, 5 seconds I thought was kind of low, but there may be a reason for it set that low. I would need to know more about how your application works to make a guess on a good setting. If your application is long running or spawns lots of threads, it may be that the timeout was set low to r

Re: Server Load Question

72K is a lot of tables. You might get clobbered by the OS trying to handle open files. Something you may need to tweak if you are running a Unix variant. As an aside, if I have a database with 500 tables, I would think of redesigning it. I would suggest looking into virtual servers. Each server

Re: Server Load Question

On Monday 19 June 2006 10:01 am, Robinson, Eric wrote: > Q: In terms of performance, is it better for each customer to have its > own instance of MySQL, each serving 3 databases, or is it better to have > one instance of MySQL serving 300 databases? > > --Eric Can you clarify a bit on instance? A

Server Load Question

I asked this question previously but didn't get much response so I'll try again. Our server will be home to 100 separate clients. Each client will have their own set of databases that will be accessed by 10-60 users at each client's site. Each client has 3 databases. Database-1: 500 tables. 13 t

Re: Weird error when creating a field

able in one of our databases. When we tried to save the field we get the error: Error on rename of "./DBNAME/TABLENAME.MYI" to "./DBNAME/#SQL2-210-174.MYI" (Errorcode: 13) Has anyone ever seen this before? Thanks, James __ NOD32 1.1607 (20060619) Informat

geometry with MySQL-5.0

Hello, I am discovering the Spatial Extensions features of MySQL-5.0 Is there a way to use a spherical geometry ? (instead of Euclidean) like for navigation, or on sky coordinates,... _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: ht

Re: Find rows in table A where table B = 'hello' AND table B = 'world'

David, How do I find all the tags that are tagged with the words "mysql" AND "databases" AND "tutorial"? If there are no url-keyword dupes in tbl_url_keyword ... SELECT u.urlid, u.url FROM tbl_url_keyword AS uk INNER JOIN tbl_url AS u USING (urlid) INNER JOIN tbl_keywords AS k USING (keywordi

Re: Find rows in table A where table B = 'hello' AND table B = 'world'

select a.urlid,a.keywordid,b.url,c.keyword from tbl_url_keyword a inner join tbl_url b on a.urlid=b.urlid inner join tbl_keyword c on a.keywordid=c.keywordid where c.keyword="mysql" or c.keyword="databases" or c.keyword="tutorial"; I think it´ll help you. "David Otton" <[EMAIL PROTECTED]> es

Re: error in copy data from mysql 4.1 to mysql 5.0 server

prathima rao wrote: hi,, the query is select sum(gtotal) from invoice this if i connect to 4.1 says 14000 but in 5.1 it says 0.00 why so is it because i copy data from 4.1 to 5.1 I don't know. Did you try exporting from 4.1 with mysqldump and running the dump script on the 5.1 server,

Find rows in table A where table B = 'hello' AND table B = 'world'

That's a lousy subject line, but I don't know how to describe this problem. I've been banging my head against this for a couple of days, and I'm certain there's a simple solution I'm missing. I've got a URL table, a keyword table, and a joining table, so each URL has a list of keywords applied

Re: Weird error when creating a field

James, that is a "permission denied" OS error. When you run an alter table command (adding a field) MySQL builds a new table alongside the old, then swaps them. Some file move/rename perations are associated with that. I would check that the mysql user on your system has full privileges on

Re: error in copy data from mysql 4.1 to mysql 5.0 server

Prathima, you'll have to provide a lot more detail about how you have copied the data from one database to the other before we can help you. What software are you using? What exact command? Any errors when you run it? Has it worked in the past? Have you updated anything lately? All this wi

Re: Weird error when creating a field

James Sherwood schrieb: Hello, Today we tried to create a new field on a table in one of our databases. When we tried to save the field we get the error: Error on rename of "./DBNAME/TABLENAME.MYI" to "./DBNAME/#SQL2-210-174.MYI" (Errorcode: 13) Has anyone ever seen this before? Thanks, Ja

Weird error when creating a field

Hello, Today we tried to create a new field on a table in one of our databases. When we tried to save the field we get the error: Error on rename of "./DBNAME/TABLENAME.MYI" to "./DBNAME/#SQL2-210-174.MYI" (Errorcode: 13) Has anyone ever seen this before? Thanks, James

Re: sort-index on geometry always fails

Gaspar Bakos wrote: Hi, I have a table that stores geometry information in one column in "point" type. After freshly uploading the table, myisamcheck --sort-index reports an error: - Sorting index for MyISAM-table 'TEST_I14_GEOM' myisamchk: Unknown error 126 myisamchk: error: Can't read key bl

Re: Join 2 tables using specific fields

Ow Mun Heng wrote: I have 2 table. Zones(Z1..Z20) and Radius(R0..R4) where R0 is equivalent to Z1 R1 " Z5 R2 " Z9 R3 " Z13 R4 " Z17 How can I make the query to join them in such ways? eg: select A,B,C,D from Zone inner join radius on R1 = Z5 on R2 = Z9 on R3 = Z13 on R4 = Z17 or do I have

Re: MySQL Performance Question

One reason you might be seeing a higher number of writes than reads is if MySQL is able to answer queries from the data it has cached in RAM, rather than having to read off disk. I would second Atle's opinion that this setup should be entirely possible with a single database daemon, especially

Re: error in copy data from mysql 4.1 to mysql 5.0 server

hi,, the query is select sum(gtotal) from invoice this if i connect to 4.1 says 14000 but in 5.1 it says 0.00 why so is it because i copy data from 4.1 to 5.1 rao - Original Message - From: "Peter Brawley" <[EMAIL PROTECTED]> To: "prathima rao" <[EMAIL PROTECTED]> Cc: Sent: Monday, Ju

Re: error in copy data from mysql 4.1 to mysql 5.0 server

prathima rao wrote: hello every one, i have two mysql servers one is the local server 4.1 and one is the centralised server 5.0 . i copy data from 4.1 to 5.0 through a option called copy database to another server/host - (drop table if exists) during this process i am not getting the same resu

error in copy data from mysql 4.1 to mysql 5.0 server

hello every one, i have two mysql servers one is the local server 4.1 and one is the centralised server 5.0 . i copy data from 4.1 to 5.0 through a option called copy database to another server/host - (drop table if exists) during this process i am not getting the same resule as i get in 4.1 ie

Re: Why would a SELECT COUNT(*)... WHERE... take way way longer than SELECT COUNT(primary_key)... WHERE... ?

Alex Arul wrote: count(*) is slow in innodb due to Multi Versioning. Which table type are you using ? Hi Alex, Thanks for answering; All tables are MyISAMs. I'm beginning to wonder if I am not taxed heavily for using floats for the geographic coordinates. -- MySQL General Mailing List F