From: andrew.2.mo...@nokia.com andrew.2.mo...@nokia.com
To: nunziodav...@yahoo.com; mysql@lists.mysql.com
Sent: Wed, September 8, 2010 4:19:19 PM
Subject: Re: Replaying the mysqld.log file from production onto QA???
Try using a mysqldump.
- Reply message -
From: ext Nunzio
Hello all, I am trying to REPLAY the mysqld.log file from a production 5.1.4
server onto a QA server with 5.5 running and was wondering if there is an easy
way of replaying the mysqld.log file? Just want to make sure all of the kinds
of inserts, updates, selects and deletes work just as well
Hello, I have been asked to replay the traffic load we have on one of our
5.1.4X servers against a new 5.5 test server we are getting ready to put into
production as a stand alone. My question is that I have 6GB of mysqld.log BUT
how to I figure out how MUCH to play back at a given time and
Hello gurus, I am trying to install the perl-DBD-MySQL and each time I get this
error message. Any ideas? I have tried it on a Sun X4150 (Dual Quad Cored
Intel) and a Sun X4200 (Dual Dual Core Opteron) both on CentOS 4.8. I have
tried to install and build with MySQL 4.x on the box and then
Hello Gurus, I have a customer who wants to create a reporting server for his
management team. He wants to take server 1,2,3 and move the 3 databases from
all 3 servers to one server server 4 and then have the management team run all
the reports from server 4 since there are tons and tons of
Hi all, I have upgraded a few test boxes and everything seems to work fine BUT
I
wanted to verify with the gurus if my syntax is correct so as to avoid any
future problems ;-)
The purpose is to dump all databases and users / user privileges from our
4.1.20
server and import it into our
Hi all, I was reading a few of the notes on this forum from a few months back
and it seems that ONE WAY of upgrading from 4.x to 5.X with MyISAM only
databases is to copy the actual data folder from the 4.X version to a temp
place, then remove 4.x from the OS, install 5.X and then just put the
the data is in MyISAM, zero InnoDB :-)
Thanks again for the advice :-)
Nunzio
From: Keith Murphy bmur...@paragon-cs.com
To: Nunzio Daveri nunziodav...@yahoo.com
Sent: Mon, August 16, 2010 9:42:07 AM
Subject: Re: Is upgrading from 4.X to 5.X really that easy
From: Keith Murphy bmur...@paragon-cs.com
To: Nunzio Daveri nunziodav...@yahoo.com
Cc: mysql@lists.mysql.com
Sent: Mon, August 16, 2010 11:47:39 AM
Subject: Re: Is upgrading from 4.X to 5.X really that easy?
I would really recommend that you have a second server set up running
Hi all, I just installed the no-install version of mysql 5.1.44 on our RHEL 5
box AFTER I yum removed the older 4.X version. The question is how do I tell
RHEL to auto start and stop mysql when I have to reboot the server? I know
that
if you use an rpm or a yum it kinda / sorta created a
version.
Thanks...
Nunzio
From: Guifre Bosch Fabregas guifre.bo...@gmail.com
To: Nunzio Daveri nunziodav...@yahoo.com
Cc: mysql@lists.mysql.com
Sent: Thu, August 12, 2010 3:40:32 PM
Subject: Re: RHEL Auto Start / stop mysql???
hi Nunzio!
Sorry but my english
by manufacturer kinda like a upc code for their internal db.
Can't have dups and don't want to have non-used id's in the db.
Any help, direction is much appreciated.
TIA...
Nunzio
From: Michael Dykman mdyk...@gmail.com
To: Nunzio Daveri nunziodav...@yahoo.com
Sundar sundar.anir...@gmail.com
To: Nunzio Daveri nunziodav...@yahoo.com
Cc: mysql@lists.mysql.com
Sent: Tue, August 10, 2010 1:06:41 AM
Subject: Re: Dropping ALL indexes from a database / not just a table?
Hello Nunzio,
Instead of Dropping a index, you can disable the indexes and get the work
): 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
'PRIMARY' at line 1
mysql
Thanks again...
Nunzio
From: Michael Dykman mdyk...@gmail.com
To: Nunzio Daveri nunziodav
syntax to use near '' at
line 1
Any ideas??? I am wondering if it has something to do with the fact that
dbf_UID is a primary AND auto_increment?
TIA...
Nunzio
From: Michael Dykman mdyk...@gmail.com
To: Nunzio Daveri nunziodav...@yahoo.com
Cc: Anirudh
Hello Gurus, is there a way / script that will let me DROP ALL the indexes in a
single database? for example, lets say my database is call db_Animals, and
inside db_Animals there are 97 tables, is there a SINGLE command or a perl
script of some kind that can read all the MYI files, remove the
and re-architecting the db ;-)
Again...
Thanks for all of your feedback Gurus :-)
Nunzio
From: Steven Staples sstap...@mnsi.net
To: Nunzio Daveri nunziodav...@yahoo.com; mysql@lists.mysql.com
Sent: Thu, August 5, 2010 7:23:19 AM
Subject: RE: Moving from one MySQL
Hello Gurus :-) I was running a simple load generator against our 16GB Dual
Quad core server and it pretty much came down to it's knees within two hours of
running tests. The customer DOES NOT WANT to change any code, they just want
to
throw hardware at it since it took them a year to create
: Paul DuBois paul.dub...@oracle.com
To: Nunzio Daveri nunziodav...@yahoo.com
Cc: mysql@lists.mysql.com
Sent: Tue, August 3, 2010 12:09:05 AM
Subject: Re: Importing User credentials from mysql.sql file???
On Aug 2, 2010, at 3:57 PM, Nunzio Daveri wrote:
Hello Gurus, I just upgraded several MySQL
Hello Gurus, I just upgraded several MySQL 4.1 to 5.1 versions and also wanted
to know how to extract the user name, password and credentials from the
mysql.sql file (around 22 of them per server - have 8 servers total)? The
contract admin emailed me a sql file which is a dump of the default
Thanks Claudio but I do that all the time. The question is where is the file?
You said to go to the download area, there are hundreads of files and not one
tar file says rhel or cent os.
What is the URL / file name to download and untar please?
Thanks for responding :-)
Nunzio
Awesome, thanks for helping that's just what I needed :-)
Nunzio
From: Joerg Bruehe joerg.bru...@oracle.com
To: Nunzio Daveri nunziodav...@yahoo.com
Cc: MySQL General List mysql@lists.mysql.com
Sent: Fri, July 30, 2010 10:49:14 AM
Subject: Re: CentOS 4.8
Thanks again :-)
Nunzio
From: Joerg Bruehe joerg.bru...@oracle.com
To: Nunzio Daveri nunziodav...@yahoo.com; mysQL General List
mysql@lists.mysql.com
Sent: Fri, July 30, 2010 1:31:54 PM
Subject: Re: Indexes larger than RAM (was: Do you know who can answer
Hi All, I was running slamdb against one of our QA boxes and noticed that the
innodb database is 190Gb in size BUT the worrying issue is that the indexes are
30GB in size!!! When I hit this server hard, it tanks on memory but still
performs, slower of course ;-) Any suggestions on what I
Hello Gurus, I am trying to see if there is a no install version of MySQL
5.1.4X
for Cent OS 4.8? We got a copy for Solaris x86 and it works AWESOME, I cant
seem to find one for Cent OS? We wanted to install several flavors and test a
200 MB query script file against it to see how the
Hello Gurus, I just inhereted a Sun 2 U Server with 2 Intel Quad Core CPU's and
16 GB of ram. Here is the problem. The machine is constantly at 99% Memory
utilization and we get random row locking, we are only using InnoDB. The
database is around 150GB with over 5,000 tables. To make things
26 matches
Mail list logo