hi,
i want to configure a two-machines mysql clusters. i have compiled from
source by enabling the clustering feature with no problem at all. i read
the documentation on mysql. but, i am not understanding on how to make a
simple mysql cluster. basically, i just want to have a kickstart. that's
hello All,
can anybody tell me how to correct this problem:
1. I use queries like that:
select /*! SQL_BUFFER_RESULT */ klient.logo, klient.klientid,
klient.klientnazwa, klient.struktura, concat(kodpocztowy,' ',miejscowosc)
miasto, aparatnumer, concat(ulicaskrot,' ',ulicanazwa,' ',posesja)
Hi,
I am trying to setup replication on MySQL.
Version 4.1.0alpha
Using:
./bin/mysql -h IPADDR -u replication -p
I can connect successfully, but my error logs show
041221 1:12:41 Slave I/O thread: error connecting to master
'replication # MU@IPADDR # MUST BE SET:3306': Error: 'Can't connect to
Hi,
I have the following problem: One table becomes locked and the lock is never
released. I do not use any form of LOCK TABLES to lock the table, I only do
SELECT, INSERT and UPDATE queries. The table stays locked until the server
reaches max_connections and server becomes unavailable. The
Michael, Gleb,
thanks a lot for your hints!
Now I know that default database means current database.
And I did not find Section 13.3.2 in the fine manual because I searched
for default database and we find the string default (current)
database there :-( .
Regards,
Frank.
Michael Stassen
Hi,
So sorry for my poor english.
I've tried to compile the last mysql snapshot on Fedora Core 1 without any
success due to a missing file.
Find here the error message obtained :
make[2]: Entre dans le répertoire
`/tmp/mysql-5.0.3-alpha-nightly-20041215/extra'
../extra/comp_err
Hi,
I have (among others) three tables in my database that i am struggling with
a join query on. The database holds dates for Bookings. If Users are
Allocated to a particular Project they can be booked. However if a user is
booked but then unallocated I want to be able to display all peolple
Daniel,
it is simply processing big SELECT queries. Maybe their optimization changed
lately? You should tune your queries.
You should also tune InnoDB, because you are running with the default 8 MB
buffer pool size, and it is reading in 6000 pages per second!
Best regards,
Heikki Tuuri
Hello,
I was wondering if it's possible to select all fields from a table except
certain columns, e.g.:
select * except text_name from text
I have found several discussions on and outside the MySQL mailing lists that
suggest it's not possible in (My)SQL. Why is this? It is a feature that
matt_lists wrote:
Can you post your my.ini or my.cnf
sense your restore actually worked
Mine is not swapping, in fact, mysql is only using 610,824 K of ram,
there is still over 1 gig of ram free
Our next server will have 16 gig of ram and quad xeons, I'm going to
completely disable the swap
matt_lists wrote:
matt_lists wrote:
Can you post your my.ini or my.cnf
sense your restore actually worked
Mine is not swapping, in fact, mysql is only using 610,824 K of ram,
there is still over 1 gig of ram free
Our next server will have 16 gig of ram and quad xeons, I'm going to
completely
Which are faster for updates queries?
Our indexes are packed, and run 2-6 gig
I'm having problems restoring tables, takes 3 weeks to restore one large
table, in fact the restore is still going so it may take a month
I was thinking this may be due to the packed fields, and a large primary key
- Original Message -
From: Mark van 't Zet [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 20, 2004 6:59 AM
Subject: Select * except certain columns
Hello,
I was wondering if it's possible to select all fields from a table except
certain columns, e.g.:
select *
Hi all,
I originally posted this to the replication list, but as I haven't yet
received a response, I thought I'd try my luck here...
I'm having some troubles with replication, in particular restarting a
slave. I'm using MySQL 4.0.22 for the slave, and 4.0.21 as the master.
I've followed the
Hi Rob,
LOAD DATA INFILE is not a very verbose command. It
doesn't spill out the exact root cause of the error.
Forgive me, if I seem to be wrong for anybody who had
a different opinion.
mysqlimport is a wrapper around LOAD DATA INFILE with
a lot of command line options. You might try your luck
I'm working on a rather large database with many cross-linked tables
currently using auto increment IDs. The system is primarily a web based
system, however, there will be times that the system will be run as a stand
alone server...meaning no internet connection is available.
The question
Software Engineer,
Hewlett Packard
--- rob byrne [EMAIL PROTECTED] wrote:
I am trying to load data from a text file into a
table using the Load data
infile statement. No matter how I change data types
I seem only able to load
in the first row of data into the MySQL table and no
more. I have not
[EMAIL PROTECTED] wrote:
However, when I restart the slave (through init scripts, or when
rebooting the server etc.), instead of continuing on from where it left
off, it appears to start again from the beginning. This is confirmed by
watching the value of Relay_Log_Pos from SHOW SLAVE STATUS\G.
So this would imply that you cannot simply stop/start a slave server -
instead, I would need to write a wrapper script that stops the slave
using STOP SLAVE, and at next startup, read the master.info file to
find out where it left off, and then issue a CHANGE MASTER TO...
statement to continue on
Hi,
I'm currently experimenting with Cluster for the first time (using mysql
4.1.8 under Red Hat 9.) I've set up a combined manager and API node, and
three storage nodes. It all seems to be working fine (I can create
tables using ENGINE=NDB and see all three storage nodes from within
the ndb_mgm
JUST copy it from the 5.0-alpha source. =)
On Mon, 2004-12-20 at 11:30 +0100, John PAUL wrote:
Hi,
So sorry for my poor english.
I've tried to compile the last mysql snapshot on Fedora Core 1 without any
success due to a missing file.
Find here the error message obtained :
make[2]:
First of all MySQL replication do not mismatch position in simply
starting and stopping the slave as long as you have all relay and info
files.
Secondly, change master recreates the master.info file.
Third...one can implement the log_position table on slave inserting a
record every minute to
Hello.
Yes, if you have one of the last releases of MySQL, you can try to test
the fifth version. But some features will be unavailable. See:
http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.1.html
Jonathan Villa [EMAIL PROTECTED] wrote:
I have an installation of 4.1 and 5 running
Hello.
When you are connecting using mysql, you usually don't specify the destination
port.
By default it's 3306.
And at the same time master-port=. Send us complete contents of config
files. What is in master error log? Check to what port slave instance is trying
to connect (with
Hello.
Looks like LOAD DATA INFILE supports only string constants in
its syntax. I think it has sense, because security risk grows,
when we can substitute variables in the file name.
Scott Klarenbach [EMAIL PROTECTED] wrote:
I can't seem to make the Load Data statement work inside of
Hello.
You should carefully read chapters of manual related to the
character sets. Use
SET NAMES 'gbk'
or
SET character_set_client = 'gbk';
SET character_set_results = 'gbk';
SET collation_connection = 'gbk';
to specify character_set_client, character_set_result,
Hello.
Use ALTER TABLE. See:
http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
I goofed up when creating my table - I established my column in reverse order.
How can I
move them all back around?
Jonathan Sampson [EMAIL PROTECTED] wrote:
--
For technical support contracts, goto
I have hit a snag in setting up a Boolean search; my query is returning 0
results when there are definitely five matches in my table.
My query is set up as follows:
SELECT * FROM resources WHERE MATCH (organization_name, description) AGAINST
('keep' IN BOOLEAN MODE);
'Keep' is a word that shows
[EMAIL PROTECTED] wrote:
So this would imply that you cannot simply stop/start a slave server -
instead, I would need to write a wrapper script that stops the slave
using STOP SLAVE, and at next startup, read the master.info file to
find out where it left off, and then issue a CHANGE MASTER TO...
keep is a full-text stopword, by default, which means it isn't indexed.
You'll need a custom stopword list if you want keep to be indexed. See
the manual for details
http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html.
The default list of stopwords is in myisam/ft_static.c in a source
On Mon, 20 Dec 2004 09:29 pm, Heikki Tuuri wrote:
Daniel,
it is simply processing big SELECT queries. Maybe their optimization
changed lately? You should tune your queries.
You should also tune InnoDB, because you are running with the default 8 MB
buffer pool size, and it is reading in 6000
I've got a 4.1.7 server on Linux and I need to use the old-passwords
option. It has taken effect as 'show variables' confirms. Also, if I
set a user's password using 'set password for user =
password('apassword')' it honors the old-passwords option. However, if
a user changes their
Hi all,
I downloaded the source from bk tree and I saw the federated engine.
Taking a look into documentation
(http://dev.mysql.com/doc/mysql/en/index.html) I didn´t find anything.
So, where I can find some info about it ?
Thanks in advance.
(sorry my poor english ;) )
--
Luciano Barcaro
Depto.
Is there anyway to get additional information about a query that is currently
running? I've got some performance problems I'm trying to analyze while
loading large data sets and I'm running a test query, but I don't have any
idea how far the query has progressed.
The test query is a
Can a user see their own permissions for a database?
I'm working on a PHP project that will hopefully automagically
generate forms based on a user's permissions. Do I have to create a
seperate account to find out what a particular user's permissions are,
or is there some way to read permissions
I'm new to MySQL and I was wondering which storage
engine is the best choice for heavily-indexed,
read-mostly data.
From skimming over the documentation, it seems that
MyISAM is a better choice since it doesn't have the
transactional overhead. Yet I'm worried that it's
becoming depricated and
Are there any way to configure MySQL 4.1 to use more than one drive for
data files (for example, in a RAID 5 solution)? If so, could somebody
point me at the right information.
Regards,
-JF
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I found that restarting the mysql server does not recreate the
master.info file in the data directory. Although I had changed some
settings in the /etc/my.cnf they did not populate the master.info file.
So after banging my head for so many hours I deleted the master.info
file and restarted the
Hi,
Could any one of you help me in creating two users like First user with
all dba privileges as root and the Second user with only dml operations.
And in loading data using LOAD DATA INFILE, if I use the file full path,
I am getting error. And if I put the file in mysql\bin it is
I downloaded a TAR file from a link I found at
http://www.itis.usda.gov/ftp_download.html
The page also includes the following instructions:
* The schema file (itis.sql) is an ASCII file that
includes all of the create table statements plus
additional information. This will allow comparison to
40 matches
Mail list logo