I use :
numRows = mysql_num_rows( Result);
numFields = mysql_num_fields( Result);
for( j=0; j numRows; j++) {
mysql_data_seek( Result, j);
CurrentRow = mysql_fetch_row( Result);
for( k = 0; k numFields; k++)
Hi
how can i write star tine to inittab (in AIX 4,3) for auto-star mysql
during star-up server?
Tomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I wrote a small C program that execute a query (show processlist).
If the name of the file is *.c all works fine.
If the name of the file is *.cp the linker gives an error:
gcc -g -I'/usr/include/mysql' -c Santino.cp
gcc Santino.o -L'/usr/lib' -lmysqlclient -lz -o test
Lay,
Lay Hoon Tan wrote:
Does MySQL support serial (auto-increment a number) and currency types ?
1. You can create an auto-increment field:
mysql create table t1 (a int not null primary key auto_increment, b char(10));
Query OK, 0 rows affected (0.02 sec)
mysql insert into t1 (b) values
Hello!
My name is Sergiu and I'm a software engineer from Romania. I have a problem using
MySql and I hope you can give me an answer at my problem.
The MySql server worked without any problem until I installed on the same machine the
Visual Studio .Net 7.1 package.
After I installed this
Hi
I am a new MySQL dba tuning a busy Apache/MySQL installation. I could do
with some advice from the gurus!
Here are some of the statistics for the last 24 hours:
Com_admin_commands978,760
What Admin_Commands does this include - at 11.3 per sec this is a
lot!
Com_analyze
Heikki,
I have two questions in regards to the tablespace changes:
1 - You mention being able to store indexes in a seperate tablespace. How
far off is this for MySQL to implement? I would like to see FULLTEXT
indexes stored in seperate tablspace (seperate RAID channel) so the two
features
Jon,
FULLTEXT is far away, unless we find a corporate sponsor. Could your company
sponsor the porting?
Journaled file systems are just extra overhead for InnoDB, though the
overhead seems to be small.
Regards,
Heikki
- Alkuperäinen viesti -
Lähettäjä: Jon Hancock [EMAIL
Hello
I get the following errors/warnings on a table:
Table is marked as crashed
Not used space is supposed to be: 3688 but is: 3624
record delete-link-chain corrupted
corrupt
What can be the cause of this crash?
Med vänlig hälsning/Best Regards
Datatal Utveckling AB
Jonas Gauffin
Tel
Hi,
As I have said before, I'm not Heikki, but I'm such a massive geek I'm
likely to have one or two useful bits of info for you. :-)
1. You'd have a rough time getting indexes and tables to be seperated
out, unless you were willing to set up your various symlinks/hardlinks
by hand. Even then,
Hi,
We upgrade one of our servers, but physical and mysql from
3.23.55-max-log to 3.23.58-max-log and run into some problems with a few
queries.
This is the old server:
mysql explain select count(id) from table where entered
date_sub(now(), INTERVAL 15 DAY) and DAYOFYEAR(entered) =
C. Reeve [EMAIL PROTECTED] wrote:
I just installed MySQL version 4 and as usual, trying to set up users
and grant permissions is a nightmare.
I followed the instructions in the MySQL manual and granted permissions
to a user, like below:
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
Hello,
i just wasn´t able to download the MySQLGUI (Windows static) under
http://www.mysql.de/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip
Is it still available?
Thanks
Thomas
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello,
I have been testing with an RPM distribution of MySQL version 4.0.15. Now that I have
bought a licenced version how do I change over to use the binary (version 4.0.16)
instead of the previously installed rpm version?
Operating system: Linux Red Hat 7.3
Thanks
Manjit
This message is
i dont think there's any privilege called ALL PRIVILEGES. You need to say
just ALL, like:
GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY
'12345678' WITH GRANT OPTION;
GRANT ALL ON *.* TO newuser@% IDENTIFIED BY '12345678' WITH
GRANT OPTION;
Enjoy
Nitin
- Original Message -
From:
* Santino ([EMAIL PROTECTED]) wrote:
I use :
numRows = mysql_num_rows( Result);
numFields = mysql_num_fields( Result);
for( j=0; j numRows; j++) {
mysql_data_seek( Result, j);
CurrentRow = mysql_fetch_row( Result);
Hello list
I want to insert ... select data from table1 of db1 to table2 of db3.
Is that possible?
Thank in advance
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
you can either erase the previous installation and then install the newer
one or simply upgrade the previous one.
- Original Message -
From: Manjit Patel [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 8:02 PM
Subject: Changing rpm installation to binary version
of course, the syntax is:
insert into db3.table2 (column list) select column list from db1.table1
for more information have a look at
http://www.mysql.com/doc/en/INSERT_SELECT.html
Enjoy
Nitin
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October
I have a program running with MySQL as the database. I have MySQLFront
running as my viewer and I want to change something in the database that
will allow me to view more items in a drop down table within my program.
Not having created this program but being a user on this system, I am not
Hello, I have created new udf function which converts time from NTP
format to timestamp. I compile it with the following command:
gcc -Wall -shared -o ntp2timestamp.so ntp2timestamp.cc
with no errors.
Then I copy this file to /usr/local/mysql (libmysql* files are located
here and
u mean, in MySQLFront or other program
- Original Message -
From: Krystan Daxner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 8:46 PM
Subject: Changing table properties
I have a program running with MySQL as the database. I have MySQLFront
running as my
I apparently am misunderstanding how the select works by referencing data in
two different tables. I have used a similar statement to the one that
follows with success, but there must be something different here that
reveals a lack of fundamental understanding as to how it works. If someone
Nikos,
Yes. Use the following syntax:
INSERT INTO db_name.tbl_name (col, col, col) SELECT col, col, col FROM
db_name.tbl_name;
Regards,
Adam
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 9:58 AM
To: [EMAIL PROTECTED]
Subject: Insert
I have successfully done this when both versions have been rpm files but how do I
upgrade from an rpm to
a binary. I have unpacked the binary file installed it but the previous version
keeps being started. And when I
try to erase the previous version it says it is not installed!
Hi Everyone;
I have published a new article covering SSH port forwarding of MySQL sessions,
which can be viewed at http://www.vbmysql.com/articles/sshtunnel.html
The article covers connecting a Windows client to a *NIX based server.
Anyone with previous experience will probably find the
You need a LEFT JOIN
select f.controlnum,f.referencenum,f.fname,f.lname from first f,
left join second s on f.controlnum = s.controlnum
where s.controlnum IS NULL and f.inputtime '07:00:00'
Larry Brown wrote:
ok, now I want to run a query that results in all of the controlnum's in
table one
The simple JOIN (which is what you have requested with the A, B syntax)
builds a conceptual table in which every row in A is paired with every row
in B, then passes the result on to the WHERE filter. Of course, it doesn't
actually do that, because it would take an enormous time, but it mimics
You are using the wrong syntax, try
SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE
table2.id IS NULL;
The query, you are using produces cross join while you need to implement
left join for your problem.
Enjoy
Nitin
- Original Message -
From: Larry Brown
Chris wrote:
Hmm
It's just occured to me that you're basically copying and entire table from
one place to another. If I recall correctly, FoxPro cheats somewhat in this
situation - it just copies the concerned files!
Which table type are you using (something I should have asked in the
Thank you all. The world makes sense again. :)
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 10:54 AM
To:
[EMAIL PROTECTED]
Cc: MySQL List
Subject: Re: unexpected results from
On Monday, October 27, 2003, at 07:45 AM, Chris Nolan wrote:
2. I personally use ReiserFS for all of my stuff, most of which is
based upon InnoDB. One thing you have to remember is that InnoDB
treats the space inside the tablespace as a Berkeley Fast
Filesystem-style space, using the
Hi all,
I am investigating upgrading from our current release of MySql. (We use
Red-Hat 7.2 and it ships with 3.23.41).
Anyway, I am interested in upgrading to either the latest 3.23 release
or the latest stable 4.0 release. My concerns are which is an easier
and/or less risky upgrade?
We
My commercial online web application currently handles 1 users with peak
loadings of 100-500 concurrent hits. Windows 2000 Server, IIS 5.0, JRun 4.0
and Enterprise Database Engine. There is a considerable amount of write
activity to 10 of the 60 tables. The total size of the data is
Hi all, i've been having an issue with binding params. If i have created an
INSERT query with a param binding to a particular column, call it column
A, is there any way that i can use that (prepared) query to get the db
defined default value into column A?
Im at a loss!
thanks much,
sean
Hi,
*** 1. row ***
Master_Host: 10.2.12.224
Master_User: rep
Master_Port: 3306
Connect_retry: 60
Master_Log_File: ef224-bin.020
Read_Master_Log_Pos: 409223612
Relay_Log_File:
Does anyone have much experience with this? How does it stack
up to MySQL?
I ask because I'm in the middle of preparing a presentation to
get MySQL on the 'approved' software list at my workplace, and
I will have to address MySQL versus this product (as well as
Oracle Express, though it
Hey everyone,
First post to the MySQL list so please be gentle.
I recently emptied some tables I shouldn't have in a db of mine and I
want to restore the data from a dump file made a few days ago.
MySQL version is 3.23.
This is the command I used to create the dump:
mysqldump --opt -u root
Mojtaba Faridzad wrote:
BUT my experience: try to change the logic of your report not to retrieve
large number of records. user LIMIT to create the reports page by page. this
is the best and even better for the user.
Ok thanks, but how exactly do I change-the-logic of this query:
mysql select
---Original Message-
--From: sean peters [mailto:[EMAIL PROTECTED]
--Sent: Monday, October 27, 2003 10:17 AM
--To: [EMAIL PROTECTED]
--Subject: bind params and default values
--
--Hi all, i've been having an issue with binding params. If i have
created
--an
--INSERT query with a param
can you send the contents of your dumpfile up to this point. assuming its
line 118 of hte dumpfile and 21 of this build table query
Jeff
---Original Message-
--From: Chris W. Parker [mailto:[EMAIL PROTECTED]
--Sent: Monday, October 27, 2003 10:46 AM
--To: [EMAIL PROTECTED]
--Subject: DB not restoring from dump file
--
--Hey everyone,
--
--First post to the MySQL list so please be gentle.
--
--
--I recently emptied some
---Original Message-
--From: Charles Cary [mailto:[EMAIL PROTECTED]
--Sent: Monday, October 27, 2003 10:10 AM
--To: [EMAIL PROTECTED]
--Subject: Conversion
--
--My commercial online web application currently handles 1 users
with
--peak
--loadings of 100-500 concurrent hits. Windows
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
on Monday, October 27, 2003 10:52 AM said:
can you send the contents of your dumpfile up to this point.
assuming its line 118 of hte dumpfile and 21 of this build table query
Line 118 is the beginning of the 'customers' table definition and line
Try changing the keyname unique to email.
SO:
UNIQUE KEY email (email)
---Original Message-
--From: Chris W. Parker [mailto:[EMAIL PROTECTED]
--Sent: Monday, October 27, 2003 11:04 AM
--To: [EMAIL PROTECTED]
--Cc: [EMAIL PROTECTED]
--Subject: RE: DB not restoring from dump file
--
Earlier I was given help understanding the need for using a left join. This
was a precursory query to arrive at my final solution which I had not
touched on since I believed that by getting the join correct I could get the
result. It seems to be evading me though. Still using the following
---Original Message-
--From: Larry Brown [mailto:[EMAIL PROTECTED]
--Sent: Monday, October 27, 2003 11:32 AM
--To: MySQL List
--Subject: illusive query
--
--Earlier I was given help understanding the need for using a left
join.
--This
--was a precursory query to arrive at my final
My old Micro-Economics professor must be chortling in his grave...
The bosses told me a few minutes ago to quit pusing MySQL for an
internal project and to move my proof-of-concept tables from MySQL
running on a Linux desktop with 512mb of ram and the bloody DB on an
external USB to a DB2
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
---Original Message-
--From: sean peters [mailto:[EMAIL PROTECTED]
--Sent: Monday, October 27, 2003 11:54 AM
--To: Dathan Vance Pattishall
--Subject: Re: bind params
My old Micro-Economics professor must be chortling in his grave...
The bosses told me a few minutes ago to quit pusing MySQL for an
internal project and to move my proof-of-concept tables from MySQL
running on a Linux desktop with 512mb of ram and the bloody DB on an
external USB to a DB2
Tell them Yahoo, Google and others use mysql in the order of power 50
servers.
50-1000 servers actually.
So, with all the great talent @ Yahoo / Google as well as these 2
companies being profitable maybe some things in life are really 2 good
to be true.
Usually no brain-er debates are the best
It's because you forgot to put the new cover sheet on your TPS (transaction per
second, in this case) report
Did you get the memo?
Similar thing happened to my college... they doubled their tuition over 5 years
because as the president of the univeristy put it, 'good colleges are
hi there,
the subject tells almost everything, I try to update records in a table
and everytime I do this, the timestamp field ist set to now().
how can I keep the previously stored value for this field (there are
values created before)?
thanks for your help,
henning
--
MySQL General
Hi Mike
I have to ask this without wanting a howto explanation but at least a basic
understanding
What this means is that if an unscrupulous individual gets between your client
and the server, they can have full access to all information transmitted.
how can someone do this? without it being
Is there a way in mYSQL to just define an auto increment sequence rather
than defining a field inside a table which is an auto increment. Bsically I
need some functionality similarto that in ORACLE where CREATE SEQUENCE seq
INCREMENT BY 1 START WITH 1 MINVALUE 1;
basically creates a seq that
Hi,
You could bring the attention to www.mysql.com - probably German software
company SAP would not integrate with MySQL, if there were any kind of
problems.
Further You could look at the success stories (
http://www.mysql.com/press/user_stories/index.html ), and You will find
NASA, Yahoo!
That is the purpose of timestamp.
Henning Heil wrote:
hi there,
the subject tells almost everything, I try to update records in a
table and everytime I do this, the timestamp field ist set to now().
how can I keep the previously stored value for this field (there are
values created before)?
On 27 Oct 2003 at 21:21, Henning Heil wrote:
how can I keep the previously stored value for this field (there are
values created before)?
Explicitly SET timestamp_column = timestamp_column. See here:
http://www.mysql.com/doc/en/DATETIME.html
But if you never want the TIMESTAMP column to
use timestamp_col = timestamp_col in your query, to override the NOW()
affect.
I just passed by this comment this morning
http://www.mysql.com/doc/en/DATETIME.html -- user comments at bottom of
page
hth
Jeff
* Henning Heil
the subject tells almost everything, I try to update records in a table
and everytime I do this, the timestamp field ist set to now().
how can I keep the previously stored value for this field (there are
values created before)?
You can assign the current value to it:
Gabriel,
- Original Message -
From: Gabriel Ricard [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, October 27, 2003 6:46 PM
Subject: InnoDB on Raw partitions in OSX (was Re: MySQL/InnoDB-4.0.16 is
released + sneak peek of 4.1.1)
On Monday, October 27, 2003, at 07:45
[EMAIL PROTECTED] wrote on 27.10.2003 21:31
use timestamp_col = timestamp_col in your query, to override the NOW()
affect.
I just passed by this comment this morning
http://www.mysql.com/doc/en/DATETIME.html -- user comments at bottom of
page
hth
Jeff
all,
thanks for your help!
On Mon, 27 Oct 2003 15:24:37 -0500, Priyanka Gupta [EMAIL PROTECTED] wrote:
Is there a way in mYSQL to just define an auto increment sequence rather than defining
a field inside a table which is an auto increment. Bsically I need some functionality
similarto that in ORACLE where CREATE SEQUENCE
Add Two Time stamps. Only one will get update.
Mat
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 1:31 PM
To: MySQL List
Cc: Henning Heil
Subject: Re: updating records without changing timestamp fields
On 27 Oct 2003 at 21:21, Henning
Hi,
You could bring the attention to www.mysql.com - probably German
software company SAP would not integrate with MySQL, if there were any
kind of problems.
Sorry a bit off topic, speaking of the germans, it seems that PHP and MYsql
is prolific in germany, as a widely used choice. I work
On 27-Oct-2003 Henning Heil wrote:
hi there,
the subject tells almost everything, I try to update records in a table
and everytime I do this, the timestamp field ist set to now().
how can I keep the previously stored value for this field (there are
values created before)?
UPDATE
---Original Message-
--From: Guilhem Bichot [mailto:[EMAIL PROTECTED]
--Sent: Monday, October 27, 2003 10:55 AM
--To: [EMAIL PROTECTED]
--Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
--Subject: RE: reproducible error 17
--
--Hi,
--
--Are the master and slave located on two
Does anyone know whether the use of persistent connections with php will
allow a temp table created by a script to linger around and cause a problem
with the next execution of the script when it tries to create the temp table
again? Also if it does present a problem with the next script execution
Think of your information like a letter in the mail. Well, for this example,
think of it even more as a post-card. Your message is written on the outside
where the anyone that touches it can read it.
This post-card is going through the post office. It is going through mail
centers, hubs, etc.
Does anyone know whether the use of persistent connections with php will
allow a temp table created by a script to linger around and cause a problem
with the next execution of the script when it tries to create the temp table
again? Also if it does present a problem with the next script execution
I'm resending this, since I never saw it come through the first
time around...
Does anyone have much experience with this? How does it stack
up to MySQL?
I ask because I'm in the middle of preparing a presentation to
get MySQL on the 'approved' software list at my workplace, and
I will have
Dathan Vance Pattishall mailto:[EMAIL PROTECTED]
on Monday, October 27, 2003 11:28 AM said:
Try changing the keyname unique to email.
UNIQUE KEY email (email)
Thanks, this worked.
I ended up having to change two more instances of the same error in
different tables.
Why would the
All;
I am having tremendous trouble attempting to do the following query; and any
help would be appreciated.
I am using Mysql 4.0.15a; and I cannot upgrade.
Given the following TEMPORARY table (it's a table I have created from a whole
host of sources):
table: endtime_table
Hi!
I've found this in:
http://www.mysql.com/information/presentations/presentation-oscon2000-2719/
Instead of doing a lot of |GROUP BY|s on a big table, create summary
tables of the big table and query this instead.
Would you please tell me how to create summary tables that can help me
get
Thanks, I got the answer from a php developer. In case anyone is wondering,
according to him the table is dropped at the end of the script execution
regardless of whether you use persistent connections or not.
-Original Message-
From: Larry Brown [mailto:[EMAIL PROTECTED]
Sent: Monday,
That is a pretty fair take on network traffic. SSH has strong enough encryption
to make the decryption effort not worth it to all but those with
supercomputers. As for the internal mail, I think we can agree that some mail
would be critical enough to warrant encryption even on an internal
It dumps the contents of the db table in its original form. If you
upgrade to a new version-mysql will respect the old table format even if
some of the column / table / key names are reserved names in the new
mysql version. BUT if you try to add back to the mysql server a dump
table that has this
On Mon, 2003-10-27 at 22:01, Dathan Vance Pattishall wrote:
---Original Message-
--From: Guilhem Bichot [mailto:[EMAIL PROTECTED]
--Sent: Monday, October 27, 2003 10:55 AM
--To: [EMAIL PROTECTED]
--Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]
--Subject: RE:
I'm interested to see what kind of solution is offered for this as I could
use it myself. I'm having to do this programatically on an expternal script
that selects distinct non_unique_id and the takes the result and loops
through each one with sort by endtime desc limit 1 and then either do
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have received only contains
the month and year, but not the date of the sale. Of course we want to store
this information, but a DATE column won't quite do the job,
what about forcing the date to the first of whatever month the sale was in? if it's
got a valid date, put that, otherwise, put the first.
-Original Message-
From: sean peters [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 4:33 PM
To: [EMAIL PROTECTED]
Subject: Unusual date
Sorry, i wasn't completely clear.
Well, thats actually what i am going to do. A date column won't take anything
but a valid date (sort of - feb. 30 is valid).
But i still need to know whether the day of month is meaningful or not, for
various search / display purposes. My users will raise a
On Mon, Oct 27, 2003 at 05:32:34PM -0500, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have received only contains
the month and year, but not the date of the sale. Of course we want to
On Mon, 27 Oct 2003 17:58:38 -0500, sean peters [EMAIL PROTECTED] wrote:
Well, thats actually what i am going to do. A date column won't take anything
but a valid date (sort of - feb. 30 is valid).
But i still need to know whether the day of month is meaningful or not, for
various search /
Trying to increase my innodb_log_file_size I get this message
031027 16:01:02 InnoDB: Data file ./ibdata2 did not exist: new to be
created
031027 16:01:02 InnoDB: Setting file ./ibdata2 size to 2000 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
At 5:32 PM -0500 10/27/03, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have received only contains
the month and year, but not the date of the sale. Of course we want to store
this information,
On Mon, 27 Oct 2003 18:34:34 -0600, Paul DuBois [EMAIL PROTECTED] wrote:
At 5:32 PM -0500 10/27/03, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have received only contains
the month and year,
At 4:41 PM -0800 10/27/03, bluejack wrote:
On Mon, 27 Oct 2003 18:34:34 -0600, Paul DuBois [EMAIL PROTECTED] wrote:
At 5:32 PM -0500 10/27/03, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have
Hi,
Well, UNIQUE is a reserved word in all versions of MySQL...
As to why mysqldump would create a dump file with a syntax error in
it, that's because *you* (or the application creator) used a reserved
word for a column/index name (bad idea) and mysqldump, by default, does
not put backticks
On Mon, 27 Oct 2003 19:11:53 -0600, Paul DuBois [EMAIL PROTECTED] wrote:
For future reference, does this effect order by clauses in the way one
would expect? (ie., 00 precedes 01). The docs make it seem as though
use of invalid dates results in undefined behavior.
Can you indicate which part of
Hi guys,
Have you seen the manual page for The Rows Holding the Group-wise
Maximum of a Certain Field:
http://www.mysql.com/doc/en/example-Maximum-column-group-row.html
I think that's what you want to do. You can either use another temporay
table, the MAX-CONCAT trick, or the LEFT JOIN ... IS
Does mysql do any optimization for then one use
`select ... limit x,y`?
For example, I have table with 200 records and want to do page web
interface to this table.
When i use `select ... from table limit 150, 20 `, it will need more and
more times (on my here is more than 60 sec).
Hi Mike,
For the corruption, upgrade to 4.0.16, since it may be caused by a
corruption bug in versions before 4.0.15.
Matt
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, October 27, 2003 12:07 PM
Subject: RE: Corruption and weird service terminations
Hi George,
I think the MySQL-Max RPM is dynamically linked (all -max binaries
actually) if you want to give it a try.
Hope that helps.
Matt
- Original Message -
From: George Chelidze
Sent: Monday, October 27, 2003 9:18 AM
Subject: CREATE FUNCTION problem
Hello, I have created new
Hi folks,
I have a bit of a problem. I'm running 3.23.53 which I've compiled up from
source (because the RPMs are not an option for me).
I have a process that does a fairly large select statement every 10
minutes - up until a few days ago it was all find and dandy.
A few days ago I did a
Hi,
Yes, MySQL stops searching for rows once the LIMIT is satisfied, as long
as filesort isn't used for an ORDER BY. But your LIMIT 150, 20 will
take much longer (assuming filesort isn't used) than, say, LIMIT 1000,
20. This is because it has to scan over 1.5M rows first. It's not really
Hi,
What version of MySQL are you using? Maybe it's because of a corruption
bug in versions 4.0.3 - 4.0.14. Try upgrading to the latest version.
Hope that helps.
Matt
- Original Message -
From: Datatal AB - Gauffin, Jonas
Sent: Monday, October 27, 2003 6:40 AM
Subject: cause of
This thread started as Re: MySQL/InnoDB-4.0.16 is released + sneak peek of
4.1.1.
I may want to have one MySQL server as the Read only Search server. If I
did this and I have all InnoDB table on my Master, then could I replicate
only certain columns into the MyISAM slave ?
Any other efficient
Hmm
How much lag time can you afford between the master's contents being updated
and the slave being updated? Taking advantage of MyISAM's compressed table
features might help performance if that is an issue.
Every independant test out there shows that in the cases where InnoDB is
slower
Which platform are you using? Which FS?
Regards,
Chris
On Tue, 28 Oct 2003 01:14 pm, Dan Goodes wrote:
Hi folks,
I have a bit of a problem. I'm running 3.23.53 which I've compiled up from
source (because the RPMs are not an option for me).
I have a process that does a fairly large select
1 - 100 of 113 matches
Mail list logo