Hello,
I've found some documentation on transposing tables, generating crosstabs
(e.g. http://dev.mysql.com/tech-resources/articles/wizard/print_version.html).
To be honest I've to admit that I tried to figure out how it works, but I'm not
able to adopt it to my problem.
My starting table looks
Hello,
I have a command-line PHP script--called Listener--that is designed
to run indefinitely with a predictable CPU usage and memory
footprint. In a nutshell, it's a multi-client socket server that
waits for incoming connections, processes incoming data, stores
results in a MySQL databa
hi...
i have the following test sql/schema. i'm trying to create a trigger that
would allow an item in tbl2 to be updated, based upon values from the tbl
that's being inserted into, and the value in a 2nd tbl.element.
the sql/schema:
/*
test schema for stratalight file project
#
# b douglas
#
#3
Greetings.
I have 1 procedure that summarises data in a table for one particular
location. It accepts the location ID, and returns the summary as a
single record. It works well.
Now I'm trying to write a procedure that selects all location IDs, and
calls this 1st procedure for every single locati
1)the user you have connected with does not have permissions to the table
2)you have not yet connected to the DB containing users table easily solved
by connect mysql and rerun query
Viel Gluck/Buena Suerte
Martin--
- Original Message -
Wrom: LYRWTQTIPWIGYOKSTTZRCLBDXRQBGJSNBOHMKHJYFMY
To
Garris, Nicole wrote:
> I'm a new MySQL DBA taking over admin duties for an existing MySQL
> nonclustered 4.1 installation. It has 6 small user databases. So in the
> mysql database, I run the query
>
> Select host, user, password from user;
>
> Which returns the following:
>
>
>
> +-
Hi,
On Dec 10, 2007 4:51 PM, Garris, Nicole <[EMAIL PROTECTED]> wrote:
> I'm a new MySQL DBA taking over admin duties for an existing MySQL
> nonclustered 4.1 installation. It has 6 small user databases. So in the
> mysql database, I run the query
>
> Select host, user, password from user;
>
> Whi
I'm a new MySQL DBA taking over admin duties for an existing MySQL
nonclustered 4.1 installation. It has 6 small user databases. So in the
mysql database, I run the query
Select host, user, password from user;
Which returns the following:
+-+-+-
At 09:45 AM 12/10/2007, thomas Armstrong wrote:
Hi
Using MySQL 4.1.19 on Linux, my server's CPU load is very high. I want
to cut it down but I don't know which parameters I might modify to do
it.
Post the "Show Full Processlist" and maybe we can figure out what MySQL is
doing to cause such a
Hi
Running of mysql actually isn't exact problem.
When I try to run mysql command, it gave me ERROR 1045 (28000): Access
denied for user 'ODXX@'localhost' (using password NO (or YES)) and i cannot
run mysql command.
I did the following operation and mysql worked on vista.
I stoped mysql
Hi,
this Thursday, Giuseppe Maxia will give a MySQL University session on:
Writing LUA Scripts for MySQL Proxy
Please register for this session by filling in your name on the session
Wiki page that you can find here:
http://forge.mysql.com/wiki/Writing_LUA_Scripts_for_MySQL_Proxy
Registerin
Hi
Using MySQL 4.1.19 on Linux, my server's CPU load is very high. I want
to cut it down but I don't know which parameters I might modify to do
it.
These are my server's data:
back log50
basedir /usr/
bdb cache size 8,388,600
bdb home/var/lib/mysql/
bdb log buffe
I have experienced this issue before. When I got the error, I just put
everything back in the data directory.
MySQL, somewhere in its code, expects the binlog index to be in the data
directory, even when we configure it to be elsewhere.
I think the regular binlogs can be stored elsewhere, but MyS
Well if MySQL uses TMPDIR only for the temporary tables, but uses the current
data directory for repairing the tables where the .TMD files will become double
in size, then it does sound like you are stuck.
If I had to manage it, and wanted automatic recovery, or at least not have to
get involved
On Dec 10, 2007 1:26 AM, David Scott <[EMAIL PROTECTED]> wrote:
> I came up with a clunky solution: REGEXP
> 'lvlscore5:[6-9][0-9][0-9][0-9][0-9]';
> This gives me all scores over 6000. I then add on another [0-9] and change
> the [6-9] to [1-9] to do 10k+
> As this was a one off and only returned
Russell E. Glaue wrote:
Hmm..,
I thought the temp tables were created in the temp directory.
What version of MySQL are you using?
5.1 latest
Perhaps you can temporarily increase the user's hard_limit, and not
increase the soft_limit. When they have finished recovering, you can
reset the hard_
try this command to shutdown mysql
mysqladmin --host=abc --password shutdown
On 12/9/07, peri <[EMAIL PROTECTED]> wrote:
>
>
> Hi,
> I installed MysqL 4.1.22 on windows vista. When I try to run any command
> in
> Mysql/MySQL server 4.1/bin path it gives me the following error :
>
> C:\Program
I came up with a clunky solution: REGEXP
'lvlscore5:[6-9][0-9][0-9][0-9][0-9]';
This gives me all scores over 6000. I then add on another [0-9] and change
the [6-9] to [1-9] to do 10k+
As this was a one off and only returned 6 out of thoustands of records it
was good enough for a quick and dirty ma
18 matches
Mail list logo
