Hi all!
Mark wrote:
On my FreeBSD:
usr/include/errno.h:#define EAGAIN 35 /* Resource temporarily unavailable
*/
/usr/include/errno.h-#ifndef _POSIX_SOURCE
/usr/include/errno.h-#define EWOULDBLOCK EAGAIN /* Operation would block */
Ok, next step then:
The OP wrote the problem was when
Hi, I'm trying to debug a stored procedure. This SP has a few queries and
also call another SP. I'm starting mysql with the --log=my_queries.log but I
found that mysql only log the call my_sp(param1, param2) but don't log any
query inside my_sp neither log the nested SP call. By the way, how can I
Seems I was in error suggesting a file limit issue; which is why I wisely
left it to to, Jörg. :)
Ok, next step, then:
ERRORS
pthread_create() will fail if:
[EAGAIN] The system lacked the necessary resources to create
another thread, or the system-imposed limit on the
total
Hi,
try putting the full path to the init file, and also try putting
the update command after the two grant commands (if you put it first
and the user r...@173.8.172.53 didn't already exist then the password
will not be set for that user) and put a flush privileges as the last
line ,
Hmm, seems indeed every non-privileged user can access it:
Your MySQL connection id is 13949
Server version: 5.1.34 FreeBSD port: mysql-server-5.1.34
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql
mysql
mysql show databases;
++
|
To me the update seems fairly pointless, unless there are other users with
the name 'root' in addition to the the two specifiied in the grant
commands.
Specifiy the full path in the '--init-file=' option.
Issue the Flush Privileges command after the two GRANT statements not in
between them.
Yes, every user has select privileges on information_schema but only see
objects they have permissions for anyway so why would you want to disable
this?
From the MySQL 5.0 Manual: Each MySQL user has the right to access these
tables, but can see only the rows in the tables that correspond to
Hi
I have a table that stores huge rows in 15 years, now we have to do some
analysis about these row in Time dimension.To gain performance,at begining,
i've extrait the data according to years from my DB to build my fact table.
But since I have 15 fact tables, that complicate my olap cube.Today,
From: haidarpes...@gmail.com
To: mysql@lists.mysql.com
Subject: select data from two table and will sort by price in second table
Date: Wed, 29 Apr 2009 10:46:48 +0700
dear all,
please help us mien for select data from two table with details as follows:
primery tabel : bookcatalog
Hello Lin
What tools are you using to model your data and build your OLAP cube? If I
were building a cube which required data from 15 fact tables which only
differed in that they contained a different years data, I would model the
15 tables so they appeared as one using something like Cognos
Lin,
I've had mixes results but you might have better success. As John mentioned,
there are a couple factors that you need to take into account.
How much data are you talking about (physical size and number of rows). I know
you say 15 years of data but is that 100's of millions of rows?
Dual master replication can be either dual master dual write or dual
master single writer. The latter is preferred. In this configuration
replication is connected in both directions but clients only ever
connect to one master at a time. It's just as safe as master - slave
replication if you handle
Thanks. NOW() and php date(); work for my newly created test tables, but it
doesn't work for my working table. I can't insert date, time or now()
into my old table (which is as below).
For now, I'm using MySQL auto timestamp ('Updated' field), but I need to
insert date when the data was created!
I think what's really being sought after, here is clustering.
--C
Eric Bergen wrote:
Dual master replication can be either dual master dual write or dual
master single writer. The latter is preferred. In this configuration
replication is connected in both directions but clients only ever
Hi Guys,
i am still lost here:
GRANT ALL ON mysql.* TO 'root'@'localhost' IDENTIFIED BY 'XXX';
GRANT ALL ON mysql.* TO 'root'@'173.8.172.53' IDENTIFIED BY 'XXX';
FLUSH PRIVILEGES;
Here is the command that I am executing:
[r...@server1 ~]# /etc/init.d/mysqld restart
At 09:49 AM 4/29/2009, you wrote:
Hi
I have a table that stores huge rows in 15 years, now we have to do some
analysis about these row in Time dimension.To gain performance,at begining,
i've extrait the data according to years from my DB to build my fact table.
But since I have 15 fact tables,
i dont think that the init.d script will accept the argument.
you need to run /usr/bin/mysqld_safe --init-file=clouds.sql
(or whatever the path to mysqld_safe is)
2009/4/29 Jason Todd Slack-Moehrle mailingli...@mailnewsrss.com
Hi Guys,
i am still lost here:
GRANT ALL ON mysql.* TO
OK, I have done this:
[r...@server1 ~]# mysqld_safe
A mysqld process already exists
[r...@server1 ~]# /etc/init.d/mysqld stop
Stopping MySQL:[ OK ]
[r...@server1 ~]# mysqld_safe --init-file=~/cloudsql.sql
Starting mysqld daemon with databases from
Hi Mark,
I am all set now, The log said it could not find the sql file, so I
put it in /tmp and hard coded the path to /tmp/cloudsql.sql and it
works now!
Weird because I had used ~/cloudsql.sql and /root/cloudsql.sql as
paths too
Thank you so much for your help! John and Andy too!
I am trying to compile mysql 5.4 for windows on fedora using the cross
compiler and I am stuck with this error: checking for termcap functions
library... configure: error: No curses/termcap library found.
I have looked and saw that I should install ncurses-devel
On Apr 29, 2009, at 11:29 AM, Antonio PHP wrote:
This is MySQL data structure. - I underlined where it causes the error
message. (datetime)
`id_Company` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
`Revenue` mediumint(6)
21 matches
Mail list logo