Re: Insert static column into VIEW

This is exactly what I tried to avoid by using a view. I do not want to have to take care about synchronizing two tables. Is there any way to avoid this? Regards, Samy

Insert static column into VIEW

Hey guys, I am trying to construct a specially crafted view for the powerdns DNS-Server. This is what I have so far: CREATE VIEW test4 AS SELECT nummer AS name, ip as content FROM jabix.spaces JOIN jabix.ves ON spaces.veid = ves.id; ++---+ | name | content | +

Re: Triggering an action every 24 hours

Dan Nelson schrieb: In the last episode (May 22), Samuel Vogel said: Hey, I am wondering how I can trigger an Action every 24 hours inside of mysql. A cron job would also do the job, but it won't work on shared hosts and it's just another point of failure. So is there any wa

Triggering an action every 24 hours

Hey, I am wondering how I can trigger an Action every 24 hours inside of mysql. A cron job would also do the job, but it won't work on shared hosts and it's just another point of failure. So is there any way to run a specific SQL command every 24 hours inside of mysql? I'm using MySQL 5.0.51

Re: 30 % of my databases dissapeared

Ok, I ran xfs_check and the filesystem is all well. Does anybody else have an idea? Regards, Samy Samuel Vogel schrieb: Hey, Thanks for the very fast reply. Of course I forgot that I'm running Linux Debian Etch with mysql 5.0.45 from backports. We have a 20GB quota set for MySQL. B

Re: 30 % of my databases dissapeared

eport back here! Regards, Samy Michael Dykman schrieb: What system are you on? What is your disk capacity? It looks like the disk got corrupted.. How *that* happened is hard to say, but know what host OS/hardware you are on would give us a first clue. - michael On Dec 6, 2007 2:42 PM, Sa

30 % of my databases dissapeared

Hey guys, I have a big Problem. About 30 % of my databases just disappeared around 6pm today. I do not have any clue how this happened. Is can just guess the time it happened from my munin graphs. The only thing that might be a clue are the following files in my data directory: h1314631:~#

Re: Processlist full of "Opening tables"

ow many tables MySQL will keep open (table cache). You need to increase this number using the table_cache variable. set global table_cache=#; The Open_files number from the show status command is important, make sure that stays within limits of your operating system. On Nov 12, 2007 5:09 PM, Samu

Processlist full of "Opening tables"

Hey guys, I do run MySQL on a high traffic Server with approximately 10k databases. Since some time MySQL is has become very sluggish. When I look at my processlist it shows more than 25 processes (sometimes of the same & table) with status "Opening tables". Some processes also show "closing t

Re: Storing Apache logs in MySQL.

Hi, An easier method may be to install mod_log_mysql on each of the Apache servers and log directly to the central MySQL installation. Regards Ian This however is not an option at all when you run Apache in prefork mode. Because the sum of your MaxClients will be equal to the connectio

Re: ADDITIONAL SETTING IN MYCNF

This line has not come later, it is standard in Debian, to be able to have parts of your configuration in different files. This line does all configuration files that are in "/etc/mysql/conf.d/. Since this directory is probably empty, nothing is done at all. So you are safe with just leaving th

Re: MySQL Server crashing & database corruption

314631 mysqld[13284]: Version: '5.0.45-Debian_1~bpo.1-debug' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution What am I supposed to do? Regards, Samy Samuel Vogel schrieb: Actually I have an somewhat reproducible test case. Problem is, it

Re: MySQL Server crashing & database corruption

ructure Oct 7 21:51:24 h1314631 mysqld[18836]: 071007 21:51:24 [Note] /usr/sbin/mysqld: ready for connections. Oct 7 21:51:24 h1314631 mysqld[18836]: Version: '5.0.45-Debian_1~bpo.1-debug' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Debian etch distribution Ma

Re: MySQL Server crashing & database corruption

I did some more research: I ran "xfs_check" on the partition and it didn't report any errors at all, so I'm guessing, that the hard drives are ok. I also recompiled MySQL with "--with-debug". How would I get some debug output about the crashes now? Thanks, Sa

MySQL Server crashing & database corruption

Hey guys, First of all: I have tried to post this Issue on forums.mysql.com, but the Topic doesn't appear in the Forum. When I try to post again, it tells me that it's a duplicate?!?! Now the real problem: I have MySQL set up on two Servers with 7000 Users each and about the same amount of d

Re: Problem with external connections

he server. I'm setting an connection timeout of 10 seconds. It seems, that under high load, some of the connections are dropped, and this causes the problem! I started logging the attempts and they seem to randomly fail (since the same host and password is used every time) ! Does this help

Problem with external connections

Hey guys, I'm using SSL encrypted MySQL connections between my Servers. Suddenly today, the connection to one of my servers stopped working. When I try to connect from the outside, I enter the password, and then nothing happens, it just stays blank: # mysql -h beta.kilu.de -p Enter password:

Re: SSL Problem with outdated zertificates

Actually I fixed the problem by generating a whole new set of SSL certificates! Thanks for the help! Regards, Samy [EMAIL PROTECTED] schrieb: Hey, This morning the default timespan of ssl certificates took my servers down... Everything was running fine, but this morning the SSL encrypted MyS