Have a look at mysqltuner. It reads the stats from a running mysql
instances and makes suggestions for what can be changed
http://blog.mysqltuner.com/
Gavin Towey wrote:
> Hi,
>
> This script might help with some tuning suggestions, run it after you have
> some production traffic running ag
Hi Shawn,
Thanks for your reply.
This is basically a marketing website for different products. The site will be
visited by the marketer and the customer.
Here is answer as you asked:
1) The customer and the marketer will visit only one database and they have no
right to create database by
Hi,
This script might help with some tuning suggestions, run it after you have some
production traffic running against your database.
https://launchpad.net/mysql-tuning-primer
Also you should enable the slow query log, so you can capture queries to be
optimized:
http://dev.mysql.com/doc/mysql/e
You have set the root password on your mysql server to root with this command
GRANT ALL PRIVILEGES ON petclinic.* TO r...@localhost IDENTIFIED BY
'root';
The IDENTIFIED BY clause of a grant sets the password.
You shouldn't run a system without a root password anyway.
Regards
John Daisley
Mobi
jeetendra.ran...@sampatti.com wrote:
Hi,
Will you plesae guide me ?
We are about to launch one website whose database is in MySQL. I am very exited
about the server setting specially about .cnf file.
I have below hardware and .cnf details. Will you please guide me is the .cnf file details suffic
At 03:00 PM 10/14/2009, James Dekker wrote:
Claudio,
Thank you for the tip... Unfortunately, I tried your suggestion and it
still didn't work!
mysqladmin -u root -p root
Enter password: (I entered root here)
mysqladmin: Unknown command: 'root'
When I tried it again (th
Fixed it!
Did the following:
mysql -u root -p
mysql> use mysql;
update user set password=PASSWORD("password") where User='root';
mysql> flush privileges;
mysql> quit
I am now able to login using my SequelPro MySQL client! :-)
Happy programming,
James
On Oct 14, 2009, at 1:00 PM, James De
Claudio,
Thank you for the tip... Unfortunately, I tried your suggestion and it
still didn't work!
mysqladmin -u root -p root
Enter password: (I entered root here)
mysqladmin: Unknown command: 'root'
When I tried it again (this time leaving the password as blank):
m
Add -p to your mysqladmin statement to change password and use 'root' as
password.
you wanted to give extra grants to root but you just set the password for
r...@localhost.
you don't need to grant anything to root, usually.
cheers
Claudio
On Oct 14, 2009 9:07 PM, "James Dekker" wrote:
Hello ther
Dear all,
Benetl, a free ETL tool for files using postgreSQL and MySQL, is out in
version 3.2.
You can freely download it at : www.benetl.net
This new version is now supporting Java SE 6 and using memory arguments
for JVM.
You can learn more about ETL tools at:
http://en.wikipedia.org/wik
Hello there,
I have been using MySQL 5 on my OS X Leopard based laptop for quite
some time now...
Didn't have a password set and my login was "root" on localhost.
Downloaded just now the Spring distribution was following the steps to
run the petclinic sample application.
Ran the followin
門田 祐輔 indexweb.co.jp> writes:
> 1. Does MySQL have lock option like Oracle's nowait or alternative way.
>acctually I'd not like to use innodb_lock_wait_timeout configuration.
>for some reasons...
I think that non-blocking queries are not supported by mysql driver natively.
--
MySQ
Kyong Kim gmail.com> writes:
> For sure all of our columns combined do not exceed 64K. We're using
> latin 1 character set.
> I don't think we would be running into the 8K limit on row length
> since the culprit seems to be data being inserted into VARCHAR(255)
> column.
Can you show us your "cr
What are the best MySQL GUI tools available at the moment, for example
SQLyog.
Thanks
Neil
I can think of no reason why this shouldn't work, My administrator
colleagues would probably beat me with 2x4's for handing them such a
delicate construct to maintain in production but it seems perfectly
feasible to me :-)
- michael dykman
On Wed, Oct 14, 2009 at 11:03 AM, Christian Meisinger
Brian,
You could spend a lot of time crawling through version release notes
looking for something which might refer to your issue, or you might
just upgrade to 5.0.86-0 which is the latest 5.0. There have been
close to 2 years worth of bug-fixes since 5.0.51a
- michael dykman
On Wed,
It is Innodb. but most of our other identical database deployments seem
to shutdown immediately, just not this one using the same image...
Since dirty buffers needs to flush out.
Thanks,
Dilipkumar
Database Engineering
Mphasis, an EDS company
phone: +91-44-6637 3167
mailto: dilipkumar.par...
I have mysql 5.0.51a running on a linux 2.6.26 box. The service my6sql
stop command fails and all that appears in the log or err log is the
following... what can I do to repair this?
091014 17:00:24guardian: instance 'mysqld' is running, set state to
STARTED.
091014 17:07:40The instanc
Hi guys.
Ok lets say i've 2 server running MySQL, NDB node and NDB manager on each.
Now I don't want to convert all tables to NDB instead I leave a few as
MyISAM.
Is it officially supported if I setup a master-master replication between
the two MySQL instances and add ignore entries for all NDB ta
mysqldump is by no means the fastest way to move data between systems.
For a bulk job of this magnitude, try this:
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
- michael dykman
On Wed, Oct 14, 2009 at 3:59 AM, Claudio Nanni wrote:
> We dumped a mysql 4.1.22 database using the mysqld
Hi,
Will you plesae guide me ?
We are about to launch one website whose database is in MySQL. I am very exited
about the server setting specially about .cnf file.
I have below hardware and .cnf details. Will you please guide me is the .cnf
file details sufficient to support current hardware.
Ini
We dumped a mysql 4.1.22 database using the mysqldump binaries from its
version,
We tried to import this in 5.0.82 and we have the error.
mysqldump Unknown command '\''.
It seems the the extended import (multiple inserts) is somewhere too big
since the single insert dump works but takes ages and
Lex Thoonen,all
> UPDATE `jos_content` SET `introtext` = replace(`introtext`," style=\"margin: 0px 0px 5px; padding: 0px; font-family: 'Trebuchet
> MS',Arial,Helvetica,sans-serif; font-weight: bold; line-height: 30px;
> font-size: 30px; color: #b4b4be;\">","")
>
> just gives me 0 results...
How
23 matches
Mail list logo
