Re: Database Migration Path / Activity List?

2008-01-02 Thread Moon's Father
I know now how to reply to all mail list On Jan 2, 2008 9:53 PM, Luis Motta Campos <[EMAIL PROTECTED]> wrote: > Hey there > > I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24, > mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1 > Master + Slave Replication

Re: Performance problem with ~0.5 GB tabel

2008-01-02 Thread Markus Fischer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I've learned a bit about the environment this server is running in. It's VMware with root NFS and storage NFS mount points for MySQL. I've been told the throughput over NFS for my Server is from 20 to 30 MB/s. The server has 3GB ram. I'm not s

Re: Database Cleaner

2008-01-02 Thread David T. Ashley
Can you say "codefendant"? David T. Ashley [EMAIL PROTECTED] (This e-mail was sent from a handheld wireless device.) On Jan 2, 2008, at 5:20 PM, "Daevid Vincent" <[EMAIL PROTECTED]> wrote: Do it anyways. Release it as Open Source. IBM is big into the FO

RE: Database Cleaner

2008-01-02 Thread Daevid Vincent
Do it anyways. Release it as Open Source. IBM is big into the FOSS community, and I seriously doubt they will persue this. Just because they have a patent, you can always build a better mouse trap. You are allowed to improve upon an idea that is patented, or do it a slightly different way the pate

Re: problems with mysql 4.1+suse 10

2008-01-02 Thread Peter
mario henriquez wrote: > hi, i got a problemas in mysql with suse 10 enterprise server, the error: > > #1064 - You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use near '' > at line 1. > > when i treat to create a new d

problems with mysql 4.1+suse 10

2008-01-02 Thread mario henriquez
hi, i got a problemas in mysql with suse 10 enterprise server, the error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1. when i treat to create a new data base, appears this message. pleas

Re: Database Migration Path / Activity List?

2008-01-02 Thread Baron Schwartz
Hi Luis, On Jan 2, 2008 11:12 AM, Luis Motta Campos <[EMAIL PROTECTED]> wrote: > Baron Schwartz wrote: > > On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote: > >> Baron Schwartz wrote: > >>> What are the biggest changes you anticipate? I'd say they will be > >>> the version upgrade, converting to

Re: Sorting Tables

2008-01-02 Thread Victor Subervi
Ah, yes. Thank you. On Jan 2, 2008 11:51 AM, Baron Schwartz <[EMAIL PROTECTED]> wrote: > Hi, > > Try this: > > SHOW TABLES LIKE 'xyz%'; > > Baron > > On Jan 2, 2008 10:17 AM, Victor Subervi <[EMAIL PROTECTED]> wrote: > > Either I don't understand your reply or I miscommunicated. How do I do > tha

Embedding MySQL

2008-01-02 Thread Octavian Rasnita
Hi, I want to embed MySQL and install it with a freeware application I make. I hope it is legally to do this. Please tell me where can I found more information about how can I do this. The app will run under Windows. Thank you. Octavian -- MySQL General Mailing List For list archives: http

Re: Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
Baron Schwartz wrote: > On Jan 2, 2008 10:04 AM, Luis Motta Campos wrote: >> Baron Schwartz wrote: >>> What are the biggest changes you anticipate? I'd say they will be >>> the version upgrade, converting to InnoDB, and using >>> replication. It looks like you have planned well for all but >>> u

Re: Sorting Tables

2008-01-02 Thread Baron Schwartz
Hi, Try this: SHOW TABLES LIKE 'xyz%'; Baron On Jan 2, 2008 10:17 AM, Victor Subervi <[EMAIL PROTECTED]> wrote: > Either I don't understand your reply or I miscommunicated. How do I do that > when it is the tables that I want to select; that is *all* tables that are > called "xyz$variable", whe

Re: Database Migration Path / Activity List?

2008-01-02 Thread Baron Schwartz
Hi, On Jan 2, 2008 10:04 AM, Luis Motta Campos <[EMAIL PROTECTED]> wrote: > Baron Schwartz wrote: > > What are the biggest changes you anticipate? I'd say they will be the > > version upgrade, converting to InnoDB, and using replication. It > > looks like you have planned well for all but using

Re: Sorting Tables

2008-01-02 Thread Victor Subervi
Either I don't understand your reply or I miscommunicated. How do I do that when it is the tables that I want to select; that is *all* tables that are called "xyz$variable", where "variable" is unknown but all tables begin "xys$"? TIA, Victor On Dec 31, 2007 3:59 PM, mos <[EMAIL PROTECTED]> wrote:

Re: Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
Baron Schwartz wrote: > What are the biggest changes you anticipate? I'd say they will be the > version upgrade, converting to InnoDB, and using replication. It > looks like you have planned well for all but using replication. That's interesting. What kind of activities (besides configuration,

Inter-version client/server compatibility

2008-01-02 Thread Charles Jardine
To what extent can MySQL clients interact with servers of different versions? In particular, if I link an Apache PHP module with the client libraries for MySQL version 5.0.51, will I be able to use it to connect to a version 4.1.22 server? I ask this because I am running a web hosting service, a

Re: Database Migration Path / Activity List?

2008-01-02 Thread Baron Schwartz
Hi Luis, On Jan 2, 2008 8:53 AM, Luis Motta Campos <[EMAIL PROTECTED]> wrote: > Hey there > > I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24, > mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1 > Master + Slave Replication server, with InnoDB tables only,

Database Migration Path / Activity List?

2008-01-02 Thread Luis Motta Campos
Hey there I have a not-so-big (50GB, including indexes) database (MySQL 4.0.24, mixed MyISAM and InnoDB tables) that I need to migrate to a MySQL 5.1 Master + Slave Replication server, with InnoDB tables only, over a new hardware. Unfortunately, this is the first time I play a role as MySQL DBA,

Re: order by in query

2008-01-02 Thread Vladislav Vorobiev
2008/1/2, Edward Kay <[EMAIL PROTECTED]>: > > > > > Hello i use this query: > > > > select i.item_id > > from orders o > > INNER JOIN item i ON i.nr=i.nr > > Should the line above not be > ... ON i.nr = o.nr ? Autch. thank you! It works now. -- Best Regards Vlad Vorobiev http://www.mymir.or

Re: Backing up via slave

2008-01-02 Thread Ananda Kumar
Hi Martijn, Master will not have any information of SLAVE how r u doing this in you second step. "- check the master servers to find out the names/ports of their slaves" regards anandkl On 1/2/08, Martijn van den Burg <[EMAIL PROTECTED]> wrote: > > Hi Martin, > > > Hi folks, > > > > I have two My

RE: Backing up via slave

2008-01-02 Thread Martijn van den Burg
Hi Martin, > Hi folks, > > I have two MySQL servers running in a master-slave > configuration, and I want to set up a process for backing up > our application's data in which backups are sent to a server > at another location. Ideally, I'd like to do a full backup > once a week, and then incr

RE: order by in query

2008-01-02 Thread Edward Kay
> > Hello i use this query: > > select i.item_id > from orders o > INNER JOIN item i ON i.nr=i.nr Should the line above not be ... ON i.nr = o.nr ? > INNER JOIN user_cart u ON u.nr=i.nr > where (i.count !=0 or i.count!=NULL) and i.isactive=1 and i.kolWo>0 > order by i.count DESC > LIMIT 5 >

RE: Performance problem - MySQL at 99.9% CPU

2008-01-02 Thread Andrew Braithwaite
Hi, If you can follow this document: http://www.ufsdump.org/papers/uuasc-june-2006.pdf You should be able to figure out what's happening. Cheers, Andrew -Original Message- From: Gunnar R. [mailto:[EMAIL PROTECTED] Sent: Tue, 01 January 2008 23:31 To: mysql@lists.mysql.com Subject: Pe

RE: Performance problem - MySQL at 99.9% CPU

2008-01-02 Thread Eric Frazier
-Original Message- From: Per Jessen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 02, 2008 7:51 AM To: mysql@lists.mysql.com Subject: Re: Performance problem - MySQL at 99.9% CPU Gunnar R. wrote: > I am thinking about buying a new dual core box (with IDE disks?), but > I have to ma

Re: Performance problem - MySQL at 99.9% CPU

2008-01-02 Thread Per Jessen
Gunnar R. wrote: > I am thinking about buying a new dual core box (with IDE disks?), but > I have to make sure this really is a hardware issue before I spend > thousands of bucks. I think you've got an application problem somewhere which you should look into first. Hardware-wise I think you're d