Search Results

We will install a webserver that writes access logs to a MySQL table. … Access logs of course will get really really big, so this will be a separate MySQL instance from the regular data and we will more librally delete the binlogs. …

I am trying to figure out how to create the best secure password for AES_ENCRYPT. Specifically, how long should the password be, and how it translates into the 128 bit key length that AES typically us …

It seems someone else has already found the answer on security.stackexchange.com Sorry but I found that later from RubyForum "The algorithm just creates a 16 byte buffer set to all zero, then …

Given a simplified example of two tables table Contact(ID int primary key, Name text not null) table ContactPhone(ContactID int not null, PhoneNumber text not null) Is there a way to tell MySQL that …

If I use CREATE TEMPORARY TABLE, can I write and update this MySQL table and know that none of it will be stored to the binlogs? …

I am Working around MySQL error "Deadlock found when trying to get lock; try restarting transaction". I am going to have to update a program to allow deadlocks. …

Does MySQL have any support for custom data types? … I mostly use MySQL, but I am curious if this has ever been implemented, short of making the application call a function like the INET_ATON function. …

/mysql/data/ibdata1 to /dev/rdsk/c0t0d0s3. … MySQL would then see it as a file, but might perform better because it does not have to go through the file-system layer, it would write directly to a designated section of the disk. …

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146) at something.pl line ... …

Emails are inserted into MySQL tables. Let's say I want my program to know immediately when the table is updated so it can check for new emails, would MySQL triggers be a good way to do this? … Do I have to implement my own event waiting service for this, or can it be done in MySQL? …

Well, I found online that the environment variable UMASK and UMASK_DIR must be set, regardless of what the command umask will output. One must add export UMASK=0640 and export UMASK=0750 to the top o …

The data-dir itself has permissions 700 thereby limiting access to the mysql user. … I want other folks who I add to the mysql group to be able to read binlogs and download the *.frm, *.MYI, *.MYD files to their local computer. My first thought is to run chmod g+rx data-dir. …

It seems odd to me that MySQL would not handle this internally: "Deadlock found when trying to get lock; try restarting transaction" Does Oracle DB work around this issue? …