Mysql memory utilization

Hi list, We are facing memory problems for our application and to analyze memory utilization by application we require below information on mysql memory utilization. how much of RAM mysql is utilizing and amount of memory allocated for innodb buffer is utilizing ,how much of innodb buffer is

Re: Output to a file

Hi Payne. Payne wrote: Hey, been trying to output a select statment to a file, all the books I have only show how to input from a file, what is the correct way I thought I could do select * from my_toy >> `/tmp/my_toys` You can do 'select * into outfile from ;' But I get an error.

Re: Help on VB and ODBC

Hi Manuel, I had a similar problem a few months ago and I found 'somewhere' in the documentation a post by Matthew van Os on May 27 2005, saying: The CursorLocation should be of the type "adUseClient" instead of "adUseServer". The adUseServer returns a -1 as recordcount. The adUseClient retur

Re: Output to a file

Payne wrote: Hey, been trying to output a select statment to a file, all the books I have only show how to input from a file, what is the correct way I thought I could do select * from my_toy >> `/tmp/my_toys` But I get an error. Payne You can use the 'tee' command, eg: tee logfile.t

Output to a file

Hey, been trying to output a select statment to a file, all the books I have only show how to input from a file, what is the correct way I thought I could do select * from my_toy >> `/tmp/my_toys` But I get an error. Payne -- MySQL General Mailing List For list archives: http://lists.my

How to rename a DB

Hi, Anybody know how can i safely and easily rename a database in MySQL 5.0.19. Have tried some tips from google results (most of them are for MySQL 4.x) but no luck till now. Any help would be greatly appreciated. Rgds/Hardi

importing a dumpfile from with the mysql client

Hi. I recently imported a dumpfile into mysql4.1.18 I did this using the 'source' syntax from inside the mysql client. this is syntax I used: mysql>create database dbname; mysql>use dbname; -unset the creation of bin-logs in my.cnf mysql> SET SQL_LOG_BIN = 0 then some tips to fast import dump f

Re: mysqlmanager logging?

As it was already advised, check the dir/log file permissions. Also, it might help if you post your my.cnf here. Petr On Wed, 2006-04-19 at 13:17 -0500, Duzenbury, Rich wrote: > MySQL 5.0.20 > > I've got two instances running with mysqlmanager. I'm not getting any > logging of any sort. > > m

Slow query using between

Hello, I am running Ver 14.7 Distrib 4.1.12, for redhat-linux-gnu (i386) using readline 4.3 on a Dual Xeon 2.4Ghz RHEL4 box with 4GB of RAM. I have a query that takes anywhere from .25 - .85 seconds to run. Following are the query and the related table structures I have currently set up

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

>> 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. > DELETE FROM A USING A RIGHT JOIN B ON B.id = A.sectionid WHERE B.id is null error message on 3.23 is: You have

Re: query of a query?

Bing Du wrote: The following are Cold Fusion code. It's interesting that previously defined queries can be used as 'tables' to pull data from. === SELECT db_entry_num, title FROM account_info SELECT projectID

question about utf and collation

I'm sorry if this is not the apropriate list, but I couldn't fined any other list where this question would fit in. If someone know where to post it, please suggest. I have a question about collation and utf in mysql. I'm using mysql on several of my websites, but the mysql database doesn't h

Re: Mysql on Production Servers

thanks keith... Regards, shivaji >On Thu, 4 May 2006, Shivaji S wrote: >> >> To: [EMAIL PROTECTED], mysql@lists.mysql.com >> From: Shivaji S <[EMAIL PROTECTED]> >> Subject: Re: Mysql on Production Servers >> >> >> Keith Roberts thanks for the input ,i have few doubts on your reply. >> >> 1.wh

Re: Mysql on Production Servers

>On Thu, 4 May 2006, Shivaji S wrote: > > To: [EMAIL PROTECTED], mysql@lists.mysql.com > From: Shivaji S <[EMAIL PROTECTED]> > Subject: Re: Mysql on Production Servers > > > Keith Roberts thanks for the input ,i have few doubts on your reply. > > 1.when i am installaing rpm based files, should

query of a query?

The following are Cold Fusion code. It's interesting that previously defined queries can be used as 'tables' to pull data from. In MySQL, does the same functionality have to be implemented using join or subselect? === SELECT db_entry_num, title

Re: Mysql on Production Servers

Keith Roberts thanks for the input ,i have few doubts on your reply. 1.when i am installaing rpm based files, should my operating system contains the necessary files that are build on rpm packagei.e compilers,gccversions etc. 2.if i want to create more than one instance on my server with same

Re: ORDER BY making recordset non-updatable

Maybe I'm thick You have a view, called vwMyView. You SELECT rows from it, and you're able to update the view? Yet when you SELECT with an ORDER BY clause, you're not allowed to update the view? I just do not understand how a read statement affects DML. I think you're going to have to pos

Re: mysqlmanager logging?

Can the program write to /var/lib/mysql/mysqlmanager.log? check permissions. On 4/19/06, Duzenbury, Rich <[EMAIL PROTECTED]> wrote: MySQL 5.0.20 I've got two instances running with mysqlmanager. I'm not getting any logging of any sort. mysqlmanager --help shows:

Re: ldd "undefined symbol" error

I'd check to make sure you installed mysql-devel, which includes the libraries and header files. -Sheeri On 4/18/06, tuxlinsecure <[EMAIL PROTECTED]> wrote: Hi, I uninstalled Mysql 3.23 (tar.gz )and installed Mysql 5.0 (rpm) on my server. When I check shared lib dependencies using the follow

Re: can't make a backup of the database?

Not sure if you're still having this problem. But if MySQL can't open the file orders_pay_methods.InnoDB I'd check the permissions in the mysql datadir. -Sheeri On 4/18/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi, I'm trying to make an backup of a database and this is what I got: [EMA

Re: Index merge optimization (with OR) and table joins

On 5/4/06, sheeri kritzer <[EMAIL PROTECTED]> wrote: (again, apologies for the lateness...) MySQL has a cost-based optimizer. If it's deciding that a full-table scan is appropriate, there's a reason. If more than 30% (approx) of the table would be returned in a range query, the optimizer reaso

Re: Index merge optimization (with OR) and table joins

(again, apologies for the lateness...) MySQL has a cost-based optimizer. If it's deciding that a full-table scan is appropriate, there's a reason. If more than 30% (approx) of the table would be returned in a range query, the optimizer reasons that it's LESS expensive to just do a full table sc

Re: Effective-dating

I don't think I noticed the original post for this discussion when it first arrived - or maybe I did and mistook it for spam having to do with social dating ;-) - but I just saw Sheeri's reply and want to jump in if I may. Most professional databases in corporate environments that I have seen o

Re: Effective-dating

Coming to the table SOOO late. But this has special relevance as I'm working on an application that stores event dates and therefore will also need to solve this problem. The biggest question I have is "What will this be used for?" My first thought is to have at least 2 tables -- one table with

Re: Mysql on Production Servers

Well I would not bother with the source distro as it can take a while to compile, and possibly end up being slower than a pre-compiled version. Personally I would choose between the .tar.gz or the RPM versions. The RPM version is basically self-installing, and also installs the scripts to sta

Re: New to TRIGGER and CALL. Example gives errors.

(catching up on old mail) What version of MySQL are using? It works in 5.0.19 and 5.1.9-beta. If you're trying on a version < 5.0, it won't work. -Sheeri On 4/9/06, Daevid Vincent <[EMAIL PROTECTED]> wrote: I'm trying to follow the example in the manual to create a trigger: http://dev.mys

Mysql on Production Servers

Hi, I have doubt on Mysql download and installation 1.Which mysql download is better to install on production server rpm installation or binary installation or source installation 2.What are the difference between them. Regards, Shivaji.

RE: Fixing Databases When Replication Is Enabled?

I assume you are referring to this thread: http://lists.mysql.com/mysql/197528 If so, a very important question still stands: What version of MySQL are you using? MySQL replication uses the binary log (binlog) to pass update queries (INSERT, UPDATE, etc) to the slave; in other words it do

MySQL 4.1.19 has been released

Hi, MySQL 4.1.19, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not a

Adding a second slave and Load Data from master questions

Hi. im trying to add a second slave using load data from master ,and it seems to me that when i run this command on the new slave that its simply picking up from where the first slave is replicating from. Does this make sense? Also interesting is that when both the IO and SQL threads are No on

Coded fields

What is the best way to create a coded field? I want to do something similar to enumeration but I don't want to have to define the values at table creation time because sometimes the end-users need to add or remove the codes. I've been using char binary fields in my database to this point fi

Re: MySQL 5 Calculate Field query

In the last episode (May 04), Hendro Suryawan said: > Hi all, > I found something strange with calculate field query in MySQL 5. > > My base table structure like this : > CREATE TABLE `BrgIn2` ( > `Qty` decimal(10,3) NOT NULL default '0.000', > `

blank user names in user table

Hi all, I've got a database I recently inherited where there are a number of records in the mysql.user table that have no user id. According to the mysql docs, this is supposed to allow guest access, and there is mention of how to turn it off. How does one actually connect in guest mode? My att

Help on VB and ODBC

Hi everybody, Please I need help on this. I am beginning a new application. I am doing it with VB 6.0 - MySQL 5.0 - MyODBC 3.51 on Windows Is there any parameter i need to establish in order to be able to work with RecordSets in the Client side , actually i can't because if i d

RE: Q2. Is there anything could be done to speed up this query

Thank you Dan, I will try that. Mikhail Berman -Original Message- From: Dan Nelson [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 03, 2006 5:29 PM To: Mikhail Berman Cc: Chris White; mysql@lists.mysql.com Subject: Re: Q2. Is there anything could be done to speed up this query In the

InnoDB Memory Problem causing mysql to crash

Hi, I'm trying to resolve why InnoDB is crashing. It happened twice for the last month without obvoius reason Any help will be appreciated. Dobromir Velev My Server is Red Hat Enterprise Linux ES release 3 (Taroon Update 7) 2.4.21-32.0.1.ELsmp Dual 3.2 GHz Intel Xeon 8 GB RAM with 3 x 146GB SC

Re: Insert Select problem

Johan Höök schrieb: Hi Barry, see: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html you cannot insert into a table you're doing select on (same goes for update). But i am doing it on a test server version 5.x and it works like a charm :) -- Smileys rule (cX.x)C --o(^_^o) Dance for me!

Re: Insert Select problem

Hi Barry, see: http://dev.mysql.com/doc/refman/5.0/en/insert-select.html you cannot insert into a table you're doing select on (same goes for update). Regards, /Johan Barry skrev: I get this error: Fehler in /home/virtual/site4/fst/var/www/html/adminheaven/artikel-vererben-save.php in

Re: Add a new value in an ENUM by manipulate .frm

Barry wrote: Jörgen Winqvist schrieb: Hi, I need to add another value in an enum so "ALTER TABLE table1 MODIFY Status ENUM('a','b','c')" where 'c' is the new value. My problem is that the tables are VERY big and it would take days to alter them all. Tried it? I also use big tables but addi

Insert Select problem

I get this error: Fehler in /home/virtual/site4/fst/var/www/html/adminheaven/artikel-vererben-save.php in Zeile 36 mit Error: Query:INSERT INTO objektflyer_verknuepfung (av_o_id_haupt,av_o_id_link,av_text,av_op_id) SELECT 418,av_o_id_link,av_text,av_op_id FROM objektflyer_verknuepfung WHERE a

Re: Add a new value in an ENUM by manipulate .frm

Jörgen Winqvist schrieb: Hi, I need to add another value in an enum so "ALTER TABLE table1 MODIFY Status ENUM('a','b','c')" where 'c' is the new value. My problem is that the tables are VERY big and it would take days to alter them all. Tried it? I also use big tables but adding a field tak

Add a new value in an ENUM by manipulate .frm

Hi, I need to add another value in an enum so "ALTER TABLE table1 MODIFY Status ENUM('a','b','c')" where 'c' is the new value. My problem is that the tables are VERY big and it would take days to alter them all. So, i figure the values in enum:s are in the .frm file so why not change it and

MySQL 5 Calculate Field query

Hi all, I found something strange with calculate field query in MySQL 5. My base table structure like this : CREATE TABLE `BrgIn2` ( `PO` varchar(17) NOT NULL default '', `BrgId` int(10) NOT NULL default '0', `Qty`

Re: Table so slow to read

Gabriel Mahiques schrieb: My name is Gabriel, "Saludos Cordiales" is the same than "Best Regard" in spanish. The server explanin is the same. The table structure is the same, the application is the same (redirect the data source only), the quantity of record is the same. All is the same, I copy

Re: DATEDIFF and TIMEDIFF

Peter Lauri schrieb: Best groupmember, I run version 3.23.58 and need to use something similar to DATEDIFF and TIMEDIFF to calculate difference between two a timestamp and current_timestamp(). Is there any other function that is working for version 3.23.58 that do the same job? Best regards, P