Dear MySQL users,
MySQL Community Server 5.0.90, a new version of the popular Open Source
Database Management System, has been released. This Community release
shares the
version number with its MySQL Enterprise Server counterpart.
Please note that the active maintenance of 5.0 has ended,and t
Carlos - Follow the below steps
1) stop the mysqld service
2) copy the current datadir to your required location ex : D:\\datadirpath
3) Edit the my.ini by placing the option in mysqld section as
datadir=D:\\datadirpath
4) save the my.ini
5) start the mysqld service
It will use your new datadir a
And, IF the application uses the file a lot, but opens it infrequently, for
example an MySQL data file, then the incremental cost is truly neglectable.
IF the symlink is looked up and followed frequently then caches will make it
neglectable.
IF the application touches a wide range (hundreds of th
I don't agree, Don't have any specific documents but seems to make a bit of
sense to me.
Opening a file that is a symbolic link takes more time than one that isn't
as you need to do more operations. Search the directory for the symbolic
link, open it (probably, though an inode look up might be eno
Not a problem as you are doing it from a whole data directory.
Thanks
Suresh Kuna
MySQL DBA
On Fri, Jan 29, 2010 at 11:56 AM, Manasi Save <
manasi.s...@artificialmachines.com> wrote:
> Hi All,
>
>
> I am creating symlinks as database.
>
> I have mysql data directory created on /var/lib/mysql/dat
Hi All,I am creating symlinks as database. I
have mysql data directory created on /var/lib/mysql/databasename.on the same path I am creating /var/lib/mydatabaseand creating
symlink from /var/lib/mydatabase to
/var/lib/mysql/databasenamewill there any performance
issues as there will be quite a few
I remembered a coworker found an online resource that generated sample data
for you. I hit google and I think I found it:
http://www.generatedata.com/
I I found it on a list of resources for data generation:
http://www.webresourcesdepot.com/test-sample-data-generators/
I've never used any of
As Suresh and others said, you have to stop the dbms, move to content of
the dir and restart the dbms.
Also, if you have a fresh install, innodb tables will be saved on a
datafile inside the same data dir, but if is not a fresh install you may
have innodb variables (ie. innodb_data_home_dir) i
As Carlos said, mention your required path in the my.ini file and restart the
MySQL or move your current datadir to your required path and restart MySQL by
mentioning the variable as below in the configuration file.
Datadir=path
In MySQLD section of your cnf file.
Thanks
Suresh Kuna
MySQL DBA
-
Hi,
For Linux:*How to change the mysql database location*
1. Create the directory that will be the new datadir. ( example: /home/db
)
2. Change ownership of new folder to the mysql user and group: sudo chown
-R mysql:mysql /home/db
3. Stop the MySQL database server: sudo /etc/init.d
Krishna
I dont have any benchmark but you can take a look on the Cafepress
presentation that includes some data (or ask the authors for deep reference)
http://assets.en.oreilly.com/1/event/2/Horizontal%20Scaling%20with%20HiveDB%20Presentation.pdf
Carlos
On 1/22/2010 11:44 PM, Krishna Chandra
If I may recommend:
http://www.generatedata.com/#download
On 1/28/2010 8:11 PM, Carlos Proal wrote:
Google for "data generator", there are free and commercial solutions
available.
Carlos
On 1/28/2010 5:52 PM, Brian Dunning wrote:
Hey all -
I need a few million sample contact records - name
Absolutely, check for the variable "datadir" on the config file (my.ini
on windows and my.cnf on *nix).
Carlos
On 1/28/2010 9:12 PM, Lucky Wijaya wrote:
Hi all,
I've installed MySQL on 320GB Harddisk (partitioned into 3 partitions). I want
to know if there's a way to change MySQL default d
Hi all,
I've installed MySQL on 320GB Harddisk (partitioned into 3 partitions). I want
to know if there's a way to change MySQL default database directory from C: to
D:.
Thanks.
Google for "data generator", there are free and commercial solutions
available.
Carlos
On 1/28/2010 5:52 PM, Brian Dunning wrote:
Hey all -
I need a few million sample contact records - name, company, address, email,
web, phone, fax. ZIP codes and area codes and street addresses should be
Brian Dunning wrote:
> Hey all -
>
> I need a few million sample contact records - name, company, address, email,
> web, phone, fax. ZIP codes and area codes and street addresses should be
> correct and properly formatted, but preferably not real people or companies
> or email addresses. But th
On 1/28/2010 4:52 PM, Brian Dunning wrote:
Hey all -
I need a few million sample contact records - name, company, address, email,
web, phone, fax. ZIP codes and area codes and street addresses should be
correct and properly formatted, but preferably not real people or companies or
email addre
Brian Dunning wrote:
> Hey all -
>
> I need a few million sample contact records - name, company, address, email,
> web, phone, fax. ZIP codes and area codes and street addresses should be
> correct and properly formatted, but preferably not real people or companies
> or email addresses. But th
Hey all -
I need a few million sample contact records - name, company, address, email,
web, phone, fax. ZIP codes and area codes and street addresses should be
correct and properly formatted, but preferably not real people or companies or
email addresses. But they'd work if you did address vali
Doesn't Google run MySQL ?
Hmmm
On Thu, Jan 28, 2010 at 4:56 PM, Carl wrote:
> A quick Google turned up
>
>
> http://www.xaprb.com/blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/
>
> Man, I love Google.
>
> Thanks,
>
> Carl
> - Original Message - From: "Daevid V
A quick Google turned up
http://www.xaprb.com/blog/2009/03/13/50-things-to-know-before-migrating-oracle-to-mysql/
Man, I love Google.
Thanks,
Carl
- Original Message -
From: "Daevid Vincent"
To:
Cc: "'changuno '"
Sent: Thursday, January 28, 2010 5:49 PM
Subject: RE: 50 things to k
> -Original Message-
> From: John Meyer [mailto:johnme...@pueblocomputing.com]
> Sent: Thursday, January 28, 2010 2:16 PM
> To: mysql@lists.mysql.com
>
> On 1/28/2010 3:21 AM, changuno wrote:
> > Read a blog which states 50 things to know before migrating
> > from Oracle to MySQL. Any co
On 1/28/2010 3:21 AM, changuno wrote:
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
would it have been too much to just link to it?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Shawn Green wrote:
> 23. There are fewer and less sophisticated tools for administration.
>
> MySQL doesn't need them. That alone should tell you something about
> our reliability.
>
This speaks to simplicity-- both in terms of easy to use and in terms of
more limited features. It says nothing
Hello All,
I have an application that must be installed with a local mysql server . I
made a setup program to automate installation
which must be suitable for a layman. I tried googling all over but did not
find a suitable code in C++ to do any of :
1. Install a service
2. create a process
3.
From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De
Meersman
Sent: Wednesday, January 27, 2010 12:18 PM
To: Jerry Schwartz
Cc: shawn.gr...@sun.com; Daevid Vincent; Dan Nelson; mysql@lists.mysql.com
Subject: Re: Event feature already working in Server 5.1.37
On Wed,
changuno wrote:
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
... list snipped ...
MySQL was never designed to be a clone of Oracle (the database). We
have distinct differences in design and implementation that make us a
Yes: YMMV. Caveat emptor. Don't switch to a product you don't know.
If you need nothing that MySQL doesn't offer, it may be a good fit for you.
If you need features that it doesn't offer, it may not be a good fit for
you. News at eleven.
On Thu, Jan 28, 2010 at 11:21 AM, changuno wrote:
> Hi fo
For MyISAM that's not a problem (with some caveats if you wanna do it
online). For InnoDB you can't do that, but you can create a new database,
and rename from olddb.table to newdb.table.
On Thu, Jan 28, 2010 at 10:34 AM, Cui Shijun wrote:
> hi,
> Is there an easier way to change the name of a
Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
28-Jan-10
Complete Data Management and Analysis Suite for MySQL in dbForge Studio 4.00
Teaming up with the users, Devart launches a new version that re
Hi folks,
Read a blog which states 50 things to know before migrating from Oracle to
MySQL. Any comments on this?
1. Subqueries are poorly optimized.
2. Complex queries are a weak point.
3. The query executioner (aka query optimizer / planner) is less
sophisticated.
4. Performance t
CREATE TRIGGER sync_t
AFTER UPDATE ON table1
FOR EACH ROW
UPDATE table2
SET name = NEW.name WHERE id = NEW.id;
> i have two tables namely.. table1 and table2, table1 and table2 have the two
> columns samely like id and name, by using triggers i have to bring the
> updates in table1 to table2, if
hi,
Is there an easier way to change the name of a database other than mysqldump?
Can I physically move the database to another directory?( I've tried
and it works, at least it seems like it works)
Thank you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
i have two tables namely.. table1 and table2, table1 and table2 have the two
columns samely like id and name, by using triggers i have to bring the
updates in table1 to table2, if i updated name in table1 trigger has to made
the same up date for table2. please help me regarding this.
thnaks in adva
ANN: Database Workbench 3.4.3 released!
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular database development tools:
" Database Workbench 3.4.3 "
This release includes the Pro and Lite Editions.
Version 3.4.3 mostly includes bugfixes in addition to
35 matches
Mail list logo
