egfault occur
> ?
Interesting that you should pick on the length - I think that might 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
#x27;m running 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
to UDP 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
network's predicament is all too common among web
> startups that start small and grow 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
F
Johan De Meersman wrote:
> On Wed, Dec 15, 2010 at 10:08 AM, Per Jessen 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?
>>
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 Jess
network traffic. 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 trig
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.
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 a
abase.
>
> Any suggestions?
I have a very similar HP box with 8 drives too - 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
h that I'd have serious down-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
--
user does 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:
exist
> Failed to ALTER DATABASE `#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 G
quot;improvement" I can see is:
$q1 = sprintf("SELECT uid 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 Jesse
ittle black diamond devils
> come back or turn into little blank 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
ba
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.
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 fol
uffer space, I didn't really pay much attention.
/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
r about a month (although not with
much load, mostly idling). I might as well suspect 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
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 pe
ual
quad-core Xeons and 10Gb RAM. The filesystem is JFS 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 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-upg
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:
way mid-query 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 Jes
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 se
is running 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,
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
F
to the MySQL user. No change in
> outcome.
If you're running SElinux 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
0 Z 5 0.0 0:00.15 make
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ow I'm storing the name of the timezone,
but the manual is clearly lacking some info in this respect.
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ne. If the id might (for whatever reason) change in the future,
I'd have 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_
I think you're 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
ain, then Solaris. 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.mysq
henticates?
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re. If
> you don't think I can use mysql, do you 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!
)
This will take maybe a month, 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]
0mill 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]
mlm did not
complain when 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
ome to
be cleared up.
--
/Per Jessen, Zürich
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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.my
index 1
- Fixing index 2
- Fixing index 3
Key 3 - Found wrong stored record at 0
MyISAM-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 Gen
amount of data?
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:
y followed by the opening parentheses (is one just a
> parenthesi? :) ).
>
> Is this a problem?
Not any longer - the first reply (use --ansi) solved the problem - thanks.
rgds,
Per Jessen, Zurich
-
Before postin
at's with this blank 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 th
49 matches
Mail list logo
