Does the version of mysqlbinlog match that of the server that wrote
the binlog?
I'm using MySQL 4.0.14 [linux]
mysqlbinlog version 1.6 [linux]
Regards
Jan Josefowicz
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
On Mon, Aug 18, 2003 at 02:33:04PM -0500, Miguel Perez wrote:
>
> I have an ibdata file that its size is 4.5GB, and it will increase
> every day the max size of the hard disk is about 330GB, the question
> is should I split this ibdata file in several files in a way that I
> can reach this size?
D
On Tue, Aug 19, 2003 at 04:10:12PM +1000, Chris Nolan wrote:
> Thanks. :-)
>
> On another note, do you automate your sig in some way?
Yup, I use mysig:
http://jeremy.zawodny.com/mysql/mysig/
But I havne't posted the code yet. Hmm. I've been meaning to do that
for about a year now. Bug me a
Thanks. :-)
On another note, do you automate your sig in some way? And, more
importantly, does the access of the MySQL server to determine the quoted
statistics count as one query or more than one? :-)
Chris
> On Mon, Aug 18, 2003 at 04:09:01PM +1000, Chris Nolan wrote:
>> Hi all,
>>
>> I was w
Hi i have just come across an issue where a word is not being searched up if there is
any punctuation ie. AMROZI'S will not be search upon if you type AMROZI , please help
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMA
Hello,
I'm having a problem importing a CSV file into a MySQL table using
phpMyAdmin. The DB is on the hosting company server. I'm on WindowsXP, the
server is Unix. The table has 6 initial entries, that I'd like to save.
The table is structured as:
Table name "campuses"
inst_id, name, zip_id, st
Johnson, Michael unknowingly asked us:
What is the best book on MySQL with regard
to its Architecture and how it starts up, shutdowns,
processes queries, rolls back data, etc etc. ?
Doesn't the documentation help?
--
Think to think more, work to work more.
_
Thomas Deliduka unknowingly asked us:
Thank you for the code, when I did that (which I should have done, you're
right) it worked fine. So, now I gotta find out where this is going wrong
and why the same code is working in one place but not the other. While my
connection function is only run once
On Mon, Aug 18, 2003 at 04:14:21PM +1000, Chris Nolan wrote:
> Hi all!
>
> Currently, one of my clients has a MySQL+InnoDB database that they use for
> storing "stuff". My question is, even though I know it will take more time
> and will slow down operations for everyone, will mysqldump with the s
On Mon, Aug 18, 2003 at 04:09:01PM +1000, Chris Nolan wrote:
> Hi all,
>
> I was wondering, does anyone know if there are any plans to add FULLTEXT
> indexes to the almighty InnoDB such that it catches up with the funky
> MyISAM in terms of things you can pass to ALTER TABLE?
If you check the lis
On Fri, Aug 15, 2003 at 03:45:40PM -0700, Dathan Vance Pattishall wrote:
>
> Replicating queries where re-written to fix various bugs, most notably
> time and auto-increment bugs.
Hm? I didn't quite pars that sentence.
> Why doesn't replication also enforce rewriting INSERT INTO into
> INSERT
On Mon, Aug 18, 2003 at 04:51:17PM -0700, Michael S. Fischer wrote:
> Jeremy Zawodny writes:
>
> > Perhaps you could tell us more about the queries that take
> > too long. Maybe there are some things you can do to reduce that time?
>
> You don't want to go there.
>
> But because you do... :-)
On 8/18/03 3:18 PM this was written:
> Firstly, you will have to re-read your message before you press the send
> button each time. What you are saying is very unclear to the rest of us.
Sorry
> Nextly, your statement:
>
>> It's as if the PHP mysql_select_db function simply doesn't want to sele
Andrew,
One, it sound like you have downloaded a binary distro, and this does
not require a make. If your want to compile from source, you will need
to grab the source distro instead. If you would like to continue with
the binary, you can untar the package under /usr/local , and then add
the
Jeremy Zawodny writes:
> Perhaps you could tell us more about the queries that take
> too long. Maybe there are some things you can do to reduce that time?
You don't want to go there.
But because you do... :-)
As far as I can tell, the queries are as optimized as they're going to
get. I'm doi
On Mon, Aug 18, 2003 at 11:53:29AM -0700, Michael S. Fischer wrote:
>
> I'm using MySQL 4.0.13 for a web application, and one of my queries
> is sufficiently complex such that it might take several seconds to
> return the results to the user. I'd like to return a "please wait"
> page if the query
Hi,
I'm trying to get a version of MySQL 4.1.0 installed on my (Gentoo Linux)
machine. I have a copy of MySQL 4.0.13 already installed, using Gentoo's
ebuilds, but am trying to install 4.1.0 in a side-by-side configuration.
(Into /usr/local/mysql_alpha, talking to port 3300) - So I can run 4.0
What is the best book on MySQL with regard
to its Architecture and how it starts up, shutdowns,
processes queries, rolls back data, etc etc. ?
I am not looking for a SQL book here.
What is the best My SQL book you have read ?
Thank you in advance.
Mike
--
MySQL General Mailing List
For list a
On Mon, Aug 18, 2003 at 10:30:31PM +0200, Jan Josefowicz wrote:
> Hi all,
> I get following output from "mysqlbinlog mylog-bin-file.001":
>
> # at 4
> #030818 13:38:00 server id 1 Start: binlog v 4, server v created
> 700101 1:00:00
>
> The file mylog-bin-file.001 contains many querie
On Mon, Aug 18, 2003 at 09:42:51AM -0500, mos wrote:
>
> External RAM disks that are around 8g are extremely
> expensive. Some have built in in battery protection and operate
> independently from the OS so if the OS reboots, you still have your data. A
> couple of years ago I priced t
Thomas Deliduka unknowingly asked us:
Right, however, I am following the progression of 1,2,3. My code I pasted
here showed that the connection function did the connect and select in the
same function and in my debugging I did confirm that $db does equal
my_database. I have also manually typed it
You can use an option in my.cnf slave-skip-error= error nums
separated by ,.
The error below means that the master had a shutdown event and the slave
can't tell if it added / deleted / changed that row or not. I wouldn't
advise in skipping this error less you want your data to be inconsistent
or
I am having a problem with replication in MySQL 4.0.13. I have a
my.cnf file in the data directory of the slave that should exclude a
specific table in one of my databases from replication. I am getting
the following error message:
"error 'unexpected success or fatal error' on query 'UPDATE
Dathan Vance Pattishall unknowingly asked us:
There is actually a C++ mysql list that might be able to help you better
then this one.
-->-Original Message-
-->From: Z. S.Ghand [mailto:[EMAIL PROTECTED]
-->Sent: Monday, August 18, 2003 9:49 AM
-->To: [EMAIL PROTECTED]
-->Subject: Problem to
I have about 20K records that result from the following query. Front end for the
database is ACCESS97 and pulling up 20K records makes a huge performance hit.
For the form in question I am using PASSTHROUGH type query (the one that just
passes everything straight to server without ODBC).
NOTE: souc
Hi all,
I get following output from "mysqlbinlog mylog-bin-file.001":
# at 4
#030818 13:38:00 server id 1 Start: binlog v 4, server v created
700101 1:00:00
The file mylog-bin-file.001 contains many queries but they don't appear
in the output from mysqlbinlog.
What is wrong?
Thanks in adva
At 10:19 AM 8/18/2003, you wrote:
Mike,
This is very helpful.
Database consists of approximately 220,000,000 records. Raw data total
(roughly) 5.5 GBytes. I don't know how large the database will be loaded
(don't know about overhead, etc.)
Running InnoDb. Probably split 90% read and 10% wri
Hi list:
I would like to know some of the best practices to manage innodb tables. I
have an ibdata file that its size is 4.5GB, and it will increase every day
the max size of the hard disk is about 330GB, the question is should I
split this ibdata file in several files in a way that I can rea
Your MySQL installation should have a directory called "support-files".
In there are a couple of configuration files you can use with obvious
names like my-huge.cnf, my-large.cnf, ..., my-small.cnf.
There are comments in each file about what kind of system they were
designed for. You can read up
I'm using MySQL 4.0.13 for a web application, and one of my queries is
sufficiently complex such that it might take several seconds to return
the results to the user. I'd like to return a "please wait" page if the
query is not already in the cache. Is there a way (or a proposed way)
of doing a qu
All right, you can disregard this :-) I was too quick to post it to the
list... those _are_ threads, the kernel upgrade must have introduced
them :-). Sorry for the bandwidth!
But other than that, something off-topic: on the very same server I have
found that I cannot issue the 'su' command, be
Hi,
I have a P4 server with RedHat 8.0 running on the lates stable kernel. I
also have MySQL 3.23.54 installed.
My problem is that when I do a 'ps aux', I only see one mysql process:
mysql 916 0.0 0.3 38616 3936 ?S17:39 0:02
/usr/sbin/mysqld --defaults-file=/etc/my.cnf --
Sorry the MySQL list server seems to have bounced my attachment. I have
include the text below.
my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# skip_innodb
innodb_data_file_path=idbdata1:200M:autoextend
set-variable = innodb_buffer_pool_size=80M
set-variable = innodb_a
On Mon, Aug 18, 2003 at 01:34:59PM +0100, Andrew Braithwaite wrote:
> Hi All,
>
> I have a database with many files in it and our research tells us that
> disabling the recording of atime (access time) for that DB may have
> significant performance improvement.
>
> 2 questions:
>
> 1. Has anyone
On Mon, Aug 18, 2003 at 12:10:16PM -0400, Tom Mattison wrote:
> Greetings List,
>
> I'm running a dedicated MySQL server on a Dell PE 2550, dual proc. 4GB
> RAM. Its using the Dell PERC 3/Di Scsi RAID controller with 18GB disks. I
> running RH 7.3 with the latest updates(Kernel 2.4.20-19.7smp)
On Mon, Aug 18, 2003 at 11:15:31AM -0700, [EMAIL PROTECTED] wrote:
> I could fix this if I changed the table type to InnoDB, correct?
Yes.
InnoDB uses a very different locking model. You'll get very good
read/write concurrency with InnoDB.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, L
I could fix this if I changed the table type to InnoDB, correct?
-James
Quoting Jeremy Zawodny <[EMAIL PROTECTED]>:
> On Mon, Aug 18, 2003 at 10:41:55AM -0700, [EMAIL PROTECTED] wrote:
> > Hello,
> >
> > I just have a question about the table locking in 3.23.56. If I am
> inserting a
> > row i
On Mon, Aug 18, 2003 at 10:41:55AM -0700, [EMAIL PROTECTED] wrote:
> Hello,
>
> I just have a question about the table locking in 3.23.56. If I am inserting a
> row into a table that is MyISAM type, is the entire table locked?
Yes.
> And, if so, what does this mean for concurrent selects?
An I
In the last episode (Aug 18), [EMAIL PROTECTED] said:
> I just have a question about the table locking in 3.23.56. If I am
> inserting a row into a table that is MyISAM type, is the entire table
> locked? And, if so, what does this mean for concurrent selects?
Inserting a row into a full table doe
-->-Original Message-
-->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
-->Sent: Monday, August 18, 2003 10:42 AM
-->To: [EMAIL PROTECTED]
-->Subject: Table locking...
-->
-->Hello,
-->
-->I just have a question about the table locking in 3.23.56. If I am
-->inserting a
-->row into a t
There is actually a C++ mysql list that might be able to help you better
then this one.
-->-Original Message-
-->From: Z. S.Ghand [mailto:[EMAIL PROTECTED]
-->Sent: Monday, August 18, 2003 9:49 AM
-->To: [EMAIL PROTECTED]
-->Subject: Problem to use mysql
-->
-->Hi All;
-->I have written a
Hello,
I just have a question about the table locking in 3.23.56. If I am inserting a
row into a table that is MyISAM type, is the entire table locked? And, if so,
what does this mean for concurrent selects?
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
If mysqld is running, you must force a sync/close of all tables with FLUSH TABLES and
ensure that no one is using the tables while you are running myisamchk. In MySQL
Version 3.23 the easiest way to avoid this problem is to use CHECK TABLE instead of
myisamchk to check tables.
If i didnt do t
Thank you for the info. That certainly sounds like my problem.
Time to switch back to the older kernel & see if things improve.
Regards,
tom.
> -Original Message-
> From: Philip Molter [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 18, 2003 12:19 PM
> To: Tom Mattison
> Cc: [EMAIL PROT
Hi All;
I have written a small mysql program with c++ in linux. i compile it by
g++ -L/usr/lib/mysql -I/usr/include/mysql -lsqlplus myprogram.cc
it works properly. but when i want to execute it i receive this error:
error while loading shared libraries: libsqlplus.so.1: cannot open shared objec
On Mon, Aug 18, 2003 at 12:10:16PM -0400, Tom Mattison wrote:
: Greetings List,
:
: I'm running a dedicated MySQL server on a Dell PE 2550, dual proc. 4GB
: RAM. Its using the Dell PERC 3/Di Scsi RAID controller with 18GB disks. I
: running RH 7.3 with the latest updates(Kernel 2.4.20-19.7smp)
Right, however, I am following the progression of 1,2,3. My code I pasted
here showed that the connection function did the connect and select in the
same function and in my debugging I did confirm that $db does equal
my_database. I have also manually typed it in and it still doesn't work.
It's as
Greetings List,
I'm running a dedicated MySQL server on a Dell PE 2550, dual proc. 4GB
RAM. Its using the Dell PERC 3/Di Scsi RAID controller with 18GB disks. I
running RH 7.3 with the latest updates(Kernel 2.4.20-19.7smp). The MySQL
version is the rpm currently being provided by the RH updat
Oh, I see now!
When you gave the command mysql ... my_database, at the moment of the MySQL
shell, you have the database "my_database" already selected. So all of your
queries works fine because you are in the right database.
In the PHP or other environment, you need to select the database after
co
I'm not sure. You could run a test. I'd be surprised if counting rows
from the resultset was slower.
Charles So wrote:
>
> which is more efficient?
>
> 1) find num from rs or
> 2) select count(*) from table?
>
> cheers,
> Charles
>
> On Saturday, August 16, 2003, at 05:01 AM, Jeff Mathis wrot
Your PHP code for the server 1 is not the same with the code for the server
2 or the names of the tables from MySQL server 1 are not the same with the
value of your PHP queries.
Put the first PHP not-working query in the command-line for server 1 and see
if it works.
Put here the PHP code for th
Mike,
This is very helpful.
Database consists of approximately 220,000,000 records. Raw data total
(roughly) 5.5 GBytes. I don't know how large the database will be loaded
(don't know about overhead, etc.)
Running InnoDb. Probably split 90% read and 10% writees.
If nothing else replication
Sorry, in an attempt to further clarify my server situation.
I have Three actual servers, physical computers they are setup with:
s1: Apache 1.3.27, PHP 4.3.2, MySQL 4.0.14
s2: Apache 1.3.27, PHP 4.3.2, MySQL 4.0.12
s3: Apache 1.3.27, PHP 4.3.2, MySQL 3.23.54 (I believe 54 is the step value)
Pro
Server = physical machine.
Every query, it doesn't matter what query I send, it tries to use the wrong
database. I thought I put "select * from table_name" but perhaps I didn't.
I have another message just sent with code and perhaps a little additional
information.
On 8/18/03 10:48 AM this was w
If you can post your current my.cnf + box configuration I'm sure we can
come up with some suggestions..
On Mon, 18 Aug 2003, Creigh Shank wrote:
> How would I tune my.cnf for a larger memory box? (Running on UPS;
> production machine(s) will go into Co-Lo with UPS and generator.) I
> realize
At 10:14 -0400 8/18/03, Thomas Deliduka wrote:
I have written this to the PHP-DB list and couldn't get any answers. I have
gone through all the documentation I could find. I have been everywhere and
cannot find an answer to this problem! Perhaps someone on this list can
lend me some insight?!
We
The table is in the SQL statement. "Select * from table_name" If you
really want my code it's very long. I will paste in the stuff that's
relevant. It's at the bottom.
If it's a PHP matter why does the same code connecting to a 3.23 server work
perfectly fine. This same EXACT code works perfect
How would I tune my.cnf for a larger memory box? (Running on UPS;
production machine(s) will go into Co-Lo with UPS and generator.) I
realize there is some risk here. I am more concerned with the system
failing and some kind of mirroring solution to protect data.
Creigh
At 10:34 AM 8/18/200
At 09:17 AM 8/18/2003, you wrote:
Have a very large database and due to performance requirements it seems
that running MySQL in RAMDisk might be a good solution. Access to the
database is through PHP. Any suggestions or experiences?
Creigh
305-541-1122
Creigh,
How large is the database
You have selected my_database as database. What about the table? Put some of
your code to clarify the problem. It's a PHP matter.
Iulian
- Original Message -
From: "Thomas Deliduka" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 18, 2003 5:14 PM
Subject: Server to Server
"Rick Robinson" <[EMAIL PROTECTED]> wrote:
>
> When will 4.1.1 be officially available in a packaged download?
>
>
It should be released in September or in early October.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http:/
Depends on db size... kinda risky putting it in memory if it's being
updated and power goes bye-bye..
You should be able to get alot more performance just tuning my.cnf for a
larger memory box..
On Mon, 18 Aug 2003, Creigh Shank wrote:
> Have a very large database and due to performance requi
At 8:37 -0500 8/18/03, Dan F wrote:
Folks,
I find it useful for browsing to dump each table of a DB, i.e.
psuedo-code like
foreach table
mysqldump --add-drop-table DB table > table
This produces a file per table, and that file has the DDL and data.
My question: does this per-table version capt
I have written this to the PHP-DB list and couldn't get any answers. I have
gone through all the documentation I could find. I have been everywhere and
cannot find an answer to this problem! Perhaps someone on this list can
lend me some insight?!
I think, at heart, the problem is with MySQL perm
Have a very large database and due to performance requirements it seems
that running MySQL in RAMDisk might be a good solution. Access to the
database is through PHP. Any suggestions or experiences?
Creigh
305-541-1122
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
Last week many of our server and client servers had a power problem. Not quite sure
how the servers were handled, wasn't on site, but I don't think some of these servers
got shut down gracefully. but anyways that shouldn't matter to my question
I ran myisamchk on the data directories and I get
Hi
I can't help establish a
relationship between two tables (table 1, table 2) in Mysql.
I work with DBTools, it has an
relationship editor, but it doesn't work, since after i ' ve created the
relationship for the field email, if i delete a register in table 1, the
register with sa
Folks,
I find it useful for browsing to dump each table of a DB, i.e.
psuedo-code like
foreach table
mysqldump --add-drop-table DB table > table
This produces a file per table, and that file has the DDL and data.
My question: does this per-table version capture all the information
that doing
To whom it may concern,
We are having some trouble installing a MySQL database onto one of our
servers and would appreciate some assistance, details are below.
Installing MySQL v4.0.14 on a Solaris 8 (Sparc) system on a Netra X1.
We have downloaded the source files from your website and have had
Hi All,
I have a database with many files in it and our research tells us that
disabling the recording of atime (access time) for that DB may have
significant performance improvement.
2 questions:
1. Has anyone done this and if so, what results did they have?
2. Is the atime used in MySQL/MyISAM
Steve,
There is really no point in creating a separate table or group of tables for
each user. Your concern seems to be that you will make a typo and the user will have
the wrong supplier_id--well, you can make typos that send data to the wrong table just
as easily. Peter's suggestion
I meant that the solution is to put master_connect_retry=2.
When I met this problem, to solve it, I did :
1.stop the slave thread;
2.save the table from the master;
3.drop the table on master;
4.drop the table on slave;
5.reset the master and slave;
6.set master_connect_retry=2;
7.start the slave
At 16:18 +1000 8/18/03, Chris Nolan wrote:
Hi all,
Here's one of those damned annoying "what if" questions for everyone.
If I have a transaction that performs INSERTs or UPDATEs on a bunch of
tables, some InnoDB and some MyISAM, and after performing a bunch of
modifications on each I issue a ROLL
Hi, it's my story.
I have two 4.0.14 mysql server on one machine with win XP Professional
polish version.
First acts as master: on port 3300
Second acts as slave: on port 3301
below my configuration:
### FOR MASTER #
# This will be passed to all mysql clients
[client]
#pass
[EMAIL PROTECTED] wrote:
>
> I think there is a bug in mysql 4:
>
> select week("2003-08-15") from po.orders limit 1;
>
> produces: 32
>
> after:
>
> set session default_week_format=3;
>
> it produces: 33 (which is correct in the Netherlands)
>
> The documentation states:
>
> set global de
[EMAIL PROTECTED] wrote:
>
> I am new to mysql admin. I have created a database and set a user name
> and passwd for it using
>
> grant all privileges on MICDB.* to [EMAIL PROTECTED] identified by 'passdw'
> with grant option;
>
> Now the xxx user is able to login in to the database with
>
Prem Soman <[EMAIL PROTECTED]> wrote:
>
> i have gone thru what u referred long before, i know
> that this "set" method is not fully supported in 3.23
> version, thats why i posed this question, i wanted to
> know whether there is any other way to do it.
>
> when i make changes to my.cnf file i
Hi all,
I think there is a bug in mysql 4:
select week("2003-08-15") from po.orders limit 1;
produces: 32
after:
set session default_week_format=3;
it produces: 33 (which is correct in the Netherlands)
The documentation states:
set global default_week_format=3; (As root!)
This command sho
Vladimir Espinosa Angarica <[EMAIL PROTECTED]> wrote:
>
>I've found a bug in the example presented in the Official MySQL
> Manual in the section 9.1.15.6 A Simple Embedded Server Example. I tried
> to compile the program following the instructions depicted in the manual
> and a compiling er
Hi all,
I am new to mysql admin. I have created a database and set a user name
and passwd for it using
grant all privileges on MICDB.* to [EMAIL PROTECTED] identified by 'passdw'
with grant option;
Now the xxx user is able to login in to the database with
the passwd , but he is not having
select database();
Regards,
Joseph Bueno
Vinay wrote:
Is there an SQL command that i can perform which will return me the name
of the Database i'm currently conected to.
Thanks for your help.
Vinay
--
http://www.uptoten.com - The fun place to learn on-line
UpToTen Kids : 600 educational games an
Is there an SQL command that i can perform which will return me the name
of the Database i'm currently conected to.
Thanks for your help.
Vinay
--
http://www.uptoten.com - The fun place to learn on-line
UpToTen Kids : 600 educational games and activities.
UpToTen Parents : Practical ideas and ad
82 matches
Mail list logo
