A great discussion on a potential problem for database servers with
limited drive space (life EC2 small instances). The best solution is in
the comments section so be sure to read through.
One very interesting thing I noticed with MySQL was that if you delete a
database, ibdata file doesn’t shrink by that much space to minimize disk
usage. I deleted the database and checked usage of /usr/local/mysql/var
folder and noticed that ibdata file is still the same size. So the
problem I face now is, how do I claim back this space?
Maatkit (formerly MySQL Toolkit) contains essential command-line tools
for MySQL, such as table checksums, a query profiler, and a visual
EXPLAIN tool. It provides missing features such as checking whether
slaves have the same data as the master.
| ShellSQL - SQL for shell
scripts
| ShellSQL is a suite of programs designed to enable LINUX/UNIX shell
scripts to connect to SQL engines and execute SQL queries and commands
in a simple way enabling intergration with the rest of the script. For
example, it can do things like..
#/bin/shHANDLE=`shpostgres dbname=mydb`
shsql $HANDLE "begin"
for ARG in $
do
shsql $HANDLE "insert into mytable fld1, fld2" \
"values nextvalmyseq, $ARG"
done
shsql $HANDLE "commit"
if [ $# -gt 0 ]
then
ROWS=`shsql $HANDLE "select count from mytable"`
echo "No of rows now in table is" $ROWS
fi
shsqlend $HANDLE
For details on how it hangs together have a look at the
overview.
| Wfuzz - A Tool for Bruteforcing/Fuzzing Web Applications | Darknet -
The
Darkside
| Wfuzz is a tool designed for bruteforcing Web Applications, it can be
used for finding resources not linked directories, servlets, scripts,
etc, bruteforce GET and POST parameters for checking different kind of
injections SQL, XSS, LDAP,etc, bruteforce Forms parameters
User/Password, Fuzzing,etc.
| As you already know, the RPM database contains a list of all installed
RPM packages on your system. You can query this database to get info
of the packages on your Linux system. To query a single package, you
use the -q option. For example, to query a package whose name is
"software":
| # rpm -q software
This is a simple backup solution for people who run their own web server
and MySQL server on a dedicated box or VPS. Most dedicated hosting
provider provides the backup service using NAS or FTP servers. These
service providers will hook you to their redundant centralized storage
array over private VLAN.
He shows you how to install Apache and PHP on Windows XP, as well as how
to set up a nice working environment. As a bonus, he also shows you how
to install MySQL if you're interested. You can have a complete working
server environment on your desktop and be able to do all your test
there.
read
more | digg story \<http://digg.com/programming/Installing_Apache_2.0_and_PHP_5\_(and_MySQL)\_on_Windows_XP\>__
This blog is written by a Windows veteran, a Mac newbie, describing his
switch to Mac from Windows. It's both slightly technical and very
technical, ranging from IM clients to setting up PHP/MySQL.
Worth a read, especially for people considering a switch.
read more | digg story \<http://digg.com/apple/A_Windows_users_journey_to_Mac\>__
One of the biggest issues involved with becoming a web publisher is the
question of hosting. With an internet clogged with false hosting review
sites, hosting companies trying to rip you off, and hosting companies
run by 14 year olds, the majority of web publishers are at the mercy of
random chance when it comes to finding a quality host. To solve this
huge problem and to grant freedom to all, we have come up with 75
extremely specific steps that will get you up and running with a *nix
box (running FreeBSD), along with the most recent versions of Apache,
Perl, PHP, and MySQL.