Lock Wait Timeout Problem

Hi, I have 1 SP that does INSERT and UPDATE query to 1-2 tables. It runs ok for sometime, but i sometime got this error message: "ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction" The message would ussually dissapear and the SP runs well for sometime until the same er

RE: Re: How to find size of my database

> 1) I'll assume you use myisam tables, as your version is kinda outdated. > 2) I'll assume you want the total DISK space required for your > database. (could be rows, could be tables, could be space used by the > rows and tables, all of those are different, different storage engines > use space d

Optimizing mysql client/server interactions

Hi All, Our current setup has the mysql server and the client app run on the same host. We are using mysql++ (ports/mysql++-1.7.9) for the database client api. The application returns huge data sets in the order of 50K. When we do a show processlist most of the threads spend their time in th

ndbd --initial startup issues in mysql cluster

hi, i am trying to install a cluster. i am facing issues in starting up the ndbd. My configuration is as follows. *Config.ini:* [NDBD DEFAULT] NoOfReplicas=2 [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] [TCP DEFAULT] # Section for the cluster management node [NDB_MGMD] # IP address of the management n

Re: Streaming LOB Data

Hi! On Apr 29, Robert DiFalco wrote: > Thanks Sergei, it's nice to know for sure. Do you know if there is any > documentation on how memory is used to store LOB data? For example, is > it a percentage of the total buffer pool size or is it allocated from > available memory un-allocated to the buff

RE: Getting the previous months documents

Ok, a little more clear: $query = "SELECT * //Change tempdate to the table name of your board document table FROM `tempdate` //Change temptext to the field name of the date in your board doc table WHERE CONCAT(SUBSTRING(temptext, 7, 2),SUBSTRING(temptext, 4, 2), SUBSTRING(temptext, 1, 2)) < '06

Re: Re: Re: Re: How to find size of my database

Thanks Daniel,Rhino for the wounder full explanations given.I will work on finding the size of my databases with answers given by you. Regards, Shivaji. On Wed, 03 May 2006 Rhino wrote : >Daniel de Veiga has already answered you on how to determine the size of your >database by using the file

RE: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

I haven't personally done a store locator, but... Store locators are relatively crude, yet useful. It is unlikely that exacting math will make one less crude in such a way as to make it significantly more useful. They usually just display a list of locations that *might* be convenient, and that's

Possible show databases bug with many databases

Hi, we've had a strange problem with mysql for quite some time which could not be solved so far. The problem is with servers with a lot of databases (10.000+) If one connects to mysql and issues a show database this will take ages and eat up 100% cpu. It does not matter if you connect as roo

Re: HELP --- Slow SP

Guys, So many thanks for you kind help. I was able to find the culprit, just adding 1 index i can get as fast as 30 thousands record per hour. So that I can proccess 2 million data in about 4 days only. But now, after my main tables loaded with more than 2 million data (2,9 million), i have an

Should I upgrade to 4.1 or 5.0 (Newbie level question)

MySQL Mailing List, Currently I'm running MySQL 4.1.15 on my home computer where I do web development, and MySQL 4.1.13-beta on my hosting service. Actually, I do work on web sites that are hosted on many hosting services, but on only one of them do I have enough access to decide for myself if

Re: Have You Seen My CV?

Anago Chima wrote: Tired of spam? Yahoo! Mail has the best spam protection around Oh the irony. -- Rob Munsch Solutions For Progress IT -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Have You Seen My CV?

__ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to move the MySQL data directory?

Specify the data dir in the local my.cnf and be sure your instance uses it by starting it with the --defaults-file parameter set to that instance's local copy. Regards, Paul -Original Message- From: Yves Goergen [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 3:11 PM To: Dan Buettne

Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?

On 2006-05-02, at 08:51, The Nice Spider wrote: Wow, impressive pseudonym...Are you strong enough to be my man? ;-} DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null ...AND the_reader IS a_fool. Hell and damnation! SQL POETRY! :-} This task is

RE: Streaming LOB Data

Anyone know for sure if the memory needed to insert a LOB is a percentage of the system's available memory or if it is allocated from the innodb_buffer_pool_size? IOW, how should my configuration settings be modified to allow the insertion of larger blobs? :) -Original Message- From: Rober

Re: How to move the MySQL data directory?

On 02.05.2006 22:24 (+0100), Dan Buettner wrote: > The easiest way might be to tell mysql in the config file where to > look for the data directory. > > In your my.cnf file (typically /etc/my.cnf) under the [mysqld] section: > > datadir = /Volumes/mysql-data/data One of the main problems with a

Re: Re: Re: How to find size of my database

Daniel de Veiga has already answered you on how to determine the size of your database by using the file system and simply looking at the size of the physical files in your database. Another possibility is that you could use the SHOW TABLE STATUS command in MySQL. If you go to your MySQL promp

Re: Fixing Databases When Replication Is Enabled?

On 5/2/06, Atle Veka <[EMAIL PROTECTED]> wrote: On Mon, 1 May 2006, Kishore Jalleda wrote: > On 5/1/06, Robinson, Eric <[EMAIL PROTECTED]> wrote: > > I ran mysqlcheck against a replication master database and it reported a > > problem with a table, which it corrected. Is the slave now out of syn

Re: Re: How to find size of my database

On 2 May 2006 20:33:56 -, Shivaji S <[EMAIL PROTECTED]> wrote: Hi Rhino, Thanks for the input. I mean to say the total Database Size ,that is to see my current Database Size.I am using 4.0.20 version Hmm, as generic as your first post. I'll just assume a lot of things in order to try a

Re: Re: Re: How to find size of my database

  Hi Rhino, sorry ,for my unclear reply. the size i meant is in KB or MB.. Regards, Shivaji On Wed, 03 May 2006 Rhino wrote : >You still haven't said what you mean by "size"! > >Let me put it to you this way: what units would be used in the answer you >want? In other words, would the answer

Re: Re: How to find size of my database

You still haven't said what you mean by "size"! Let me put it to you this way: what units would be used in the answer you want? In other words, would the answer look like: 1. 234,000 KB? 2. 2.75 million rows? 3. 321 tables? Or something else altogether? -- Rhino - Original Message -

Re: Fixing Databases When Replication Is Enabled?

On Mon, 1 May 2006, Kishore Jalleda wrote: > On 5/1/06, Robinson, Eric <[EMAIL PROTECTED]> wrote: > > I ran mysqlcheck against a replication master database and it reported a > > problem with a table, which it corrected. Is the slave now out of sync? > > If so, how do I correct the problem without

Re: Re: How to find size of my database

Hi Rhino, Thanks for the input. I mean to say the total Database Size ,that is to see my current Database Size.I am using 4.0.20 version Regards, Shivaji On Wed, 03 May 2006 Rhino wrote : >It would be easier to help if you specified what you meant by "size". > >Do you mean the amount of spa

Mysql add multiple index

Mysql, Is there any difference between alter table test add index(id, lastname); alter table test add index(zip5, zip4); and alter table test add index(id, lastname), add index(zip5, zip4); The test table has 90 millions records. Thanks. -- MySQL General Mailing List For list archives: ht

Re: Calculate LONG/LAT from ZIP+4 (positve vs. negative longitude)

On 2006-04-26, at 20:53, Nicolas Verhaeghe wrote: Also, in order to do the Zip+4 translation, you need a good CASS certification script. Most of these products are expensive. You could program your own, but from talking to a programmer who created such a product, it takes years to come with a g

Re: How to move the MySQL data directory?

The easiest way might be to tell mysql in the config file where to look for the data directory. In your my.cnf file (typically /etc/my.cnf) under the [mysqld] section: datadir = /Volumes/mysql-data/data Dan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

Re: MySQL JDBC Problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Dyego Souza Dantas Leal said the following on 5/2/2006 2:58 PM: > I have a problem using the latest version of Connector/J > > > the DESC of table shows: > > mysql> desc tiposelo; > ++-+--+-+-+

Re: How to find size of my database

It would be easier to help if you specified what you meant by "size". Do you mean the amount of space the database is using on your hard drive? Or the number of tables in the database? Or the number of rows in the tables? Or somethng else altogether? You should also mention which version of M

How to find size of my database

Hi, is there any command to find the total size of mysql db. Regards, Shivaji.

How to find size of my database

Hi, is there any command to find the total size of mysql db. Regards, Shivaji.

MySQL JDBC Problem

I have a problem using the latest version of Connector/J the DESC of table shows: mysql> desc tiposelo; ++-+--+-+-++ | Field | Type| Null | Key | Default | Extra | ++-+-

Re: How to move the MySQL data directory?

Well, moving the datadir to the new MySQL 5.0.21 directory, messing around with all the stupid symlinks, it seems I have finally managed to delete that datadir... It was empty anyway, yet, but this is an extremely dangerous task. So I really need to move the datadir to a safe place, outside all tha

How to move the MySQL data directory?

Hello, I've just wanted to update MySQL 5.0 on my test machine that will be a productive server very soon. But upgrading MySQL like installing it after MySQL's guide brings a problem: I'd need to move the data directory to the new programme directory every time. So I want to move the datadir outsid

Re: How can I get my disk space back?

David, If you want to decrease the size of the ibdata files, you will have to restart the mysqld process. According to the manual (http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html) the only way is to: 1. Use *mysqldump* to dump all your |InnoDB| tables. 2.

Grant to some database question

I have a database 'DB1' and user 'user1'. How to allow this user to full access (read/write/create etc.) only to database 'DB1' and deny to other databases, including view its names? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Re: difference between mysql max version and non-max version

On 5/2/06, ashwini c.v <[EMAIL PROTECTED]> wrote: Can anybdoy please tell me the difference between mysql max version andthe non-max version? Also lemme know how the max version is helpful if the installation of mysql on the clinet machine is to be done easily wihout any hassals and minimal hu

Re: Fixing Databases When Replication Is Enabled?

My Sincere apologies, I intented to mean mysqlcheck but somehow came out as myisamchk :) Kishore Jalleda On 5/2/06, Marciano <[EMAIL PROTECTED]> wrote: How myisamchk can write to binlog if the server need to be down? - Mensagem Original De: "Kishore Jalleda" <[EMAIL PROTE

Re: sorting with php/mysql

Ross, This is my database. Nope, it's a table, not a database. ..I will use the item_id for the order but what if I want to change item_id 3 to item id 1? A primary key shouldn't be edited, and the literal value of an auto_increment column oughtn't to be relevant. If you really need a settabl

RE: Finding duplicates, etc.

> -Original Message- > From: Peter Brawley [mailto:[EMAIL PROTECTED] > Sent: Monday, May 01, 2006 16:55 > To: Dirk Bremer > Cc: mysql@lists.mysql.com > Subject: Re: Finding duplicates, etc. > > Dirk, > > >I would like to know where there ar duplicate accounts that > do not have > >dupl

RE: innodb file per table

> > but you don't know __when__ innodb_file_per_table was set! > > So it's possible that many innodb tables actually reside in ibdata > > [1-4]. > > Check your data directory to see the individual innodb files/tables > > (*.ibd). > > This is true, and even on a fresh install that has always had

I Have Problem with this Timestamp

Hi MySql Community, I put up a default null value TIMESTAMP on field type TIMESTAMP. Now I enter to the database as '-00-00 00:00:00' default for null value. From this on, I mapped it using hibernate with mysql-connector-java-3.1.6-bin.jar driver. I extract it but error occurred: Caused b

Re: How can I get my disk space back?

Barry <[EMAIL PROTECTED]> writes: > David Israelsson schrieb: >> I have a really simple (two tables, one relation) but big (~70 GB) >> innodb database containing rather dynamic data. After deleting lots >> of records from the tables, the innodb data files still take the same >> amount of disk spa

Re: How can I get my disk space back?

David Israelsson schrieb: I have a really simple (two tables, one relation) but big (~70 GB) innodb database containing rather dynamic data. After deleting lots of records from the tables, the innodb data files still take the same amount of disk space as before. What is the correct way of freei

How can I get my disk space back?

I have a really simple (two tables, one relation) but big (~70 GB) innodb database containing rather dynamic data. After deleting lots of records from the tables, the innodb data files still take the same amount of disk space as before. What is the correct way of freeing the disk space? The gene

sorting with php/mysql

This is my database...I will use the item_id for the order but what if I want to change item_id 3 to item id 1? How can I push all the items down one place? How can I delete any gaps when items are deleted. Say I delete item 2 how can I delted the gap and 'promote item_id 3 to item_id 2 CREAT

Re: difference between mysql max version and non-max version

Hi! ashwini c.v wrote: Can anybdoy please tell me the difference between mysql max version andthe non-max version? I answered this here on April 26. Also, please use exact terminology: A "version" is a two- or three-level numeric designator, like "4.1" or "5.0.21". "max" is a package, or (

difference between mysql max version and non-max version

Note: forwarded message attached. Yahoo! India Answers: Share what you know. Learn something new. Click here--- Begin Message --- Can anybdoy please tell me the difference between mysql max version andthe non-max version? Also lemme know how the max version is helpful if the installation o

RE: Getting the previous months documents

I did this, sorry for bad format. This will do it for you. SELECT CONCAT(SUBSTRING(temptext, 7, 2),SUBSTRING(temptext, 4, 2), SUBSTRING(temptext, 1, 2)) AS docdate FROM `tempdate` WHERE CONCAT(SUBSTRING(temptext, 7, 2),SUBSTRING(temptext, 4, 2), SUBSTRING(temptext, 1, 2)) < '060703' ORDER BY CONCA

Re: Killing MySQL connections on a specific interface from a specific host

I am not really sure why you would need this , but I am just throwing in a possible solution.. First I would say since you need to kill connections on a specific interface (eth0), It would be fair to assume that you have more than one interface, if thats the case and you don't have the "--bind

Re: Getting the previous months documents

My sql is not so great. The dates are entered through a dropdown box in the format dd/mm/ (uk date format) as a VARCHAR. I could use strrev and str_replace (PHP) to get it in the correct format but will the mysql query you send work on a VARCHAR which it is it present or will I have to ch

RE: Getting the previous months documents

You should start by using MySQL date as the standard for date: -MM-DD After that it is simple: SELECT * FROM documents WHERE doc_date<2006-05-02 ORDER BY doc_date DESC LIMIT 1; Othervise you could use MySQL function to take sub strings and create a field in the query that extract it as 06-05

Getting the previous months documents

I have a database that stores documents relating to meetings. They have all the usual stuff agenda, minutes etc. There are 3 paper types for each date agenda (1 only), minutes (1 only), and a bunch of general documents titled 'papers'. I need to display all the documents for a specific date whic

difference between mysql max version and non-max version

Can anybdoy please tell me the difference between mysql max version andthe non-max version? Also lemme know how the max version is helpful if the installation of mysql on the clinet machine is to be done easily wihout any hassals and minimal human intervension regards, Ashwini

Re: How to convert this DELETE command from MySQL 4.0.25 to 3.23?

The Nice Spider schrieb: Hi, This query running fine on 4.0.25 but when trying on 3.23 an error occurs. can one help me to find correct command for 3.23? Probably if you post the error message you get. -- Smileys rule (cX.x)C --o(^_^o) Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o) -- MySQL G