uot; of this
user, he needs to log in from each of his "personality" hosts, and set it on a
case-by-case basis.
--
Sasha Pachev
AskSasha Linux Consulting
http://www.asksasha.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the records or something crazy
like that, and this will help you detect it.
--
Sasha Pachev
AskSasha Linux Consulting
http://www.asksasha.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
option is to contact Heikki and coax him into hiring
somebody to add FULLTEXT to InnoDB tables.
--
Sasha Pachev
AskSasha Linux Consulting
http://www.asksasha.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the most recent items. You need to add an ORDER BY
some timestamp DESC for it to work right.
I would, however, be seriously concerned about diskspace if a table is adding
200 MB a day with no archiving/compression/purges.
--
Sasha Pachev
AskSasha Linux Consulting
http://www.asksasha.com
--
MySQ
o_date, but it keeps failing.
Looks like it's not in version 4.0.2?
Minh:
Your options are:
* upgrade to 4.1
* parse and convert the date in your applications
* use an ugly combination of SUBSTRING() and CASE to parse out the date
* write a UDF implementing STR_TO_DATE()
* backport STR_TO_DATE
ity.
Also note that in MyISAM all keys are stored in one MYI file. So dropping a key
is not as easy as just deleting a file.
--
Sasha Pachev
AskSasha Linux Consulting
http://www.asksasha.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
es for when the trouble starts is largely
application dependent.
--
Sasha Pachev
AskSasha Linux Consulting
http://www.asksasha.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#x27;ll do fine on modern hardware - this query under those
curcumstances should take the order of maginitude of 0.01 s. However, if you
have more records in the table, and the WHERE clause is not optimized, things
could get bad, and this time the query cache does not save you.
--
Sasha Pachev
Crea
_id = 1 and b.doc_id = 2 and a.col_soundex = b.col_soundex and
name_soundex.col_soundex = a.col_soundex
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ems like a struggling user prints a
lot. You cannot be 100% sure about the cause and effect relationship, though,
but trying to go printless might activate something that speeds up skill
acquisition.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
side. Just install 4.1 under a different root (e.g
/opt/mysql-4.1), and make sure to fix up mysqld_safe from 4.1 to read the
correct my.cnf
4.1 should be a fairly safe bet at this point if you mostly use the features
that are from 4.0.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com
ainst
incompatible libraries.
Another option is dig deep into Solaris and try to figure out the SUNW_1.4
mystery. Unfortunately, in the end the answer is still very likely to be that
you just need to build your own binary.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL Ge
s studying your problem, so it is very likely
that I might have overlooked something. However, at this point it appears to me
that you should just use two separate queries and a temporary table (or just
post-process in the application) to get the results you need.
--
Sasha Pachev
Create online s
12-29 08:36 mysql.sock
drwxrwxr-x 2 root mysql 48 2004-12-28 09:49 test
Russ:
chown -R mysql.mysql /var/lib/mysql
add
user=mysql in /etc/my.cnf
that should be enough, if for odd some reason it is not, read the error log, it
will tell you what else needs to be fixed.
--
Sasha Pachev
Creat
our table for a long time once in a while. This would
explain the results you are observing.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mizer is making bad choices because of incorrect key statistics, you can
instruct it to use the correct key with FORCE INDEX
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
first.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
os and cons of each
engine for my particular situation?
Homan:
I believe in your situation MyISAM is better. I do not expect to see it becoming
obsolete for at least another 5 years. If it does at some point in time, you
will be able to run ALTER TABLE to covert to a better table type.
--
Sasha P
ser_ID
AND A.Project_ID = '11'
ORDER BY User_Firstname;
Shaun:
If I understand the problem right, it sounds like you are missing AND
B.Bookings_ID is NULL in the where clause.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For
that possible with MySql?
Mauricio:
I do not know of a way to do it without generating the name in the client
langauge, or hacking MySQL source.
However, MySQL 4.1 does support a subselect. This may solve the need for the
temporary table creation in your case.
--
Sasha Pachev
Create online surve
uld be appreciated.
John:
You are assigning to $myaddress outside of the loop after the row has been
invalidated.
Try
while ($myrow = mysql_fetch_array($result))
{
echo $myrow[Email];
$myaddress = $myrow[Email];
}
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Ma
ny other MySQL mirror.
The problem with sprintf() is that it does not check buffer boundaries, and does
not escape the strings. snprintf() will check the boundaries, but you would have
to do the escaping yourself. mysnprintf() will do both for you.
If sprintf() fix/check does not help, get valgrind
hen both reads and writes are small. With InnoDB it becomes particularly
important that you use good keys.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cting. Each time you connect, you
have some overhead on the order of a few megabytes. Times 55, and you can easily
eat up the remaining 300 MB. Also, mysqld is probably not the only process on
the system.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing
nt you try to connect to it.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rrors will help. Also, try
increasing connect_timeout. And set up a cron job that runs FLUSH HOSTS every so
often.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.m
rtition, or set max-relay-log-size to a lower value.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
that
big of a minus. Due to the strong commitment of the MySQL team to backwards
compatibility, most if not almost everything the book says applies to 4.1 and
5.0. It is just that the newer versions have some new features and options that
the book does not cover.
--
Sasha Pachev
Create online
/errmsg.sys host:
ssh host
mkdir mysql-data
./mysqld --skip-grant --skip-net --datadir=`pwd`/mysql-data --language=`pwd`
--socket=`pwd`/mysql-data/mysql-test.sock &
you can now connect on socket `pwd`/mysql-data/mysql-test.sock and issue
queries.
--
Sasha Pachev
Create online surveys at
uery
that creates a temporary table.
Enable log-long-format and try to figure out what those queries are. See if you
can optimize the ones that are scanning a lot of rows by adding a key, or by
convincing your developers to re-write them.
--
Sasha Pachev
Create online surveys at http://www.s
u may need to do
some special tuning of Solaris to make it cache better.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Przemyslaw Popielarski wrote:
Sasha Pachev <[EMAIL PROTECTED]> wrote:
Check if you have any replication restricting rules on the slave.
There might be a bug that incorrectly flags a query to be excluded.
If that is the case, then try to re-write the rules to see if you can
get around the bug
sages file has the
expected number. Otherwise, if you are within the same version, mysqld will be
able to deal with all the files from the old one.
Hmmm, ok. Do you think I should file a bug?
Lenz is already looking at it.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
uilding 4.1.7 from source - there was another user that was reporting
a really strange crash that went away after he complied the binary himself. So
there is some strong evidence that the standard MySQL 4.1.7 binary was not built
properly, in which case, odd behaviour is to be expected.
--
Sasha Pachev
ly like to know what is wrong when I'm using the binary
distribution.
Most likely a mistake of some kind on the part of MySQL AB. A similar problem
has happened in the past.
I hope somebody on the build team is listening.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
-
Ugo Bellavance wrote:
Sasha Pachev wrote:
I tested the memory and it seems ok.
I doubt this is an hardware issue, since version 4.1.3 works perfectly.
Ugo:
Do the production and the test server run on the same hardware?
One is a single Athlon XP, the other is a dual Athlon MP.
Are you using the
quite what you wrote to it in the first place due to OS/hardware problems.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
not
been compiled for the right processor type.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
th indexes is ~1.4GB
Running NetBSD 1.6.2 and mysql 4.0.21
What can cause these segfaults? and is there anything i can tune to get
rid of them?
Try lowering your sort_buffer_size and read_buffer_size - those are allocated
per thread, and with a lot of connections can cause a memory shortage if they
4.0 to 4.0.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
TEMPORARY TABLE t1 (,UNIQUE KEY(size))
then
INSERT IGNORE INTO t1 SELECT ... ORDER BY size,if(ServerName='primary_server',0,1)
and then
SELECT * FROM t1
DROP TABLE t1
A little convoluted, but nothing better really comes to my mind at this point.
--
Sasha Pachev
Create online surve
minute or so.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
o do it in Visual Studio:
Download the source, and load it in VS. Go to the Properties of mysqld, and
where you can add Define statements, add HAVE_VIO and HAVE_OPENSSL (not
WITH_OPENSSL). then compile the mysqld project, and you're done!"
--
Sasha Pachev
Create online surveys at ht
.
It is, nevertheless, a bug, for the server to coredump on this. The code does
thread stack checking to make sure it does not exceed the limit, but apparently
it does miss some cases.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives
it is even possible to write a
machine subquery optimizer that will outperform a good human "optimizer" that
re-writes them into something better digestible. Kind of like no super-smart JIT
will ever beat a good C programmer on execution speed, although it might help
with the develop
exing only a prefix of the address in the
(name,address). Try key(name(16),address). In general, order by on a key or key
part cannot use prefix-indexed fields.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
or
faster) you are looking at the order of magnitude of 10,000 per seconds.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
thing I would check is if the kernel was
configured to be SMP-cabaple/enabled.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Greg Willits wrote:
Greg Willits wrote:
On May 20, 2004, at 11:08 AM, Sasha Pachev wrote:
Greg Willits wrote:
I have two mysql apps running on the same machine (OS X 10.3.3). A
mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a
config file specifying the port and a unique socket
) select
serial,sum(cost) from conveyor,accessory where conveyor.serial =
accessory.serial group by serial;
select s.serial,s.cost as support_cost,a.cost as accessory_cost from
support_cost s, accessory_cost a where s.serial = a.serial;
--
Sasha Pachev
Create online surveys at http
is written with a lot of care to use the CPU cache efficiently.
Having a larger cache will compensate for the lack of CPU speed to a great
extent. So the results do look about right.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list arch
where db='db' and user='user1'
and host='host';
update tmp_db set user='user2';
insert into db select * from db;
drop table tmp_db;
flush privileges;
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archi
Greg Willits wrote:
On May 20, 2004, at 11:08 AM, Sasha Pachev wrote:
Greg Willits wrote:
I have two mysql apps running on the same machine (OS X 10.3.3). A
mysql 3.23.54 on port 14551, and a mysql 4.0.16 on 3306. Each has a
config file specifying the port and a unique socket name in /tmp.
They
heap tables?
Amount of RAM + max_heap_table_size setting in the server.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
back to that old thread?
Shawn:
Enable both log and log-bin. Then you can match the thread_id field in
mysqlbinlog output with the Connect command and track down the user.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: h
to a normalized design.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
irect access, they can either read no rows, or all of them.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
m would be to create small shell scripts called
mysql-3 and mysql-4 that will connect to the right instance.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
does not want to give up CPU,
it will not be forced to do so. What platform is this on?
In any case, my recommendation would be to do whatever it takes to keep that
queyr from running for 2 minutes. Try to optimize it, or re-write it so it gets
its data in small chunks.
--
Sasha Pachev
Create
Any particular reason to use 2.4.x vs 2.6.x from kernel for base?
2.6 has not been around long enough to prove itself, in my opinion. I know 2.4
will work well, but I cannot say the same about 2.6 with the same degree of
confidence.
--
Sasha Pachev
Create online surveys at http
the trick does work. In three years
of doing MySQL support I have learned this simple formula:
RH kernel from 7.0 and newer + MySQL + high load = highly probable instability
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://li
uld find a
good way to sell it, I would write it.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
3 | f |
|6 | f1 |
|7 | ft1|
+--++
3 rows in set (0.00 sec)
Once the bug gets fixed, you would not need to pad.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
bsequent modifications (delete/insert/update) have fixed or obscured
the corruption
* CHECK TABLE has a bug that resets some flag in the table status area which
obscures the corruption
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the end of the last log.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ers in Europe
won't have these problems?
Chris:
You need to use mysql_real_escape_string() on user input before you insert it.
Then there will be no need on character code range limitations.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing Lis
To verify - md5sum
/path/to/fname, and compare that with select md5(content) where ...
If that fails, file a bug report to MySQL developers after doing the regular
nose pinching routine to make sure you are seeing things as they really are.
--
Sasha Pachev
Create online surveys at http://www.s
orts the transaction. If this is indeed a bug, I am sure
Heikki would like to fix it ASAP.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
elease it after
mysql_store_result() returns.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
all of the text is "By County."
Ken:
Consider having two columns - num_val, and text_val, and then order by num_val,
text_val
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
a lot of read/write syscalls. To illustrate the
difference - I recall a case when performance on MyISAM was terrible over NFS
(well, that is to be expected), but once the table was changed to InnoDB, it
improved drastically.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL
s on the client, use some client language (C,Perl,PHP), call
mysql_real_escape_string() on the contents of the file and insert the escaped
string.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
ng to 3.23.58 or 4.0.18.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
useful help in the
manual or archives when I searched for those errors.
Gabriel:
Check the master error log to see what binary log it is trying to read, and why
the read is not successful, eg. ownership/permission problems.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com
ficiet to restore.
P.S. If you are using MyISAM, binary snapshot would work better for this much
data. For InnoDB, hotbackup utility is a good investment.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
_join).
Enable log-slow-queries and log-long-format in my.cnf, then police the slow log
fixing the queries/table schema as you go along. Start with the ones that
examine most rows.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives:
-h 127.0.0.1 instead to bypass
the Unix socket and use TCP/IP.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
add debugging messages to mysqld_safe script
(safe_mysqld in the older versions).
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
user that mysqld runs as must be able to read from and write to the table files.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
of concern, try both and see which one performs better.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
index?
Just curious,
Lou
Lou:
Are you familiar with a hash data structure? If not, you can read here:
http://ciips.ee.uwa.edu.au/~morris/Year2/PLDS210/hash_tables.html
or other pages that Google finds for "hash data structure".
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
you.
Jason:
See http://dev.mysql.com/doc/mysql/en/Adding_native_function.html
I also cover this subject in the last chapter of my book "MySQL Enterprise
Solutions".
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: htt
nd it works different on
different machines, I would start checking the RAM it make sure it is not going bad.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
lot, this would help.
* Create a record count summary table that will store the value of count(*)
and update it in your application every time you insert or delete records
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.
appear in the slow log
* fix each one of them so it does not by adding the appropriate keys, rewriting
it to be more efficient, and/or reorganizing the schema to avoid the slow queries
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives
machine.
Does somebody know how I can add more "stand-by" threads for my mysqlds
that mysqld become faster?
The number of stand-by threads is controlled by thread_cache_size parameter.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For lis
AMD 1800+ (those
can do 8000 indexed selects of one row per second). If some AIX fan wants to
challenge my intuition with a benchmark, you are more than welcome.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http
once, and then run
many times, rather than prepare each time. If that is indeed the case, send your
code to MySQL developers and have them check out the performance bug.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http:/
/mysql-4.0.18/extra'
gmake: *** [all-recursive] Error 1
make: 1254-004 El código de error del último mandato es 2.
Any idea ?
At first glance, looks like a broken compiler. Very stranges that gcc would
break like this.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MyS
f you really want to handle SIGPIPE while in the middle of a mysql call. In
that case, recomple the client without --enable-thread-safe-client or hack the
source.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysq
is a practical problem, and not just a study of how things
work, I would suggest reporting the bug ( if this happened with the latest
version), and resetting the replication.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://
libc to the latest patch level?
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the details to the
MySQL developers.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
and if so,
correct it with an update query.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ing at all if you are not doing any queries.
Based on the test results you have reported, I would put your libc as the
primary suspect, and the next one would be bad build/compiler bugs. I would
suppose that --skip-innodb just changes some memory allocation patters on
startup, which possibly
y should keep reading from the old one until they catch up. Do they fail to
roll over to the next one after finishing the old one? If yes, it would be a bug.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
slave connects and
asks the master to give it a dump of its update log.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nd restart the slave SQL thread with "SLAVE START". We stopped at log ...
I've seen it on my systems. The problem is a bug in DELETE in 4.0 that was fixed
in 4.0.18.
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archiv
tion for a workaround - add a column rev_reference with a key on it,
update t1 set rev_reference = reverse(reference), and then do where
rev_reference like '2332%';
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
--
MySQL General Mailing List
For list archives: http://list
}
(...)
The client should try again if the EINTR error was returned.
Did we do something wrong in the configuration of the server or is this a
tiny bug?
Regards, Jigal.
It's a bug. I would recommend to patch libmysql.c for now until MySQL developers
fix it.
--
Sasha Pachev
Create online
1 - 100 of 412 matches
Mail list logo
