and writing to
localhost instead, which works fine. I still feel writing to a UNIX
socket ought to work and even if I've got a permission issue or
similar, a segfault is not the appropriate handling. Any clues?
--
Per Jessen, Zürich (16.5°C)
--
MySQL General Mailing List
For list archives: http
on Linux, so that is glibc - they work fine in a lot of
other code. I find it hard to suspect those two.
/Per
--
Per Jessen, Zürich (23.0°C)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
be
it. When I switched to using a UDP socket, sendto() did complain about
the length. (error 90, message too long). Hmm, that's probably a UDP
packet-size restriction, whereas no such restriction exist for a unix
socket (I presume). Thanks for the idea!
--
Per Jessen, Zürich (24.4°C)
--
MySQL
to epic proportions.
Fortunately those web startups that start small and grow to epic
proportions are quite limited in numbers :-)
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch
. Instead I
see lots and lots of replication traffic? I'm guessing the master
notifies the slave(s) of all changes, not just changes to the
replicated tables?
Is there a way of limiting that? Alternatively, is there a way of
doing replication-on-demand, perhaps triggered by cron?
/Per Jessen
Per Jessen wrote:
Is there a way of limiting that? Alternatively, is there a way of
doing replication-on-demand, perhaps triggered by cron?
Ignore this, problem solved. I'll let the slaves query the master
regularly and just reload the entire table.
/Per Jessen, Zürich
--
MySQL General
Johan De Meersman wrote:
On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen p...@computer.org wrote:
Per Jessen wrote:
Is there a way of limiting that? Alternatively, is there a way of
doing replication-on-demand, perhaps triggered by cron?
Ignore this, problem solved. I'll let the slaves
What does this error mean?
mysql select ipaddr,reverse,count(distinct domain) from mxdata,domain
group by ipaddr;
ERROR 126 (HY000): Incorrect key file for
table '/var/lib/mysql/.tmp/#sql_d57_2.MYI'; try to repair it
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http
Per Jessen wrote:
What does this error mean?
mysql select ipaddr,reverse,count(distinct domain) from mxdata,domain
group by ipaddr;
ERROR 126 (HY000): Incorrect key file for
table '/var/lib/mysql/.tmp/#sql_d57_2.MYI'; try to repair it
Please ignore.
/Per Jessen, Zürich
--
MySQL
- I've got it running one
RAID1 (2x72Gb) for system and one RAID6 (6x146Gb) for data.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Per Jessen wrote:
mysql list,
after my upgrade to 5.1.36 I hit this odd little problem:
I have an application which does roughly this:
CREATE TEMP TABLE new LIKE old;
populate 'new'.
do some stuff
TRUNCATE new;
populate again
This has always worked fine, but after the upgrade
-time issues
(last time I benchmarked the upgrade it came in at over day).
This may or may not be useful, but I've just upgraded from 5.0.51 to
5.1.36, which took about 6 hours using mysqldump+reload - the database
is about 20Gb.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives
`#mysql50#.tmp` UPGRADE DATA DIRECTORY NAME
Error: Table 'mysql.event' doesn't exist
I've now also got two databases named '.protected' and '.tmp'. Does
anyone what might have happened?
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
not have DROP authority on 'new'. Can anyone explain to me
what causes this change in behaviour? For the time being I've changed
the TRUNCATE to a DELETE.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
FROM users WHERE users.username='%s',
$username);
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
I've been trying to make mysqld write a coredump following a crash, and
this morning I finally succeeded - according to mysqld.log anyway. It
clearly says Writing a core file - but where to? I've checked the
datadir /var/lib/mysql, whereelse might it be?
/Per Jessen, Zürich
--
MySQL General
squares on IE8...
I think we've gone OT here, but honestly I have no problem with accents
nor any other special characters anywhere - database, browser,
whereever. And yes, I work with 4-5 different languages on a daily
basis.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list
Per Jessen wrote:
It happened agaIn this morning, but slightly different:
[snip]
thd=0x7fe0140c7e00
Attempting backtrace. You can use the following information to find
out where mysqld died. If you see no messages after this, something
went terribly wrong...
Cannot determine thread, fp
Per Jessen wrote:
I have just discovered that my mysql server was restarted this
morning, which is what gave me the 2013. In the log I found this:
[snip]
It happened agaIn this morning, but slightly different:
[snip]
thd=0x7fe0140c7e00
Attempting backtrace. You can use the following
remotely on 32bit using mysql library from
version 5.0.67.
I've been googling quite a bit, but haven't really found anything of any
use. I've checked the two configurations, and they are the same. Can
anyone help point me in the right direction? Thanks.
/Per Jessen, Zürich
--
MySQL General
Per Jessen wrote:
This weekend we completed migrating a large(ish) mysql server from
5.0.26 on 32bit to 5.0.51a on 64bit. Everything went relatively
smoothly, until this morning when I noticed an application had choked
on getting Error 2013 Lost connection to MySQL server during query.
I
generally does mean you have run
into a bug of some sort but, more often than not, you were doing
something ill-advised at the time.
The setup has been running for at least two years with no such problems.
Let me know what other info would be interesting.
best regards
Per Jessen
--
MySQL
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
best regards
Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
Per Jessen wrote:
Michael Steinfeld wrote:
just a thought: Did you run mysql_upgrade after the import?
No, I didn't - I didn't think of it as I really only moved the data
across.
Okay, have done a mysqlcheck --check-upgrade - came back all clean. I
don't see a need to run
on hardware RAID6.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Per Jessen wrote:
Michael Dykman wrote:
Have you tried running the offending SQL manually against you new
installation? Does it come back clean in the isolated case?
No, not manually, but the job/the SQL is run several times a day,
maybe 2-3 times per hour.
I've also just run the query
the mysql build and
try upgrading to a newer one.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
INTERACTIVE_TIMEOUT
WAIT_TIMEOUT
NET_WRITE_TIMEOUT
NET_READ_TIMEOUT
MAX_CONNECT_ERRORS
Hi Darryle
I did notice references to some of those when I was googling, but
because I didn't change any settings in my migration except up the
key_buffer space, I didn't really pay much attention.
/Per Jessen
Michael Widenius wrote:
Bernt We have a Norwgeian word for this helpfullness:
bjørnetjeneste, but Bernt I'm not sure what the english idiom would
be.
A disservice. In German Bärendienst.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
or AppArmor, check the audit logs,
e.g. /var/log/audit/audit.log
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
John Meyer wrote:
I'm trying to help out a friend with repairing myisam tables. Does
anybody know the best freeware solutions if CHECK TABLE and REPAIR
TABLE don't do the job?
Did you try myisamchk ?
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http
defunct
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
reference to a time zone.
I'd prefer not to use offset, as I would loose the little bit of
geographical info then. ('Europe/Zurich' has the same offset
as 'Europe/Copenhagen'). For now I'm storing the name of the timezone,
but the manual is clearly lacking some info in this respect.
/Per Jessen
to store the timezone name.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
All,
I will be recording timezone information based on user input using the
time zone names from mysql.time_zone_name - names
like 'America/Los_Angeles'.
When recording this information, do I store the full name or just
the 'time_zone_id' which is present in mysql.time_zone_name ?
thanks
Per
doing fine, except you
could probably increase overall performance with more memory. MySQL is
pretty good at query-caching.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
All,
how do I go about building a binary on my workstation with e.g.
libmysqlclient.15 such that same binary can also be deployed on a
production machine with libmysqlclient.14 )or lower) ?
Do I need to have the lower-level mysqlclient library available on my
development workstations?
/Per
. A sysadmin worth his pay won't have problem working
any of
them.
/Per Jessen, Zürich
--
http://www.spamchek.com/freetrial - managed anti-spam and anti-virus solution.
Sign up for your free 30-day trial now!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
?
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
think Microsoft SQL server is
good enough for this task?
I don't think so, no.
/Per Jessen, Zürich
--
http://www.spamchek.com/freetrial - managed anti-spam and anti-virus solution.
Sign up for your free 30-day trial now!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
records too ...
It's not a major disaster, but I'd like to know if it is intended behaviour?
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, but I'll try to provoke the situation again.
Hmm, or I guess I could just fill it up with random records.
Let me have a look.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I set it up earlier this morning.
/Per Jessen, Zurich
--
http://www.spamchek.ch/freetrial - managed anti-spam and anti-virus solution.
Lassen Sie sich überzeugen - 30 Tage Kostenlos!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
/--tmpdir to a place where you have sufficient space. I started the
REPAIR, which ran
for a while, then stopped and appeared to be idling. It took me a few hours
before I checked
the mysqld.log and found out that it had run out of space in /tmp and was
waiting for some to
be cleared up.
--
/Per
- Fixing index 3
Key 3 - Found wrong stored record at 0
MyISAM-table 'table' is not fixed because of errors
Where do I go from here? I've got a backup of the table, but I'm not sure what
sort of state it
is in.
--
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http
Per Jessen wrote:
I've got a backup of the table, but I'm not sure what sort of state
it is in.
Correction - no backup is available. This table has got to be recoverable.
--
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
?
Not much - good indexes and prooper querying.
Could the database be split over several database servers?
Possibly, but I don't see a need.
--
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
between COUNT and ( ?
thanks,
Per Jessen, Zurich
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL
? :) ).
Is this a problem?
Not any longer - the first reply (use --ansi) solved the problem - thanks.
rgds,
Per Jessen, Zurich
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
49 matches
Mail list logo