PM
To: mysql@lists.mysql.com
Subject: Re: Slave stuck at "registering"
Victor Pendleton wrote:
> Can you see the slave thread on the master when you do a show processlist
> from the master?
Yes. It shows up with the command as "Sleep", nothing in the
"State"
Can you see the slave thread on the master when you do a show processlist
from the master?
-Original Message-
From: Keith Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 05, 2005 1:48 PM
To: mysql@lists.mysql.com
Subject: Slave stuck at "registering"
I'm trying to set up replication o
Try show index from t1;
Show index from t2;
-Original Message-
From: Jacek Becla [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 03, 2005 4:00 PM
To: Jay Blanchard
Cc: mysql@lists.mysql.com
Subject: Re: how to check if keys disabled?
Jay
Are you sure? DESCRIBE tells me the table has an ind
What device driver are you using to access the database? Can you run a sql
trace or maybe turn on the logging on the server side?
-Original Message-
From: mos [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 23, 2005 11:05 AM
To: MySQL list
Subject: MySQL server disconnects when executing
Does SQLyog log any errors for you? Are your lines terminated by \n or
\r\n? Have you tried performing this import with the LOAD DATA INFILE
command? There you could at least see if warnings or errors were
encountered.
Scott Hamm wrote:
I got my csv delimited using "{" as follows:
87547{2404149
Do you know how the file was created/exported from Oracle? Are the files
contents viewable?
Marcos Sanches wrote:
Hello all,
I am a new user, in fact I've never used any software like Mysql,
oracle or sqlserver. But I am very familiar with analysing data, I am a
statistician. I've just received
Is the DATE_ADD(time, INTERVAL) an option?
SELECT Now(), DATE_ADD(Now(), interval 60 minute)
schlubediwup wrote:
Hi again mysql-listers
mysql> select version();
++
| version() |
++
| 4.1.9-standard-log |
++
1 row in set (0.00 sec)
InnoDB files can not be copied from one machine to another like the
MyISAM files. If you did not dump the data or you do not have an
archived backup you will more than likely have to recreate the table
structures.
David Blomstrom wrote:
Yikes...I've been replying to myself! I forgot that
when I
I believe it may be because the tables in the Query cache have been
modified causing the cached results to become invalid.
Olivier Kaloudoff wrote:
Hi,
I noticed the following behaviour on mysql 4.1.8
and two servers;
to setup replication, I did the required grant on
the master, and choo
Did you install MySQL as a service and have you started the service?
Sheni R. Meledath wrote:
Hello:
I am trying to install mysql on my laptop which is running Windows XP
professional. But after installation when trying to connect to the MySQL
server I am getting the following error message:
Erro
What do you get when you do a `which mysql` from the command line?
James Sherwood wrote:
Yes, there are other databases on that mysql installation.
The only thing is, I recently upgraded it to the latest release of mysql.
James
- Original Message -
From: "Victor Pendleton&quo
Did you install MySQL on the other box? It sounds like you took a
snapshot of the data but have not installed the executables yet.
James Sherwood wrote:
I am trying to transfer a database from one linux box to another, both using
redhat.
On one I performed a mysqldump and it worked fine.
On the o
Have you verified that the MySQL server is currently running? Was this
installed as service to automatically start up?
Leandro Melo wrote:
Hi, i built an application which uses MySQL 4.0.17
using Windows XP Professional.
Tomorrow, i need to present the application to my
client, so i preparing my
What does the show processlist look like?
Have you ran top/vmstat/iostat when the `hanging` occurs?
Hjalmar Gislason wrote:
Hi there,
I've been having some trouble with an application that I'm running
(www.spurl.net).
I have a database that consists of about 20 tables. The largest tables are a
litt
Have you tried optimizing or run an analyze table command on this table?
Aaron wrote:
Hi all ,
I have a relatively simple query that is taking longer than I think it
should. Can anyone possibly give me some idea why this might be or any
potential bottleneck areas I might want to check out?
thanks
What errors are being displayed when you attempt to log in? Is anything
being written to the error log itself?
A. Clausen wrote:
I made a copy of my entire Mysql 3.23 data directory and moved it on
to a box with a fresh install of MySQL 4. While the NT service starts
up fine (I'm using 4.0.22-
Understandable. The state, command and info values from `show
processlist` could shed some light on what is occurring.
Paul Smith wrote:
%% Victor Pendleton <[EMAIL PROTECTED]> writes:
vp> What state are the queries in while they are hung? What command or
vp> SQL are th
What state are the queries in while they are hung? What command or SQL
are they executing?
Paul Smith wrote:
%% Victor Pendleton <[EMAIL PROTECTED]> writes:
vp> When the database is in a `hung` state, is the file system where
vp> the MYI, MYD and frm files accessible?
Definitely.
When the database is in a `hung` state, is the file system where the
MYI, MYD and frm files accessible?
Paul Smith wrote:
%% Gleb Paharenko <[EMAIL PROTECTED]> writes:
gp> Very often similar symptoms causes various lock problems. Do you
gp> use InnoDB? Try log_slow_queries to find hung queries.
t (0.00 sec)
Jeff Smelser wrote:
On Tuesday 07 December 2004 02:03 pm, Victor Pendleton wrote:
> A function on the left hand side will nullify the use of an index.
Sides dont matter, a function on an index, no matter what side, will
kill an
index.
Jeff
--
MySQL General Mailing List
For list arch
A function on the left hand side will nullify the use of an index.
Marc Dumontier wrote:
Hi,
I'd really appreciate any help in speeding up this type of query
SELECT BindId,RecordType from BrowseData WHERE
DATE_FORMAT(DateLastRevised,'%Y-%m-%d') = '2004-12-07';
On a MYISAM table of 122,000 rows, t
When the server begins to slow down, what does top reveal?
Andrew Nelson wrote:
The reason I ask is because eight select statements should not bog
down a production server. On the MySQL side, is anything being
written to the slow query log? On the application side is there any
virus scanning or
The reason I ask is because eight select statements should not bog down
a production server. On the MySQL side, is anything being written to the
slow query log? On the application side is there any virus scanning or
similar activity being performed? Does iostat show any heavy reading or
writing
How did you deduce that the database server is the bottleneck? Are all
your processes running on the same machine?
Andrew Nelson wrote:
Hi,
I have a MySQL 3.23.55 server managing accounts on my exim mail server..
The table type on all tables MyISAM.. I have the MTA performing
various queries
fo
Have you tried connecting with this user directly from the MySQL monitor?
Hathaway, Scott L wrote:
I have a server that is Windows 2003 server. It is running php from IIS
6. I access the latest 4.0x MySQL and am having some trouble. My
database access is readonly. The user that I connect as has
Do you have an index on the client_id in the t_quiz table? Can you post
the ddl for t_quiz?
Ady Wicaksono wrote:
mysql> alter table t_quiz_trivia add foreign key (client_id)
references t_client (client_id) on delete set default;
ERROR 1005: Can't create table './smsserver/#sql-215d_11eff.frm'
(
connections will be allowed.
|Scott Haneda wrote:
on 11/30/04 8:53 PM, Victor Pendleton at [EMAIL PROTECTED] wrote:
If you plan on connecting only from the localhost host or via an ssh
tunnel you block port 3306 at the firewall or router. What exactly are
you looking to accomplish?
Well, some
If you plan on connecting only from the localhost host or via an ssh
tunnel you block port 3306 at the firewall or router. What exactly are
you looking to accomplish?
Scott Haneda wrote:
I can do a telnet host.com 3386 and get a answer back from mysql. Is the
only way to turn off remote access
Are you data files on a local filesystem? When this issue occurs can you
access any regular files on the drive?
Ajay Kalambur wrote:
Hi
We have been having problems with a MySql database that runs on Linux.It
just occurred suddenly and was working fine before
Details:
MySql Version:# mysql Ver 1
Is there an index on the column in the table referenced?
F.Balicchia wrote:
Hello i'd like to converte this DDL for mysql
ALTER TABLE MYTABLE_ROLE
ADD ( FOREIGN KEY (LOGIN)
REFERENCES MYTABLE_USER ) ;
i wrote
ALTER TABLE MYTABLE_ROLE
ADD FOREIGN
Is the MySQL server running and you can not connect? Or are you not able
to start the MySQL server?
Morris, Andrew wrote:
../var/lib/mysql/mysql.sock.
I've been round the houses with this following the thread but I can't
get past this error despite all the chmod and chown modifications,
insta
To: Victor Pendleton
Cc: [EMAIL PROTECTED]
Subject: RE: how to connect to MyDBPAL from MySQL
YES ODBC work perfect. I am using same data source for MySQL
administrator and Query Browser too.
Anyway, if you are using can you go over the steps for db connection
1. Open dbPAL, Click on Workshop
2
Are there any MySQL errors being logged? Did you confirm that the ODBC
connection is working?
Sanjeev Sagar wrote:
I have seen mails talking about MydbPAL. I downloaded it and I have
MySQL ODBC data source too but not able to connect to MydbPal at all. I
have tested my odbc data source, it work j
http://www.gunmuse.com
469 228 2183
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 23, 2004 11:10 AM
To: [EMAIL PROTECTED]
Cc: Eamon Daly; [EMAIL PROTECTED]
Subject: Re: On but off topic Putting a file in Ram
Is the actual data stored in the dat
Is the actual data stored in the database or somewhere in the file
system? If you do not have text or blob columns you may be able to use
heap/memory tables.
[EMAIL PROTECTED] wrote:
Actually no. I have a file that is determined to be requested by mysql (Top
100 site) What I am wanting to do i
You can load the file to an intermediate table and then complete your
process using
INSERT INTO targetTable
SELECT col_1, col_5, col_28, col_71
FROM intermediateTABLE
Ferhat BINGOL wrote:
Hi,
I have a 72 fields data txt file and I was inserting all data previously
but now I need only some of them
If you build the composit indexes as suggested, does your performance
improve?
John Smith wrote:
On Thu, 2004-11-11 at 13:58, Victor Pendleton wrote:
What does the explain plan look like?
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE
What does the explain plan look like?
John Smith wrote:
Afternoon All,
I have the following table structure:
CREATE TABLE properties (
id int(11) NOT NULL auto_increment,
propid varchar(14) NOT NULL default '0',
townid varchar(255) NOT NULL default '',
countyid mediumint(5) NOT NULL default '0'
If you are on an *nix system you can try
\! echo Hello > test.txt
Rhino wrote:
Sorry, you still haven't got it;-)
I want the echo command to be in the *script*, not to be supplied at the
command line. Is there some way to put a mix of MySQL commands and OS
commands into a script and have both execu
What is written to ther error log?
Marc wrote:
I'm using MySQL on Gentoo Linux and today it stopped starting up. It was
working a few days ago, and I haven't played with anything in the system
- no new installs, config changes, etc. It just decided to go on
vacation.
I run mysqld_safe and it quit
A data type conversion will have to take place and depending on the size
of the tables the performance could be quite miserable.
Qunfeng wrote:
Hi,
MySQL seems to be able to JOIN columns with different types, e.g., one
column type is int; the other type is varchar. My question is: how
badly do
What version of MySQL are you using? I believe multiple delimited
statements are available in 4.1.x and later.
Jeff Burgoon wrote:
I'm writing my first MySQL app in VB.net using myODBC. However I think this
question applies to all languages using MySQL. From what I understand, I
am unable to i
In the slave's my.cnf have you tried just expliciting statement what tables
to ignore?
replicate-ignore-table=db.table1
replicate-ignore-table=db.table2
...
replicate-ignore-table=db.tablen
And remove the other statements?
-Original Message-
From: Mike Lohman
To: [EMAIL PROTECTED]
Sent:
Did you actually stop all writes to the master data while you were copying
the data over to the slave database? Is it possible that the connection you
issued the read lock with timed out before the transfer was completed?
-Original Message-
From: Alex Greg
To: [EMAIL PROTECTED]
Sent: 9/2/
DuBois just trumped me. Just check the version from the command line.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 9/2/04 10:13 AM
Subject: RE: 4.1.4 still reports itself as 4.1.3b-beta
Further to last message, I've found that string in three different
places
in
You can test if this is correct by manually starting the service from a dos
window and logging and seeing what version this executable actually is.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 9/2/04 10:01 AM
Subject: RE: 4.1.4 still reports itself as 4.1.3b-beta
In the registry and/or the windows service utility see which executable is
actually in the path.
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 9/2/04 9:19 AM
Subject: Re: 4.1.4 still reports itself as 4.1.3b-beta
Oh, yes, certainly, Egor. I stopped it before doin
Not if the host that is blocked is `localhost`.
-Original Message-
From: Michael Winston
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 9/1/04 11:24 AM
Subject: Re: bad "too many connections" error (os x)
This would make sense since they all the connections are c
What will the connection be used for? Replication? Query between
datasources? There are some third party applications such as Golden Gate
that have replication products. You could also write the connection yourself
in a language such as Java or C.
-Original Message-
From: Seena Blace
To:
Is it a too many connections or Host blocked because of many connection
erros? If it is the later you have reached max_connect_errors and need to
issue flush-hosts.
-Original Message-
From: Michael Winston
To: [EMAIL PROTECTED]
Sent: 9/1/04 11:02 AM
Subject: bad "too many connections" erro
Is there already a mysql privileged account logged in? The database will
allow for an administrative account to login, if one is not already active,
in the event of too many connections. It sounds as if you may be running one
or more accounts with this privilege.
-Original Message-
From: J
How did you plan on using the information pulled from the database? If you
are currently using MS Query or a DSN you can modify the current connection
information to point to your MySQL database.
-Original Message-
From: redhat
To: mysql
Sent: 8/27/04 2:21 PM
Subject: powerpoint and mysql
Can you run this from inside the monitor and see if any messages are sent to
the consol?
\. latest_distribution.sql
-Original Message-
From: Mike Morton
To: [EMAIL PROTECTED]
Sent: 8/26/04 12:05 PM
Subject: Mysql command line queries not working
I know the subject is not totally desc
You will have to call the last_insert_id() function in order to obtain the
autoincrement value.
-Original Message-
From: dan orlic
To: [EMAIL PROTECTED]
Sent: 8/25/04 2:26 PM
Subject: autoincrement question
question:
I have an insert statement that has a null for the value of the
pr
If you have DTS you can export the data to a CSV format. If you have MyODBC
installed you could export directly to MySQL.
-Original Message-
From: Tim Winters
To: Victor Pendleton; '[EMAIL PROTECTED] '
Sent: 8/24/04 11:34 AM
Subject: RE: sql2000 to mysql
Hi Victor,
Just Table
Are you wanting to move Foreign keys, Triggers, Stored procedures and the
like as well or just the data?
-Original Message-
From: Tim Winters
To: [EMAIL PROTECTED]
Sent: 8/24/04 10:36 AM
Subject: sql2000 to mysql
Hello,
Can someone advise me of the best/easiest way to move an entire DB
Do you have anything in the show processlist? Are you using innodb table
types and a rollback is occurring?
-Original Message-
From: Thomas - Lists
To: [EMAIL PROTECTED]
Sent: 8/24/04 6:49 AM
Subject: runaway process eating all cpu-time?
Hi there,
after a system-crash I got the following
Why don't you disable the indexes before the load and enable the indexes
after the data load?
-Original Message-
From: Jesse Sheidlower
To: [EMAIL PROTECTED]
Sent: 8/23/04 3:33 PM
Subject: Testing for the existence of an index
I have a database where, most of the time, I'm bulk-loading
Try
alter table usuarios auto_increment = 1;
-Original Message-
From: Yusdaniel Rodriguez Espinosa
To: [EMAIL PROTECTED]
Sent: 8/23/04 9:15 AM
Subject: How to Reset a field
Hello
I have a db with table "usuarios" I erased all data in this table but
"Id"
is a autoinc and he have the value
If you wanted html output you could do this
mysql -u -p -H -e"query_to_run" > webFile.html
...
The -H switch produces HTML output.
-Original Message-
From: mos
To: [EMAIL PROTECTED]
Sent: 8/23/04 12:11 PM
Subject: Re: into outfile
Scott,
At 11:58 AM 8/23/2004, you wrote:
>SELECT
>
Are you loggin into the terminal and PHPmyadmin as the same user?
-Original Message-
From: Hull, Douglas D
To: Note To MySQL List (E-mail)
Sent: 8/23/04 8:30 AM
Subject: showing dbs in terminal window opposed to phpmyadmin
How come when I am using the terminal on my mac os x 10.3.x and
Use the -p option so that the server can prompt you for the password you
just created.
mysql -uroot -p
-Original Message-
From: Francois A. Atallah
To: [EMAIL PROTECTED]
Sent: 8/20/04 12:59 PM
Subject: Login problem
After Installed mysql on Windows I have entered a root password using
th
Can you use the -w/--where option in mysqldump to dump only the records you
want?
-Original Message-
From: Tucker, Gabriel
To: Mysql General (E-mail)
Sent: 8/20/04 8:07 AM
Subject: Remotely dumping data to a file
Hi All
I would like to dump certain data remotely from a table.
I am unable
What is the current value for you id field? Approximately how many records
are you inserting?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/20/04 3:16 AM
Subject: load data infile
Dear freinds,
I am still getting errors.Load infile script. Guidance , please.
Are you getting any error messages?
-Original Message-
From: Andre Mato
To: [EMAIL PROTECTED]
Sent: 8/19/04 9:59 AM
Subject: Restoring dump file problem
Hi List,
Today I got a surprise when I tried to restore a dump file did
yesterday. I
did not work. I don't know if because is too big,
Has the ODBC user been removed? Have you logged into mysql, mysql -uuser -p
and done show databases?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/19/04 9:44 AM
Subject: Databases not showing in cmd and mysqladmin?
Just so you know I am pretty new to all this.
There is not a function equivalent to Oracle's dump but you could throw
together a substring loop that prints out the ascii value of each character.
-Original Message-
From: Martin Gainty
To: [EMAIL PROTECTED]
Sent: 8/18/04 3:24 PM
Subject: contains?
is there way to interrogate what is
Felenstein
To: Victor Pendleton; '[EMAIL PROTECTED] '
Sent: 8/18/04 3:14 PM
Subject: RE: Strange Text Field
In the table that fails, and the one that works, I'm
using some products from a company called Interakt. I
mentioned this in my last reply, however didn't
mention one par
Can you log on as the web account and try to insert, update, select directly
from the MySQL monitor?
-Original Message-
From: Chip Wiegand
To: Victor Pendleton wrote on 08/17/2004 10:54:14
AM:
> Are there any errors being caught by the web form or being logged to
the
> MySQL err
What is the application you are using to insert and retrieve the blob data?
Is the data actually being inserted?
-Original Message-
From: Stuart Felenstein
To: [EMAIL PROTECTED]
Sent: 8/18/04 2:49 PM
Subject: Strange Text Field
Hoping I can figure this out. Using MySQl
4.0.20-Standard.
Either the socket has been removed or is in a different location than you
think. Try connecting by host and port. I would also verify with a database
restart that the socket is being created where you think it is. If you
continue to have issues look over this page to see if it helps.
http://dev.mys
Currently your timeout values are set for four hours. I would first attempt
to adjusty these to whatever suits your needs. Then connect and see if the
connections are disconnected.
-Original Message-
From: Linda
To: Victor Pendleton; [EMAIL PROTECTED]
Sent: 8/17/04 9:13 PM
Subject: Re
You have a cartesian join because you do not have join criteria between the
resume and candidate tables.
-Original Message-
From: Eve Atley
To: [EMAIL PROTECTED]
Sent: 8/17/04 12:22 PM
Subject: Assistance with SQL syntax: pulling duplicates back
I think this is an easy question...I've s
These server settings are independent of one another. Query cache size
should not effect your *_timeout values. Can you post the my.cnf section
where these values are intialized?
-Original Message-
From: Linda
To: [EMAIL PROTECTED]
Sent: 8/17/04 10:10 AM
Subject: query_cache_size will impa
Are there any errors being caught by the web form or being logged to the
MySQL error log?
-Original Message-
From: Chip Wiegand
To: [EMAIL PROTECTED]
Sent: 8/17/04 11:29 AM
Subject: I can delete, add, but not update
I don't know for sure, but I think I may have something wrong with
perm
If you are using MyISAM tables you can create a fulltext index. This index
should give you better performance over a wildcarded like search provided
that no more than fifty percent of your rows do not contain the word or
words you will be searching for.
-Original Message-
From: Eve Atley
T
This is described here:
http://dev.mysql.com/doc/mysql/en/Silent_column_changes.html. The table is
created as a fixed table format.
-Original Message-
From: Emi Lu
To: [EMAIL PROTECTED]
Sent: 8/16/04 3:20 PM
Subject: Why "VARCHAR" TO "CHAR" automatically when the length less than 4.
Hello
Do vmstat and top reveal anything about the server's performance? Can you
post the show status output?
-Original Message-
From: Boyd E. Hemphill
To: [EMAIL PROTECTED]
Sent: 8/13/04 12:17 PM
Subject: Tuning InnoDB situation
All:
I have been nosing about for some time now and think I need
: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'EWAGW '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, August 13, 2004 1:09 PM
Subject: RE: Pinging
> Can you describe your network setup? Are you expecting port 3306 to be
open
>
That depends on the setup and configuration and network and other factors. I
have been running slaves for months and a year with little to no problems.
Are you asking something in specific or just looking for feedback?
-Original Message-
From: Scott Hamm
To: 'Mysql ' (E-mail)
Sent: 8/13/04
Can you describe your network setup? Are you expecting port 3306 to be open
on your ISP? Are you ssh'ed in and you can not connect?
-Original Message-
From: EWAGW
To: [EMAIL PROTECTED]
Sent: 8/13/04 12:02 PM
Subject: Pinging
Hi list, I get this error from MySQL administrator, everything
If possible, and for testing purposes try starting the 4.1.3 server with the
options given on the command line. (datadir, pid, socket, port, etc...)
-Original Message-
From: sean c peters
To: [EMAIL PROTECTED]
Sent: 8/12/04 6:37 PM
Subject: datadir specification, etc
I am 100% convinced
Yes. Those keys are redundant.
-Original Message-
From: Cemal Dalar
To: Group MySQL List
Sent: 8/13/04 7:12 AM
Subject: Indexes
mysql> show index from urun;
+---++--+--+-+--
-+-+--++--+--
Have you set it up so that these instances run on different ports and
different sockets? If you are not using mysqld multi you will have to
specify which mysql/bin/safe_mysqld you want to start on the command line.
-Original Message-
From: sean c peters
To: [EMAIL PROTECTED]
Sent: 8/12/04
You can use mysqldump with the --fields-terminated by= option.
-Original Message-
From: David Perron
To: [EMAIL PROTECTED]
Sent: 8/12/04 1:07 PM
Subject: CSV Output
Im looking for a way to output a file into true CSV format (with quoted
fields) using the Perl DBI.
Does anyone know of a
Can you reset the slave to read the next event its relay log? If this is not
possible, is refreshing the data from the master a viable option?
-Original Message-
From: matt ryan
To: [EMAIL PROTECTED]
Sent: 8/12/04 10:22 AM
Subject: Help, slave wont stay running!
I cant keep the slave up f
On your two word plus searches, `New York` for example, have you tried using
`IN BOOLEAN MODE` to reduce the number of false positives?
AGAINST("New York" IN BOOLEAN MODE)
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/12/04 8:33 AM
Subject: RE: Fulltext Search ta
Are you using InnoDB tables? If so, have you properly configured the
directories?
-Original Message-
From: Jevos, Peter
To: '[EMAIL PROTECTED]'
Sent: 8/12/04 6:02 AM
Subject: Problem after crash
Hello
Please help me. Im newbie in the database and I got one crash after
outage.
Now my mysql
We Fulltext index multi million rows with very good response time. The
cardinality of `1` is okay. Did you fulltext index the rows as is or did you
create some sort of combined field?
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/12/04 7:43 AM
Subject: RE: Fullte
Can you system.out.println the sql statement to verify what you have is
correct? Also, are you using prepared statements?
-Original Message-
From: Shaffin Bhanji
To: [EMAIL PROTECTED]
Sent: 8/11/04 2:07 PM
Subject: HELP!!! SEVERE: VendorError: 1064 during INSERT
Hello All,
I have the fo
If you do an
ALTER TABLE table_name MODIFY id INTEGER AUTO_INCREMENT, ADD PRIMARY
KEY(id);
...
The next record entered should be properly auto_incremented.
-Original Message-
From: Scott Hamm
To: 'Mysql ' (E-mail)
Sent: 8/11/04 1:32 PM
Subject: Auto_increment and existing table
I've impo
You will need to know the name of the column(s) you will be indexing in
order to do this.
create temporary table some_table (index idx_name(col1)
SELECT * from source_table
-Original Message-
From: David Perron
To: [EMAIL PROTECTED]
Sent: 8/11/04 11:36 AM
Subject: Indicating an INDEX duri
Unless you are specifying some other type in your table creation statements,
your tables will be created as MyISAM.
-Original Message-
From: EWAGW
To: [EMAIL PROTECTED]
Sent: 8/11/04 11:30 AM
Subject: MySQL Tables
Hi list, If I am converting an access db to mysql what will the tables
be
Who did you log in as?
-Original Message-
From: Farnaz Akhavi
To: [EMAIL PROTECTED]
Sent: 8/10/04 9:57 AM
Subject: bug
I have downloaded and installed MYSQL Client/Server 4.0.
1. when I get a query on SHOW DATABASES, it only shows "test" and not
"mysql" which has the users info
2. It d
CREATE TEMPORARY TABLE
SELECT *
FROM
...
Query temp table
...
DROP TABLE
-Original Message-
From: bruce
To: [EMAIL PROTECTED]
Sent: 8/10/04 12:45 AM
Subject: using temp tables...
hi...
in trying to get a better understanding of temp tables. is there a way
to
perform a select, to writ
You can use mysqld_multi to run different versions of MySQL on the same
Server. You can run 4.0.x, 4.1.x and 5.0.x and manage these with
mysqld_multi.
-Original Message-
From: sean c peters
To: [EMAIL PROTECTED]
Sent: 8/9/04 4:43 PM
Subject: mysqld_multi & different server versions
In my
You can load the data by using the mysql command.
mysql -uuser -ppassword < fileToLoad.sql
...
If you are on a shared database server I do not think you will be able to
issue the CREATE and DROP database commands.
-Original Message-
From: EWA Goodson Wickes
To: [EMAIL PROTECTED]
Sent: 8/9/
Are you in the process of stopping and restarting the MySQL Database server?
-Original Message-
From: Ciarochi, Anthony
To: [EMAIL PROTECTED]
Sent: 8/9/04 2:13 PM
Subject: what is causing these XX.1.1.1.1 logs?
For some reason, I am getting hundreds of zero-length binary log
remnants in
The rename scenario is your best option. Just make sure you flush the tables
to ensure that users are seeing current data. You normally do not want to
`pull the rug` out from your users by deleting a table that they may be
attempting to access.
-Original Message-
From: Haitao Jiang
To: [E
For this type of custom loading you may want to explore a programming
language such as Java or C/C++ or Perl. Depending on your platform you could
even explore some third party tools.
-Original Message-
From: sean c peters
To: [EMAIL PROTECTED]
Sent: 8/4/04 3:27 PM
Subject: load data infil
1 - 100 of 462 matches
Mail list logo
