in
the mysql database?
If it isn't the same, is there a way to generate this [fix_priv_tables] script
outside of an actual upgrade, so that I could apply it myself?
-RG
Russell E Glaue wrote:
According to this page in the MySQL 5.0 Manual:
http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html
?
Is this [fix_priv_tables] script the same as the
share/mysql_fix_privilege_tables.sql script distributed with MySQL?
-RG
Russell E Glaue wrote:
I am upgrading minor MySQL versions, 5.0.67 to 5.0.84
I have a master-master replication setup, and want to upgrade both
installations.
The ideal procedure for upgrading
I am upgrading minor MySQL versions, 5.0.67 to 5.0.84
I have a master-master replication setup, and want to upgrade both
installations.
The ideal procedure for upgrading mysql using the mysql_upgrade command is to
have binary logging turned off during the execution of mysql_upgrade.
My situation
tables to be created on another partition.
I cannot think of another possible solution for your scenario.
-RG
Artem Kuchin wrote:
Russell E. Glaue wrote:
Hmm..,
I thought the temp tables were created in the temp directory.
What version of MySQL are you using?
5.1 latest
Perhaps you can
I have experienced this issue before. When I got the error, I just put
everything back in the data directory.
MySQL, somewhere in its code, expects the binlog index to be in the data
directory, even when we configure it to be elsewhere.
I think the regular binlogs can be stored elsewhere, but
Garris, Nicole wrote:
I'm a new MySQL DBA taking over admin duties for an existing MySQL
nonclustered 4.1 installation. It has 6 small user databases. So in the
mysql database, I run the query
Select host, user, password from user;
Which returns the following:
extra steps to copy back and forth from the temp directory.
-RG
- Original Message -
From: Artem Kuchin [EMAIL PROTECTED]
To: Russell E Glaue [EMAIL PROTECTED], mysql@lists.mysql.com
Sent: Sunday, December 9, 2007 9:03:45 AM (GMT-0600) America/Chicago
Subject: Re: How to auto repair db
Using Quota on Unix, you can specify a different quota soft_limit for temporary
space.
You can set MySQL to use /tmp as the temporary space, then set a soft_limit of
10mb and a hard_limit of 300MB.
This quota should be separate from the normal user space quota.
With MySQL temp dir set to /tmp,
connection per user? (so one user
cannot abuse the server and take all max_connections connections
for himself).
--
Regards,
Artem
Russell E Glaue wrote:
Using Quota on Unix, you can specify a different quota soft_limit for
temporary space.
You can set MySQL to use /tmp as the temporary space
be the QPP (Query Processing Programs) that I and a
co-worker have developed. They can be downloaded at
http://www.paragon-cs.com/queryprogs.
thanks
Keith
Michael Dykman wrote:
Have you considered:
http://forge.mysql.com/wiki/MySQL_Proxy
On Dec 5, 2007 5:14 PM, Russell E Glaue [EMAIL
Does anyone know of a programming library/module (C or PERL or ?) to interface
with the MySQL binary logs?
Preferably a PERL module which wraps some C library to gain a PERL OO api
interface to manipulating MySQL Binary Logs.
If this does not exist, can someone point me at the API documentation
Does anyone know of an open source SQL analysis tool?
I have query logging turned on in MySQL.
And I would like to analyze all the logged SQL select queries to find out how
the database is being used, and then optimize MySQL databases or the SQL
views/statements accordingly.
Perhaps it would
No one probably wants to go through the trouble to code this solution but it
is possible to use MySQL Proxy to filter the SQL statements and results.
MySQL Proxy sits in between MySQL Server and the MySQL Client.
It can read queries, modify them, send queries to the server or deny them all
How much power do you want?
We migrated from Oracle to MySQL because to get enough power from Oracle 8/9i,
we had to buy an extremely powerful machine.
We had oracle on a sun solaris 9 box, and got X amount of power out of it.
On a similar machine we installed MySQL and we got XX amount of power
Try putting the data directory on a small partition and let it get filled 100%
with a single update that does not get fully committed due to disk full, then
turn the power off to the computer so there is no attempt for a nice shutdown.
You should also get a corruption in the master binary logs,
Your mysql server is either not running, or is not creating the sock file at the
location /var/lib/mysql/mysql.sock that calendar.php expects.
What do you get when you do this?
linux$ ls -la /var/lib/mysql/mysql.sock
look in the my.cnf file to find where the MySQL sock is written to, and modify
Run this SQL Query
mysql select Host,User from user;
Make sure the output has this record values:
+---+--+
| Host | User |
+---+--+
| localhost | usuario1 |
+---+--+
If your mysql error message were to say this:
Access denied for user
I assume your collation on the database table 'city' is utf8_general_ci
And also check the columns of the database table 'city' to ensure they are also
utf8_general_ci.
The database, its tables, and the tables individual columns can all have a
different collation.
Last, ensure that you set utf8
The mysql.sock location '/var/lib/mysql/mysql.sock' attempted to be used by your
connecting client may be wrong.
linux$ ls -la /var/lib/mysql/mysql.sock
Does the file exist?
You say this is the sock file created by mysqld:
srwxrwxrwx mysql mysql system_u:object_r:mysqld_var_run_t mysql.sock
Does the client loose the MySQL connection completely? Or is there just an error
in receiving the responding packet back?
Here is an idea:
You can do a ping to test the connection.
Fist ping the connection to verify you can send and receive on that connection.
Then send the SQL Command.
If you
Permit me to query the users on this list to ask a few questions on if and how
they scale their MySQL with the use of load-balancers.
I am only expecting very short answers, but you may choose to answer how ever
you like.
My goal is to try and understand what state the MySQL community is in
Philip Hallstrom wrote:
...
6) When it comes to scaling MySQL and the use of load-balancing, what
do you
feel is a technology that is missing that the MySQL community should
create?
(I.e. perhaps some new technical item in the MySQL database server
software, or
something on the
Philip Hallstrom wrote:
...
6) When it comes to scaling MySQL and the use of load-balancing, what
do you
feel is a technology that is missing that the MySQL community should
create?
(I.e. perhaps some new technical item in the MySQL database server
software, or
something on the
Philip Hallstrom wrote:
pgpool is a connection pool server for PostgreSQL. pgpool runs between
PostgreSQL's clients(front ends) and servers(back ends).
Well there are a few solutions out there.
The first comparable product for MySQL is MySQL Proxy.
http://forge.mysql.com/wiki/MySQL_Proxy
I'd like to speak/write with someone, off the list, on the MySQL Proxy project
who might be involved in the following topics I found on the MySQL Proxy
Cookbook:
# (TODO) Advanced - Use a Proxy between master and slaves to monitor
replication traffic
# (TODO) Guru - Use a Proxy between master
output.
start slave;
The above process should fix your problem.
On 9/4/07, *Russell E Glaue* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
wrote:
I had a disk full error on the master MySQL (4.1.22), which was
replicating to a
slave (4.1.22 ).
My question is, how do I
I had a disk full error on the master MySQL (4.1.22), which was replicating to a
slave (4.1.22).
My question is, how do I recover a slave replica when the master had a disk full
error, space was freed, but the 'disk full' issue left a corrupted master
binlog?
1) Do I have to reinitialize the
We have fail-over using Linux Virtual Server, now upgrading to Red Hat
Cluster Suite. We do not implement load-balancing.
Here is why.
In order to have full true load balancing, you need to have two or more
MySQL database server replicating data to each other in real time.
Currently your only
I am setting up a master-master replication.
I have the masters set up correctly (I guess), and they update their
position when changes occur. 'show slave status' and 'show master
status' both show the correct positions between each server.
However. Although the slave position increments to
'
create_table_from_dump: failed in handler::net_read_dump()
Any help from any one?
-RG
Russell E Glaue wrote:
I am setting up a master-master replication.
I have the masters set up correctly (I guess), and they update their
position when changes occur. 'show slave status' and 'show master
status' both show
I did a mysqldump from serverA, took that output and did the following
as illustrated below to import into serverB.
why did I get an error?
Did mysqldump output the wrong SQL syntax? I would not think so, but I
got this error which says so.
I am using mysql-4.0.20 on both servers.
I am
Daniel Kasak wrote:
Russell E Glaue wrote:
snipped
ERROR 1064 at line 14071: 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 'order int(1) NOT NULL default '0',
PRIMARY KEY (moduleID),
snipped
Would
I think it would be a good idea to be able to specify the error log on
the command line when starting mysqld. Right now mysql users can only
specify the following logs on the command line:
log (access/activity log)
log bin
log bin index
log update
log isam
Yes. Look in this months digest. There is a thread about this.
-RG
On Thu, 18 Apr 2002, Jimi Oleksiak wrote:
I am having real trouble trying to get mysqld to start automatically
when I restart my Mac OS X or Mac OS X Server systems.
I am reading the MySQL document, chapter 2.4.3, and have
If your database is read-only, you can use Linux Virtual Server to load
balance traffic to MySQL servers.
-RG
On Fri, 12 Apr 2002, Frankie Gravato wrote:
Date: Fri, 12 Apr 2002 10:54:56 -0400
From: Frankie Gravato [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Load Blancing Mysql Max Db
We use a Network Time Server to keep the MySQL server in the right time.
-RG
On Fri, 12 Apr 2002, John Klein wrote:
[EMAIL PROTECTED] wrote:
As I understand it, the mysql TIMESTAMP type represents the time in your
local timezone (the one your computer is using).
This makes it
Your binary distrubution downloaded from mysql.org installs in
/usr/local/mysql
If you remove everything from that directory, you can just install the
binary distribution again into that directory.
Don't forget to run the mysql_install_db script after installation so to
set up your
I have the same exact setup down to the hardware (believe it or not).
Your best game plan is to install the MySQL binary distro into
/usr/local/mysql as the root user. And then run the MySQL server as root.
You'll have to start the MySQL Server when you start the laptop.
Otherwise, you can log
Try linux virtual server.
You can Load Balance any port on a multitude of servers.
Your MySQL Servers you would load balance would have to be read-only
slaves though.
We are currently running two linux virtual servers to load-balance
same-port services on multiple servers with multiple Unix
Has anyone though about writing an internal function to have MySQL dump
database statistics into a flat file or database tables?
-RG
On 5 Apr 2002, Jason Yates wrote:
Date: 05 Apr 2002 16:04:01 -0500
From: Jason Yates [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: mysql monitoring
Is
current program languages.
-RG
On Tue, 2 Apr 2002, Jeremy Zawodny wrote:
On Tue, Apr 02, 2002 at 06:20:41PM -0600, Russell E Glaue wrote:
On the mysql-internals mail list we had a thread going about this. I
was suggesting something like embedding PERL into MySQL to produce
something like
Currently there is no built-in straight-forward methods to authenticate
against LDAP Directories. However, I have heard from others who have
compiled OpenLDAP using MySQL as a back-end database.
OpenLDAP: I do not know if the possibility exists to replicate the
MySQL tables storing the
Have you looked at mysqlmanager?
It is still being developed and I am told it should not be used other than
for testing MySQL. There is a mysqlmanagerc (client) app that goes with
it. It looks like it is being made to execute commands remotely.
I am waiting for someone to tell me what
We use mysqldump.
It is fast and easy. restoration is not hard.
If you want more a more percise restoration option, look at using the
change-log. It wil allow you to revert back in time to a state of the DB.
-RG
On Tue, 2 Apr 2002, Kory Wheatley wrote:
Date: Tue, 02 Apr 2002 11:26:58 -0700
It's easy shell.
-
#!/usr/bin/bash
DATE=`/usr/bin/date '+%Y%m%d%H%M%S'` # or '+%Y%m%d'
mysqldump -uUsername -pPassword --all-databases tmp.sql tar \
-cf MySQL-Backup-${DATE}.tar.gz -z tmp.sql rm -f tmp.sql
-
-RG
On Tue, 2 Apr 2002, David McInnis wrote:
Date: Tue, 2 Apr 2002
On Tue, 2 Apr 2002, Mark Stringham wrote:
What would the script look like if I'm on Win2k ?
Good luck!!
But seriously; there is a $300 software package out there (can't remember
name) that will give your billy-boy OS some unix shell-like capabilities,
including TAR. It was featured in like
at the PERL.EXE executable.
-RG
On Tue, 2 Apr 2002, Mark Stringham wrote:
Could I run something similar as a BAT file?
-Original Message-
From: Russell E Glaue [EMAIL PROTECTED]
To: Mark Stringham [EMAIL PROTECTED]
Cc: Rodney Broom [EMAIL PROTECTED]; [EMAIL PROTECTED]
[EMAIL
forgot to mention.
you'll have to use ZIP, since TAR is not available on Windows (unless
you use the previously mentioned software packages).
-RG
On Tue, 2 Apr 2002, Russell E Glaue wrote:
Maybe... after some long hours and many lines. I am not sure. I know it
won't necessarilly be easy
On the mysql-internals mail list we had a thread going about this. I was
suggesting something like embedding PERL into MySQL to produce something
like PERL/SQL (similar to PL/SQL in oracle).
Unfortunately, although promising and liked among people of the list,
there are no plan right now to
a
mysql server process to be managed remotely? Like starting and stopping
from the shell, or doing data checks?
-RG
On Mon, 1 Apr 2002, Michael Widenius wrote:
Hi!
Russell == Russell E Glaue Russell writes:
Russell in the '{MYSQLROOT}/bin' there are two executables in particular.
Russell
in the '{MYSQLROOT}/bin' there are two executables in particular.
mysqlmanager
mysqlmanagerc
I see these are version 1.0, and such are recently added.
Can anyone tell me:
What does bin/mysqlmanager do, and how do I use it?
Why does the bin/mysqlmanagerc give me an
On Wed, 20 Jun 2001, Michael Widenius wrote:
Hi!
Sasha == Sasha Pachev [EMAIL PROTECTED] writes:
Sasha On Tuesday 19 June 2001 17:43, Russell E Glaue wrote:
. After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
or BUILD/compile-pentium-debug - it will build
. After you've pulled, run BUILD/compile-pentium (for a lean fast binary)
or BUILD/compile-pentium-debug - it will build a binary for you.
We run all our MySQLs on the fast SPARCs and PPCs
is pentium the only supported hardware right now?
-RG
On Tue, 19 Jun 2001, Sasha Pachev wrote:
53 matches
Mail list logo