Mike,
you cannot run two mysqld instances on the same InnoDB data files. Think
what happens with the indexes cached in the buffer pool.
The same holds for MyISAM, because its indexes are in the key buffer, unless
you flush the table after each access to it, and prevent simultaneous
accesses with
Daevid,
CONSTRAINT `0_359` FOREIGN KEY (`rep_company_code`) REFERENCES
`company_table` (`company_code`)
you do not have ON UPDATE CASCADE in your constraint. MySQL versions < 4.0.8
ignored it.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level
I have Mac OS X 10.2.6 with December 2002 Dev Tools and the Dec 2002 gcc
updater, which means I'm using gcc 3.3. Following the directions in
INSTALL-SOURCE, I ran configure with:
CC=gcc \
CFLAGS="-O3 -fno-omit-frame-pointer" \
CXX=gcc \
CXXFLAGS="-O3 -fno-omit-frame-pointer -felide-constructors
-f
hi there, i am trying to use transactions on some innodb tables although a few things
i am experiencing, on one query the value appears, i refresh the page and the value
dissapears again, i am using persistant connections in php, the value is actually
there in the console, what could be the prob
SQL guru's,
I could use some help writing a bit of SQL.
There's 3 tables:
orderable_parts
partID varchar,
topCatID int, # top level category ID
...
part_attributes
partID varchar,
attName varchar,
attValue varchar,
...
topcatattributevalues
tcavID int,
topCatID int,
attName varchar,
attValue varc
hi there i keep getting an error on a table
Lock wait timeout exceeded; Try restarting transaction
i intitally had made the update query but it wasnt committed, as it was using a myisam
query function i have gone back to it with and innodb query function which starts a
transaction , i have trie
hi i was wondering if there is a way to check for a table type ?
ie i have an authentication class, in some situations it uses innodb and sometimes its
myisam and currently its not autocomitting
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
> OK, here are the last few lines from make. I configured using the
> following:
>
> ./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
>
> errors:
>
> libmysql.c: In function `mysql_real_connect':
> libmysql.c:1790: warning: passing arg 5 of `gethostbyname_r' from
> incompatible point
OK, here are the last few lines from make. I configured using the
following:
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
errors:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1790: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
libmysql.
is there such a gui tool for linux ? i like sqlyog alot so anything similar
would be excellent.
> Good news for OS X users. CocoaMySQL has just been updated and it now
> supports CSV imports among other improvements. It's freeware too.
>
> http://www.MacUpdate.com/info.php/id/10573
>
>
> --
> MySQ
Good news for OS X users. CocoaMySQL has just been updated and it now
supports CSV imports among other improvements. It's freeware too.
http://www.MacUpdate.com/info.php/id/10573
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
At 10:22 AM -0400 9/11/03, Peter Koutsoulias wrote:
I couldn't find an appropriate mailing list for compiling MySQL, so I
thought I'd try here.
anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on
libmysql.c during the make step. Google doesn't reveal a whole lot about
compil
On Thu, Sep 11, 2003 at 04:27:10PM -0400, Brent Baisley wrote:
> Have tried using the --opt parameter on mysqldump? This is supposed
> optimize the dump speed and create a file optimized for reloading. I
> haven't played with this option, so I don't know what kind of
> difference it makes.
It m
Heikki, I took your advice and installed the RPM updates to no avail:
[root]# rpm -qa | grep "mysql" -i
MySQL-server-4.0.15-0
mod_auth_mysql-1.11-1
MySQL-devel-4.0.15-0
MySQL-shared-4.0.15-0
php-mysql-4.1.2-7.2.6
MySQL-client-4.0.15-0
MySQL-shared-compat-4.0.15-0
And it seems to be running...
my
At this point it is pure academic curiousity. I am putting together a cheap
cluster to play with shared drive failover, and thought I would see what
happens when I point two MySQL machines at the same drive while I'm at it.
Mike
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL P
Dan Greene wrote:
select unique t1.*
from table1 as t1
left outer join table2 as t2 on t2.name = t1.name
where t2.name is null
That'll get the t1s not in t2, but not the other way around. Consider:
SELECT t1.name, t2.name
FROM table1 t1 LEFT JOIN table2 t2 ON t1.name = t2.name
WHERE t2.name IS
Joe,
I think I see why this can happen. Even though the search condition is
unique, the search may end up on the B-tree leaf node which immediately
precedes the right node. That is why Transaction 1 is waiting for a lock on
a 'supremum' record. It is the supremum of the previous leaf.
Hmm... I ma
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeremy Zawodny wrote:
> On Thu, Sep 11, 2003 at 10:08:18AM -0400, Luc Foisy wrote:
>
>>Are there packages for java to include a standalone mysql database?
>
>
> No.
>
>
>>Or are there plans for such?
>
>
> Last time I saw Mark discuss it, no. There w
i'm about to do this tonight as i'm setting up a desktop system to do my
local development on, all i can say is redhat and gnome is slow as hell !,
i only have 160 meg ram on the machine and after loading a few apps it only
has 4 meg ram left ! plus the apt package manager for redhat is slow as
hel
user_id is the primary key..
relevant parts of show create table:
| plx_user |CREATE TABLE `plx_user` (
`user_id` int(11) NOT NULL auto_increment,
`is_deleted` int(11) NOT NULL default '0',
`edit_counter` int(11) NOT NULL default '0',
`sendlist_edit_counter` int(11) NOT NULL default '0',
I have a fresh install of mysql 4.0.11 on a linux box. When I try to
open mysql as a [EMAIL PROTECTED], I get the following error:
>mysql -u [EMAIL PROTECTED] -p db_name
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]@localhost' (Using
password: YES)
However
Joe,
what does SHOW CREATE TABLE give as the table definition?
What do
EXPLAIN SELECT ... where user_id = 190864 and is_deleted = 0;
and
EXPLAIN SELECT ... where user_id = 190864;
say? If user_id is not the full primary key, then an index scan will happen
and deadlocks of the type below are p
On Thu, Aug 28, 2003 at 04:14:13PM -0400, Ken Menzel wrote:
> Hi Nick,
>This is due (so I am told) to a problem in FreeBSD threads. I have
> this happen once in a while also. There have been some threads
> changes for 4.9 but I am not sure there is any change in this.
>
> The common suggestio
On Thu, Aug 28, 2003 at 04:20:50PM -0400, Nick Gaugler wrote:
> Ken,
>
> Thanks for the response. I really wish MySQL AB would compile FreeBSD
> binaries with LinuxThreads. It's really a pain when you find a bug, the
> first thing they ask is "have you compiled this yourself" when in this
> cas
On Thu, Sep 11, 2003 at 10:22:13AM -0400, Peter Koutsoulias wrote:
> I couldn't find an appropriate mailing list for compiling MySQL, so I
> thought I'd try here.
>
> anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on
> libmysql.c during the make step. Google doesn't revea
Hi Sergei!
Thanks for your reply and taking time to read and consider my
suggestions. :-) I didn't reply sooner because I was deciding what to
say in this message. ;-)
I joined the list specifically for posting these suggestions, and, with
your reply, I wanted to say that it's great to have dire
On Thu, Sep 11, 2003 at 03:41:21PM -0700, [EMAIL PROTECTED] wrote:
>
> Ok, here's another question. Given effective external locking by the OS, could
> MyISAM tables achieve this?
Yes.
> If so, do you know any operating systems that would have reliable
> external locking?
I'm not sure what the
I'd like to be able to look at show innodb status, notice that a query
is waiting on a lock to be released, and then determine which tx is
holding that lock.
I know you can use the innodb_lock_monitor table, but this would make
things a lot faster especially when there are a lot of active
transac
I noticed this deadlock in show innodb status on a mysql 4.0.14 box
today. Both transactions seem to be trying to execute the a query on
the same record, which I don't think should cause a deadlock. What am I
missing?
030911 10:12:45
*** (1) TRANSACTION:
TRANSACTION 0 153127600, ACTIVE 53 sec, p
On Thu, Sep 11, 2003 at 10:08:18AM -0400, Luc Foisy wrote:
>
> Are there packages for java to include a standalone mysql database?
No.
> Or are there plans for such?
Last time I saw Mark discuss it, no. There was significant overhead
in coming up with a Java-to-embeeded-MySQL bridge. Check th
Ok, here's another question. Given effective external locking by the OS, could
MyISAM tables achieve this? If so, do you know any operating systems that would
have reliable external locking?
Mike
Quoting Jeremy Zawodny <[EMAIL PROTECTED]>:
> On Wed, Sep 10, 2003 at 06:00:55PM -0600, Mike Hilly
On Thu, Sep 11, 2003 at 04:10:21PM -0400, Pierre-Luc Soucy wrote:
> Hi again,
>
> Does any of you have an idea on this? I get the same error in 4.0.15. I
> could find that the problematic code was in mysql-test/mysql-test-run.sh:
>
> sleep_until_file_created $MASTER_MYPID $wait_for_master
> wa
On Thu, Sep 11, 2003 at 02:30:59PM +1000, Daniel Rossi wrote:
>
> when is it a good time to do the set auto commit=0 , while doing the
> update or insert query or sometime before that in the application ?
Whenever you need explicit transactions.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux
On Wed, Sep 10, 2003 at 06:00:55PM -0600, Mike Hillyer wrote:
> Hi All;
>
> First of all, I think this will probably be a question for Heikki.
>
> If I remember correctly, InnoDB and the MySQL external locking flag are
> unrelated as InnoDB tables are unaffected by external locks.
>
> Now the qu
not adept
at solving problems syndrome, MySQL has always just worked like a charm
for me.
Kelley
[EMAIL PROTECTED] wrote:
>
> Dear Kelley:
>
> We tryed with your suggestion, thank you very much. We can see the
> mysqlupdate and 20030911.mysqldump files. However when we connect a
On Thu, Sep 11, 2003 at 11:30:20AM -0700, Mark Kaufer wrote:
> > By the way, Jeremy's original answer was more correct than mine, because
> > he noted where I did not that the sort buffer is a per-client resource
> > and is allocated once for each client -- or at least for each client that
> > issu
our current "situation" is a mysqld crash, it hits an assertion
in my_seek.c.
Assertion failed: pos != (~(my_off_t) 0), file
c:\build\build\mysql-4.0.14\mysys\my_seek.c, line 31
This is with a myisam table containing variable length text fields.
I'm not expecting any solution from this list, b
Use the --opt option when performing the dump. It can make a tremendous
difference.
-JF
> -Original Message-
> From: dan orlic [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2003 12:31 PM
> To: [EMAIL PROTECTED]
> Subject: mysql dump speed
>
>
> I have a bit of an issue wit
>From what I understand about InnoDB, you want to make that InnoDB buffer
pool as big as 60-80% of your allowable RAM. If you use only InnoDB,
then the other settings won't help you to give much ram. If you use no
InnoDB, then don't bother giving InnoDB buffer pool any real ram.
If it works correc
Have tried using the --opt parameter on mysqldump? This is supposed
optimize the dump speed and create a file optimized for reloading. I
haven't played with this option, so I don't know what kind of
difference it makes.
On Thursday, September 11, 2003, at 03:30 PM, dan orlic wrote:
I have a bi
Hi Dan,
- Original Message -
From: "dan orlic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 11, 2003 2:30 PM
Subject: mysql dump speed
> I have a bit of an issue with mysqldumps and inserting it back into
> mysql.
>
> Granted, I have 1 table that has over 1Millio
Hi again,
Does any of you have an idea on this? I get the same error in 4.0.15. I
could find that the problematic code was in mysql-test/mysql-test-run.sh:
sleep_until_file_created $MASTER_MYPID $wait_for_master
wait_for_master=$SLEEP_TIME_FOR_SECOND_MASTER
MASTER_RUNNING=1
I guess I could pro
Dear Kelley:
We tryed with your suggestion, thank you very much. We can see the
mysqlupdate and 20030911.mysqldump files. However when we connect an do
some queries to our Mysql server, we can not see anything, the columns
Time, Id Command and Argument are in blank.
Is there something
"Mikhail Entaltsev" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've found the phrase in MySQL documentation
> http://www.mysql.com/doc/en/Temporary_table_problems.html
>
> "You can't use temporary tables more than once in the same query. For
> example, the following doesn't work.
> mysql> SELECT * FROM
On 11 Sep 2003 at 15:31, Tongprasith, Anan wrote:
> I think you are right. I try adding and deleting data one by one and
> found no particular data that will always "turn off" index in all
> circumstances. myisamchk --analyze doesn't help. Is there a way to
> force using index?
Yes, 'USE INDEX (i
Never mind. New MySQL has "force index" option.
Thanks for your help Brent.
Anan T.
-Original Message-
From: Tongprasith, Anan
Sent: Thursday, September 11, 2003 3:32 PM
To: Brent Baisley
Cc: [EMAIL PROTECTED]
Subject: RE: Query optimizer decision to use index depends on data?
I think
Daevid,
there is really one update you need to do first: upgrade to MySQL-4.0.14.
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
"
Starting from version 3.23.50, you can also associate the ON DELETE CASCADE
or ON DELETE SET NULL clause with the foreign key constraint. Corresponding
ON UPDAT
I think you are right. I try adding and deleting data one by one and found no
particular data that will always "turn off" index in all circumstances. myisamchk
--analyze doesn't help.
Is there a way to force using index? I don't think optimizer is smart enough. My table
has more than 30,000 row
I have a bit of an issue with mysqldumps and inserting it back into
mysql.
Granted, I have 1 table that has over 1Million entries, but generating
these tables takes about 3 hours with a java app.
But when I do a mysql -u root -p < it is taking
about 28 hours to complete the load.
Can anyone te
Hi,
I'm trying to do a simple UNION in MySQL (4.0.11a on Linux). I am trying the
following ...
If I do
SELECT THIS.PRODUCT_ID,"net.ajsoft.WebShop.Inventory.Product" AS
JPOXMETADATA,THIS.ID FROM PRODUCT THIS LEFT OUTER JOIN BOOK SUBCLASS0 ON
THIS.PRODUCT_ID = SUBCLASS0.BOOK_ID WHERE SUBCLASS0.BOOK
Dear Listmembers,
I have two tables, one is an updated version of the other. How can I find
only the "new" items on the newer table?
Table "newtest"
mom flowers
dad tools
dave video
matt magazine
Table "newtest2"
mom flowers
dad tools
dave video
matt magazine
gram book
erin flower
Query:
SELEC
ok...
I think this'll work...
select unique t1.*
from table1 as t1
left outer join table2 as t2 on t2.name = t1.name
where t2.name is null
> -Original Message-
> From: xander xxx [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2003 2:56 AM
> To: Dan Greene
> Subject: Re: RE: j
I try to compile MySQL/InnoDB 4.1.1 ( loaded from BK )
My Configure Line is:
export CFLAGS="-O6 -mpentiumpro"
export CXX=gcc
export CXXFLAGS="-O6 -mpentiumpro -felide-constructors -fno-exceptions -fno-rtti"
./configure --with-innodb --without-isam --without-docs --without-bench
--with-charset
Thanks for your answer, this is what I ended up putting in my
/etc/hosts.allow file, just to remove any doubt
ALL : ALL : allow
auth : ALL : allow
mysqld: ALL : allow
At 10:17 AM 9/11/2003 -0700, Jennifer Goodie wrote:
Assuming mysql server is running on a unix box, does the connecting client
h
> By the way, Jeremy's original answer was more correct than mine, because
> he noted where I did not that the sort buffer is a per-client resource
> and is allocated once for each client -- or at least for each client that
> issues queries requiringn sorting, such as those with ORDER BY clauses.
I don't think so. Based on what I've read, MySQL always assumes and
equal distribution of data for an index. Based on this assumption it
may determine that it's just not worth it to use the index, like if
your search will return most of the records. You should periodically
optimize your indexes
I really appreciate your help with this.
Hmmm... So, while SET FOREIGN_KEY_CHECKS allowed me to ALTER the table, now
I can't UPDATE the company that has a rep with the same company_code
because:
Error :: 1217 :: Cannot delete a parent row: a foreign key constraint fails
UPDATE company_table SET c
I have two tables which are exactly the same but have different set of data on them. I
wrote a query and used EXPLAIN to see how it would run on each table.
It turn out that the same query will use index on one table but not the other. So I
delete all data on the "bad" table (the one that won't u
xander xxx wrote:
Hi, I´m trying to join two tables with the follow statement
SELECT t1.name,t2.name FROM table1 t1,table2 t2 WHERE
t1.name<>t2.name.
I supose the expected result must be the non-matching rows of both
tables, but it´s not what I get. ¿What it´s wrong with that query?. I
hope do
At 10:17 AM -0700 9/11/03, Jeremy Zawodny wrote:
On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote:
Linux reports the threads of a process as processes. You really only
have one process, with 31 threads. (Probably because a bunch of clients
have connected.) So your resources are sha
On Thu, Sep 11, 2003 at 12:06:23PM -0500, Paul DuBois wrote:
>
> Linux reports the threads of a process as processes. You really only
> have one process, with 31 threads. (Probably because a bunch of clients
> have connected.) So your resources are shared among the threads of
> the server proce
> I then try to connect to the server from a remote location and get
> ERROR 1130: Host 'xxx.yyy.zzz' is not t allowed to connect to
> this MySQL server
> which is normal since i did not create a user yet
>
> I do this:
> GRANT ALL PRIVILEGES ON *.* TO stew@'%' IDENTIFIED BY '123' WITH
> GRANT OPTI
Abs wrote:
hi
i know this has been discussed before, storing bools
in the right column type. in the case of enum as:
enum("N","Y") or "n","y", etc. it might be easy to
read when u're looking at the database table itself,
but if u had to communicate this properly to other
programmers designing a fro
On Thu, Sep 11, 2003 at 09:29:27AM -0700, Mark Kaufer wrote:
> I've looked and looked but really can't find an answer to this question.
> In my my.cnf file, these are some of the things that are specified in
> [mysqld]:
>
> set-variable = key_buffer=256M
> set-variable = table_cache=64
> set-varia
At 9:29 AM -0700 9/11/03, Mark Kaufer wrote:
I've looked and looked but really can't find an answer to this question.
In my my.cnf file, these are some of the things that are specified in
[mysqld]:
set-variable = key_buffer=256M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-vari
Hi, I´m trying to join two tables with the follow statement
SELECT t1.name,t2.name FROM table1 t1,table2 t2 WHERE
t1.name<>t2.name.
I supose the expected result must be the non-matching rows of both
tables, but it´s not what I get. ¿What it´s wrong with that query?. I
hope do you understand my doub
Nicola Hartland wrote:
I am not sure this is the right place for this question but I am trying to find a personal server that I can install on my PC, I run XP that I can have to test the web pages. Does anyone have any suggestions and how to configure them.
thanks in advance
Nicci
http://source
where something bad happened, human or machine wise.. :)
and then when you have this running, you probably should run the mysqldump
program from the command line, and use the
mysqldump --opt --flush-logs --all-databases > 20030911.mysqldump.sql
and that should give you a good backup from
I've looked and looked but really can't find an answer to this question.
In my my.cnf file, these are some of the things that are specified in
[mysqld]:
set-variable = key_buffer=256M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = max_connections=1000
set-variable = t
Dear Friends,
After days of struggling with the 2013 error which no one seems to know how
to fix. I decided to install a 3.xx version of mysql, and then a new 4.0.15
version as well from binary this time. (even tried the RPM and src versions)
Installation is easy
Mysql Server is up
I then try t
Dear Mohamed:
I tried with your suggestion but when I like to see the /var/
mysql_query.log file my system says that this file doesn`t exist.
What can I do?
Thank you,
Edwin Limachi N.
DATACOM - Instalaciones La Paz
Tel.: 591-2-212-3978
Cel.: 591-715-29967
Fax.: 591-2-212-3975
Mohamed Lrhazi
Dear Miguel:
Firstly I found the path for mysqld, in my system (Linux RH7.3), it is in
/usr/libexec/
Then I write this command:
/usr/libexec/mysqld --log=/var/mysqldquery.log -u root
however the system give me this message:
bash: mysqld: command not found
I don`t understand what is happen. Co
On 11 Sep 2003 at 11:04, Andrew Kuebler wrote:
> Are BLOB column types the only columns that will let you write a NULL
> (Hexidecimal 0) and still write beyond that? CHAR, CHAR BINARY,
> VARCHAR, and VARCHAR BINARY all seem to truncate the string and stop
> at the first null even if I escape the s
http://www.mysql.com/doc/en/Adding_users.html
First, use the mysql program to connect to the server as the MySQL root
user:
shell> mysql --user=root mysql
Then you can add new users by issuing GRANT statements:
mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
-> IDENTIFIED BY '
Are BLOB column types the only columns that will let you write a NULL
(Hexidecimal 0) and still write beyond that?
CHAR, CHAR BINARY, VARCHAR, and VARCHAR BINARY all seem to truncate the
string and stop at the first null even if I escape the string being
updated.
I don't want to use a BLOB column
I couldn't find an appropriate mailing list for compiling MySQL, so I
thought I'd try here.
anyone successfully compile MySQL 4 on RedHat 9? I keep getting errors on
libmysql.c during the make step. Google doesn't reveal a whole lot about
compiling MySQL on RedHat which leaves me to believe most
Are there packages for java to include a standalone mysql database? Or are there plans
for such?
Luc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I've found the phrase in MySQL documentation
http://www.mysql.com/doc/en/Temporary_table_problems.html
"You can't use temporary tables more than once in the same query. For
example, the following doesn't work.
mysql> SELECT * FROM temporary_table, temporary_table AS t2;"
Does it mean that I
Hi There,
errno 145 means:
'Table was marked as crashed and should be repaired'
You can Type on the commandline (dosbox, bash, etc-): perror
to get information about errors.
prosit
Klaus
P.S.:REPAIR TABLE (manual chapter 4.4.5) might help.
--
MySQL General Mailing List
For list a
Deependra b. Tandukar wrote:
Dear all,
what is the meaning of
Can't open file: 'products_description.MYI'. (errno: 145)
in mysql?
Regards,
_DT
$ perror 145
145 = Table was marked as crashed and should be repaired
Hope this helps
--
Joseph Bueno
--
MySQL General Mailing List
For list archives:
"Deependra b. Tandukar" <[EMAIL PROTECTED]> wrote:
>
> what is the meaning of
>
> Can't open file: 'products_description.MYI'. (errno: 145)
>
> in mysql?
$ perror 145
Error code 145: Unknown error 145
145 = Table was marked as crashed and should be repaired
You should repair table with REPAIR
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Thu, 11 Sep 2003, Andy Callan wrote:
> I can log in as 'root' if need be. After the install I
> get errors like:
>
> /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server throug
Hi!
On Sep 11, Andrea Gangini wrote:
> I need help understanding how Mysql processes the & simbol (ampersand) in
> full text search; I've a text field in a table with this data:
>
> kw
> kw&z
> kw&zw
> at&t
>
> Of course I've instructed mysql to index words of 2 chars or greater; here's
> my fin
Dear all,
what is the meaning of
Can't open file: 'products_description.MYI'. (errno: 145)
in mysql?
Regards,
_DT
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I need help understanding how Mysql processes the & simbol (ampersand) in
full text search; I've a text field in a table with this data:
kw
kw&z
kw&zw
at&t
Of course I've instructed mysql to index words of 2 chars or greater; here's
my findings:
- MATCH (mycolumn) AGAINST ( 'kw' IN BOOLEAN MODE
Hello!
My Mysql version is 3.23.56.
I want to use specific index, but when I use "use
index" EXPLAIN gives me that key not used. And when
I'don use "use index" mysql uses other index.
Where I test this in 4.0.14 with force index it works
and the query time is 4x faster with index I choose,
then t
Hello!
My Mysql version is 3.23.56.
I want to use specific index, but when I use "use
index" EXPLAIN gives me that key not used. And when
I'don use "use index" mysql uses other index.
Where I test this in 4.0.14 with force index it works
and the query time is 4x faster with index I choose,
then t
Hello!
My Mysql version is 3.23.56.
I want to use specific index, but when I use "use
index" EXPLAIN gives me that key not used. And when
I'don use "use index" mysql uses other index.
Where I test this in 4.0.14 with force index it works
and the query time is 4x faster with index I choose,
then t
I'm rather new to OS X after not using a Mac since grade school. I have a bit of UNIX
experience so its not too complicated but having never administered to either I've
been
having some difficulty setting mySQL up after the auto-install. I'm interning for a
company and the computer I'm using
Sebastian Haag wrote:
Steve,
Steve Davies sagte:
Sinisa Milivojevic wrote:
On Mon, 08 Sep 2003 19:57:25 +0100
Steve Davies <[EMAIL PROTECTED]> wrote:
Hi All
I'm currently trying to learn C so that I can recode some php/mysql apps
I've got but I've run into probs right at the s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 10 Sep 2003, Jason Frisvold wrote:
> Aha... I think I figured it out...
>
> I have the MySQL-4.0.15-0.src.rpm in the same directory... I'll bet
> that an rpm -Fvh automatically installs the source.. The source is
> "owned" by mysqldev,
I'm rather new to OS X after not using a Mac since grade school. I have a bit of UNIX
experience so its not too complicated but having never administered to either I've
been
having some difficulty setting mySQL up after the auto-install. I'm interning for a
company and the computer I'm using
"Daevid Vincent" <[EMAIL PROTECTED]> wrote:
> Thanks Victoria for the pointer. I should have looked there first. Duh!
>
> Now for the help... I tried:
>
> ALTER TABLE rep_table ADD FOREIGN KEY (`rep_company_code`) REFERENCES
> `company_table` (`company_code`) ON UPDATE CASCADE;
>
> But get "ER
Maria,
Maria Garcia Suarez sagte:
> Hi there!
>
> I'm currently developing a web where we let users
> create their own forums. All the messages (wherever
> they are posted) are stored in the same mysql table.
>
> When users read a certain message I would like to
> display the previous and next mes
I have this query which looks something like,
(
SELECT count(*) AS tCount, amount, block
FROM table_a
GROUP BY amount, block
)
UNION
(
SELECT count(*) AS tCount, amount, block
FROM table_b
GROUP BY amount, block
)
ORDER BY amount;
tCountamountblock
3400A<--
95 matches
Mail list logo
