pgrade the tables 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/r
his [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 idea
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
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:
>
>
>
> +-
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 MyS
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 u
h two
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/Ch
;
> Any idea on how to limit 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_
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, and
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
>> Have you considered:
>>>
>>>http://forge.mysql.com/wiki/MySQL_Proxy
>>>
>>>
>>>
>>> On Dec 5, 2007 5:14 PM, Russell E Glaue <[EMAIL PROTECTED]> wrote:
>>>
>>>> Does anyone know of an open source SQL analys
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 gen
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
tog
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, if
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
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.soc
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
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 '
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
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/
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
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 wit
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
the above command from your show slave status 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
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 slav
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 c
s the error in the logs when I
issue 'LOAD DATA FROM MASTER'
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 chan
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 matc
Daniel Kasak wrote:
Russell E Glaue wrote:
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),
Would thi
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 importi
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 hav
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 make
drive.
This is even true for Oracle and MS SQL which both don't support that
type of application.
-RG
On 12 Apr 2002, Jason Yates wrote:
>
> On Fri, 2002-04-12 at 11:47, Russell E Glaue wrote:
> >
> > If your database is read-only, you can use Linux Virtual Server to load
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 M
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 ou
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 initia
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
>
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 OSes
I am an avid PERL programmer, I also know java. I cannot completely agree
with either of you.
However, this debated subject is best discussed in another community.
The focus here is what has the necessary abilities/functionality to cause
SQL to become a 4th level language in MySQL.
High level fe
ties to improve 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 li
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 devel
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 n
ipts point 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
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
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
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
>
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 'bin/mysq
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 Op
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 writes:
>
> Russell> in the '{MYSQ
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/com
> . 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:
> Hel
55 matches
Mail list logo