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?
Regards,
Chris
--
MySQL General Mailing List
For list archives:
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 single
transaction option give a consistant snapshot of InnoDB tables if
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 ROLLBACK, does the fact that a MyISAM
table is
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
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
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
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 error
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
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 am able to
[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
the
[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
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]
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
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
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
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
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
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
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 same data
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
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:
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
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
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
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
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
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
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
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
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
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
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
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)
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
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
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
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
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
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
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
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
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
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:
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 small
---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 table that
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 does
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 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 into a table
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,
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 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 done
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 =
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
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,
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
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
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
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%
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
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:
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 use
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
You can use an option in my.cnf slave-skip-error=list 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
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
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 these
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 queries but
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
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
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 is not
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
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
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 select
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... :-)
Uh oh.
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: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 list
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 single
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
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.
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,
79 matches
Mail list logo
