Hello
A user of the Debian packages that I maintain reported a problem with the
mysqlcheck --all-databases --fast --quiet command that is run in the
/etc/init.d/mysql script just after the server is up and running as reported
by mysqladmin ping.
According to all documentation that I found and
put the following option in your my.cnf on the slave in order to ignore
errors. Just use the error-numbers you'd like to ignore:
slave-skip-error=1053
Jan
Jim Nachlin wrote:
Is there any way within mysql to have the slaves not stop replicating
on an error. For some reason, my application is
is there an option to perform mysqldump to a file and to have the case sensitiveness
of the tables saved as well in windows os? (I had all tables in lower case)...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
[Could not convert from 'ks_c_5601-1987']
Hello.
I'm using MySQL 4.1.2 on Linux(Fedora Core 2) and Window 2003 Server.
When connect from Linux to Windows, or from Window to Linux connection time is
very slow.
( it takes about 6 seconds)
But Linux to Linux or Windows to Windows Fast.
Anybody
IMHO
You have problems on the DNS server.
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER
Permanent e-mail address :
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-Original Message-
From: Heo, Jungsu [mailto:[EMAIL
The syntax for a LEFT JOIN is identical to the syntax for the INNER JOIN.
All you need to do is replace the word INNER with the word LEFT and your
query should work as you want it to work. :-)
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Scott Fletcher [EMAIL
Why should it use any other?
Timestamp is the only field in the where clause, and you are selecting
all fields.
The second index would require more index reads, and the third can't be used
to satisfy the where clause.
Eamon Daly wrote:
Okay, now I'm even /more/ confused. I whittled everything
At 0:54 +0200 7/29/04, Christian Hammers wrote:
Hello
A user of the Debian packages that I maintain reported a problem with the
mysqlcheck --all-databases --fast --quiet command that is run in the
/etc/init.d/mysql script just after the server is up and running as reported
by mysqladmin ping.
Hi all,
I'm using two tables for handling a little room reservations system:
a rooms table:
CREATE TABLE `rooms` (
`id` int(11) NOT NULL auto_increment,
`room_number` int(3) default NULL,
`room_type` char(1) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
a reservations table:
CREATE
The problem with putting the OS on the same drive as the database is
that they will be competing for the drive resources. On the flip side,
following the safety first rule will make sure your system will stay
up if a drive fails. I always go for safety first.
If you are going to put everything
Years ago I designed a system using Lasso (3.5 I think) with FileMaker
running on OS 9 on a 300Mhz G3 that handled about 4K hits per day, most
hits during typical works hours. Your system is definitely not in the
high-performance realm (no offense) and your hardware should handle the
load
Hello,
How can I see what char set is being used as the
default char set on the server or database?
Also, is there a way to change the default setting?
Thanks,
Yves
__
Post your free ad now! http://personals.yahoo.ca
--
Wes,
I don't think this is the issue as my passwords are all still in
the old format. Plus, the 4.0.16 client has no problem connecting.
Thanks -keith
Keith:
I don't know if it's the same problem, but I recently had issues where
I had a similar setup with only two MySQL servers, one 4.0.20,
Assume you want to check the availability of a room between two dates. You
only want to get the rooms that are available for the entire time from
@startdate to @enddate
set @startdate='some_start_date', @enddate='some_end_date'
SELECT r.room_number, r.room_type
FROM rooms r
LEFT JOIN
You can see it by executing the SHOW VARIABLES query on your server.
You will find the used charset in the 'character_set' variable.
You can also use the query SHOW VARIABLES LIKE 'character_set' which
will directly match what you want.
Yves wrote:
Hello,
How can I see what char set is being
Thanks,
As it turns out, I was trying show variables like --
And had a syntax mistake
Does SHOW VARIABLES only show a certain number of
lines? When I ran this command, character_set was not
listed... the list seemed cut off just before it.
Unless it is an issue with SSH only showing x
I would assume it would use reporting_id_t, since the WHERE
clause has both a.a_id and a.timestamp in it.
Eamon Daly
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Eamon Daly [EMAIL PROTECTED]
Cc: [EMAIL
It's possibly due to your ssh connection but I couldn't answer you about
this because I only use mysql with phpmyadmin.
Regards
Yves wrote:
Thanks,
As it turns out, I was trying show variables like --
And had a syntax mistake
Does SHOW VARIABLES only show a certain number of
lines? When I
So it turns out that the RPM install didn't work nor did the binary version
but by rebuilding the source with a
configure --prefix=/usr/local/mysql --- Well, that worked in the end. I
still don't know why but there it is. :)
Just thought I'd post my experience.
Cheers
-Original
mc [EMAIL PROTECTED] wrote:
Just curious if I have got something wrong with my eyes or fingers:
[EMAIL PROTECTED] mysql-max-4.0.20-unknown-linux-x86_64]# ldd bin/mysqld
librt.so.1 = /lib64/tls/librt.so.1 (0x003c71f0)
libdl.so.2 = /lib64/libdl.so.2 (0x003c7190)
Yves Goergen [EMAIL PROTECTED] wrote:
I'm using UTF-8 in my newsboard, too, and I have no major problems with
it. UTF-8 doesn't need to be handled as binary, I believe, since all
characters should be in a range over the control characters. Anyone
please correct me, if that's wrong...
Tris
Michael Dykman [EMAIL PROTECTED] wrote:
could someone please tell me which versions of mysql support SSL
connections for both clients and replication slaves?
The -Max build.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by
Brilliant !
thank you so much!
only one more question: INNER JOIN is not a good choose because it
lists only the record with a matching ON clause, and this is the only
difference between LEFT and INNER, correct?
thanks again,
Giulio
Il giorno 29/lug/04, alle 16:03, [EMAIL PROTECTED] ha
Batara Kesuma [EMAIL PROTECTED] wrote:
I use MySQL 4.0.20 on my replication (slave) server. I noticed that when
I use kernel 2.4.26 SMP, the slave runs very slow (it can't catch up
with master). My machine has dual CPUs with HT. But if I change to
kernel 2.6.6 SMP, everything just runs fine,
[EMAIL PROTECTED] wrote:
Ok, I will be the first to say that I am learning about indexes, however
it is my understanding that if I have a database with MANY rows and I
wish my queries to be faster I should index my database. With that being
said, I have 2 tables in my database that are being
Robert Harrison [EMAIL PROTECTED] wrote:
I have been asked to provide a searchable electoral roll.
This data comprises of first name, surname, address for every person
over 18 in the UK. Approximately 30 GB
The data is to be used to find people in a certain area.
EG
All John Smith in
Santino [EMAIL PROTECTED] wrote:
The question is very simple:
Your question was forwarded to MySQL licensing people. You will receive an answer
shortly.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
No. a.a_id is used in the join to b, not for selecting records in a.
Eamon Daly wrote:
I would assume it would use reporting_id_t, since the WHERE
clause has both a.a_id and a.timestamp in it.
Eamon Daly
- Original Message -
Stephen Rasku [EMAIL PROTECTED] wrote:
We are currently using a flash drive to store our database but we want
to store it in a RAM disk to prolong the life of the drive. We want to
install the database on the RAM disk on startup and save it to flash on
shutdown.
There are two databases
Rick Dwyer [EMAIL PROTECTED] wrote:
I want to install MySQL on a RAID mirror drive using two ATA 125GB
for the mirror. I know in a webserver config, it's best to put the
boot OS on one drive and the shared serving folder on the RAID mirror
drive. Under a MySQL server, if I install the OS
On 29.07.2004 17:33 (+0200), Egor Egorov wrote:
Yves Goergen [EMAIL PROTECTED] wrote:
I'm using UTF-8 in my newsboard, too, and I have no major problems with
it. UTF-8 doesn't need to be handled as binary, I believe, since all
characters should be in a range over the control characters. Anyone
Hello all
Can any one give some advise on moving mysql databases from
windows 3.x to unix 4.x
I have created dump files using:
Mysqldump --user=myuser --password=mypassword --opt database
database.dump
Are there any issues I shoud be looking out for?
Thanks,
Bert
--
MySQL General
M$ SQL server has a function MM that will do some date conversion, is
there an equivalent in MySQL ??
Chris Hood
Investigator Verizon Global Security Operations Center
Email: [EMAIL PROTECTED]
Desk: 972.399.5900
Verizon Proprietary
NOTICE - This message and any attached files may
Not being an MSSQL expert, I don't know what MM does, and since you did not specify
what type of conversions you wish to perform, I can't say exactly which function would
suit your needs, but here is a link to the manual page that lists all date and time
functions --
When it comes to JOINS, there are 3 flavors in MySQL: LEFT, RIGHT, and
INNER.
This is an example of how to join two tables a and b:
SELECT (some columns) FROM a XXX JOIN b ON (some logical comparison) WHERE
(some overall condition)
Behind the scenes, the data engine creates a virtual table
[snip]
No. I've forgot to tell that the -Max binary is linked dynamically because
it uses
SSL.
Here are the results from my installation... in case you may find them
useful :)
[EMAIL PROTECTED] root]# file
mysql-standard-4.0.20-unknown-linux-x86_64/bin/mysqld
Hi,
I configured MySQL to compile as a 64bit executable on a Sun Ultra10. I
set all up as per the installation instructions and created/installed
the startup scripts:
- /etc/init.d/mysql
- /etc/rc3.d/S99mysql
- /etc/rc0.d/K01mysql
The MySQL daemon failed to start at system startup. The log
the fact that data is stored in Cluster/NDB instead of one of the more
conventional engines is pretty much transparent to the client
application: it just connects to mysql server as per usual and the
server does all that work.
What you will have to worry about is the incompatibility between mysql
Windows does not preserve the case sensitivity of the table names.
-Original Message-
From: Bert Beaudin
To: [EMAIL PROTECTED]
Sent: 7/29/04 11:02 AM
Subject: Moving database from windows 3.x to unix 4.x
Hello all
Can any one give some advise on moving mysql databases from
I do not know of an MM() date function in MS SQL, only mm used for the date
part. What are you attempting to accomplish?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 7/29/04 11:17 AM
Subject: Date Conversion Function
M$ SQL server has a function MM that will do
Is it possible to use the Lucene fulltext search on a MYSQL database -
say for text type fields?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Shawn,
Thanks for your help, I was wondering, if you can make any sense out of
WHERE should I insert the TOP Commands, in the snippet below. Although
this code is specific to our application, but maybe you can help me with
this.
Thanks, and I really appreciate your help.
-Kamal.
/*
In MySQL, the LIMIT clause is usually the very LAST part of any query. I
would put it here:
/* Logic goes here for Offset parsing */
PRINTF (s_Where, WHERE iv_alert.uuid %d ORDER BY iv_alert.uuid ASC,
i_Offset )
Right after the ASC. This should limit you to only 1 responses:
...ORDER BY
Hi, i have been using Lucene MySQL but separately, MySQL is written in
C/C++ with a JDBC driver available and Lucene is coded in Java, so (besides
the mysql team opinion) you can mix searches throught both apis and
referring to each other with the PrimaryKey.
This combination works fine for
Carlos Proal wrote:
Hi, i have been using Lucene MySQL but separately, MySQL is written
in C/C++ with a JDBC driver available and Lucene is coded in Java, so
(besides the mysql team opinion) you can mix searches throught both
apis and referring to each other with the PrimaryKey.
Does anyone
matt ryan wrote:
There is a perl script that comes with MySQL called mysqldumpslow.
You can just run it on your slow log and it will output summary
statistics about the slow log.
I saw that in the docs, but I definitly dont want to install perl on a
production server, I never looked to see
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jon Hancock wrote:
| Carlos Proal wrote:
|
|
|Hi, i have been using Lucene MySQL but separately, MySQL is written
|in C/C++ with a JDBC driver available and Lucene is coded in Java, so
|(besides the mysql team opinion) you can mix searches throught
...snip...
This combination works fine for some scenarios but it doesnt for
others, in some cases the best choice is to use the FullText feature
available in MySQL which employs the same Vectorial Model that
Lucene's do. One advantage of Lucene is that is composed of layers and
you can
Hello all,
I have two mysql tables. They have a slightly different structure but
share comom columns.
I need to get the top 100 sold parts ( partnumbers and quantities) from
table Sales and insert into table Suggestion
if I issue a query : SELECT partnumber,qty from Sales order by qty desc
From: leegold [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: Lucene with MYSQL
Date: Thu, 29 Jul 2004 16:56:23 -0400
...snip...
This combination works fine for some scenarios but it doesnt for
others, in some cases the best choice is to use the FullText feature
available in MySQL which
I am running MySql 3.23.58-1 on a snort database containing IDS alerts.
At 12:00am I would like move the previous day's alerts from four tables to
a backup database named for the previous day.
Has anyone implemented such a backup schedule? And if so can someone
send me a script?
I had the
Hi,
You can use
Insert into Suggestion
(column 1, column 2, column 3, ..)
SELECT partnumber,qty from Sales order by qty desc limit 1,100
Regards,
Laercio.
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: quinta-feira, 29 de
I'm reading through the doc (gasp!) on the mysql.com site, specifically,
2.4 Unix Post Installation Procedures:
http://dev.mysql.com/doc/mysql/en/Unix_post-installation.html
The first sentence in the last paragraph before the numbered steps says:
In the examples shown here, the server
At 17:40 -0500 7/29/04, Whil Hentzen wrote:
I'm reading through the doc (gasp!) on the mysql.com site, specifically,
2.4 Unix Post Installation Procedures:
http://dev.mysql.com/doc/mysql/en/Unix_post-installation.html
The first sentence in the last paragraph before the numbered steps says:
Got it. One of those 'had to read and re-read' multiple times things.
If you install using an RPM, the account should be created for you.
I've done this now. I ripped out all the old files, did a complete RPM
install and up to testing, everything ran fine.
In order to see if the
2.6 - IO scheduler has some major problems. The DeadLine and Anticipatory
schedulers underperforms compared to 2.4 Linus scheduler. In theory they
should rock, but there are some major problems with it. Currently the 2.6 VM
rocks and is way to fast for the 2.6 IO schedulers. On top of that they
INSERT INTO Suggestion SELECT partnumber,qty from Sales Limit 1,100;
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 29, 2004 2:01 PM
To: [EMAIL PROTECTED]
Subject:
Hello, mysql Gurus,
Because of disk space issues, the data dir of my mysql DB is somewhere
else other than /var/lib/mysql. I did not link /var/lib/mysql to the real
data dir though. It works OK until I want to use perl DBI which complains
can't connect to mysql thru
people
actually this is a stupid question i suppose..but..
i tried out to run a query from my C program using prepared statements..
It is giving ..undefined reference
so anyone who worked on prepared statements can give me the headers that i
should include to run them..
Thanx in
On Thu, Jul 29, 2004 at 08:10:42PM -0700, Ginger Cheng wrote:
Hello, mysql Gurus,
Because of disk space issues, the data dir of my mysql DB is somewhere
else other than /var/lib/mysql. I did not link /var/lib/mysql to the real
data dir though. It works OK until I want to use perl DBI
60 matches
Mail list logo