in most 32-bit computers the process
> InnoDB: memory space is limited to 2 GB or 4 GB.
>
> How can I make the size of LOBs I insert NOT be memory constrained?
No way.
Unfortunately, it's the way MySQL works at the moment.
Which does not mean it's not going to be changed i
-allocated to the buffer pool size?
No, I don't. Sorry :(
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Kerpen, Germany
how we could repeat this bug.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mail
Hi!
On Feb 14, Mariella Petrini wrote:
> Hi All,
>
> Is there any plan to release a binary version for
> mysql-5.1.23-maria-alpha for Linux 64 for AMD ?
Yes.
Regards / Mit vielen Grüssen,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[
ems one can use a sequence in postgresql in different
> tables. is it possible in a similar way?
Try UUID() function
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, S
ere in cache,
> this would speed up things so much !
It's fixed in 4.1.8.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
keys. And even if you have an index over
VARCHAR(255), actual values are usually shorter, right ?)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_
gards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://li
qldoc
repository on mysql.bkbits.net).
Plans - yes, if the current one is bad.
But I don't know what to put instead.
Feel free to suggest a better weighting scheme :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\
text.
>
> As far as this is technically possible it would be helpful to give some
> extra relevance to those hits where the 'distance' between words is small.
Tnanks, good idea.
(I'll see how it could be done)
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /
. It's not functioning in Mysql 4.1
You can submit a bugreport at http://bugs.mysql.com/
(but please provide a *readable* EXPLAIN output, using "mysql -t")
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <
. In particular it defines '+' for "must be
present" and a space ' ' for "optionally present" words.
You want to put the space first (for "must be present" words)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \
caches the result
of the query as it is sent to the client. Raw data on the wire (almost).
So it can only cache the complete query, not a part of it.
By the way, there's no need to measure query execution time, you can
do 'SHOW STATUS' and watch Qcache% variables - just like
ne?
In the unix source distribution (any recent one).
Probably it'll be in the 4.1.11 windows source distribution too.
> And where can I find other documentation that provides
> pointers on the subject?
Check other engines in the sql/examples directory.
Ask your questions in the
Hi!
On Apr 11, Christian Hammers wrote:
> Hello Sergei
>
> On Thu, Apr 07, 2005 at 03:14:10PM +0200, Sergei Golubchik wrote:
> > > I've just run into deep troubles while upgrading from 4.0.24 to 4.1.10a
> > > using precomiled Debian packages on Debian Woody al
> InnoDB tables, only on MyISAM tables. Is this correct?
Yes.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL
al bugs in name resolution
for INSERT ... SELECT ... ON DUPLICATE KEY UPDATE reported recently,
I believe yours is one of those.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/
>
> just looking for tips/suggestions to tweak the results it returns and
> anything else i should know.
>
> lastly... this might be more related to php, if anyone knows of a
> reliable function/class to highlight search terms, please let me know.
>
Regards,
Sergei
--
> didn't see any message saying that he got a solution.
>
> Or simply, is it possible to tell MySQL daemon to use OLD_PASSWORD when encrypting
> passwords?
yes.
--old-passwords switch.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golub
s.html
Nope. The manual says "it works with UTF-8 from 4.1.1".
You have 4.1.0.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___
Hi!
On Dec 02, Sergei Golubchik wrote:
> Hi!
>
> On Dec 02, Hu, Yiguang wrote:
> > Is the fulltext search working for cjk text (use UTF-8) in 4.1.0 alpha ? I
> > have trouble doing search on cjk text in 4.1.0alpha, though it seems should
> > be working according to
om any `UNION'.
before 4.0.14 you could only use a union without parenthesis in INSERT
or CREATE.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\
y to create a complete repeatable test case that I can use to
repeat this behaviour and submit it to bugs.mysql.com.
Then the bug will be fixed asap.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
your data.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.my
_CALC_FOUND_ROWS MySQL goes on and reads all rows, it takes
time.
Finding relevant rows and sorting is based on index only, row data are
not read.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]
otal while using the index
> and use "select FOUND_ROWS()" without
> SQL_CALC_FOUND_ROWS to retrieve the total?
Yes, it could.
It is the optimization that wasn't implemented yet.
(but it's in the TODO)
Regards,
Sergei
--
__ ___ ___ ___
xed.
"WITH QUERY EXPANSION" is now documented.
Thanks for spotting this.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___
Hi!
On Dec 07, Chris Elsworth wrote:
> On Sun, Dec 07, 2003 at 01:48:08PM +0100, Sergei Golubchik wrote:
>
> > > What is WITH QUERY EXPANSION? I found no details in manual.
> >
> > Fixed.
> > "WITH QUERY EXPANSION" is now documented.
>
> I&#x
ectly.
It's all fixed now - in 4.1.2.
Thank you.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
&
e is quite a different, why is that ?
What does EXPLAIN show for both queries ?
And are you sure the numbers are correct, the first query - the one
without "IN BOOLEAN MODE" - is faster ? I would expect the opposite.
Regards,
Sergei
--
__ ___ ___
ead of linear one, etc.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
mysql.com)
as far as I rememebr this bug was already reported there and was fixed.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\__
ot;SET NAMES koi8r;" from mysql command line client or start it
with --default-character-set=koi8r (or put
default-character-set=koi8r in ~/.my.cnf) - to inform the server that
you send queries and want to receive results in koi8r charset.
That's all!
Regards,
Sergei
--
) table names to import them on my webhoster's
> > Linux server. If the setting was enabled, I'd get all wrong table names and
> > my application couldn't find its tables anymore (as 'bb1_GroupMembers' gets
> > to 'bb1_groupmembers' and that's something
( http://lists.mysql.com/mysql/149644 ),
> you said "Another reply will follow..." I never saw another reply
> though. :-/ It's OK, I was just wondering what other interesting things
> you were going to say! :-)
Oops, checking...
Yes, sorry.
But I have to admit, I abso
ackup is always recommended :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
My
NULL,
> `xmlstatus` enum('HTML','XML') NOT NULL default 'HTML',
> `bid` char(6) NOT NULL default '',
> `toolbar` int(1) default '0'
> ) TYPE=MyISAM;
What columns are you trying to index ? What is the in
ed to waste the time sending emails back and forth and speculating,
when your test case is small enough :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/
er of row reads.
I agree this optimization is not the best for all situations,
optimizing this type of queries is in the todo.
btw, it could be that my guess about the slowness was wrong :)
Compare these N,M,K,L numbers yourself.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ _
may tell myisamchk that all rows longer
than that are false matches and should be ignored.
> 1) Are there any tools which will allow me to salvage some data?
myisamchk as of 4.1.1.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Go
the first prefix is
> > looked up in the index) and to add a row scan (in the LIKE sense and as you
> > described in #1), to remove "half-matched" rows.
>
> OK, I see. :-) I'm surprised they're not looked up in the index. But
&
or phrase syntax.
I tried - works ok.
So - examples are not enough, I need a repeatable test case (e.g. your
table data).
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
Hi!
On Jan 11, Matt W wrote:
> Hi,
>
> - Original Message -
> From: "Sergei Golubchik"
> To: "Steven Roussey"
> Sent: Wednesday, December 10, 2003 7:44 AM
> Subject: Re: 4.1.1 FTS 2-level?
>
>
> > Hi!
> >
> > On Dec 09
--+
> 1 row in set (5.00 sec)
Not a bug.
In the manual, section "Upgrading from Version 3.23 to 4.0", there is
* To use `MATCH ... AGAINST (... IN BOOLEAN MODE)' with your tables,
you need to rebuild them with `REPAIR TABLE table_name USE_FRM'.
Regards,
Sergei
gives
> me a table of about 16Gb, leaving 75+Gb of free space on my Compaq
> Proliant DL380G2, 1.2Gb RAM. The kernel is compiled with HIGHMEM
> support, and the MySQL database is using a cnf based on my-huge.cnf.
>
> Somebody knows where to start looking?
What is the exact comm
it helps ?
Unfortunately we don't have FreeBSD-5/Alpha
to try this ourselves.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___
uot;upgrading" sections are difficult to follow.
I'm forwarding this request to our doc team.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
pect that you need only a few rows from your table for this
bug to appear. (of course, finding these exact rows in your gigabytes
could be not easy :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/
sted
Thanks for alerting us!
> Can this be fixed ?
It should be.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /__
.com/bug.php?id=1737
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
F
0.0 1:37 0 sshd
>
> Thanks
> Rob
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/
How big are your tables (rows and bytes) ? What are typical values for
ThemenCount and MessageCount in the result of this query ?
Can you provide the results of SHOW CREATE TABLE for forum and forum_msg ?
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubch
all table rows, get
> the column and tokenize and collect words?
Use the ft_dump utility program that comes from MySQL source
distribution.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
me thing happens for a single column fulltext index.
Fixed.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
iority issue that I can probably look at
later. As a workaround just compile MySQL without libwrap.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/
table test case on http:/bugs.mysql.com.
This way you can make sure it won't happen for the third time :)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software
akes a
string as a value. Now it's possible, but 4.0 is stable, so I cannot
make ft_boolean_syntax a changeable variable there.
But I just pushed this to 4.1.
Should be in 4.1.2
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Serge
's the first. Each new need for a temp file picks from
> the round-robin list.
Yes, it's how it works.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Dev
se and query that illustrates the
> problem. Please let me know if you would like me to do this.
Yes, please do!
Then, please, submit a bugreport at http://bugs.mysql.com/
Thank you for your help!
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Se
g to get some variables.
> Some pointers may be invalid and cause the dump to abort...
> thd->query at 0x8584920 = O.H..B.
> thd->thread_id=4
> The manual page at http://www.mysql.com/doc/en/Crashing.html contains
> information that should help you find out what is causing
T ('+touch +bit') AND ... LIKE '%16-bit%'
that is rows would be selected based on an index lookup for two words,
and as a post-processing a substring search would filter out rows
without "16-bit" substring.
Regards,
Sergei
--
__ ___ ___ __
/
hing like
select IF(UNCOMPRESSED_LENGTH(msg_body) > 102400, msg_body,
IFNULL(UNCOMPRESS(msg_body), msg_body)) ...
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Sof
?
Ok, sorry.
If the original query is '"16-bit Touch"' then it would be executed
functionally similar to
MATCH keywords AGAINST ('Touch' IN BOOLEAN MODE)
AND keywords LIKE '%16-bit Touch%'
> Sergei Golubchik wrote:
>
> >Hi!
> >
> >
try your query after upgrade.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archiv
means AND
and space ' ' means OR. You can change it to be other way around.
Unfortunately to change this variable one have to rebuild MySQL.
See http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html
Regards,
Sergei
--
MySQL Development Team
__ ___ ___
Any xxxTEXT field can be used in FULLTEXT index.
TEXT, MEDIUMTEXT, LONGTEXT, TINYTEXT - they all work.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ My
ic)
> or knows where I could receive it from (Hello MySQL AB ;-) ?
They are installed by mysql_install_db script
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQ
-+--+-+
>
>
> the first was using the force index, the second was without
>
> so is adding to force to use and index going to make it slower ?
No.
EXPLAIN output is identical, as far as I see, so your FORCE INDEX did
nothing. Speed change is probably due to caching.
R
anual:
Changes in release 3.23.56 (13 Mar 2003):
...
* Better `RAND()' initialisation for new connections.
...
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabru
In 4.1 there is INSERT ... UPDATE command:
INSERT INTO TABLE VALUES ("20030713","20")
ON DUPLICATE KEY UPDATE VALUE = VALUE + 20
assuming, of course, there is a UNIQUE (or PRIMARY) key on ID, so that
there will be "duplicate key"
Regards,
Sergei
--
__ _
in release 4.0.14 (to be released soon)
---
Functionality added or changed:
* Enabled `INSERT' from `SELECT' where the table to be inserted into
can also be in the table list from the `SELECT'.
...
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_
and you won't be able to
follow the progress log, as you will not be the owner of the ticket.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
upgrade to the recent stable version - 4.0.x - it does not have
this bug.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
all priveleges with grant option were granted to '[EMAIL PROTECTED]' -
it's different user!!!
I'm not sure why it does not work on Debian - may be some bug in the
really old version.
As for 4.0.12 - there was a bug, that is fixed in 4.0.14.
egards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.c
M
or create dummy MYI file, TRUNCATE TABLE, restore MYD file (you backed
it up, didn't you ?), REPAIR TABLE
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL
myself can offer some insight.
Are you sure you compiled mysys/ with -DSAFE_MUTEX ?
safe_mutex* symbols are defined in mysys/thr_mutex.c
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
tes and WITHOUT spaces.
--ft_min_word_len=2
or
-O ft_min_word_len=2 <-- but -O is obsolete
but not
-O 'ft_min_word_len = 2'
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ /
one is simlpy
ft_min_word_len=2
(or with spaces, they are allowed in my.cnf)
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.co
and
GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED] WITH GRANT OPTION;
Only after the second comamnd [EMAIL PROTECTED] can give grants to
others.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/
ysql client to apply
> today's updates.
>
> It's also just cool to watch when nothing else is happening.
>
> Anyone know why it's being depreciated?
Because you can do all the same (and more) with binary log.
Regards,
Sergei
--
e {No value for `mysqlversion'} version of `MySQL
> Server' but it is also applicable for ...
>
>
> Regards,
> Thomas Spahni
Oops!
Sorry for this :(
It's fixed - and won't happen again.
Regards,
Sergei
--
__ ___ ___ __
romanian one to fairly sort the chars for me. I must do
> change the behaviour and I don't know how.
check http://www.mysql.com/doc/en/Localisation.html
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ /
;indexing is on its second day"...
How is it done ?
You insert data into the table with FULLTEXT index ?
Or you add an index to existing table (with ALTER TABLE or alike) ?
What does SHOW PROCESSLIST shows ?
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei
M
>
> I thought the recommended way was using CHECK/ REPAIR TABLE from
> inside mysql for the supported backends? Also, (my)isamchk can't be
> run while the database is running, can it? (I might be confused here)
Use mysqlcheck
Regards,
Sergei
--
__ ___ ___ __
you can do it with UNION even now,
but it's not nice solution at all.
Note - when you insert more than 1% of the old table size, it's faster
to use ALTER TABLE t DISABLE KEYS before loading (and ... ENABLE KEYS
after).
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \
yet of
how to make them significantly faster.
Neither it is any high in the todo :(
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Develope
t; can do with out any error.
On what query does it crash ?
Could you go to bugs.mysql.com and submit a bugreport about it ?
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, S
. Enabled
by default, disable with --skip-opt.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germa
/tcp/10.1.1.12/4711 > /mysql/db/x/x
mysql -e "LOAD DATA INFILE 'x' INTO TABLE x" x
...
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Dev
g an insert, i also do a delete ...
> But pseudo "coucou" is repeated 53250 times.
>
> I tried something like :
> insert into Log_Forums (pseudo,date,Type_Message) values
> ("buh08",2003080611,"0");
> Don't work.
>
> But if
pwords list? Is there
> > >any way I can see what words are in there? Can I exclude words from the
> > >stopword list without recompiling MySQL?
> >
> > I don't believe you can exclude words from the list without recompiling.
You can, actually, there is ft
ill_note_search
WHERE MATCH notes AGAINST("this" IN BOOLEAN MODE);
SELECT COUNT(*) FROM temp_bill_note_search
WHERE MATCH notes AGAINST("bill" IN BOOLEAN MODE);
?
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Go
he `core file size' by adding `ulimit -c
100' to `mysqld_safe' or starting `mysqld_safe' with
`--core-file-size=100'. *Note `mysqld_safe': mysqld_safe.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __
d HAVE_SNPRINTF_
> (which doesn't exist anywhere) instead of HAVE_SNPRINTF.
Everything is fixed.
Thank you!
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, S
Hi!
On Aug 14, James Fryer wrote:
> At 10:28 am 14/08/03, Sergei Golubchik wrote:
> >It's in the 4.0.14 changelog, and thus, is available in 4.0.14
>
> Hmm, I am using
>
> Ver 13.5 Distrib 4.1.0-alpha, for apple-darwin6.4 (powerpc)
>
> which I should have sa
looks like hardware problem.
Regards,
Sergei
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archive
UNION...ORDER BY statement as input to CREATE TABLE.
>
> Same holds for INSERT INTO.
>
> Is this a bug? I can't find it documented anywhere.
It's in the 4.0.14 changelog, and thus, is available in 4.0.14
Regards,
Sergei
--
__ ___ ___ __
/ |/
; | id| int(11) | | | 0 | |
> | name | char(30) | YES | | NULL| |
> | tel | char(20) | | PRI | | |
> +---+--+--+-+-+---+
> 3 rows in set (0.00 sec)
>
> Unique key was dropped. Why not Primary key, why no error message???
Confirmed. Fixed in 4
1 - 100 of 398 matches
Mail list logo
