ER ;
# End of log file
ROLLBACK /* added by mysqlbinlog */;
/*!50003 SET completion_ty...@old_completion_type*/;
r...@:/usr/local/mysql/data ]
~Lawrence
Tom Worster wrote:
Frankly, I didn't entirely understand what you were proposing. I got lost
around step 6.
Is the issue total time
properly.
Is this correct?
~Lawrence
Shawn Green wrote:
Lawrence Sorrillo wrote:
Hi:
I want to upgrade a master and slave server from mysql 4.1 to mysql 5.1.
I want to so something like follows:
1. Stop all write access to the master server.
ok
2. Ensure that replication on the slave is caught
This is two upgrades done in sequence(the reload takes about three hours
per machine) . I can do what I am proposing in parallel.
Do you see it as problematic?
~Lawrence
Tom Worster wrote:
How about:
1 shut down the slave, upgrade it, restart it, let it catch up.
2 shut down the master
both servers will have the same databases abd replication and
binary logging will start on the two databases with no data loss and
continue forward.
Comments?
~Lawrence
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Carsten:
Can you demonstrate this?
~Lawrence
Carsten Pedersen wrote:
Is there any particular reason not to use the MySQL ODBC driver to
import the data directly into Excel?
/ Carsten
Jim Lyons skrev:
A command to convert the table mytab in database mydb into a
tab-delimited
file
;m looking at it.
- Original Message
From: Kyong Kim
To: Lawrence Robertson
Cc: mysql@lists.mysql.com
Sent: Monday, September 21, 2009 4:25:34 PM
Subject: Re: 100% CPU load problem
Is the status information correct?
> mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)
Are you using
>Is the status information correct?
>> mysql Ver 14.12 Distrib 5.0.27, for Win32 (ia32)
>Are you using some sort of vm?
I'm not using a VM at all. It's a simple PC with CentOS 4 and MySql.
Don't know why is that Ver 14.12 Distrib 5.0.27, for Win32 (ia32). But the
> | version_compile_os
Hi.
We have some MySql servers in a circular replication, and one of the servers is
having some performance issues for some weeks. I tried with mysqlcheck and
nothing is wrong. I'm logging the slow queries and there's nothing wrong.
The complete database in this server is like 1GB when it's G
Are you doing the insert and the select in different sessions, ie
different connections to the server(different terminals)?
This might simply be an intended symptom of isolation levels and InnoDB
MVCC(multi versioning concurrency control).
In addition, can you tell us what you get from:
mysql>
Are the values of these variables all accessible via the command: "show
variables"?
Josh Miller wrote:
MAS! wrote:
btw, I have to get the Master_Log_File and Read_Master_Log_Pos or
Relay_Master_Log_File and Exec_Master_Log_Pos to start the new slave
correctly !?
If the Master_Log_File and
"Lawrence K. Hixson" wrote:
> 4) This has been fixed in MySQL server 4.1, but why wasn't
> this caveat explicitly WELL DOCUMENTED in the documentation
> so developers could avoid this land mine along with the
> additional gotcha under Windows? Could someone please
&g
Dear MySQL Support List:
Way back in early 2003 two questions and answers appeared on
this list and bug list RE: DECIMAL precision. See both at
http://lists.mysql.com/mysql/141268 and
http://bugs.mysql.com/bug.php?id=559
1) Did anyone else notice that the 'INSERT INTO' value DID
NOT MATCH the 'S
such as road conditions, location of road work crews, etc.
Am I on the right track with MySQL or am I barking up the wrong tree?
Thanks
--
Lawrence Strydom
Open Source Software Solutions Consultant
email: [EMAIL PROTECTED]
web: www.rpcdata.co.za
www.midafrica.com
Tel: +27 (0)44 8770453
Tel
using the '--nodeps' flag?
Any ideas?
Colin Lawrence
utely last question (only
just occurred to me): will the space in the file used
by the deleted data be reused?
Thx
Lawrence Smith
=
http://www.explanation-guide.info
BT Yahoo! Broadband - Free modem offe
Heikki,
thanks for the reply, will note.
Just to confirm if I understand the situation
correctly: innodb datafiles cannot be reduced in size
to reclaim spaced freed by deleted data? (That'd
probably explain why I had a hard time finding ISPs
offering innodb-enabled MySQL).
Lawrence
--- Jeff Mathis <[EMAIL PROTECTED]> wrote: >
someone will no doubt echo what I'm about to say.
> InnoDB files are created at startup. the files use
> all the disk you
> allocate to them in your my.cnf startup file.
>
> If you want smaller InnoDB files, specify a smaller
> file size in your
> my
I have recently dropped a database with a big innodb
table in it - but the data file (ibdata1) failed to
get smaller. It's pretty big (nearly 2GB) and I'd like
to
reduce it if possible. Is there any way to do this?
Thx
BT
Greetings All,
I have made a terrible newbie stupid mistake and I am wondering if there is anything I
can do to save my bacon
I made a backup of a database which failed, but mysql didn't tell me :-( Stupidly a
dropped the database, as you do and then the restore failed . because there
Greetings All,
I have made a terrible newbie stupid mistake and I am wondering if there is anything I
can do to save my bacon
I made a backup of a database which failed, but mysql didn't tell me :-( Stupidly a
dropped the database, as you do and then the restore failed . because there
Greetings All,
I have made a terrible newbie stupid mistake and I am wondering if there is anything I
can do to save my bacon
I made a backup of a database which failed, but mysql didn't tell me :-( Stupidly a
dropped the database, as you do and then the restore failed . because there
* TO [EMAIL PROTECTED];
mysql> GRANT USAGE ON *.* TO [EMAIL PROTECTED];
It appears that my syntax is consistant with the examples provided in the
4.0.13 documentation. The root account, of course, has full privileges with
GRANT.
Any ideas?
--
Adam Lawrence
Susta
a result set
pointer that was already freed, an exception is raised and my code
gracefully crashes out.
--
Adam Lawrence
Sustaining Engineering
Tectrol Inc.
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
cute the SELECT statement?
--
Lawrence S. Stephens III
[EMAIL PROTECTED]
Paterson, New Jersey 07514-1711
USA
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
I am trying to set up a mail server using Postfix, Web-cyradm and mysql
on SusE 8. I have followed all the steps in Luc de Louw's documentation
so far and MySQL server is running. When I try to use the scripts that
came with Web-Cyradm to create the databases and tables I get the
folowing erro
Hi,
I am trying to install pam_mysql but seem to have a dependency problem.
This is the output from make:
lawrence:/usr/local/pam_mysql # make
mkdir -p ./dynamic
gcc -O2 -Dlinux -DLINUX_PAM -ansi -D_POSIX_SOURCE -Wall -Wwrite-strings
-Wpointer-arith -Wcast-qual -Wcast-align -Wtraditional
ror 2
make[1]: Leaving directory `/usr/local/mysql-3.23.52/sql-bench'
make: *** [install-recursive] Error 1
I dont want to use the binary included in my distro as it has not been
compiled with pam_mysql.
Please help, I needed this up yesterday. Any help will be much apreciated.
Thanks
Would I get better performance if mysql were being run from a SCSI hard
drive?
Lawrence
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
I suspect somewhere in libmysql/net.c - which is where the timeouts
are set.
Would it be possible to have the client set these values via
an SQL statement to explicitly increase the timeouts for those
connections?
Thanks a bunch!
>Submitter-Id:
>Originator:
Support
I am new to mySQL and would like to use the MySQLGUI .
I can see the download page but are there any instructions for installing
and setting the GUI up under windows 2000
Many thanks
Lawrence Wharton
-
Before posting
I'm new to MySQL as they laid off the dev who setup our intranet and I need
to allow access priveleges to an internal testing server to connect to the
remote host that the live site is on. I've read the doc on setting up
priveleges at http://www.mysql.com/doc/P/r/Privileges.html
but as I am so n
ave tried creating the database as root and the
user ID i am using and I get the same error.
WHat is the problem?
Thank you,
LDB
--
~~~~~~
~ Lawrence D. Bowie
Hi Darren, were you ever able to resolve the failures for tests
rpl15 and rpl16 (mentioned in your 27-Apr message)?
I have the same problem, when building (using gcc-2.95.3) for
Solaris/SPARC 7 and 8. When I run rpl15, the mysqld-slave.err
messages say --
010508 20:50:19 Slave: con
Hi David, did you ever find out how to resolve the problem
where rpl15 and rpl16 fail, after a mysql-3.23.37 build?
I have the same problem, when building (using gcc-2.95.3) for
Solaris/SPARC 7 and 8. When I run rpl15, the mysqld-slave.err
messages say --
010508 20:50:19 Slave: co
]$
-
Larry
--
Lawrence S. Stephens III
Shem Hotep
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
ges value. (Note that an UPDATE that sets a column to the
> value it already has will not cause the TIMESTAMP column to be updated,
> because if you set a column to its current value, MySQL ignores the update
> for efficiency.)
> You explicitly set the TIMESTAMP column to NULL.
> [
Hey all,
Is there a way to quickly obtain the last time a table was updated/touched?
In my app I am caching queries so long as the table data has not changed. I'd like a
quick check to see if a table has changed since the query was first executed. My
perusal of documentation plus a few searche
37 matches
Mail list logo